IBPhoenix
Home
Products
Services
Contact
Shop
Categories
Tags
Archives
All Posts
2024
Development News - September 2024
Tue 01 October 2024
Development News - August 2024
Mon 02 September 2024
Development News - July 2024
Thu 01 August 2024
Development News - June 2024
Tue 02 July 2024
Development News - May 2024
Mon 03 June 2024
Development News - April 2024
Thu 02 May 2024
Development News - March 2024
Tue 02 April 2024
Development News - February 2024
Fri 01 March 2024
Development News - January 2024
Thu 01 February 2024
Development 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