Category: Worth Reading
Content not direct related to FB, but interesting reading.
Timeout for wait transactions in FirebirdClient
rfc: TRUNCATE TABLE in Firebird
Vlad Khorsun posted on Firebird-Architect
One of the often task in ETL applications is to quick erase all data in some table(s). Often amount of data is big or huge (tens of millions records). In Firebird we have two choices currently – DELETE all rows or RECREATE TABLE. Both have its own drawbacks. DELETE produced a lot of record versions to clean up, its slow as works row-by-row basis and fire triggers which is almost always is not needed. RECREATE is free from this drawbacks but it will fail if there is dependencies and all related objects such as triggers, indices, constraints must be recreated too. Read more
Firebird and MSVC8 run-time. Again
Vlad Horsun wrote on Firebird-Devel list
After reading MSDN articles about assemblies, side-by-side installation,
context activation API, etc, i think i have an idea how we can avoid (in most
cases) requirement to install MSVC8 runtime via Windows Installer and just
deploy it with our binaries. Read more
Is Firebird poor?
Dmitry Kuzmenko posted the continuation of his first post about Firebird in his blog. Check it out.
What is Firebird?
Dmitry Kuzmenko has an interesting post in his blog that tries to describe what is the “Firebird Project” and “Firebird Foundation” (as well its papers in the whole thing). Also, it has some interesting statistics about downloads and installations, ie:
…But it stands more than 5000 visits every day and log more than 1000 installations at Windows platform per day (!), according to the statistics of the installer’s ‘landing page’. Also there are more than 1 mln downloads of all Firebird installers and other files per year from the sourceforge.
Read the full post.
Firebird on Solaris10 and Sun T2 build is completed
Installing and libdbi abstraction layer for Firebird c api
If you wish firebird C api were simpler to use similar to dbi api that is used in the perl world
then now you can with the help of libdbi and it’s nice C api , Here is my howto install such an abstraction layer over the standard Firebird C api.
Here is how the libdbi example should look for firebird
Patch for DotNet Provider 1.7 to connect against Firebird 2.1
Attached is a patch file ( a ZIP file with extension changed , you should rename it from piz to zip ) with
changes to allow v1.7 of the provider to connect against Firebird 2.1,
changes has been done by backporting 2.5 svn sources to the v1.7 sources.
[ED: soon there will be an v1.7 release that will integrate this patch]
Building Firebird 2.1.x with Mingw compilier
Here is my how Firebird 2.1.x can be build with Mingw(g++) compiler on windows or wine
This in case you like and the gcc tools on all platforms (Linux, Windows, Macosx, Unix ..)