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.

Interbase Stored Procedure Grammar

One of our customer recently wanted to perform some heavy duty computations on his Interbase Stored Procedures (analysis and transformations).
Instead of plunging head on in an ad-hoc tool, we started to build a general parser. So we had to start-off with a BNF grammar. We already presented a simplified Sql grammar for the main INSERT, UPDATE, DELETE and SELECT requests. So we extended this grammar to handle the stored procedures as well.

Most of the grammar applies to Firebird as well. You can read the full article here.

Poll about auto-index stats update in FB

Dear users,
I work at a project related to a possibility to have the index statistics auto-updated and humbly I ask your opinion. Please feel free to vote below.
TIA,
m. Th.

PollPub.com Vote

How do you look a possible implementation of Auto update index statistics in Firebird?

Very useful.
It would be nice, but I can live without.
Indiferent.
I preffer my own custom way to update the statistics.
No, I’m against it.
What is this about? (or I don’t know what ‘statistics’ are)

View Results

Poll powered by PollPub.com Free Polls

SEFIP now uses Firebird

SEFIP is an application used by almost 1.5 millions of companies in Brazil to collect/pay social welfare tributes. It is distributed by Caixa Econômica Federal (a federal bank), and in its latest version (8.3) it replaced InterBase 6.0 with Firebird. With this change, Firebird embedded installed servers base in Brazil grow in some millions.

You can find the announcement here (in portuguese – self extract exe containing a PDF file).

Who is better?

A quite interesting message/answer posted by Ann Harrison in the Firebird-Architect discussion list.

Re: [Firebird-Architect] Firdbird 2.0 vs the World
Posted by: “Ann W. Harrison”
Date: Thu Dec 28, 2006 8:55 am ((PST))

rvbyron wrote:
open source databases, however, the list is not very extensive. Further,most of the comparisons are not referencing Firebird 2.0, but an earlier version of Firebird.

1 73 74 75 76 77 100