I Spent a lot of time online searching for a embedded database that can be used with any kind of application regardless of platform and technology. And you all can guess that SQLite is the best option for the purpose. But there are some other options as well for instance firebird. This firebird has also server package and has sp and trigger facility with is a big plus. Bellow a short description is given and taken from there home site.
“Firebird is a relational database offering many ANSI SQL standard features that runs on Linux, Windows, and a variety of Unix platforms. Firebird offers excellent concurrency, high performance, and powerful language support for stored procedures and triggers. It has been used in production systems, under a variety of names, since 1981.
The Firebird Project is a commercially independent project of C and C++ programmers, technical advisors and supporters developing and enhancing a multi-platform relational database management system based on the source code released by Inprise Corp (now known as Borland Software Corp) on 25 July, 2000.
FREE LIKE A BIRD. Anyone can build a custom version of Firebird, as long as the modifications are made available, under the same IDPL licensing, for others to use and build on.
FREE LIKE FREE BEER. No fees for download, registration, licensing or deployment, even you distribute Firebird as part of your commercial software package.
Firebird's development depends on voluntary funding by people who benefit from using it. Funding options range from donations, through Firebird Foundation memberships to sponsorship commitments.
Choosing Firebird and saving or making money by your choice? Show your appreciation and encouragement by contributing money in proportion to these benefits.”
No database is popular unless you have good management studio and administration facility for developers as well as database administrators. But unfortunately after spending few minutes in google I found no good free management studio for it. “EMS SQL Manager for InterBase/Firebird” is a commercial and trial ware that can be used to administer that firebird database. Bello a screen shot is given.
But we can use ado.net provider and leverage visualstudio data feature to work with firebird easily. Hope to write more about firebird in future.