The Firebird Book

The Firebird Book: A Guide for Database Developers is a comprehensive, practical guide for developing client/server FirebirdSQL database applications for small and large networks of users. FirebirdSQL is an open source database, and while not as popular as MySQL or PostgreSQL, it has a dedicated following, and has far more advanced features.

Ur innehållet:

From the contents: Introduction to Firebird.- Part I: Firebird Boot Camp: 1: Installation; 2: Network Setup; 3: Configuring Firebird; 4: Operating Basics.- Part II: Understanding Client/Server: 5: Introduction to Client/Server Architecture; 6: Firebird Server; 7: Firebird Clients.- Part III: Data Types and Domains: 8: About Firebird Data Types; 9: Number Types; 10: Date and Time Types; 11: Character Types, BLOBs, Arrays; 12: Domains.- Part IV: A Firebird Database and its Objects: 13: From Drawing Board to Database; 14: Creating and Maintaining a Database; 15: Tables; 16: Referential Integrity; 17: Indexes; 18: Views and Other Derived Tables; 19: Types of SQL Statements; 20: Queries; 21: Expressions and Predicates; 22: JOIN Operations; 23: Ordered and Aggregated Sets; 24: Union Queries.- Part VI: Transactions and Concurrency: 25: Overview of Firebird Transactions; 26: Record Versions, Concurrency and Isolation Levels; 27: Programming with Transactions.- Part VII: Programming on the Server: 28: Introduction to Firebird Programming; 29: Developing PSQL Modules; 30: Stored Procedures; 31: Triggers; 32: Error Trapping and Handling; 33: Events; 34: External Code Modules.- Part VIII: Security: 35: Security in the Operating Environment; 36: Server Protection; 37: Database-level Security.- Part IX: Tools; Summary of Firebird's Command-line Tools; 39: Database Backup and Restore (gbak); 40: Housekeeping Tool (gfix); 41: Server Statistics Tools.- Appendices: SQL Statement and Function Summary; Migrating to Firebird; Implementing Auto-incrementing Keys; Solving Network Problems; Appendix V Application Interfaces.