Case Study: Moscow City Hospital

Take a look at the new case study published in the FirebirdSQL site. Interesting that they choosed Firebird over Oracle, and cost was not the only factor. Worth reading!

There are other case studies published in the site. Make sure to read them all, and if you have an interesting case to show, contact the moderator to know how to publish it there.

Next step for world domination : Do you think that Firebird should create new documentation ?

Since Intebase 6 release of the source code, Firebird created a lot of changes and additions to the engine.

The only updates that we see today, are small references for new or changed features for specific version.

Further more, the time has changed, and wiki, and other format of documentation should also be in place, including the ability of users to comment and even share how to things in the proper page.

So what do you think on this ?

Status of PHP PDO_Firebird as of May 2011

Working both with Firebird SQL and PDO (but not yet at the same time) I am interested in the combination of both.
According to the documentation the extension is still in experimental status, but I was still curious about how far it has progressed. I decided to redo the experiments Lorenzo Alberton did in an article in 2006.

I performed these tests on PHP Version 5.3.6 with Firebird 2.5 on a Windows 7 machine.

http://www.gn0s1s.nl/?p=108

 

Firebird nagios plugin written in #python

At work we use a lot of Firebird databases, and so far our system admins checked the availability of a Firebird Database by simply trying to connect via telnet to the port 3050 and see if they would get a response. With this kind of check you can’t really determine if the database is really up and running,

Therefore they asked me if I could write a plugin for nagios which would do a real check to ensure that the Databases are up and running, here is my result.

I chose to write the plugin in python, due it’s simplicity, and because I already wrote some script using the python-kinterbasdb extension

New Firebird site is almost ready

From Alexey Kovyazin:

Hello All,

Current data transfer from old site to the new site is almost complete. There are following areas in process:

  • In Development – QA, Documentations for developers and .NET/Python drivers
  • Old news – we will transfer old news for a while, now at 2009-2008 level.
  • In About Firebird -> Features description, is in progress
  • Grantee reports from old years
  • Some minor content adjustments

Also we need to manage setup for daily snapshot uploads.

For regular site updates, like adding news or new FF members/sponsors, dedicated person from DQTeam will manage data adding/changing, until other site contributors will learn how to use CMS.

Actual transfer and redevelopment is almost over, now web-site redevelopment is about “intellectual” re-writing and new content creatiion.

Such process will be run constantly, and there will be always gap between ideal site and good-enough site.

I ask everyone to join the action now, look through the site thoroughly, and then provide actual help in order to jump over gap and switch to the new site in the next few days, and then go to the Phase 2 – improvements and extensions.
Old site will be live for a while, of course, so no content will be missed.

Regards,
Alexey Kovyazin

Firebird 2.0 (and up) Maximum Number Of Records In Table

Maximum number of records in table in Firebird is depended on record_size and page_size.
Here is a spreadsheet in Open/Libre Office Calc (for all calculations look at sheet 1, sheet 2, sheet 3 and sheet 4):
I would like to here from developers from Firebird is this calculations are correct.
Here is the original blog post , and here are the related threads on firebird-support
1 22 23 24 25 26 84