All Posts · IBPhoenix

2024

Monthly News - March 2024 Tue 02 April 2024

Monthly News - February 2024 Fri 01 March 2024

Monthly News - January 2024 Thu 01 February 2024

Monthly News - December 2023 Mon 01 January 2024

2023

Migration to newer versions of Firebird Mon 09 October 2023

How to write and build UDRs Wed 08 March 2023

Meaning of BACKOUTS, PURGES and EXPUNGES in monitoring tables Tue 10 January 2023

2021

Design suggestion for GUID columns Tue 30 November 2021

Firebird 4 Migration Guide Mon 26 April 2021

2020

SQL to split delimited text field into separate strings Sat 26 September 2020

2019

Python with Firebird: FDB Driver 101 Thu 24 October 2019

The Firebird Butler, An Introduction Thu 24 October 2019

Fireswarm/Avalerion Thu 24 October 2019

Firebird Butler in Python part I, Introduction to Saturnin SDK Thu 24 October 2019

Firebird Butler in Python part II, Introduction to Saturnin Thu 24 October 2019

Out-of-memory failure with BLOB Sat 26 January 2019

2018

How to get the value for database linger parameter Thu 21 June 2018

How to measure the effectiveness of incrementing page buffers Mon 21 May 2018

How to always select exact number of rows Wed 21 March 2018

Database Parameter - isc_dpb_utf8_filename Wed 21 February 2018

How to get new (FB 3) advanced plan output in your application Wed 21 February 2018

How to convert a string to a number in a where clause without errors Sun 21 January 2018

2017

BLOBs, DISTINCT and GROUP BY Thu 21 December 2017

Firebird and Windows 10 Fall Creators Update Wed 20 December 2017

Alternative to MySQL ELT() function Tue 21 November 2017

How to retrieve values not present in table Tue 21 November 2017

Creating a conditional "order by" statement Sat 21 October 2017

Simplifying GRANT USAGE Wed 26 July 2017

Limits of the Event Parameter Buffer? Wed 29 March 2017

How to create random dates? Sat 21 January 2017

2016

Inserting into a table with only an identity column Wed 21 December 2016

How to calculate Median, Mode and Range? Mon 21 November 2016

How to Size a Firebird Database Thu 27 October 2016

More on - How to implement the full text search using only what PSQL offers Wed 19 October 2016

Upgrading from Firebird 1.5 to 2.5 and beyond Mon 17 October 2016

Firebird development process — Past, present and future Mon 17 October 2016

Managing Firebird with Ansible Mon 17 October 2016

SQL best practices Mon 17 October 2016

Using Accent Insensitive Collation has significant impact on performance Sun 21 August 2016

Embedding 3.x into a Windwos/Mac .NET Application Tue 21 June 2016

How to discover which architecture is installed on Windows Sat 21 May 2016

How to write an internal UDF function Tue 26 April 2016

How to get a list of tables in dependency order Mon 21 March 2016

RDB$DB_KEY and Delphi Tue 15 March 2016

RFC: Tablespaces Wed 02 March 2016

What is the max. size of event name? Thu 21 January 2016

How to Migrate Users from Firebird 2 to Firebird 3 Mon 11 January 2016

2015

Firebird 2.5 and 3.0 performance comparison Mon 21 December 2015

Updatable Firebird Views Tue 08 December 2015

Understanding the Firebird Optimizer and Plans Thu 03 December 2015

Understanding Firebird Transactions Thu 03 December 2015

Database on a RAM-disk, shadows and NBackup Tue 24 November 2015

Problems running gfix and gbak from windows service Sat 21 November 2015

Performance comparision for primary keys - int vs. varchar, and more Wed 21 October 2015

Firebird 2.5 And FreeBSD 10.2 Thu 01 October 2015

How to Extract Filename from file path inside a stored procedure Mon 21 September 2015

Some caveats of autonomous transactions in database triggers Fri 21 August 2015

How to Configure Firebird Classic to use systemd Tue 28 July 2015

Functions with PSQL in Firebird 3 Mon 27 July 2015

How to convert a database down from v2.5 to v1.5? Tue 21 July 2015

Is there a limit for maximum number of concurrent connections? Sun 21 June 2015

Why table of type "key-value" takes so much space on disk? Sun 21 June 2015

Why Blob concatenation consumes memory? Sun 21 June 2015

The Chequered Career of nBackup Tue 02 June 2015

Beware useless indices on expressions Thu 21 May 2015

What is the scope of uniqueness constraint? Tue 21 April 2015

New Pseudocolumn RDB$RECORD_VERSION Fri 10 April 2015

Error messages on client shows only templates Sat 21 March 2015

How to store an unusual data type Sat 21 March 2015

Working days between two dates Wed 21 January 2015

2014

Equality on NULL column values Fri 21 November 2014

How to Install the Firebird ODBC Driver on Linux Thu 20 November 2014

How to install system wide fbembed.dll on Windows? Tue 21 October 2014

Strange OIT/OAT/OST/Next Transaction numbers Tue 21 October 2014

Orphans, Corruption, Careful Write, and Logging Fri 17 October 2014

Threading in Firebird and the Future Fri 17 October 2014

Using TPC-C to study Firebird performance Fri 17 October 2014

Using monitoring tables & trace/audit for system analysis Fri 17 October 2014

Updated lesson about max. index key size Sun 21 September 2014

Microsoft Windows - Forced Writes ON or OFF? Mon 08 September 2014

Is it possible to store Firebird DB file on a NAS? Thu 21 August 2014

How to avoid columns with total values (summarized from multiple rows) Mon 21 July 2014

Wait vs. no-wait transactions Mon 21 July 2014

How does the optimizer determines join order? Wed 21 May 2014

How to copy table into newly created one using stored procedure? Mon 21 April 2014

Slow I/O performance on Linux? Look at the filesystem! Fri 21 March 2014

How to use stored procedure for a computed field Fri 21 March 2014

Required information for Firebird database performance optimization Fri 21 February 2014

Why you should check the stack size when you're using embedded Firebird engine Fri 21 February 2014

How to find all records on all tables that violate constraints? Fri 21 February 2014

Lesson about compound Indexes Tue 21 January 2014

2013

How many pages must engine read to fetch a data record? Sat 21 December 2013

Advantages of using CURSOR? Sat 21 December 2013

Trusted Autentication and multi-word group/role names Thu 21 November 2013

Trouble with RDB$ADMIN? Mon 21 October 2013

NBackup level 0 vs. file copy Mon 21 October 2013

The Mystery of the RDB$DB_KEY Fri 04 October 2013

Practical Use of the RDB$DB_KEY Fri 04 October 2013

The Interpretation of Database Statistics Wed 02 October 2013

Lesson about index direction Sat 21 September 2013

Stack size in your application affects embedded Firebird Sat 21 September 2013

Getting OpenCobol on Linux working with Firebird’s Cobol gpre. Thu 29 August 2013

Do global temporary tables have performance advantages over usual tables? Wed 21 August 2013

RDB$USER_PRIVILEGES vs. RDB$SECURITY_CLASS Sun 21 July 2013

How to check in trigger code whether action was caused by cascade or user Fri 21 June 2013

Efficient way to manage hierarchies in database Fri 21 June 2013

Can I use any version of gbak to backup/restore any version of Firebird database? Fri 21 June 2013

How to use Firebird ARRAY type? Fri 21 June 2013

Why Firebird never automatically upgrades database ODS Tue 21 May 2013

Some methods how to assign version to database schema Sun 21 April 2013

How to change database character set Sun 21 April 2013

Why you can't update metadata and data in single transaction Thu 21 March 2013

How to improve performance for range search Thu 21 February 2013

How to create conditional DROP statements in SQL scripts Thu 21 February 2013

How to determine whether connection was made via alias Thu 21 February 2013

The life cycle of a Firebird SQL statement Mon 21 January 2013

Do inserts in FB benefit from ordered or sequential Primary Keys? Mon 21 January 2013

Fragmented records may affect sweep performance Mon 21 January 2013

2012

Lesson about lock resolution, deadlocks and history Wed 21 November 2012

Fun with Firebird and Python Fri 16 November 2012

Examples for Fun with Firebird and Python Fri 16 November 2012

Data and Information Fri 16 November 2012

What is the effective difference between key elements orderings? Sun 21 October 2012

Query to get information about the current transaction Sun 21 October 2012

Working with very large Firebird databases Wed 17 October 2012

Does collation affects index size? Fri 21 September 2012

How to compare content of two databases Tue 21 August 2012

How to list tables and field wich use the primary key from other table as FK Sat 21 July 2012

Jaybird: Is there any way to set socket timeouts? Thu 21 June 2012

How to estimate temporary space needed for index creation? Thu 21 June 2012

How do convert or display the date or time as string? Sat 19 May 2012

How to install SuperClassic with custom Inno Setup Installer Sat 19 May 2012

Is it possible to enforce uniqueness among non-null values in nullable column? Thu 19 April 2012

How to drop a view only if it exists? Thu 19 April 2012

How table cardinality may affect query prepare times Wed 28 March 2012

Explanation of the maximum key size limit Wed 28 March 2012

Some facts about read_committed + isc_tpb_no_rec_version Wed 28 March 2012

Firebird vs Windows: file-system caching issue Tue 27 March 2012

What is the fastest transaction isolation level ? Sun 19 February 2012

TMP space required during restore Thu 19 January 2012

How to find out whether a field has set a default value Thu 19 January 2012

Lesson about how to avoid deadlocks and lock conflicts Thu 19 January 2012

Lesson about inreasing scale on NUMERIC column Thu 19 January 2012

A story of project conversion Thu 19 January 2012

2011

Lesson about table inserting into itself Mon 19 December 2011

A Lesson about Firebird databases on RAW devices Sat 19 November 2011

BLOB segment size: What it is and is it needed when saving BLOBs? Sat 19 November 2011

Problem passing long parameter values? Wed 19 October 2011

Insert performance may depend on index key type Wed 19 October 2011

Why does Firebird write so much data for simple select queries? Wed 19 October 2011

How to mark every inserted/updated record by increased number, generated at commit time Wed 19 October 2011

Firebird and RAID Mon 17 October 2011

Measuring Firebird disc IO Mon 17 October 2011

Firebird drivers for Python Mon 17 October 2011

Tips for success Mon 17 October 2011

Firebird on Linux Mon 17 October 2011

Firebird 3 Windowing Functions Mon 17 October 2011

How to put an entire Database in memory using cache? Fri 30 September 2011

A Lesson about BLR and ODS Fri 30 September 2011

How to detect computed columns Fri 30 September 2011

How to count recors in more efficient way Fri 30 September 2011

Oldest Snapshot Mon 01 August 2011

Why DROP TABLE can sometimes take very very long time Mon 01 August 2011

A Lesson about Implementation Restrictions Mon 01 August 2011

How to enforce that table has exactly only one row Mon 01 August 2011

How to set up Firebird to accept connections only from localhost Fri 01 July 2011

Firebird V2.1 - Error: value exceeds the range for valid dates Wed 01 June 2011

Is it safe to copy a database between Linux/Windows/32/64-bit? Wed 01 June 2011

Trusted authentication problem - little space for user names Sun 01 May 2011

How to get the length of a BLOB Sun 01 May 2011

What are the explicit cursors good for? Sun 01 May 2011

Oldest Active Transaction and MON$ Fri 01 April 2011

How can I use gstat to find the size of table? Fri 01 April 2011

Jaybird - org.firebirdsql.jdbc.FBSQLException: GDS Exception. 15. No message for code 15 found. Fri 01 April 2011

Changing the owner of a table or stored procedure Fri 01 April 2011

What is the maximum number of rows per table in Firebird 2.1 and up? Fri 01 April 2011

How to Identify 64-bit Firebird Fri 01 April 2011

GUID or BIGINT? That's the question! Tue 01 March 2011

How to get number of rows for all tables Tue 01 March 2011

Problem with the Windows System Cache Tue 01 February 2011

A Quick Start Guide to Index Optimisation Sat 01 January 2011

Forced Writes? Sat 01 January 2011

Changes in the result type of RPAD() and LPAD() Sat 01 January 2011

2010

Does a newly added column cause all records to be touched - what happens? Wed 01 December 2010

How to use variable cursors in PSQL Wed 01 December 2010

Do you want to Inactivate / Activate a trigger from stored procedure? Wed 01 December 2010

101 about Firebird indices Mon 01 November 2010

Lesson about hash table and Firebird performance Mon 01 November 2010

How to select a first, second and third child record to a master Mon 01 November 2010

How to create users under a different account than SYSDBA in FB2.5 Fri 01 October 2010

How to get the smallest number that is missing in a sequence Wed 01 September 2010

How to add minutes to a TimeStamp value Wed 01 September 2010

How to change the collation of a field without dropping and recreating it Sun 01 August 2010

Delphi and FLOAT vs. DOUBLE PRECISION Sun 01 August 2010

How to alter column widths when you don't know the column names Sun 01 August 2010

How to deal with an overflow when multiplying decimals Thu 01 July 2010

How does the foreign key implementation work? Tue 01 June 2010

How to check whether a unique constraint is defined Tue 01 June 2010

Table structure for efficient storage Tue 01 June 2010

Firebird Road Trip and What's New in V.2.5 Sat 01 May 2010

Audit and Trace Services in Firebird V2.5 Sat 01 May 2010

Firebird or InterBase and the Oldest Interesting Transaction Sat 01 May 2010

Lesson about PSQL variables Sat 01 May 2010

Lesson about Indices Sat 01 May 2010

How to get the last date a database was restored Sat 01 May 2010

Sphinx Full-text search and Firebird Thu 01 April 2010

Atomicity of UPDATEs Thu 01 April 2010

Data type for small binary data Thu 01 April 2010

Lesson about the FileSystemCache on 64bit Windows Thu 01 April 2010

Best hard drive configuration for Firebird Thu 01 April 2010

Lesson about Classic server and per-connection cache Mon 01 March 2010

Size of NULL columns Mon 01 March 2010

Fastest method to create a backup and sweep the database Mon 01 February 2010

Lesson about concurrent updates Mon 01 February 2010

Lesson about the size of temporary disk space Mon 01 February 2010

Synergy between users and developers in action Mon 01 February 2010

How the Validation Tools Work Fri 01 January 2010

How To Analyse and Repair a Corrupted Database Fri 01 January 2010

The Free Database Niche Fri 01 January 2010

The Free Database Niche - Response Fri 01 January 2010

Interview with FrontRange Fri 01 January 2010

Aggregate Tables with Firebird Fri 01 January 2010

Choosing a File System on Linux for Firebird Fri 01 January 2010

Embedded Firebird on MacOSX Fri 01 January 2010

Using KEEPALIVE-sockets to avoid 10054 errors Fri 01 January 2010

Fulltext Search for Firebird using DotLucene Fri 01 January 2010

How to Lock a Record in InterBase/Firebird Fri 01 January 2010

Blob Filter Sample Code Fri 01 January 2010

Minimum Firebird Client Installation on Windows Fri 01 January 2010

Index with two key values Fri 01 January 2010

Concatenated fields Fri 01 January 2010

2009

Gbak and Firebird Versions Mon 14 December 2009

What is better : null or empty string in index? Tue 01 December 2009

Performance of events Tue 01 December 2009

How to convert a large database from UNICODE_FSS to UTF8 Tue 01 December 2009

Interesting lesson about DDL and commit Sun 01 November 2009

Lesson about dates and timezones Sun 01 November 2009

Performance issues on Intel CPUs Thu 01 October 2009

Lesson about data alignment in External Tables Tue 01 September 2009

Maximum number of active connections Tue 01 September 2009

Lesson about implicit parameter length Wed 01 July 2009

Database owner Mon 01 June 2009

How to configure local protocol for work with multiple Firebird installations Mon 01 June 2009

How to get a string date from a datetime field Mon 01 June 2009

Secure DB only for the owner Mon 01 June 2009

Firebird 2.1 is more strict about number formats Fri 01 May 2009

How to let an non-SYSDBA user add and delete USERS Fri 01 May 2009

Transaction Counters in monitoring tables vs. header page Fri 01 May 2009

An example of how to change row data into columnar data Fri 01 May 2009

Firebird Dialect 3 Decimal Number Limits Wed 01 April 2009

Sharing BLOB values among several records Wed 01 April 2009

How to find a record in a table that has a null value where the field does not allow a null value Wed 01 April 2009

A Lesson about Sort was: Sort table depending on the select list instead of depending on the order-by key Sun 01 March 2009

Lesson Two: Querying metadata was: Fastest way to query tables and views and return no records Sun 01 March 2009

Lesson about "Careful Write" Sun 01 February 2009

Semantics of "for select" Sun 01 February 2009

Can't index a 1k+ utf-8 column Thu 01 January 2009

Determining database ODS (pre 11.1) Thu 01 January 2009

Allowing Space for Unicode Thu 01 January 2009

2008

Example of using first..skip in a stored procedure Mon 01 December 2008

DBKEY or cursor in PSQL Mon 01 December 2008

Table ID limit Sat 01 November 2008

Age Calculation Sat 01 November 2008

UUID (octets) to something readable Sat 01 November 2008

Windows system clock and Firebird server Wed 01 October 2008

Firebird 2.1.x and the use of indices for IN predicate optimalization Mon 01 September 2008

Looping Stored Procedure Mon 01 September 2008

Problem with Index Key size Mon 01 September 2008

Understanding character sets Fri 01 August 2008

RunSum in Firebird Tue 01 July 2008

ORDER BY with LPAD is too slow Sun 01 June 2008

New internal functions in Firebird 2.1 may collide with your external UDF's! Sun 01 June 2008

How to ignore exceptions in PSQL Sun 01 June 2008

Tracking Down Crashes on Linux Thu 01 May 2008

UDF returning database file path Thu 01 May 2008

System date and time into a stored procedure Tue 01 April 2008

Database on a virtual Drive created with subst Tue 01 April 2008

Embedded vs. Server Sat 01 March 2008

Primary Key and Unique Index Sat 01 March 2008

Prepared statements - use them or not? Sat 01 March 2008

Questions on mon$tables Sat 01 March 2008

How to identify the Firebird version via SQL Fri 01 February 2008

Reduce query / transaction priority Tue 01 January 2008

Fetch multiple records in a single call Tue 01 January 2008

Alter column to shorter width Tue 01 January 2008

2007

Two phase recovery Sat 01 December 2007

Why "cooperative" garbage collection? Sat 01 December 2007

Gsec output to stderr Sat 01 December 2007

Custom System Table Thu 01 November 2007

Bulk collate update on system tables Thu 01 November 2007

SUM performance Thu 01 November 2007

Firebird and Security Wed 17 October 2007

Who is who Wed 17 October 2007

External file structures Mon 01 October 2007

Difference between * vs fieldname in aggregate Sat 01 September 2007

Weird RDB$DB_KEY printing in ISQL Sat 01 September 2007

Best way to update index statistics on new database Wed 01 August 2007

Corrupted Index Wed 01 August 2007

Ignore Seconds when getting unique list of times Wed 01 August 2007

Significance of join order Sun 01 July 2007

Linux Classic Server User Limit Sun 01 July 2007

Running two or more versions of Firebird simultaneously under Windows Mon 18 June 2007

How to opimize a query with a field that has been cast Fri 01 June 2007

External Tables Fri 01 June 2007

Getting time with milliseconds Tue 01 May 2007

FB Client DLL upgrade advice Tue 01 May 2007

Version Control of Stored Procedures/Triggers Tue 01 May 2007

Using one prepared statement for updating a different field Tue 01 May 2007

Oldest Transaction greater than Oldest Active? Sun 01 April 2007

Valid Firebird date format strings Sun 01 April 2007

How to shred records Sun 01 April 2007

How to alter a table column with dependencies to use a domain Thu 01 March 2007

Order of execution of SQL statements Thu 01 February 2007

How to know when an index has become unbalanced? Thu 01 February 2007

Lock Manager Out Of Room Error Thu 01 February 2007

Process Priority Level Thu 01 February 2007

Updating index statistics Mon 01 January 2007

CURRENT_TIMESTAMP vs. NOW Mon 01 January 2007

2006

Building Firebird on Windows and Linux Fri 01 December 2006

Replicating with IBReplicator 2.5 Fri 01 December 2006

Making your own Firebird PowerTools with Python Fri 01 December 2006

Transportable Firebird Databases Fri 01 December 2006

fbserver command line options Fri 01 December 2006

Renaming tables in Firebird Fri 01 December 2006

Can virus-scanners interfere with Firebird? Wed 01 November 2006

Backup and restore elapsed time Wed 01 November 2006

Limit for External Tables Wed 01 November 2006

Fill ratio when doing a restore Sun 01 October 2006

What is the best page size? Sun 01 October 2006

Converting data to Firebird by Writing "Native" External Files Fri 22 September 2006

gfix -mend warning Fri 01 September 2006

What is the use of the "for update" clause Fri 01 September 2006

Using UUDIs/GUIDs as Primary Keys Sat 01 July 2006

Problem with not in queries in Firebird 2.0 RC3 Sat 01 July 2006

Why "SELECT FIRST 1 ..." and "EXISTS ( SELECT * FROM ... )" are so slow in a big database Sat 01 July 2006

Killing a client starting a very large query Sat 01 July 2006

How do I know what the ideal page is size for my database? Thu 01 June 2006

An easy way to see how many database pages are being used to track old transactions Thu 01 June 2006

How ON DELETE CASCADE works, and why Thu 01 June 2006

Absolute value Thu 01 June 2006

Rounding variant Mon 01 May 2006

Max Table size record count Sat 01 April 2006

Inserting rows with cyclic referential dependencies Sat 01 April 2006

Global trigger Sat 01 April 2006

Firebird Databases as the Back-end to Enterprise Software Systems Wed 08 March 2006

Embedded version run on a CD Wed 01 March 2006

Multiplication and Data Types Wed 01 March 2006

BLOB conversion Wed 01 March 2006

String equality match pitfall Wed 01 February 2006

Primary Keys / Indexes Wed 01 February 2006

The First to select Wed 01 February 2006

Deleting all the foreign keys in my database Wed 01 February 2006

Smart backup Wed 01 February 2006

Updatable views Sun 01 January 2006

UPDATE Bug ? Sun 01 January 2006

Data encryption Sun 01 January 2006

2005

Limits of the Firebird Database Thu 01 December 2005

Detecting, correcting, and preventing database corruption Thu 01 December 2005

Firebird Quality Assurance Thu 01 December 2005

From Basic to Advanced ISQL scripting Thu 01 December 2005

Firebird future development: what to expect Thu 01 December 2005

First steps in performance tuning Thu 01 December 2005

Making your own Firebird PowerTools with Python Thu 01 December 2005

Migrating a PHP application to Firebird Thu 01 December 2005

Record versions: consistent read, concurrency control, and undo log Thu 01 December 2005

Backup in 2.0 => Restore in previous versions? Thu 01 December 2005

Understanding (and upgrading?) ODS Tue 01 November 2005

Too Many Versions Tue 01 November 2005

How much space does a NULL take? Tue 01 November 2005

Drop primary key constraint with no name Tue 01 November 2005

High CPU consumption Sat 01 October 2005

Oldest Snapshot and Performance Issues Sat 01 October 2005

Why is CommitRetaining bad? Sat 01 October 2005

InterBase has an (alleged) 2GB Database size limit Thu 01 September 2005

Why rebuild your indices Thu 01 September 2005

Concurrency issues Thu 01 September 2005

How to determine whether a column is computed Thu 01 September 2005

Missing pointer page Thu 01 September 2005

Configuring Firebird for Your Application Mon 01 August 2005

Violation of UNIQUE KEY constraint during UPDATE Mon 01 August 2005

More about SAVEPOINTs Mon 01 August 2005

Strange performance on a VIEW Fri 01 July 2005

Database Header page structure Wed 01 June 2005

Ambiguous field, problem with Borland Database provider Wed 01 June 2005

Domains inside Stored Procedures Wed 01 June 2005

Firebird Indexing Wed 01 June 2005

Firebird uses 100% CPU Wed 01 June 2005

Database statistics Wed 01 June 2005

External Tables and EOL Wed 01 June 2005

L’isolement des transactions dans Firebird Sun 01 May 2005

Quick restore from backup with Classic Sun 01 May 2005

Weird query execution plan Sun 01 May 2005

Bulk Loading for FB Sun 01 May 2005

Careful-write documentation Sun 01 May 2005

Firebird Null Guide Fri 15 April 2005

What's the row limit/file size for a FB table? Fri 01 April 2005

Blob segment size and Filesystem block size Fri 01 April 2005

Question about Record Versioning Fri 01 April 2005

Firebird File and Metadata Security Mon 14 February 2005

OSRI Architecture Sat 01 January 2005

2004

Building Firebird V1.5 Classic on HPUX 11 Wed 20 October 2004

The Rough Guide to building Firebird 1.5 on MacOSX Thu 01 January 2004

2003

Y-Valve Architecture Sat 13 December 2003

InterBase, Firebird and Blobs - A Technical Overview Wed 01 October 2003

Japanese Firebird User Association Tue 10 June 2003

Lock Management in Firebird Sun 01 June 2003

Using Stream Blobs Sun 01 June 2003

Firebird on Linux Sun 09 March 2003

Interview with Jim Starkey from InterBase World Sun 09 February 2003

Interview with Paul Beach from InterBase World Fri 31 January 2003

Interview with Ann Harrison from InterBase World Sun 12 January 2003

2002

A not-so-very technical discussion of Multi Version Concurrency Control Mon 01 April 2002

What's happening with Firebird and InterBase? Fri 01 March 2002

Firebird (yet) another Open Source Database Fri 01 February 2002

Conceptual Architecture for InterBase/Firebird Tue 29 January 2002

2001

Whats Happening With Firebird? Thu 01 November 2001

Request Handles and What They Do Tue 01 May 2001

Securing your Firebird/InterBase Installation Sun 21 January 2001

Adding New Messages to msg.gdb Mon 01 January 2001

Firebird Coding Style Guides Mon 01 January 2001

Explicit Join Semantics In Firebird Mon 01 January 2001

A Comparison of SQL Server and InterBase Datatypes and Some Other Issues Mon 01 January 2001

2000

Whats Happening to InterBase? Fri 01 December 2000

Tips for Improving InterBase Server Performance Fri 01 December 2000

A Quick Guide to the Windows Startup Parameters for Firebird/InterBase Sun 01 October 2000

Ann Harrison's reminiscences on InterBase's beginings Sun 01 October 2000

How Jim Starkey remembers it Sun 01 October 2000

Further recollections from Ann Harrison Sun 01 October 2000

Datatrieve and Wombats Sun 01 October 2000

The Story of the Blob Sun 01 October 2000

InterBase Rises Fri 01 September 2000

InterBase Flap Could Fork Code Mon 07 August 2000

The451 - Disappearing Inprise spawns InterBase Mon 07 August 2000

The451 - Will Borland let InterBase go? Mon 07 August 2000

Inprise Spins Out Database Division for Open Source Future Mon 07 August 2000

Understanding the Assumptions Behind InterBases Technology Thu 01 June 2000

Introduction to InterBase Stored Procedures and Triggers Sat 01 January 2000

What Open Source Means to You Sat 01 January 2000

Explanation of Deadlocks Sat 01 January 2000

InterBase 6.0 SQL Dialects Sat 01 January 2000