Technical articles, How-tos, guides, etc.
ODBC Escape sequences has included in ODBC standard and allows write SQL queries which compatible with many DBMS. Firebird and Interbase does not contains own implementation for escape sequences and therefore we have implemented them in IBProvider and now users can write compatible SQL queries for Firebird and Interbase as for MS SQL Server, Oracle, My SQL, PostgreSQL, DB2 and etc.
Beta version of the Firebird 2.1 database was published at the end of June. I suppose, most interesting features are the global database triggers, the temporary tables, possibility of the database monitoring through the SQL, canceling running queries and the new SQL statements. We are implemented new Firebird 2.1 features in IBProvider
Read the rest of the article here
Here is the full thread on nhibernat and the quote
“However, the thing that finally made us switch from SQLite to Firebird was the fact that it only support one open transaction at a time. This makes it essentially useless for multithreaded/multiuser applications. SQLite is excellent for some tasks, but if you have more than one thread/process accessing the database at the same time you really should consider using another database. ”
From the FUD department Here is one sponsored article
The somewhat moribund Firebird project, for example, is listed with 195 identified defects, of which it has verified zero and fixed zero
Wireshark (formerly Ethereal) 0.99.6 allows remote attackers to cause a denial of service (infinite or large loop) via the (1) Firebird/Interbase, (2) DCP ETSI, (3) IPv6, or (4) USB dissector, which can trigger resource consumption or a crash.
Some bugs are fixed in php 5.3.x and firebird could work now with symfony project (must be tested first)
Following is a PHP script to run nbackup on FB2.1
Put this script in a place where your system can call it
automatically/regularly in back-ground
Microsoft is releasing the beta 3 of its ADO.Net Entity Framework, along with a preview of ASP.Net 3.5 Extensions.
