Category: Worth Reading

Content not direct related to FB, but interesting reading.

Firebird SuperClassic – Another option

Leave a comment

Called SuperClassic, it will be the basis for the multi-processor support that we’ll see in Firebird 3.0.

Don’t lose count. Starting from Firebird 2.5 you will be able to choose among SuperServer, ClassicServer and SuperClassic.

Basically SuperClassic is like ClassicServer. Only instead of a process for each attachment it uses a single process with a thread for each attachment. The benefit being that it uses fewer kernel resources and is a bit faster.

Read a deeper comparison between the three architectures.

Apache, PHP and Firebird Performance Tuning

Leave a comment

In the last post I commented that I had a test-bed application, based on Apache, PHP and Firebird, and once the problem with the images was solved I could finally start doing the actual performance testing/tuning that I originally wanted to do. 

The only major changes from the last post is that I’ve now upgraded the database engine to the “Firebird v2.5 Alpha 1” that supports SMP, and that the application now contains more base data in the tables.

The Darwin Race of Languages

Leave a comment

The Darwin Race of Languages is a “competition” started by Bart Roozendaal to check what programming language is better. It seems that they will choose a kind of application that need to be developed, and participants will use the language of their choice to code it, and in the end, they will choose which one is better.

Anyway, the reason I’m posting this here is that among the topics being discussed to decide what kind of application will be developed, there is a Firebird tool.

Firebird has some funny ways of handling passwords

Leave a comment

Firebird has some funny ways of handling passwords. The maximum length of passwords that is evaluated is 8 characters. Every character after the 8th is silently ignored. That’s especially funny because the ‘default’ password for a Firebird-installation is ‘masterkey’, which has 9 characters. You can, however, successfully log in to freshly installed Firebird-servers providing the password ‘masterke’.
I’m working with Interbase and Firebird for more than four years and just now realized that when a co-worker at our company found it out while learning SQL.
The only program that I know that makes note of that is gsec, which prints a warning when setting the password to something longer than 8 characters.

http://daniel-albuschat.blogspot.com/2008/04/passwords-in-firebird.html

[ED:Daniel is working on webkit based browser named arrora ]

Firebird 1.5 SQL Temporary Reference Update

Leave a comment

This guide documents the changes made in Firebird 1.0 and 1.5 SQL since the fork from the open-sourced InterBase 6.0 codebase.

Here is the Pual Vinkenoog’s announcement on firebird-docs list

Just uploaded a Firebird 1.5 SQL Update Reference to this temporary location:

This is NOT ready for publication yet, but all the entries are there and (AFIACT) correct, except maybe in one or two places where I have to contact the developers for clarification.

I’ll commit the DocBook sources to the repository and build a version for publication. After that, I’ll start working on update refs for 2.0 and 2.1. After that, I guess we must take the 2.1 ref and start expanding it to a complete Firebird SQL reference. This last step may take some time 😉

Firebird QLI scripts documentation

Leave a comment

Does someome have any links or documentation for qli.exe?

I recently used qli.exe scripts for fixing BD structure corruption as described in this article , since then and I’ve been searching for information about qli commands or scripts but it seems not to be so much information about it.

Near the bottom of this page is a download link for the qli syntax document from InterBase 3.  Qli hasn’t changed.

Update: QLI is deprecated and unsupported fore firebird > 2

 

Open Source Awards Accepting Nominations – Firebird mention

Leave a comment

Is open source software a part of your daily computing life? Now is your chance to sound off about it. Sourceforge.net, an online community that hosts open source projects, is accepting nominations for its annual Community Choice awards.

[ED:Read the rest of the article here

At the end Firebird is mentioned for the last year awards]

Firebird and Suse

Leave a comment

By philippe on Thursday 29 May 2008

Since I helped Mandriva to do their packages for Firebird, I jumped and with Michal, we made things happen
Users of Opensuse 10.0,10.1,10.3 and future 11.0 but also SLE 10 can now just use the server:database repository  and get Firebird 2.0.4
As soon as the Firebird Project will publish Firebird 2.1.1, packages will be there too.

1 … 54 55 56 57 58 … 84