Choosing a File System on Linux for Firebird
Philippe Makowski wrote a nice article comparing the performance of Firebird database on different linux file systems.
Don’t believe benchmarks made by someone other than yourself !
Read it here.
Category: Technical Articles
Technical articles, How-tos, guides, etc.
Get Started with #QT and #Embedded FireBird
This article is the description of the first steps in setting QT, Visual Studio and FireBird.
Firebird SQL and Web Traffic Analysis with Delphi
Whether you want to learn how to efficiently import data into Firebird, or you wonder if it is worth upgrading to Delphi 2010 for “routine” tasks, this article will give you some food for thought.
In particular, this article explores the use of Delphi and the open-source relational database system named “Firebird SQL” to load and analyze web traffic logs. Along the way, the size and performance of EXEs compiled with Delphi 7 versus Delphi 2010 are compared, plus the speed of Firebird 1.5 versus Firebird 2.1 and four common Firebird data access components are measured.
Read full article here.
Java procedures in Firebird – how it was done, how it works
Adriano (Firebird Core Team member) published a document (sorry, only in Portuguese) describing how he developed the integration between Java and Firebird, allowing people to write procedures and triggers in Java.
Link updated on 1-dec-2023
Firebird 2.5 new features in ActiveDelphi #portuguese
Firebird 2.5 new features in portuguese
Issues 68 and 69 of ActiveDelphi
Via Sinatica’s tweet
Firebird database-corruption and what you can do about it
There are usually only two reasons why a database can be corrupted in Firebird: 1) You copied the fdb-file while the Server was accessing it and 2) You don’t have forced writes enabled and the server shut down unexpectedly (e.g. power-outage)
Database recovery is done in four steps. Here’s how you do it:
#RIP #Dudley #GDML in Firebird 3.0 – #Sql won
Dudley – Sounds like DDL (data definition language) and is the pre (interbase) 4.0 data definition utility GDEF. It’s actually named after Dudley Doright, a character from Rocky and Bullwinkle. GDEF accepts a data definition language based on GDML.
Full thread on Firebird-devel list
Another definition on original source code description (interbase 6.0)
DDL utility. Interpreted commands in the old data definition language (declare relation, declare field – square brackets where you want to put parentheses). Generates BLR for views and triggers, GDML (non-SQL relational language) for metadata updates.
Switch between versions of Firebird SQL Server
Pierre Yager posted in his blog an interesting Windows script (aka. bat file) to easily switch between different versions of the Firebird server. Check it out.
Firebird in OSDB Magazine
The next issue of Open Source Database Magazine is now available. This information-packed issue has over 60 pages of information including:
- Firebird’s Road Trip and What’s New with 2.5
- Coding Corner: Trees – Where’s the Performance?
- PostgreSQL’s tsvector: Secret Sauce for Search Engines
- The Lab: The XtraBackup Program for MySQL – Part Two
- Drizzle – A Lightweight Database for the Web
- Kontrollbase: Enterprise grade MySQL monitoring and analytics
- Creating a Twitter Mashup with MongoDB
- Introducing LucidDB
Read more.