Introduction 2 Chapter 2. Generator Basics 2.1. What is a generator? Think of a generator as a “thread-safe” integer counter that lives inside a Firebird database. You can create one by giving it a name: server side, after you send the Insert statement from the client. This plainly means there is no safe way to know from the client side which ID was generated for the row you just inserted. You could from the “outside”. Although this can be very handy, it has a strong limitation: it’s not multi-user safe. If the SP would run simultaneously in two transactions, they would mess up the progress generator

how to back up a database in two quite different ways and how to switch the database to the “copy-safe” mode for performing an external backup safely. 5.1.1. CREATE DATABASE Used for Creating a new file delta that stores any mutations to the database file after it has been switched to the “copy-safe” mode by the ALTER DATABASE BEGIN BACKUP statement. For the detailed description of this clause, 1.2. ALTER DATABASE Used for Altering the file organisation of a database or toggling its “copy-safe” state Available in DSQL — both functions. ESQL — file reorganisation only Syntax ALTER {DATABASE

access rights to the database file. Local connections On Windows, both architectures now support safe and reliable local connec- tions, with only the server process requiring access rights to the database Install Superserver first; • Copy the applet Firebird2Control.cpl from the Windows system folder to a safe place; • Uninstall Superserver; • Install Classic; • Copy the applet back to the system directory longer different in Firebird 2. Also changed the row on local connections: CS and SS now both allow safe, reliable local connections on Windows. Added row on Guardian. Prepended a column with feature names

make direct local connections, but these are not as fast as the “Classic” ones on Linux and also less safe. Server must run as root. This poses a risk if the server were to be hacked or contained a severe Superserver, without using the TCP/IP loop- back. This is not a TCP/IP connection and it is not a thread-safe way to connect to a local server. For using single instances of the command-line tools (gsec, gbak contrast, direct database connections - even multiple - under a Linux Classic server are completely safe. Firebird 1.0 Quick Start Guide 11 Default user name and password The SYSDBA user has all privileges

how to back up a database in two quite different ways and how to switch the database to the “copy-safe” mode for performing an external backup safely. 5.1.1. CREATE DATABASE Used for Creating a new file delta that stores any mutations to the database file after it has been switched to the “copy-safe” mode by the ALTER DATABASE BEGIN BACKUP statement. For the detailed description of this clause, 5.1.2. ALTER DATABASE Used for Altering the file organisation of a database, toggling its “copy-safe” state, managing encryption, and other database-wide configuration Available in DSQL, ESQL — limited

• Alternatively, incorporate the date (and time?) in your backup filenames. • Keep backups in a safe location on the server. Storing backups in a location with restricted access helps reduce the chances your backup files 'escaping' into the wild. • Keep tape copies of your backups very secure. A locked safe or off-site location with good security is advisable. The off-site location will also be of use after

its declaration to see how values are passed and returned. If it says “by descriptor”, it should be safe (though it never hurts to make sure). Ditto if arguments are followed by a NULL keyword. In all other until now it works in practice, this may not be the case in future versions. It’s better to stay safe and use the SQL given above. 15.2.2. Adding a CHECK constraint to an existing column To add a CHECK

записываться изменения, внесённые в БД после перевода её в режим «безопасного копирования» («copy-safe») путём выполнения команды ALTER DATABASE BEGIN BACKUP. Полное описание данного параметра см. в ALTER записываться изменения, внесённые в базу данных после перевода её в режим «безопасного копирования» («copy-safe»). Этот оператор в действительности не добавляет файла. Он просто переопределяет умалчиваемые имя Предложение BEGIN BACKUP предназначено для перевода базы данных в режим «безопасного копирования» («copy-safe»). Этот оператор «замораживает» основной файл базы данных, что позволяет безопасно делать резервную

о генераторах 2.1. Что такое генератор? Думайте о генераторе, как о “потокобезопасном” (“thread-safe”) целочисленном счетчике, который расположен внутри базы данных Firebird. Вы можете создать его,

1.5’s version of gsplit, using it to split a backup file is pointless. Use the gbak method to be safe. Chapter 4. Splitting Backups 6 Chapter 5. Joining Backup Files Had the above backup actually