Firebird Documentation Index
Firebird Home Firebird Home Firebird Documentation Index

Firebird Database Documentation

Table of Contents

Firebird 1.0 Quick Start Guide
About this guide
What is in the kit?
Classic or Superserver?
Default disk locations
Installing Firebird
Testing your installation
Other things you need
Connecting to the sample database
Creating a database using isql
Performing a client-only install
Firebird SQL
Backup
How to corrupt a database
Where to next?
The Firebird Project
Alphabetical index
Firebird 1.5 Quick Start Guide
About this guide
What is in the kit?
Classic or Superserver?
Default disk locations
Installing Firebird
Working with databases
Safety measures
How to get help
The Firebird Project
Alphabetical index
Firebird 2.0 and 2.1 Quick Start Guide
About this guide
The Firebird licenses
Classic or Superserver?
What is in the kit?
Default disk locations
Installing Firebird
Server configuration and management
Working with databases
Protecting your data
How to get help
How to give help
The Firebird Project
Alphabetical index
Firebird 2.5 Quick Start Guide
About this guide
The Firebird licenses
Classic, SuperClassic or Superserver?
What is in the kit?
Default disk locations
Installing Firebird
Server configuration and management
Working with databases
Protecting your data
How to get help
How to give help
The Firebird Project
Alphabetical index
Firebird's nbackup tool
Introduction
Nbackup features – an overview
Functions and parameters
Making and restoring backups
Locking and unlocking
Setting the delta file
Firebird Generator Guide
Introduction
Generator Basics
SQL statements for generators
Using generators to create unique row IDs
What else to do with generators
Migration from MS-SQL to Firebird
Introduction
Pros and Cons
Database Server Setup
Database Administration
Data Types
SQL Syntax
Server-Side SQL
SQL Tricks
Client Access
Tools
Firebird Null Guide
What is NULL?
NULL support in Firebird SQL
NULL in operations
Internal functions and directives
Predicates
Searches
Sorts
Aggregate functions
Conditional statements and loops
Keys and unique indices
CHECK constraints
SELECT DISTINCT
User-Defined Functions (UDFs)
Converting to and from NULL
Altering populated tables
Changing the nullability of a domain
Testing for NULL and equality in practice
Summary
Alphabetical index
Firebird File and Metadata Security
Introduction
Background
The Problem
The Solution
Embedded Firebird Server
Other Forms of Obscurity
Acceptable Low Security
Choosing Obscurity
The Philosophical Argument
Conclusions
Acknowledgements
Coexistence of Firebird 1.5 and InterBase 5.6 or 6.0
Introduction
Running Firebird and InterBase together
Afterword
Setting up Firebird on Ubuntu Linux
Setting up Firebird on Ubuntu Linux

List of Tables

1. Firebird 1.0 Classic Server vs. Superserver
2. Components of the Firebird 1.0 installation
1. Firebird 1.5 Classic Server vs. Superserver
2. Components of the Firebird 1.5 installation
1. Firebird 2 Classic Server vs. Superserver
2. Firebird 2 component locations on Linux
3. Firebird 2 component locations on Windows
1. Firebird 2.5 component locations on Linux
2. Firebird 2.5 component locations on Windows
A..1. Classic, SuperClassic and Superserver characteristics
1. Nbackup parameters
2. Access required
1. Data Types Conversion Table
2. Migration Tools
3. Replacement Tools
1. Operations on null entities A and B
2. Boolean operations on null entity A
3. Results for “A [NOT] IN (<list>)”
4. Results for “A <op> ANY|SOME (<subselect>)”
5. Results for “A <op> ALL (<subselect>)”
6. NULLs placement in ordered columns
7. Aggregate function results with different column states
8. Adventures table
9. Result set after adding a NOT NULL column
10. Result set after adding a CHECKed field
11. Testing (in)equality of A and B in different Firebird versions
Firebird Documentation Index
Firebird Documentation Index