Aproximated record count
Ivan Prenosil posted in Firebird support list an interesting way to retrieve the aproximated record count in a table, without using the “slow” select count(*). See the code:
Read more
SQLAlchemy 0.3.6 released
SQLAlchemy 0.3.6 released. SQLAlchemy is the Python SQL toolkit and Object Relational Mapper that gives application developers the full power and flexibility of SQL.
This is the first post-Pycon release and includes the new Query object which merges in all of the functionality of SelectResults.
More docs have been added, including some description of the new Query methods. The “generated documentation” has been broken upinto separate pages per module, with navigation added for module-level functions. Docstrings are also much more PEP compliant and are formatted using docutils.
Full changelog can be viewed at: http://www.sqlalchemy.org/CHANGES
Firebird 2.0.1 Accepted in Debian unstable
1st Firebird Japan Conference
firebirdsql.ru new firebird related website
spotted via opennet.ru’s firebird 2.0.1 release announcement (scroll down to the end)
Morfik 07 released
Morfik 07 was release today. It uses Firebird as the default database. Check it out, it is a great tool for generating web applications that also works in “standalone” mode with no code changes.
PHP Interbase Extension Multiple Remote Buffer Overflow Vulnerabilities
PHP Interbase Extension Multiple Remote Buffer Overflow Vulnerabilities
BugTraq ID: 22976
Remote: Yes
Date Published: 2007-03-15
Relevant URL: http://www.securityfocus.com/bid/22976
Read more
Firebird 2.0.1
The Firebird team is pleased to announce the latest Firebird 2
sub-release, V.2.0.1. Binary and source kits for Linux and Windows
have begun to appear at the Sourceforge mirrors today. Details all at
www.firebirdsql.org.
The Firebird Project Team
Firebird Maestro 7.3 released. Now with graphical database designer!
| SQL Maestro Group is happy to announce the release of Firebird Maestro 7.3, a powerful Windows GUI solution for Firebird administration and database development. |
The main feature of the new version is the Graphical Database Designer – a case tool for managing your database in a few mouse clicks. This piece of our software is intended for creation of physical Entity Relationship Diagrams that represent objects in your Firebird databases. Each diagram displays the tables of your database and the relationships between them.
- Handy tools of Designer allow you to create new and edit existing tables and references;
- The reverse engineering feature will help you to understand the schema structure and make its modification in an easy and clear way;
- Now you can quickly and easily print your database structure with a lot of options including header and footer, paper size and orientation, etc;
- A rich set of options and settings give you a way to see your database in your own look and feel style.
A diagram of your database can help you define operational aspects of your application logic that you might otherwise overlook. Also, a well-defined data diagram that accurately represents your tasks can be helpful in orienting employees to goals and operations.
Full press-release is available here:
http://www.sqlmaestro.com/products/firebird/maestro/news/3641/

