Here is a quick routine to read values from a Firebird Database into Delphi Prism.

IBFirstAid for Firebird is an automatic tool that can open a Firebird database as a file and identify damaged page, record, BLOB and index structures. Because it does not have to "connect" to a database as a client, it can offer hope in cases where a database is damaged in ways that the gfix validation and mend routines cannot fix on their own.

Firebird versions up to and including v.1.5 provide a command-line tool called qli that can be used to pump metadata structures and data from an existing database to a new one.
The qli (Query Language Interpreter) tool provides an interface to talk gdml, an internal, non-standard query language from times past, that works with Firebird up to and including V.1.5.

You have to try very hard to corrupt a Firebird database—it’s designed to survive the hard knocks that break databases in other systems. You will know a database has been corrupted if you cannot connect to it or back it up and a message in the firebird log, or from gbak –b[ackup], tells you that there is corruption, or some other message reports a checksum error.

In the first and the second part of window function series, I talked about the OVER clause, with/without partitions and with/without ordering. Till then, no new function had been introduced, so it has about the already existing aggregate functions.

What compression is used in the page/btree_nod entries? I've got a database with a couple of known entries and I cannot decode the btree_nods sensibly. Happy to be pointed at the appropriate code file in the source.

Don't know if anyone ever needs such a crazy setup, but here it goes. I needed to run a software that requires Firebird 2.x. Nothing special, it's available in my distribution (Ubuntu). I also had to run another app that needs Firebird 1.5.

Continuing with the window functions support for Firebird 3, I have now added another OVER sub-clause: ORDER BY. The ORDER BY sub-clause can be used with or without partitions, and it makes aggregate functions return the partial aggregations as the records are being processed.

By the SQL specification, window functions are a kind of aggregation, but which does not “filter” the result set of a query. The aggregated data is mixed with the query result set. That sort of functions are used with the OVER clause. Users of Oracle also knows window functions as analytical functions.

Artículo que habla sobre corrupción (daño en datos) en las bases de datos y cómo evitar esos daños.

Un blog dedicado a Visual Basic 2005 y Firebird 2.1, tiene muchos artículos interesantes.

En idioma inglés, comparativa hecha en Japón.

Artículo que muestra cómo instalar PHP con soporte a Firebird en Ubuntu Karmic.

Artículo que muestra las adiciones al catálogo (tablas del sistema) del ODS 12.

Artículo que muestra los cambios físicos para el ODS 12, es decir, el formato físico, u organización de la base de datos de Firebird. Cada versión de Firebird tiene compatibilidad con un único ODS.

Documento PDF que muestra una comparación de las arquitecturas en Firebird 2.5, las cuales son:

Super Server
Classic
Super Classic
Embedded

Artículo que explica las diferencias entre Firebird e InterBase, en idioma inglés.

The Firebird DTP plugin enables support for the Firebird database on the Eclipse Data Tools Platform (DTP).

This plugin is a work-in-progress, bug reports can be posted to the Firebird-Java mailinglist (and Yahoo forum). See Firebird Lists and Newsgroups for details.

XMLWizard is a tool used to import and compare data from files against Firebird databases. It supports XML, CSV and flat (fixed-width column) textual files.

XMLWizard has some features that make it a unique tool.

XMLWizard es una herramienta utilizada para importar y comparar datos de archivos contra bases de datos Firebird. Soporta archivos XML, CSV y texto plano.

XMLWizard tiene algunas características que lo hacen una herramienta única.

“unavailble database” error prompt connecting to Firebird service is annoying and difficult to trace. Sometime it work and sometime it doesn’t. We don’t know when it work and when it doesn’t work.

Someone may make wrong conclusion from my previous post about sorting (http://ibdeveloper.blogspot.com/2009/06/what-is-sort.html).

Inspired by discussion about sorting (PLAN SORT), did some simple tests. Right now I do not have "an article" about this, but want to show you some discovered facts.

"..I like to use the Guid values as Primary Keys, because I do a lot of data synchronization and sometimes I need to know the ID value before saving the record into the database.."

Entrada de blog donde habla sobre conexiones perdidas, en idioma inglés.

"...In all the talk about open source databases, people think of MySQL, PostgreSQL and SQLite but often forget Firebird..."

Una breve entrada de blog donde habla sobre las bondades de Firebird, en idioma inglés.