en
brБиблиотека
Below you can find articles, guides, and other materials devoted to Firebird performance, recovery, configuration, hardware, migration, encryption, etc
Feel free to contact us if you see any mistakes or other problems.
Feel free to contact us if you see any mistakes or other problems.
Contents
- Performance
- Recovery
- Encryption of Firebird databases
- Hardware & Cloud
- Backups
- Troubleshooting
- Installation and Configuration
- Migration
- Basics (data types, tables, generators, indices, views)
- Useful pieces around Firebird: tips, tricks, jokes, and how-to
- IBSurgeon Tools Guides
Performance
- Short Firebird database performance checklist (!)
- 23 More Ways To Speed Up Firebird (!)
- 45 Ways To Speed Up Firebird Database (!)
- Optimized Firebird configuration files (!)
- How to make Firebird work 20% faster on Windows Server 2016 in less than 1 minute
- Using prefix date to speed up queries with DATE columns
- How to make Firebird consume a lot of memory?
- Negative impact of indices to INSERT, UPDATE and DELETE performance in Firebird SQL
- nbackup with switch -D ON does not work on ZFS
- Simple INSERT/UPDATE/DELETE test (!)
- Quick estimation of disk speed with backup
- Firebird OLTP-EMULator
- Firebird performance degradation: tests, myths, and truth - 1.7Tb, part 1
- More details about 1.7 Terabyte Firebird SQL database - 1.7Tb, part 2
- Tuning 1.7 Terabyte Firebird SQL database - 1.7Tb, part 3
- 1 Tb Firebird database: a preliminary report
- Optimization service: description, fees, details
- Questionary: Required information for Firebird database performance optimization
Recovery
In case of a heavy corruption Light corruptions, and general information about corruptions and their fixing- How to repair a corrupt Firebird database? (!)
- Short explanation of gfix.exe output (!)
- How to find and delete duplicate records in Firebird database
- "Cannot commit index" or how to pump data from partially restored (inconsistent) database (!)
- Fighting Petya: our experience with retrieving data from the Firebird database files encrypted by ransomware crypto-viruses
- Common InterBase/Firebird errors caused by corruptions and their recovery chances
- How to protect Firebird databases from ransomware?
- Internal gds software consistency check - full list of serious Firebird/InterBase errors
- How to check RAM and avoid database corruptions
- How to quickly check RAM on Linux
- Internal gds software consistency check - how to recover Firebird/InterBase databases (2014)
- InterBase and Firebird Recovery Guide (chapter from "The InterBase World" book)
Encryption of Firebird databases
- How Firebird Database Encryption Works
- Demo package with sources and step-by-step instructions of Firebird database encryption plugin
- Connect to encrypted database with developer tools
Hardware & Cloud
- Choosing the best AWS EC2 instance for the maximum Firebird write performance
- Firebird Hardware Guide (!)
- How to install Samsung NVME SSD disk driver on Windows Server
- Fast, Furious, and Cheap: server with good-enough performance for small business database for less than US$1000 (deprecated)
Backups
Troubleshooting
- How to configure Firebird crash dumps collection on Windows
- Errors in Firebird.log
- How to crash Firebird server
Installation and Configuration
- Installing Firebird 3 on modern Linux versions: CentOS 8 and Ubuntu 19 (!)
- How to use instreg.exe and instsvc.exe (command line tools for Firebird installation on Windows)
- How to make Firebird 3 connect like 2.5 with embedded connection string
- How to enable or disable connection protocols for Firebird on Windows
- How to enable Firebird to work through network protocol at CentOS 6.x
- fb_lock_print parameters explained
- Firebird 3 Setup Command line parameters
- Firebird 3 Database Server installation
Migration
- Short Firebird 4 Migration Guide (in PDF)
- Fast conversion of Firebird 2.5 databases to Firebird 3.0 (!)
- Testing application’s queries (the excerpt from "Migration Guide To Firebird 3")
- Differences between Firebird and InterBase
- All Firebird and InterBase On-Disk-Structure (ODS) versions
- How to migrate (copy) users from security2.fdb (Firebird 2.5) to security3.fdb (Firebird 3.0)
- List of known incompatibilities between Firebird v 2.x and 30
- List of known incompatibilities between Firebird 2.x and 2.5
- Migration service (!)
Basics
- Data types
- Tables. Primary keys and generators
- Database constraints in Firebird and InterBase
- Indices (InterBase and Firebird)
- Views (InterBase and Firebird)
- Database physical structure (InterBase and Firebird)
Useful pieces around Firebird: tips, tricks, jokes, and how-to
- Firebird Stored Procedure to split line with delimiters to recordset
- Firebird 3.0 users with the same names but different passwords (!)
- How to "inflate" Firebird database with temporary blobs (!)
- How to estimate number of records in the table using statistics value of the unique index
- How to execute SQL command with isql in command prompt
- How to determine Firebird architecture with SQL query? (!)
- How to put 29 characters into VARCHAR(10)
- Built-in Firebird 3.0 functions (SDF aka Server Defined Functions)
- All issues of "The InterBase and Firebird Developer Magazine" (!)
- Firebird Conference 2014 report
- Firebird GUI Tools
- Firebird 2.5: Autonomous Transactions
- Alias handling and ambiguous field detecting in Firebird 2.0
- Firebird Index Structure for Firebird 2.0 (ODS 11 and higher)
- The differences between VARCHAR and INTEGER fields in keys
- Space allocation in Firebird 2.1 and higher
- Fixes in Firebird 2.5 regarding connection string charset
- Maximum table size in InterBase (before version 2009)
- Firebird 2.0 garbage collector
IBSurgeon Tools Guides
- HQbird User Guide (and in PDF)
- FirstAID Recovery Guide: English, Russian, Portuguese
- FBScanner User Guide (outdated): English, Portuguese