Documentation
Firebird and InterBase documentation to help developers and users to more
fully understand both the software and source code.
You should also check the pages that contain documents and examples that
show you "how to" use InterBase and Firebird.
If you are looking for generic Firebird information...
General Documentation
Documentation for Firebird and InterBase database developers, designers and
administrators.
- Aggregate Tables with Firebird
By Thomas Steinmaurer May 2010
- Firebird Road Trip and What's New in V.2.5
By Thomas Steinmaurer May 2010
- Audit and Trace Services in Firebird V2.5
By Thomas Steinmaurer May 2010
- Using IBFirstAid to Diagnose and Repair a Corrupt Database
By IBPhoenix Writers March 2010
- How the gfix Validation Tools Work
By IBPhoenix Editors February 2010
- How To Analyse and Repair a Corrupted Database
By IBPhoenix Writers February 2010
- Using qli to Extract Data into a New Database
By IBPhoenix Writers February 2010
- Running two or more versions of Firebird simultaneously under Windows
By Paul Reeves June 2007
- Configuring Firebird for Your Application
By Ann Harrison, O'Reilly Open Source Convention, Aug 2005
- Firebird Null Guide
By Paul Vinkenoog 15 Apr 2005
- Explicit Join Semantics In Firebird
By Claudio Valderrama 16th Mar 2005
- Firebird File and Metadata Security
By Geoff Worboys, Telesis Computing 14th Feb 2005.
- Lock Management in Firebird
By Ann Harrison June 2003.
- Firebird Project Update 2003 (.pdf)
By Sean Leyne, Toronto Delphi Users Group January 2003.
- Firebird (yet) another Open Source Database
By Ann Harrison, Open Source Database Conference, Tokyo, Japan, February 2002.
- Semaphore and Shared Memory Configuration for
Classic Servers
- Introduction to InterBase Express (IBX)
By Bill Todd, Borland Developers Conference 2000.
- A Guide to Setting up a Secure Firebird or
InterBase Server
Not definitive and is targeted at Linux/Unix platforms. However it is a great
starting point for analysing security problems on your system.
- Introduction to InterBase Stored
Procedures and Triggers
By Bill Todd, Borland Developers Conference 2000.
- InterBase for Desktop Users
By Bill Todd, Borland Developers Conference 2000.
- What Open Source Means to You
By David Robinson, Borland Developers Conference 2000.
- Programming with the InterBase API using
Delphi
By Bernard Wheeler, Borland Developers Conference London 1997.
- InterBase and Blobs - A Technical Overview
By Paul Beach.
- The Definitive Guide to InterBase's Configuration
Parameters
By Ann Harrison.
- Performance Features in InterBase 6.0
By Dave Schnepper, Borland Developers Conference 1999.
- Right-Sizing And Optimizing Your Database
Applications
By John Rendell, Borland Developers Conference 1999.
- Embedding InterBase 6.0 in 10 Easy Steps
(Using the Install API)
By Marco Romanini, Borland Developers Conference 1999.
- Using the InterBase Services Manager
By Mark Duquette, Borland Developers Conference 1999.
- Understanding the Assumptions Behind
InterBases Technology
By Ann Harrison, Borland Developers Conference 1999.
- Writing to the InterBase API using Delphi
Using FreeIBComponents, the component technology that became IBX. By Greg
Deatz, Borland Developers Conference 1998.
- Using Server Specific Features in Delphi
By Lance C. Bullock, Borland Developers Conference 1995.
- Using Stored Procedures With Delphi and
InterBase
By Scott Clinton, Borland Developers Conference 1995.
- Introducing the InterBase Procedure and
Trigger Language
By Dan Ehrmann, Borland Developers Conference London 1997.
- Using InterBase Stored Procedures with
Delphi
By Jerry Coffey, Borland Developers Conference London 1997.
- Developing Client/Server Applications With
Delphi and InterBase
By Jerry Coffey, Borland Developers Conference London 1997.
- Delphi to InterBase in 15 Minutes
This is a simple, effective guide for Delphi developers who want to use
InterBase. It's writing was inspired by InterBase becoming Open Source. The
initiative to provide this support and information comes from the UK Borland
User Group UK (G. Nigel Cohen - Software Design), any feedback please to:
gnc@softwaredesign.co.uk
Associated tutorial, demonstration files etc. are downloadable separately:
The
SQL files (4kb)
Delphi
program files (9kb)
Demo Database
file (756kb)
- Controlling the InterBase Workgroup
Server from Delphi
By Dan Ehrmann, Borland Developers Conference 1998.
- Up and Running With InterBase
By Dan Ehrmann (1997 - 1998).
- Tips for Improving InterBase Server
Performance
- SQL Roles: Users and Security in InterBase
Paper given by Markus Kemper and Brett Bandy, Borland Developers Conference
1998.
- An Introduction To InterBase
Ddocument based on a paper given by Markus Kemper, Borland Developers
Conference 1998.
- InterBase Interaction with NFS Automount
- Explanation of deadlocks in InterBase
- Handling Deadlocks with Delphi and
C++Builder
By James Arias-La Rheir.
- Using InterBase Data Types
Article that first appeared in the UK Borland User Group Magazine by Paul
Reeves.
- InterClient - Java Technology For
InterBase
Document from a talk prepared by Paul Ostler, Borland Developers Conference
1998.
- InterBase Architecture: SuperServer vs
Classic
- Ten Ways You Can Make InterBase Scream
By Bill Karwin.
- InterBase's Multi-Generational
Architecture (MGA)
By Bill Todd.
- InterBase 6.0 and SQL Dialects
- InterBase 6.0 and SQL92 Reserved Words
- Firebird and InterBase Oldest Interesting, Oldest Snapshot and Oldest Active Transactions
By Paul Beach.
- Specifying Query Access Plans in the InterBase
Optimizer
- Firebird and InterBase have an (alleged) 2GB Database size limit
By Paul Beach.
- InterBase Server Configuration and
Optimization
By Bill Karwin, Borland Developers Conference 1996.
- A Quick Guide to the Firebird/InterBase
startup parameters for Windows
By Claudio Valderrama C.
- A Quick Guide to ISQL's Switches and Commands for
Firebird/InterBase
By Claudio Valderrama C.
Links To Other Useful Documentation
Migration Documentation
Other Useful Documentation
- SQL: The
Standard and the Language
A paper by Jim Melton (co-author of "Understanding the New SQL: A Complete
Guide") which is a general document on SQL-89, SQL-92 and the proposed
SQL-3 standards.
|