The Ideal Database for Your Business?

This paper from CodeGear tries to convince users that InterBase 2007 is the best database for them. It even mentions “alternatives” like MySQL, PostgreSQL and …FIREBIRD 1.5!

Of course, like any marketing paper, it tries to show that IB is the best option 😉 But it is curious that they decided to compare IB 2007 with FB 1.5 (instead of 2.0). Also, it seems that most of their “complaints” about FB, like the lack of SMP support, etc. are features that are currently being merged from Vulcan into Firebird 3. The matter of Firebird not having an official support “entity” is shown as a “problem”, but I totally disagree with this, since there is a huge and very active community offering (very good) support for free in discussion lists, and some comercial companies too. I believe that currently Firebird support is even better than IB support from CodeGear.

Anyway, the simple fact that FB is mentioned probably will attract some attention to the project 😉

Evans Data Survey mentions Firebird

Today we have a survey on Open source software. If you use Open Spurce in your development, please take our survey and help influence the course of Open Source Software. Your opinions will be read by the largest platform and tools companies and you will be automatically entered into a drawing to win $500.

To take the survey, please go to:

http://www.evansdata.com/EDC_LX_2007_1.html

Ed. Note: Firebird is mentioned in 3 questions.

Pascal Data Objects

Unsatisfied with the available libraries for object Pascal to connect to various databases with a standard API, I created “Pascal Data Objects” which is loosely patterned after PHP Data Objects, and originally supported MySQL 4.0, 4.1, and 5.0 using native client libraries. I recently moved the project to Sourceforge ( pdo.sourceforge.net ) and added support for Firebird 1.5 and 2.0.

PDO is licensed LGPL as it contains some code from Zeoslib, which is LGPL. One particularly nice thing about my implementation of the Firebird drivers is that I built in “prefetch” support. By default, the driver prefetches the entire result set and stores it internally so that functions that depend on knowing how big a result set is before accessing the data can be supported. There is also some data abstraction functions.

The source code is packaged at Sourceforge and works on Delphi and Free Pascal Compiler, tested and used in both Windows and FreeBSD programs. If you decide that this is newsworthy, then I’ll leave the wording up to you.

Regards,
John (J.R.Marino — firebirdnews @ marino.st)

SQLAlchemy 0.3.4 release is now available

SQLAlchemy is the Python SQL toolkit and Object Relational Mapper that gives application developers the full power and flexibility of SQL. It provides a full suite of well known enterprise-level persistence patterns, designed for efficient and high-performing database access, adapted into a simple and Pythonic domain language.

Changes in firebird module:

  • order of constraint creation puts primary key first before all other constraints; required for firebird, not a bad idea for others ticket:408]
  • Firebird fix to autoload multifield foreign keys [ticket:409]
  • Firebird NUMERIC type properly handles a type without precision [ticket:409]

Download it at http://www.sqlalchemy.org/

1 72 73 74 75 76 100