Firebird and Ruby on Rails
On Firebird-tools Pierre Yager asked about Firebird Ruby ActiveRecord Adapter
Does any one knows any project on maintaining an ActiveRecord-Firebird-Adapter?
On Firebird-tools Pierre Yager asked about Firebird Ruby ActiveRecord Adapter
Does any one knows any project on maintaining an ActiveRecord-Firebird-Adapter?
It’s a common question with interesting background from developers . As I can suppose from IBSurgeon statistics, 99% of Firebird and InterBase developers use default page size: since the old ages it is 1024 bytes, and only for Firebird 2.0 it is changed to 4096 by default. There are 4 main things related with page size: indices depth, database cache size, records per page quantity and disk cluster size.
The shortest answer to this question is to use 4k, 8k or 16k page size. That’s it.
If you want to go a bit deeper, keep reading…
The DDEX Provider v2.0.4 for Visual Studio has been released. Download it from
http://www.firebirdsql.org/index.php?op=files&id=netprovider.
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
Article in Sinática blog talks about architectural differences between SQL Server and Firebird.
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!