We are proud to officially announce the release of the ZEOS DBO Library 6.6.3 – stable
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.
This tutorial will walk you through the creation of a simple blog application. We’ll be getting and installing Cake, creating and configuring a database, and creating enough application logic to list, add, edit, and delete blog posts.
What is needed : Firebird ,Ubuntu , Nginx and Php but it should work with any other server (apache, lighttpd)
This is an howto create your own ubuntu live cd with firebird/ubuntu and custom applications ,in guide ubuntu variation used was Xubuntu (is smaller and can be customized easier ) but it works for any hardy release
If you get this message in firebird.log
Fatal lock manager error: semaphores are exhausted, errno: 1
It means that you sould try to increase semaphores count in firebird.conf.
FirebirdConfig is free and provides you with a friendly user interface in order to configurate the firebird operation modifying the firebird.conf file with the most intuitive and functional graphic form
Server generated values – not only autoincrements are very useful think. Entity Framework supports two types “Computed” and “Identity”. When you update or insert entity, these fields are automatically refreshed according to state in database (after calling SaveChanges). For more info look at StoreGeneratedPattern.
How to use a Rails App with Firebird DB 1.5 encoding: NONE and with accents
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.
Google led me to a comparison sheet about PostgreSQL and Firebird by AMSoftwareDesign, as it looks a bit outdated I decided to add some infos about the latest Firebird release, see it in action
