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

How to give 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

Setting up Firebird on Ubuntu Linux

Setting up Firebird on Ubuntu Linux

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

Firebird Password File Utility

Introduction

Commandline Options

Gsec Commands

Interactive Mode

Batch Mode

Running Gsec Remotely

Gsec caveats

Firebird Database Housekeeping Utility

Introduction

Command Line Options

Gfix Commands

Shadow Files

Set Database Page Buffers

Limbo Transaction Management

Cache Manager

Changing The Database Mode

Setting The Database Dialect

Database Housekeeping And Garbage Collection

Database Startup and Shutdown

Database Page Space Utilisation

Database Validation and Recovery

Database Write Mode

Version Number

Caveats

Firebird Backup File Splitting Filter

Introduction

Gsplit Command line Options

Gsplit Command Parameters

Splitting Backups

Joining Backup Files

Firebird Shell Scripts

Introduction

ChangeDBAPassword

CreateAliasDB

Fb_config

ChangeRunUser

RestoreRootRunUser

ChangeGDSLibraryCompatibleLink

Firebird Backup & Restore Utility

Introduction

Command-line Options

Backup Mode

Restore Mode

Security Of Backups

Backup & Restore Recipies

Gbak Caveats

Firebird Superserver Manager

Introduction.

Linux Systems.

Windows Systems.

Fbmgr Caveats