Documentation

Welcome to the IBExpert documentation site, where you will find a wealth of information regarding Firebird and the IBExpert Developer Studio tools. Context-sensitive help can be started directly from IBExpert using the [F1] key for menu items, windows and SQL keywords. Or view our tutorial video series on YouTube.com/IBExpertise or in our learning center. If you have any comments or questions regarding the documentation, or wish to contribute your own articles, please mail register@ibexpert.biz.

Important: All information contained in this documentation has been compiled with the utmost care. Nevertheless it is not possible to completely rule out incorrect information. IBExpert Ltd, the authors and the translators are not liable for any errors and their consequences.

• IBExpert
• IBEBlock
• IBExpertBackupRestore
• IBExpertDemoDB

• IBExpert Server Tools

• IBExpert FAQs
• Firebird and IBExpert error messages
• IBExpert Replication FAQs

• White paper: DBEncryption Plugin Delphi demo for Firebird 3 and Firebird 4
• White Paper: DBEncryption Plugin for Firebird 3.0 and 4.0
• See Also: IBExpert Encryption OEM for Firebird 3 and Firebird 4 PDF Download
• Firebird Performance comparison of Windows and Linux Operating Systems
• Firebird 4 versus Firebird 3 single thread performance comparison
• Thoughts on Firebird performance
• Firebird 4.0 technical specifications
• Firebird 4.0 Release Notes (12 May 2020 - Document v.0400-33 - for Firebird 4.0 Beta 2 Release)
• Firebird 4.0 Language Reference (23 May 2021, version 0.9)
• White Paper: Firebird 4 Replication (German-language version here)
• White Paper: Firebird 4 and IBExpert

• The Cloud and Firebird (PDF download) (German-language version here)
• Database technology articles
• Basic introduction to the Firebird Security Database, port redirection and multi-instances?

• Identify unusually high database load: take two
• IBExpert: How to do it? Automatically synchronize metadata and data and a permanently active backup!
• Firebird and IBExpert White Paper: Advanced debugging event block
• See Also: IBEBlock documentation: Event Blocks
• White paper: DBEncryption Plugin Delphi demo for Firebird 3 and Firebird 4
• White Paper: DBEncryption Plugin for Firebird 3.0 and 4.0
• See Also: IBExpert Encryption OEM for Firebird 3 and Firebird 4 PDF Download
• Firebird and REST (PDF)
• Firebird external engine and UDRs written in Pascal (PDF)
• ibec_StartTraceSession (PDF)
• IBEBlock example: Firebird and REST
• Thoughts on Firebird Performance (PDF)
• White Paper: Firebird 3 Stored Functions
• White Paper: The way to the Cloud and Firebird
• White Paper: The Pascal Language
• White Paper: Time for a review: Is your database server the right solution or part of the problem?
• White Paper: Time for a review: Is your database server the right solution or part of the problem?
• White Paper: Software Performance Optimization
• White Paper: Minimizing database size: should you store data files in the file system?
• White Paper: Alternatives to virtualization for database servers
• White Paper: The Pros and Cons of virtualising SQL and other databases
• White Paper: Firebird Replication
• White Paper: Firebird Performance or: How can I improve it?
• White Paper: Big Data, Replication or "Where are the limits of Firebird?"
• White Paper: Why typical Delphi projects often fail
• White paper: Firebird performance recommendations
• Firebird development using IBExpert
• Firebird administration using IBExpert
• Chromium Embedded Framework (CEF)

• White Paper: Understand and control the full stack

• Firebird 3 Quick Start Guide
• Firebird 3.0 Developer's Guide (Release 1.1)
• Firebird 4.0 Release Notes (12 May 2020 - Document v.0400-33 - for Firebird 4.0 Beta 2 Release)
• Firebird 3.0.5 Release Notes (4 January 2020 - Document v.0305-03 - for Firebird 3.0.5 Release)
• Firebird Database Cache Buffer
• Firebird 2 Administration Handbook
• Firebird 2 Cheat Sheet
• Firebird 2.0 and 2.1 Quick Start Guide
• Firebird 2 Migration & Installation
• Firebird 2.0.4 Release Notes
• Firebird 2.1 Error Codes
• Firebird 2.1.6 Release Notes
• Firebird 2.5 Quick Start Guide
• Firebird 2.5.3 Release Notes
• Firebird Internals
• Firebird Superserver Manager
• Get to know Firebird in 2 minutes
• Migration from MS SQL to Firebird
• Public documentation license
• Setting up Firebird on Ubuntu Linux
• Setting up PHP and Firebird on Linux

• SQL language reference
• Firebird 4.0 Language Reference (23 May 2021, version 0.9)
• Firebird 3.0 Language Reference (Version 0.15, 31 July 2021)
• Firebird 2.5 Language Reference (27 April 2021, version 1.5)
• Firebird 2.1 language reference update
• Firebird 2.0 language reference update
• InterBase 6.0 DSQL syntax

• Firebird and InterBase command-line utilities
• Firebird Backup & Restore Utility
• Firebird Backup File Splitting Filter
• Firebird Database Housekeeping Utility
• Firebird Database Statistics Reporting Tool
• Firebird Generator Guide
• Firebird and InterBase command-line utilities
• Firebird's nbackup Tool
• Firebird Null Guide
• Firebird Password File Utility
• Firebird Shell Scripts

The complete range of InterBase 6.0 documentation is available for download at the IBPhoenix website:

• InterBase 6.0 API Guide
• InterBase 6.0 Data Definition Guide
• InterBase 6.0 Developer's Guide
• InterBase 6.0 Embedded SQL Guide
• InterBase 6.0 Operations Guide
• InterBase 6.0 Language Reference
• InterBase 6.0 full set, cross-indexed

The full range of InterBase documentation since version 7.5 can be found at the Embarcadero website

• Overview of the main character sets in Firebird
• InterBase character sets and collation orders
• Please also refer to the: Database Technology Articles section, Character sets

• Glossary