Category: Blogroll

Timeout records – Feature request

Leave a comment

For several years now, I’m yearning for a feature that I think that all SQL based databases that I know are missing, and throw it back to the program side.

The feature I wish to have is a way to set a specific record to be valid for only a known period of time, and when the time is up, I’ll be able to do something.

In this post I’ll try to create some sort of general specification for such feature, and I hope that there will be many comments on this that will benefit everyone, and I hopeful, that they will make the idea better.

Firebird: choosing an owner for database deployment

Leave a comment

Like most users when I started using Firebird I connected using the SYSDBA username. That is the default username for server administration: every server has it.

It looked like a good idea because I did not have to care with users management, but I have now realized that using SYSDBA for database development can cause problems when the database is deployed to the customer’s computer.

Read the rest on Accounting++ blog

We are currently preparing to release Firebird 2.0.7

Leave a comment

From Paul Beach’s Blog:
We are currently preparing to release Firebird 2.0.7, since I take responsinility for the Mac builds, I did a 2.0.7 build on MacOSX 10.7 using the development tools installed by XCode 4.1 (gcc 4.2.1 etc). I set up the relevant environment variables for this older 32bit only build CFLAGS, CXXFLAGS, LD_FLAGS and also set the MACOSX_DEPLOYMENT_TARGET=10.4. The builds completed without any problems, some simple tests on MacOSX 10.7 showed no problems.

Now – Imagine my surprise when Philippe told me that when he tried to QA the builds on MacOSX 10.5 we got this error on SuperServer startup.

Firebird speed RUBY vs DELPHI vs .NET

Leave a comment

From http://ramsees.blogspot.com:

I did some comparitions selecting 1000, 10000 and 100000 with Ruby Fb gem, Delphi Fibplus and the FB .NET driver, here is the result:

ROWS RUBY DELPHI .NET
1000 0.12 0.47 0.09
10000 0.94 0.48 0.53
100000 10.95 3.79 5.53

The results are on milliseconds, the table is from a production database with 40 fields and about 3 million records, as you can see, native code is still the king, .NET result are quite good, but Ruby is quite dissapointing handling lots of data.

Firebird Roadmap updated for January 2012

Leave a comment

This document states the current development activities of the project and establishes the estimated release schedule for the foreseeable future. It’s getting periodically updated in order to be in line with the reality.

The project’s development resources are currently dedicated to the v2.5 and v3.0 versions, with v2.0 and v2.1 versions being maintained on the regular basis.

As notified earlier, the v1.5.x series is not being released anymore. Firebird 1.5.6 was the last release of that series officially published by the project. However, its codebase may still collect some bugfixes occasionally backported from the newer versions. Any subsequent binary releases, should they be necessary, would be available from IBPhoenix on a commercial basis.

Please pay attention that the v2.0.x series celebrates its sixth anniversary this year. So far the project maintenance practice was to discontinue support for the release series older than five years. Thus please be prepared that the next point release (v2.0.7) could be the last one published by the project in that series.

For more details about the anticipated releases, read on.

1 … 9 10 11 12 13 … 48