Materialized views in Firebird: store the pre-calculated result of a query instead of running it every time. See in this video MV's syntax, refresh options and an example running 95x faster.
Check out new versions and new tools for Firebird: Plamenix 1.0.0 beta, BeeKeeper Studio, RdbExpert 2026.8
Watch part 2 of the video on common SQL query optimization mistakes in Firebird
Watch part 1 of the video on common SQL query optimization mistakes in Firebird.
Summer is fading, but it’s still hot — and we’re already moving into an intensive autumn season. Click to see updates on drivers and several other interesting projects.
Jaybird 6.0.6 and Jaybird 5.0.13 have been released
Digest of Q2 2026 Firebird news: Firebird minor release and more
We’re pleased to announce that the new edition of EmberWings Magazine (2026/2) is now available to all Firebird supporters. [read more..]
New article "Using UUID in Firebird" by D. Simonov covers practical approaches to working with UUIDs in Firebird without core modifications. Topics include storing UUIDs as BINARY(16), generating them via GEN_UUID(), converting between binary and character forms, UUID v4 vs v7 comparison, index efficiency analysis, and Firebird 6.0 improvements. A must-read for developers designing distributed-friendly primary keys in Firebird databases.
The second edition of must-have book for Firebird SQL database developers who want to use the full potential of Firebird 5.
