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
After a long struggle on Devshed forums I decided to try on my own, after all I know Firebird and don’t see why it and ColdFusion can’t play nice together … infact they did, and easily.
Firebird 2.1 added the long-awaited monitoring tables. By querying special system tables starting with MON$, you get a snapshot of the current activities in your database like who is connected to your database, which transactions and statements are running and so on. You even can cancel a running query by executing a DELETE statement on MON$STATEMENTS. Firebird 2.5 will also allow you to cancel an entire attachment via a DELETE on MON$ATTACHMENTS.
VVV is an application that catalogs the content of removable volumes like CD and DVD disks for off-line searching.
Folders and files can also be arranged in a single, virtual file system. Each folder of this virtual file system can contain files from many disks so you can arrange your data in a simple and logical way.
Other than CREATE USER something really valuable has been added, the ability to query other databases.
