Category: Tools & Products releases

New release with Firebird/Interbase bugs fixed

SQLObject Version 0.7.3 release is now available.

SQLObject is a popular python ORM for providing an object interface to your database, with tables as classes, rows as instances, and columns as attributes.

SQLObject includes a Python-object-based query language that makes SQL more abstract, and provides substantial database independence for applications.

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)

SQLLY Development team is happy to announce the availability of the next version of Interbase/Firebird Development Studio. This release introduces InterBase 2007 support. New interesting feature is an ability to automatically collect undefined variables in the SP or trigger and detect their data types.

Please find detailed list of news and fixes at:
http://www.sqlly.com/news/chagelogs/changelog9.en.html

More information about Interbase/Firebird Development Studio can be found at:
http://www.sqlly.com/IBDS.en.html
http://www.sqlly.com/features.en.html

30-days evaluation version is available at the following page:
http://www.sqlly.com/download.en.html

BlazeTop (former SQLHammer) version 1.7.0.99 is available for download.
What’s new in version 1.7.0.99?
Purchase BlazeTop (129 Euros for Single license):

I am happy to inform that FIBPlus 6.5 (trial) is available for download.

As I have already announced, version 6.5 in particular has a better support of Firebird 2.0.

Purchase FIBPlus for 235 Euros only.

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/

XpertMart has released an updated version of XpertMart for Mac .The latest release runs on the Firebird database manager which also runs natively on Intel-based Macs.

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.