In this post I explained how to set up an embedded Firebird version for Linux.A few weeks ago I read a post from Olivier Mascia that explained a simpler way: instead of starting the program using a script that sets up a couple of environment variables, just callsetenv() to set those variables in the program.
There are many good articles in the archives about firebird and creating an accounting program with open source tools.
Here is a good howto create an Lazarus Application with Firebird Embedded and ZeosLib components .Original Article is in Portuguese
A very interesting thread about using Firebird embedded on Raw devices (SSD) , this way bypasing filesystem overhead
Engine has nearly complete support for raw disks on Windows (useful
for new SSD devices)
We found this Firebird feature useful for very fast SSD devices where
filesystem layer creates a big deal of overhead.
I need an embedded database for my next project. During the last few days I’ve done a lot of virtual leg-work researching and comparing the various alternatives, trawling through documentation and forums. The results are below. Hopefully, if you’re ever in the same situation, this list will make your life a bit easier.
Here is the full thread on nhibernat and the quote
“However, the thing that finally made us switch from SQLite to Firebird was the fact that it only support one open transaction at a time. This makes it essentially useless for multithreaded/multiuser applications. SQLite is excellent for some tasks, but if you have more than one thread/process accessing the database at the same time you really should consider using another database. ”