Firebird Docset → Firebird Database Docs
Firebird home Firebird home Home: Firebird DocsetUp: Firebird DocsetNext: Firebird 2 Quick Start

Firebird Database Documentation


Table of Contents

Firebird 2 Quick Start Guide
About this guide
What is in the kit?
Classic or Superserver?
Default disk locations
Installing Firebird
Server configuration and management
Working with databases
Preventing data loss
How to get help
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 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 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
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
Testing for NULL and equality in practice
Summary
Alphabetical index
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
Coexistence of Firebird 1.5 and InterBase 5.6 or 6.0
Introduction
Running Firebird and InterBase together
Afterword
Firebird's nbackup tool
Introduction
nbackup features - an overview
Making and restoring backups
Locking and unlocking
Setting the delta file

List of Tables

1. Firebird 2 Classic Server vs. Superserver
2. Firebird 2 component locations on Linux
3. Firebird 2 component locations on Windows
1. Firebird 1.5 Classic Server vs. Superserver
2. Components of the Firebird 1.5 installation
1. Firebird 1.0 Classic Server vs. Superserver
2. Components of the Firebird 1.0 installation
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. NULL placement in ordered sets
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
1. Data Types Conversion Table
2. Migration Tools
3. Replacement Tools
Home: Firebird DocsetUp: Firebird DocsetNext: Firebird 2 Quick Start
Firebird Docset → Firebird Database Docs