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/

New versions of SQLObject are now available

Versions 0.7.3b1 and 0.8.0b2 of SQLObject are now available.

SQLObject is an object-relational mapper for python. Your database tables are described as classes, and rows are instances of those classes. SQLObject is meant to be easy to use and quick to get started with.

SQLObject supports a number of backends: MySQL, PostgreSQL, SQLite, and Firebird. It also has newly added support for Sybase, MSSQL and MaxDB (also known as SAPDB).

Changes regarding Firebird support:

  • Fixed a bug in FirebirdConnection caused by column names having trailing spaces.
  • Fixed a missed import in firebirdconnection.py.
  • Remove a leading slash in FirebirdConnection.
1 72 73 74 75 76 100