Get to know FB in 2 mins – Arabic
The introductory document “Get to know Firebird in 2 minutes” was translated to Arabic by Khaled Shagrouni! You can find it here.
Category: Technical Articles
Technical articles, How-tos, guides, etc.
Howto:Building #php 5.3.x Firebird driver (php_interbase.dll) with #VC9
I have finished and updated my guide to build the Firebird (2.5) driver for php 5.3 and added some missing small steps (some include issues)
Building the #Qt FireBird #SQL driver with #MinGW on #Windows
The Qt toolkit contains many great SQL drivers and among them is also an InterBase / FireBird SQL driver. But the Windows version of the toolkit ships with SQLite and ODBC driver binaries only. The other ones have to be built by ourseleves. This article describes how to build the FireBird driver using MinGW 32bit version of Qt 4.6 for Windows.
Manuals updated and uploaded
Norman wrote on the Firebird-doc mailing list :
“I’ve just uploaded the following manuals to the firebirdsql.org doc site”
- Gfix
- Gbak
- Firebird Internals (Added to the reference Section)
- Firebird Cache (Added to the reference section)
Firebird 2.5 compliation with Visual Studio C++ 2008 ( aka #VC9.0 ) on #Windows
I have wrote the steps in compiling php_interbase.dll with using the Firebird 2.5 binaries here but if you want to debug the Firebird client dll or the engine you should follow these steps (requires full Firebird 2.5.x compilation)
If you want to build only Firebird 2.5 with a free beer compiler i have created a video where i describe and show the steps that you need to follow
Connecting to a Firebird database from a VB.net 2008 web application
There’s a couple of posts related to connecting to a Firebird database from an asp.net 2008 web application that are helpful but not complete
Here is the detailed way with screenshots but is using ODBC .
Firebird’s Big Databases Presentation (in English)
At FDD’2010 Dmitry Kuzmenko has presented 2 presentations – the first one about approach to maintain big databases (50-400Gb) in the right way and the second is about restore speed tests.
DDL Execution Architecture
Adriano posted about DDL execution artchitecture, its flaws and new improvements for FB 3.
Here I’m going to explain how Firebird DDL commands works in the architecture, why it stops innovation and how it is supposed to work in Firebird 3.0.
DDL in FB works more or less like DML, so first a briefly explanation of how DML works. When a DML command is prepared, it starts in the parser constructing a tree of nodes. That nodes are all a single pointer type, used for all node types and others usages (like storing constants). A node have a list of child nodes.
Real full post here.
Ultimate EFv4 CTP4 Code First full mapping example using Firebird
Jiří {x2} Činčura created an example with Entity Framework 4 CTP4
Let’s model some kind of simple library and try to use there couple of Entity Framework’s features. And to make things worse, try to do it with ADO.NET provider for Firebird.Good news is I succeeded. My database structure was my first and non-touchable object (to be honest the first was the idea what to create and how to represent it in database) together with the idea of objects.
Firebird Embedded in comparison to SQL Server Compact Edition 4
Scott Guthrie recently posted article about New Embedded Database Support with ASP.NET. This made me think about other options, Firebird in particular, and advantages and disadvantages. What I’m going to do is to introduce Firebird Embedded here and compare with features Scott wrote.
Read full post at Jiri Cincura blog.