Know your server
Article in Sinática blog talks about architectural differences between SQL Server and Firebird.
Technical articles, How-tos, guides, etc.
Article in Sinática blog talks about architectural differences between SQL Server and Firebird.
To blob or not to blob… good question!
I guess if you develop data intensive applications dealing with large files at some point, you’ve thought about it at least once: should I put my data files inside the database or should I write them directly to disk?
Ok, so here’s my point:
storing files in Firebird is faster than writing the same files on the filesystem!
Mario Cornejo talks about the Windows Authentication feature introduced in Firebird 2.1 in his blog. With this feature, you can login to your database using a Windows user.
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.
See how to set up Mondrian (Open Source OLAP server) to be used with Firebird, in Thomas Steinmaurer’s Blog
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