nBackup tests
Dmitry Kouzmenko writes about new nBackup tool in his blog.
Author: Cantu
I'm the owner of the www.Firebase.com.br site and the author of the books Firebird Essencial, Firebird 2 and Migration Guide to Firebird 3. Loving Firebird even before it was born!
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:
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/
Garbage Collection problem in IB/FB
Dmitry Kouzmenko just posted a new article in his blog, describing currently Garbage Collection problems with both IB and FB. Very interesting reading!
His blog has other interesting posts, you really should read it.
Firebird 2.0.1 RC
Release Candidate kits of Firebird 2.0.1 are now available for download at the Firebird main site.
This version corrects many bugs reported since FB 2.0 was released, but does not contain any new features.
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.
Firebird Developers Day 2007 – Survey
For Brazilians (and Portuguese speakers in general) that pretend to attend the next FDD edition (2007), please answer the survey available at infopoll.net/live/surveys/s30419.htm to let us know about what is your expectations for the conference.
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.
Papers of Firebird Conference 2006
The papers (where available) for the Firebird Conference 2006 talks are available for download here (you need to right click and use “Save As”).