2024

Latest news and articles
Monthly News - May 2024
Monthly News - March 2024
Monthly News - January 2024
Monthly News - December 2023

2023

How to write and build UDRs
Meaning of BACKOUTS, PURGES and EXPUNGES in monitoring tables

2021

Firebird 4 Migration Guide

2020

SQL to split delimited text field into separate strings

2019

Fireswarm/Avalerion
Out-of-memory failure with BLOB

2018

How to convert a string to a number in a where clause without errors

2017

BLOBs, DISTINCT and GROUP BY
Simplifying GRANT USAGE
How to create random dates?

2016

Managing Firebird with Ansible
SQL best practices
RDB$DB_KEY and Delphi
RFC: Tablespaces
How to Migrate Users from Firebird 2 to Firebird 3

2015

Updatable Firebird Views
Firebird 2.5 And FreeBSD 10.2
Working days between two dates

2014

Equality on NULL column values
Lesson about compound Indexes

2013

Advantages of using CURSOR?
Trouble with RDB$ADMIN?
NBackup level 0 vs. file copy
The Mystery of the RDB$DB_KEY
Lesson about index direction
Fragmented records may affect sweep performance

2012

Fun with Firebird and Python
Data and Information
A story of project conversion

2011

Firebird and RAID
Measuring Firebird disc IO
Firebird drivers for Python
Tips for success
Firebird on Linux
Firebird 3 Windowing Functions
A Lesson about BLR and ODS
How to detect computed columns
Oldest Snapshot
Forced Writes?
Changes in the result type of RPAD() and LPAD()

2010

101 about Firebird indices
Lesson about Indices
Atomicity of UPDATEs
Size of NULL columns
Lesson about concurrent updates
How the Validation Tools Work
The Free Database Niche
Interview with FrontRange
Aggregate Tables with Firebird
Embedded Firebird on MacOSX
Blob Filter Sample Code
Index with two key values
Concatenated fields

2009

Gbak and Firebird Versions
Performance of events
Lesson about dates and timezones
Database owner
Lesson about "Careful Write"
Semantics of "for select"
Can't index a 1k+ utf-8 column
Allowing Space for Unicode

2008

DBKEY or cursor in PSQL
Table ID limit
Age Calculation
Looping Stored Procedure
Problem with Index Key size
Understanding character sets
RunSum in Firebird
Embedded vs. Server
Questions on mon$tables
Alter column to shorter width

2007

Two phase recovery
Gsec output to stderr
Custom System Table
SUM performance
Firebird and Security
Who is who
External file structures
Weird RDB$DB_KEY printing in ISQL
Corrupted Index
Significance of join order
External Tables
How to shred records
Lock Manager Out Of Room Error
Process Priority Level
Updating index statistics
CURRENT_TIMESTAMP vs. NOW

2006

Transportable Firebird Databases
fbserver command line options
Renaming tables in Firebird
Backup and restore elapsed time
Limit for External Tables
What is the best page size?
gfix -mend warning
Absolute value
Rounding variant
Max Table size record count
Global trigger
BLOB conversion
String equality match pitfall
Primary Keys / Indexes
The First to select
Smart backup
Updatable views
UPDATE Bug ?
Data encryption

2005

Limits of the Firebird Database
Firebird Quality Assurance
Too Many Versions
How much space does a NULL take?
High CPU consumption
Why is CommitRetaining bad?
Why rebuild your indices
Concurrency issues
Missing pointer page
More about SAVEPOINTs
Firebird Indexing
Firebird uses 100% CPU
Database statistics
External Tables and EOL
Bulk Loading for FB
Firebird Null Guide
OSRI Architecture

2004

The Rough Guide to building Firebird 1.5 on MacOSX

2003

Y-Valve Architecture
Using Stream Blobs
Firebird on Linux
Interview with Ann Harrison from InterBase World

2002

Conceptual Architecture for InterBase/Firebird

2001

Whats Happening With Firebird?
Adding New Messages to msg.gdb
Firebird Coding Style Guides
A Comparison of SQL Server and InterBase Datatypes and Some Other Issues

2000

Whats Happening to InterBase?
How Jim Starkey remembers it
Datatrieve and Wombats
The Story of the Blob
InterBase Rises
What Open Source Means to You
Explanation of Deadlocks
InterBase 6.0 SQL Dialects