Firebird 2.1 update or insert statement
Another great feature that I like in Firebird 2.1 is the UPDATE OR INSERT statement. It’s a really time saver and it makes the SQL cleaner.
Category: Technical Articles
Technical articles, How-tos, guides, etc.
Firebird TPC Benchmarking Part 1 – Porting the TPC-H suite
German article on aggregate tables with Firebird is available as download
For the German speaking folks here …
I made my article “Aggregatstabellen mit Firebird” (aggregate tables
with Firebird) from the Entwickler Magazin 5.2008 available as download.
Check out my blog:
http://blog.upscene.com/thomas/index.php?entry=entry081202-183802
Access to Firebird from Delphi using dbGo components
The new article was published: Working with Firebird and Interbase from Delphi using IBPRovider and dbGo components.
Table of content:
- TADOConnection component
- TADOTable component
- TADODataSet component
- Sending changes to database – updatable rowsets technology
- Client and server cursors
- What provider to choose?
- TADOQuery component
- SQL-queries with parameters
- TADOStoredProc component
- TADOCommand component
- Transactions
How to fix an corrupt database
Firebird 2.1.1 is included in Ubuntu 9.04 Jaunty Jackalope
Zend framework 1.7 released
Here is the download and release link . Thanks to Luiz Fernando Firebird Suport is included
Firebird DDEX for VS2008
How to install Firebird database engine and DDEX extension for VS2008 step by step…
New IBProvider support of 49 code pages
The new IBProvider version:
- Support of 49 Firebird and Interbase code pages including UNICODE_FSS, UTF8 and OCTETS binary data. Supported character sets.
- Possible provider operation without registration in the system via manifest file.
The article: Example of working with Firebird and Interbase without registering additional components. - Prevention of memory leaks in Firebird client during library unloading.
- Specific errors have been fixed.
Read details on: Firebird driver news channel
Firebird, PHP, and CentOS 5
I (Dan Wilson) put together the procedure I used in order to get native and PDO firebird support working with PHP and CentOS 5. I was unsuccessful using the FAQ at http://www.firebirdfaq.org/faq191/, and couldn’t find any other tricks on the web that worked. So, I compiled from a fedora source RPM as follows