Category: Technical Articles

The following patch was applied that allows to open databases on network shares in Windows using RemoteFileOpenAbility parameter in firebird.conf

Patch allows remote shadows as well and it will be implemented in 2.5 RC 1

Yes, it does. Creating shadow copy on network share (SMB) mounted as
local disk was succesfull.

Wings of Wind blog just posted the results of polls about Delphi 64bits and 4GB support. In the workarounds section, he mentions Firebird:

Use the 64-bit version of Firebird configured to keep the data in memory. It has the advantage that you have a full blown 64-bit SQL server (so, no AWE paging etc.) […]

Read the full post.

From Firebird Surgeon blog:

As you know, IBSurgeon was a publisher of “The InterBase and Firebird Developer Magazine” (or shortly IBDeveloper) in 2005 and 2006. There were 4 issues which attracted a lot of interest (up to 20000 of readers) but at that time there was no way to monetize it, so IBSurgeon decided to close the magazine as a redundant line of business.

Now we’ve put all issues of IBDeveloper to Scribd for easy reading and full text search indexing. You know, there are still “all times greatest hits” articles and materials (like one regarding locking in Firebird by Ann W. Harrison in Issue 2).

Read full post and check the magazines here.

Today I needed to convert a Delphi/Pascal code to Firebird PSQL. Part of the code used the integer value of a date to do some calcs. First, I tried to use Firebird CAST to convert a Date to Integer, but FB can’t do this type of cast (anyway, I’m not sure if the result would be the same as Delphi, since I don’t know what starting date Firebird uses for internal storage). So, the solution was to create a workaround and subtract the date from 30-December-1899 (Dublin Julian Day), ie:

my_int_var = current_date – cast(‘30.12.1899’ as date);

The above line will return the integer value of the today date, as Delphi/Pascal would do. In other words, it is the number of days since 30-Dec-1899.