Posts about softwares and people currently using Firebird as database engine
I started to implement a DBX4 Driver for Firebird 1, 1.5, 2 and 2.1, it is for Delphi 2007 and 2009, open source and all code is done with Delphi it self.[ED:Please Send any questions/ideas]
Regards,Cesar Romero
http://blogs.liws.com.br/cesar
I’ve got a database problem.
So I’m throwing this out to the rather small readership I have here in the hopes that someone knows some SQL code or something that can help us out.
Say you want to randomly select your employee of the month, but not so randomly, better, you’d like to give your best employees a bigger chance to be selected based on their rating.
This is just an example, you could be randomly displaying ads from your customers, but giving an higher chance to be displayed to those who are paying more, there can be a million other example, but I hope you got the sense of this.
How to put firebird and dotnet framework on small windows machines (based on pentium @233Mhz)
Part 1 http://vault-co.blogspot.com/2008/08/98lite-megacheap-embedded-windows.html
and Part 2 http://vault-co.blogspot.com/2008/08/nano98-windows-in-7-seconds-45.html
While on vacation I’ve been working on a pet-project that has been around for many years now. The service is a mobile device chat and is powered by Firebird and PHP.
There used to be lots of problems handling more than 400 simultaneous users, but after a DB upgrade to Firebird v2.5 Alpha 1 things really look different.
If there were statistics on corrupted Firebird databases, I believe more than 80% of them would have something in common: they were running with forced-writes off.
Since Firebird 2.1 forced-writes also work in linux. With that in mind I put together a comparison between the two modes.
What are forced-writes and when to use them?
I hope DBAs who like to live dangerously find this useful.
For those tired of maintaining separate code bases for Web and desktop applications, Servoy offers a way to consolidate those code bases and cut development time in half.
Servoy apps can access many different databases, including Firebird.
More information here.
In the last post I commented that I had a test-bed application, based on Apache, PHP and Firebird, and once the problem with the images was solved I could finally start doing the actual performance testing/tuning that I originally wanted to do.
The only major changes from the last post is that I’ve now upgraded the database engine to the “Firebird v2.5 Alpha 1” that supports SMP, and that the application now contains more base data in the tables.
The application was a test-bed app that uses the FireBird SQL database to handle sessions and dynamic data, all on the same machine. [Performance Tip :Seems that you need to put KeepAlive Off on apache to server many images and too many clients :If you have more clients than available apache children, KeepAlive settings will hurt overall performance and should be turned off.]
