- Notes on the effect of using ALTER INDEX ACTIVE
- Migration to newer versions of Firebird
- How to write and build UDRs
- Firebird 4 Migration Guide
- Database Parameter - isc_dpb_utf8_filename
- Firebird and Windows 10 Fall Creators Update
- Simplifying GRANT USAGE
- Limits of the Event Parameter Buffer?
- How to Size a Firebird Database
- More on - How to implement the full text search using only what PSQL offers
- How to write an internal UDF function
- RDB$DB_KEY and Delphi
- RFC: Tablespaces
- How to Migrate Users from Firebird 2 to Firebird 3
- Updatable Firebird Views
- Understanding the Firebird Optimizer and Plans
- Understanding Firebird Transactions
- Database on a RAM-disk, shadows and NBackup
- Firebird 2.5 And FreeBSD 10.2
- How to Configure Firebird Classic to use systemd
- Functions with PSQL in Firebird 3
- The Chequered Career of nBackup
- New Pseudocolumn RDB$RECORD_VERSION
- How to Install the Firebird ODBC Driver on Linux
- Microsoft Windows - Forced Writes ON or OFF?
- The Mystery of the RDB$DB_KEY
- Practical Use of the RDB$DB_KEY
- The Interpretation of Database Statistics
- Getting OpenCobol on Linux working with Firebird’s Cobol gpre.
- The life cycle of a Firebird SQL statement
- Firebird Road Trip and What's New in V.2.5
- Audit and Trace Services in Firebird V2.5
- Firebird or InterBase and the Oldest Interesting Transaction
- How the Validation Tools Work
- How To Analyse and Repair a Corrupted Database
- The Free Database Niche
- The Free Database Niche - Response
- Interview with FrontRange
- Aggregate Tables with Firebird
- Choosing a File System on Linux for Firebird
- Embedded Firebird on MacOSX
- Using KEEPALIVE-sockets to avoid 10054 errors
- Fulltext Search for Firebird using DotLucene
- How to Lock a Record in InterBase/Firebird
- Blob Filter Sample Code
- Gbak and Firebird Versions
- Tracking Down Crashes on Linux
- Running two or more versions of Firebird simultaneously under Windows
- Converting data to Firebird by Writing "Native" External Files
- Firebird Databases as the Back-end to Enterprise Software Systems
- Limits of the Firebird Database
- InterBase has an (alleged) 2GB Database size limit
- Configuring Firebird for Your Application
- Database Header page structure
- L’isolement des transactions dans Firebird
- Firebird Null Guide
- Firebird File and Metadata Security
- OSRI Architecture
- Building Firebird V1.5 Classic on HPUX 11
- The Rough Guide to building Firebird 1.5 on MacOSX
- Y-Valve Architecture
- InterBase, Firebird and Blobs - A Technical Overview
- Japanese Firebird User Association
- Lock Management in Firebird
- Using Stream Blobs
- Firebird on Linux
- Interview with Jim Starkey from InterBase World
- Interview with Paul Beach from InterBase World
- Interview with Ann Harrison from InterBase World
- A not-so-very technical discussion of Multi Version Concurrency Control
- What's happening with Firebird and InterBase?
- Firebird (yet) another Open Source Database
- Conceptual Architecture for InterBase/Firebird
- Whats Happening With Firebird?
- Request Handles and What They Do
- Securing your Firebird/InterBase Installation
- Adding New Messages to msg.gdb
- Firebird Coding Style Guides
- Explicit Join Semantics In Firebird
- A Comparison of SQL Server and InterBase Datatypes and Some Other Issues
- Whats Happening to InterBase?
- Tips for Improving InterBase Server Performance
- A Quick Guide to the Windows Startup Parameters for Firebird/InterBase
- Ann Harrison's reminiscences on InterBase's beginings
- How Jim Starkey remembers it
- Further recollections from Ann Harrison
- Datatrieve and Wombats
- The Story of the Blob
- InterBase Rises
- InterBase Flap Could Fork Code
- The451 - Disappearing Inprise spawns InterBase
- The451 - Will Borland let InterBase go?
- Inprise Spins Out Database Division for Open Source Future
- Understanding the Assumptions Behind InterBases Technology
- Introduction to InterBase Stored Procedures and Triggers
- What Open Source Means to You
- Explanation of Deadlocks
- InterBase 6.0 SQL Dialects
- Detecting, correcting, and preventing database corruption
- Firebird Quality Assurance
- From Basic to Advanced ISQL scripting
- Firebird future development: what to expect
- First steps in performance tuning
- Making your own Firebird PowerTools with Python
- Migrating a PHP application to Firebird
- Record versions: consistent read, concurrency control, and undo log
- The Firebird Book II : a Reference for Database Developers
- Interbase 7 Desenvolvendo e Administrando Banco de Dados
- Firebird 1.5
- The IBExpert Book - Tools for Database Developers
- Firebird Essencial
- The Firebird Book: a Reference for Database Developers
- InterBase and Firebird
- Database Development with InterBase
- Yet Another Open Source Database. Firebird RDBMS
- Firebird - The Third Open Source Database
- InterBase and Firebird Administration and Practice
- The InterBase World. Architecture, administration and development with InterBase, Firebird and Yaffil
- Relational Databases en SQL
- Advanced InterBase - Open Source Versions 6.x
- Delphi 6 Client/Server with Firebird/InterBase - POS and Supply Management Application's
- Firebird and InterBase 6.0 Client/Server with Delphi 6 - Advanced Topics
- Client Server Applications with Delphi 6 and InterBase 6 - A Practical Approach
- Developing with Borland Delphi 6 and InterBase 6
- InterBase 6 - Developer's Guide
- InterBase Database Development with Delphi
- InterBase Database with Delphi
- InterBase - Learn Fast
- InterBase with Delphi - Learn Fast
- Real-time Firebird – Monitor for Firebird – Server 2.5/3.0/4.0
- IBEasy+
- FlameRobin
- Firebird Editor Pro
- FirebirdWebAdmin
- TurboBird
- IB LogManager
- Marathon
- FenixSQL
- ibWebAdmin
- Port Guardian
- FB Config
- DBManager
- DBOne 2005
- FBExplorer
- Firebird Database Manager
- FSQL
- IB_SQL
- IBAdmin
- IBOConsole
- IBQueryEditor
- Interbase Query
- Nagios Plugin for Firebird
- SQuirreL SQL Client
- Database Workbench
- Red Expert
- Hopper
- Database .NET
- DB Explorer For Firebird Databases
- FirebirdDbComparer
- Firebolt
- FBCompare
- IBExpert
- Firebird Maestro
- Firebird Stored Procedure Generator
- BlazeTop
- Database Comparer
- DbVisualizer
- EMS SQL Manager for InterBase/Firebird
- IBDataWorks
- InterBase Description tool
- Interbase/Firebird Development Studio
- MyGeneration
- SQLeo Visual Query Builder
- Firebird VAR: Vertec Group
- Firebird VAR: XPert Billing Solutions
- Firebird VAR: Compass Municipal Services Inc.
- Firebird VAR: Aurora Software
- Firebird VAR: Creative IT
- Firebird VAR: Crypton Computers Ltd.
- Firebird VAR: Ellermaa Softwarehouse Ltd.
- Firebird VAR: Firmos Business Solutions
- Firebird VAR: Frred Software GmbH
- Firebird VAR: Mi7 MicroSolutions Inc.
- Firebird VAR: OrderWeb
- Firebird VAR: PRALO
- Firebird VAR: The Software Shack
- Firebird VAR: Top Systems S.A. de C.V.
- Firebird VAR: TurboCASH
- Firebird VAR: WSPD BW
- Meaning of BACKOUTS, PURGES and EXPUNGES in monitoring tables
- Design suggestion for GUID columns
- SQL to split delimited text field into separate strings
- Out-of-memory failure with BLOB
- How to get the value for database linger parameter
- How to measure the effectiveness of incrementing page buffers
- How to always select exact number of rows
- How to get new (FB 3) advanced plan output in your application
- How to convert a string to a number in a where clause without errors
- BLOBs, DISTINCT and GROUP BY
- Alternative to MySQL ELT() function
- How to retrieve values not present in table
- Creating a conditional "order by" statement
- How to create random dates?
- Inserting into a table with only an identity column
- How to calculate Median, Mode and Range?
- Using Accent Insensitive Collation has significant impact on performance
- Embedding 3.x into a Windwos/Mac .NET Application
- How to discover which architecture is installed on Windows
- How to get a list of tables in dependency order
- What is the max. size of event name?
- Firebird 2.5 and 3.0 performance comparison
- Problems running gfix and gbak from windows service
- Performance comparision for primary keys - int vs. varchar, and more
- How to Extract Filename from file path inside a stored procedure
- Some caveats of autonomous transactions in database triggers
- How to convert a database down from v2.5 to v1.5?
- Is there a limit for maximum number of concurrent connections?
- Why table of type "key-value" takes so much space on disk?
- Why Blob concatenation consumes memory?
- Beware useless indices on expressions
- What is the scope of uniqueness constraint?
- Error messages on client shows only templates
- How to store an unusual data type
- Working days between two dates
- Equality on NULL column values
- How to install system wide fbembed.dll on Windows?
- Strange OIT/OAT/OST/Next Transaction numbers
- Updated lesson about max. index key size
- Is it possible to store Firebird DB file on a NAS?
- How to avoid columns with total values (summarized from multiple rows)
- Wait vs. no-wait transactions
- How does the optimizer determines join order?
- How to copy table into newly created one using stored procedure?
- Slow I/O performance on Linux? Look at the filesystem!
- How to use stored procedure for a computed field
- Required information for Firebird database performance optimization
- Why you should check the stack size when you're using embedded Firebird engine
- How to find all records on all tables that violate constraints?
- Lesson about compound Indexes
- How many pages must engine read to fetch a data record?
- Advantages of using CURSOR?
- Trusted Autentication and multi-word group/role names
- Trouble with RDB$ADMIN?
- NBackup level 0 vs. file copy
- Lesson about index direction
- Stack size in your application affects embedded Firebird
- Do global temporary tables have performance advantages over usual tables?
- RDB$USER_PRIVILEGES vs. RDB$SECURITY_CLASS
- How to check in trigger code whether action was caused by cascade or user
- Efficient way to manage hierarchies in database
- Can I use any version of gbak to backup/restore any version of Firebird database?
- How to use Firebird ARRAY type?
- Why Firebird never automatically upgrades database ODS
- Some methods how to assign version to database schema
- How to change database character set
- Why you can't update metadata and data in single transaction
- How to improve performance for range search
- How to create conditional DROP statements in SQL scripts
- How to determine whether connection was made via alias
- Do inserts in FB benefit from ordered or sequential Primary Keys?
- Fragmented records may affect sweep performance
- Lesson about lock resolution, deadlocks and history
- What is the effective difference between key elements orderings?
- Query to get information about the current transaction
- Does collation affects index size?
- How to compare content of two databases
- How to list tables and field wich use the primary key from other table as FK
- Jaybird: Is there any way to set socket timeouts?
- How to estimate temporary space needed for index creation?
- How do convert or display the date or time as string?
- How to install SuperClassic with custom Inno Setup Installer
- Is it possible to enforce uniqueness among non-null values in nullable column?
- How to drop a view only if it exists?
- How table cardinality may affect query prepare times
- Explanation of the maximum key size limit
- Some facts about read_committed + isc_tpb_no_rec_version
- Firebird vs Windows: file-system caching issue
- What is the fastest transaction isolation level ?
- TMP space required during restore
- How to find out whether a field has set a default value
- Lesson about how to avoid deadlocks and lock conflicts
- Lesson about inreasing scale on NUMERIC column
- A story of project conversion
- Lesson about table inserting into itself
- A Lesson about Firebird databases on RAW devices
- BLOB segment size: What it is and is it needed when saving BLOBs?
- Problem passing long parameter values?
- Insert performance may depend on index key type
- Why does Firebird write so much data for simple select queries?
- How to mark every inserted/updated record by increased number, generated at commit time
- How to put an entire Database in memory using cache?
- A Lesson about BLR and ODS
- How to detect computed columns
- How to count recors in more efficient way
- Oldest Snapshot
- Why DROP TABLE can sometimes take very very long time
- A Lesson about Implementation Restrictions
- How to enforce that table has exactly only one row
- How to set up Firebird to accept connections only from localhost
- Firebird V2.1 - Error: value exceeds the range for valid dates
- Is it safe to copy a database between Linux/Windows/32/64-bit?
- Trusted authentication problem - little space for user names
- How to get the length of a BLOB
- What are the explicit cursors good for?
- Oldest Active Transaction and MON$
- How can I use gstat to find the size of table?
- Jaybird - org.firebirdsql.jdbc.FBSQLException: GDS Exception. 15. No message for code 15 found.
- Changing the owner of a table or stored procedure
- What is the maximum number of rows per table in Firebird 2.1 and up?
- How to Identify 64-bit Firebird
- GUID or BIGINT? That's the question!
- How to get number of rows for all tables
- Problem with the Windows System Cache
- A Quick Start Guide to Index Optimisation
- Forced Writes?
- Changes in the result type of RPAD() and LPAD()
- Does a newly added column cause all records to be touched - what happens?
- How to use variable cursors in PSQL
- Do you want to Inactivate / Activate a trigger from stored procedure?
- 101 about Firebird indices
- Lesson about hash table and Firebird performance
- How to select a first, second and third child record to a master
- How to create users under a different account than SYSDBA in FB2.5
- How to get the smallest number that is missing in a sequence
- How to add minutes to a TimeStamp value
- How to change the collation of a field without dropping and recreating it
- Delphi and FLOAT vs. DOUBLE PRECISION
- How to alter column widths when you don't know the column names
- How to deal with an overflow when multiplying decimals
- How does the foreign key implementation work?
- How to check whether a unique constraint is defined
- Table structure for efficient storage
- Lesson about PSQL variables
- Lesson about Indices
- How to get the last date a database was restored
- Sphinx Full-text search and Firebird
- Atomicity of UPDATEs
- Data type for small binary data
- Lesson about the FileSystemCache on 64bit Windows
- Best hard drive configuration for Firebird
- Lesson about Classic server and per-connection cache
- Size of NULL columns
- Fastest method to create a backup and sweep the database
- Lesson about concurrent updates
- Lesson about the size of temporary disk space
- Synergy between users and developers in action
- Minimum Firebird Client Installation on Windows
- Index with two key values
- Concatenated fields
- What is better : null or empty string in index?
- Performance of events
- How to convert a large database from UNICODE_FSS to UTF8
- Interesting lesson about DDL and commit
- Lesson about dates and timezones
- Performance issues on Intel CPUs
- Lesson about data alignment in External Tables
- Maximum number of active connections
- Lesson about implicit parameter length
- Database owner
- How to configure local protocol for work with multiple Firebird installations
- How to get a string date from a datetime field
- Secure DB only for the owner
- Firebird 2.1 is more strict about number formats
- How to let an non-SYSDBA user add and delete USERS
- Transaction Counters in monitoring tables vs. header page
- An example of how to change row data into columnar data
- Firebird Dialect 3 Decimal Number Limits
- Sharing BLOB values among several records
- How to find a record in a table that has a null value where the field does not allow a null value
- A Lesson about Sort was: Sort table depending on the select list instead of depending on the order-by key
- Lesson Two: Querying metadata was: Fastest way to query tables and views and return no records
- Lesson about "Careful Write"
- Semantics of "for select"
- Can't index a 1k+ utf-8 column
- Determining database ODS (pre 11.1)
- Allowing Space for Unicode
- Example of using first..skip in a stored procedure
- DBKEY or cursor in PSQL
- Table ID limit
- Age Calculation
- UUID (octets) to something readable
- Windows system clock and Firebird server
- Firebird 2.1.x and the use of indices for IN predicate optimalization
- Looping Stored Procedure
- Problem with Index Key size
- Understanding character sets
- RunSum in Firebird
- ORDER BY with LPAD is too slow
- New internal functions in Firebird 2.1 may collide with your external UDF's!
- How to ignore exceptions in PSQL
- UDF returning database file path
- System date and time into a stored procedure
- Database on a virtual Drive created with subst
- Embedded vs. Server
- Primary Key and Unique Index
- Prepared statements - use them or not?
- Questions on mon$tables
- How to identify the Firebird version via SQL
- Reduce query / transaction priority
- Fetch multiple records in a single call
- Alter column to shorter width
- Two phase recovery
- Why "cooperative" garbage collection?
- Gsec output to stderr
- Custom System Table
- Bulk collate update on system tables
- SUM performance
- External file structures
- Difference between * vs fieldname in aggregate
- Weird RDB$DB_KEY printing in ISQL
- Best way to update index statistics on new database
- Corrupted Index
- Ignore Seconds when getting unique list of times
- Significance of join order
- Linux Classic Server User Limit
- How to opimize a query with a field that has been cast
- External Tables
- Getting time with milliseconds
- FB Client DLL upgrade advice
- Version Control of Stored Procedures/Triggers
- Using one prepared statement for updating a different field
- Oldest Transaction greater than Oldest Active?
- Valid Firebird date format strings
- How to shred records
- How to alter a table column with dependencies to use a domain
- Order of execution of SQL statements
- How to know when an index has become unbalanced?
- Lock Manager Out Of Room Error
- Process Priority Level
- Updating index statistics
- CURRENT_TIMESTAMP vs. NOW
- fbserver command line options
- Renaming tables in Firebird
- Can virus-scanners interfere with Firebird?
- Backup and restore elapsed time
- Limit for External Tables
- Fill ratio when doing a restore
- What is the best page size?
- gfix -mend warning
- What is the use of the "for update" clause
- Using UUDIs/GUIDs as Primary Keys
- Problem with not in queries in Firebird 2.0 RC3
- Why "SELECT FIRST 1 ..." and "EXISTS ( SELECT * FROM ... )" are so slow in a big database
- Killing a client starting a very large query
- How do I know what the ideal page is size for my database?
- An easy way to see how many database pages are being used to track old transactions
- How ON DELETE CASCADE works, and why
- Absolute value
- Rounding variant
- Max Table size record count
- Inserting rows with cyclic referential dependencies
- Global trigger
- Embedded version run on a CD
- Multiplication and Data Types
- BLOB conversion
- String equality match pitfall
- Primary Keys / Indexes
- The First to select
- Deleting all the foreign keys in my database
- Smart backup
- Updatable views
- UPDATE Bug ?
- Data encryption
- Backup in 2.0 => Restore in previous versions?
- Understanding (and upgrading?) ODS
- Too Many Versions
- How much space does a NULL take?
- Drop primary key constraint with no name
- High CPU consumption
- Oldest Snapshot and Performance Issues
- Why is CommitRetaining bad?
- Why rebuild your indices
- Concurrency issues
- How to determine whether a column is computed
- Missing pointer page
- Violation of UNIQUE KEY constraint during UPDATE
- More about SAVEPOINTs
- Strange performance on a VIEW
- Ambiguous field, problem with Borland Database provider
- Domains inside Stored Procedures
- Firebird Indexing
- Firebird uses 100% CPU
- Database statistics
- External Tables and EOL
- Quick restore from backup with Classic
- Weird query execution plan
- Bulk Loading for FB
- Careful-write documentation
- What's the row limit/file size for a FB table?
- Blob segment size and Filesystem block size
- Question about Record Versioning
- Development News - April 2025
- Development News - March 2025
- Development News - February 2025
- Development News - January 2025
- A sad day for the Firebird Project
- Development News - December 2024
- Development News - November 2024
- Firebird Advent Calendar 2024
- Development News - October 2024
- Press Release: Firebird Foundation Transitions to New European Base for Enhanced Project Support
- Development News - September 2024
- Development News - August 2024
- Development News - July 2024
- Development News - June 2024
- Development News - May 2024
- Development News - April 2024
- Development News - March 2024
- Development News - February 2024
- Development News - January 2024
- Development News - December 2023
- User of Firebird: Vertec Group
- User of Firebird: Advanced International Translations
- User of Firebird: Agritec
- User of Firebird: Baucenter
- User of Firebird: Cointec
- User of Firebird: Concord Software Ltd
- User of Firebird: Consic Software Engineering
- User of Firebird: Cox-Colvin & Associates, Inc
- User of Firebird: Cyber Sea Incorporated
- User of Firebird: Dubost Automation
- User of Firebird: Omni Accounts
- User of Firebird: Passfield Data Systems
- User of Firebird: ProfitMed
- User of Firebird: Repostor
- User of Firebird: Stonito Software
- User of Firebird: TTSOFT, Vietnam Software JSC
- User of Firebird: Venus Software Operations
- User of Firebird: Anton Röckenwagner
- User of Firebird: Guacosoft
- User of Firebird: Magister
- User of Firebird: Rising Software
- User of Firebird: Cocemfe Toledo Multiple Services, S.L. (CTS)
- User of Firebird: wobe-systems
- User of Firebird: MusiCHI Suite
- User of Firebird: Specialized Business Software
- User of Firebird: Epix Systems Ltd
- User of Firebird: Duzen Laboratories Group
- User of Firebird: ADR IMDG SPIEGEL
- User of Firebird: Airsol Canarias S.L.
- User of Firebird: AP group d.o.o.
- User of Firebird: Artawahista Co.
- User of Firebird: Baywood Technologies
- User of Firebird: BDCSoftware Inc.
- User of Firebird: BeMat Automatisering bv
- User of Firebird: Chillisoft Solutions
- User of Firebird: Clarus Management Solutions
- User of Firebird: Clientel Telefonmarketing GmbH
- User of Firebird: DeeBank Financial Services Ltd.
- User of Firebird: Deutsche Presse-Agentur GmbH
- User of Firebird: EOS Development
- User of Firebird: Euristic s.r.l.
- User of Firebird: Examiner Newspaper
- User of Firebird: Forte CRM
- User of Firebird: GES Limited (UK)
- User of Firebird: Gruppo Q S.r.l.
- User of Firebird: Kappix
- User of Firebird: KIMdata GmbH
- User of Firebird: Lenvica Computer Solutions Pvt Ltd
- User of Firebird: Magic Partner d.o.o.
- User of Firebird: Microcom ApS
- User of Firebird: Miracle Information Systems
- User of Firebird: Northwest Software Technologies, Inc
- User of Firebird: PearlPOS
- User of Firebird: Republic Biscuit Corporation (REBISCO)
- User of Firebird: Sainfotech
- User of Firebird: TECT Software Ltd
- User of Firebird: Telensa
- User of Firebird: Transfertex GmbH
- User of Firebird: Unidad de Diagnostico Anatomopatologico (UDIAP)
- User of Firebird: Unisoft Colombia Ltda.
- User of Firebird: University of the Visayas
- User of Firebird: Viasoft Informática Ltda
- User of Firebird: Yoursoft
- User of Firebird: Zest-O Corporation