Firebird Database Documentation

Table of Contents

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

Introduction

What is NULL?

NULL in expressions

NULL handling in UDFs

NULL in if statements

Testing if something is NULL

Setting a field or variable to NULL

Dealing with NULLs

Summary

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