Some last database repair cases we did were with multi-file databases. Interesting, that latest InterBase and Firebird versions was used, and also file system for the storage was NTFS, not FAT32 and FAT16. But, the databases was created and maintained using 1 gigabyte files.
[ED: seems that is better to put the database on an good file system and in an single file ]
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.
On Firebird-tools Pierre Yager asked about Firebird Ruby ActiveRecord Adapter
Does any one knows any project on maintaining an ActiveRecord-Firebird-Adapter?
Mario H. Cornejo wrote in his blog about creating domains in Firebird 2.1
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
The Firebird 2.1.1 packages are now in ppa for Ubuntu Dapper, Gutsy , Feisty , Hardy and Intrepid Ibex
The guide for installing is located in the ubuntu wiki
Also there is an released version in debian experimental
It’s an recomended update if you are still using firebird 2.1.0
Here is the tutorial with screenshots in French , but from images you can follow the lazarus wizzards and it should be ok in any language
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!
The list of open issues for Lazarus 0.9.26 is getting smaller by the day. Most are fixed. Some are re-targeted to 0.9.28, if we estimate it takes too long fix them now. Some are re-targeted to 1.0.0, if closer inspection turns out the bug is not a regression.
The Free Pascal team is pleased to announce that version 2.2.2 is
released and available for download for all major platforms
A list of major changes is available Here.
