Milliseconds are now stored in the timestamp KInterbasDB + Firebird
David Rushby (the autor of the KInterbasDB) has
solved the problem applying such a feature in the code. Thank you David.
Category: Technical Articles
Technical articles, How-tos, guides, etc.
Firebird and Multi Version Concurrency Control – why is so good
Spotted on dotnetfirebird blog
A nice white paper by Roman Rokytskyy that describes the multi version concurrency control system used in Firebird in comparison to IBM DB2 and Oracle 9i.
I found this quote on the Hibernate Tuning blog: [Ed:They linked to the Roman’s Page , Scroll down to “db2 and friends”]
In fact glaring are the benchmarks published by MySQL. I’d put to you that MVCC support is probably more important than a lot of other concerns in transactional computing (as opposed to batch processing and OLTAP type stuff)
Backup Firebird Databases
There are to different backup Systems in Firebird:
nBackup included in Firebird 2.0 an up
and gBak included in Firebird since humm, good old Borland days back in 199x up to the (still in beta) Firebird 2.0.
When you dont want to struggle with the commandline switches of gbak, you can use the (very useful) GUI-Frontend for gbak developed and provided for free by Talat Dogan: FIBS Firebird-Interbase Backup Scheduler
Read more on this blog
Jim Starkey: Introducing Falcon (Storage Engine for MySQL)
Last session of the MySQL UC is Jim Starkey giving an introduction to the new Falcon storage engine. Jim is an icon in the database field, was the creator of MVCC and the BLOB data type. There’s a can of Falcon beer for anyone who asks a good question.
Read the Falcon intro
[Ed :When i read the word Falcon i always associate it with Millennium Falcon, Yes Jim is fighting a good cause against evil empire ;)]
Firebird used at siemens.com
Firebird seems to be used in embedded area at siemens (amd mips processors) .
You can follow the mips porting thread on sf.net
Common Firebird Errors and Firebird .NET Provider Exceptions
When working with Firebird in .NET I’ve been collecting Firebird errors and exceptions and their causes. It saved me a lot of time because the exceptions usually came again… I’m sharing my list here – if you have something to add don’t hesitate and add a comment.
Building Firebird 1.5.3 with gcc 4 – patches
All patches applied to the debian package of firebird are available on
[1]. The ones you’re looking for are gcc4.dpatch and gcc4+amd64.dpatch
Deploying the ASP.NET application which is using Firebird .NET Data Provider (with design-time support)
A few days ago I was trying to deploy my web app, which is using Firebird .NET Data Provider with design time stuff too. There was some problem with this, so I’ve created small how-to.
Here is the link: http://blog.vyvojar.cz/jirka/archive/2006/04/22/7975.aspx
Using Firebird with SME Server 7.O (an modified version of Red Hat Enterprise Linux)
Here are the instructions to run firebird on SME Server
Creating Firebird database programatically (C#/.NET)
After the “Creating Firebird database programatically (Delphi)” post I’ve created the “Creating Firebird database programatically (C#/.NET)” example.
You can find it on http://blog.vyvojar.cz/jirka/archive/2006/04/20/7968.aspx.