Category: General news
Firebird related news
ANN: “InterXpress for Firebird” v2.1.0 released
Ladies, gentlemen,
“InterXpress for Firebird” is our driver that supports Borlands
dbExpress technology! Today we release version 2.1.0 of our driver,
this version includes support for Delphi 2009.
You can download a copy of it http://www.upscene.com.
Currently supported are Delphi 6, Delphi 7, BDS 2006, Delphi 2007,
RAD Studio/Delphi 2009, Kylix 3 and C++Builder 6.
What’s fixed, new and changed? Check it out here:
http://customer.upscene.com/script/mantisgateway.exe/fixed?fixedin=2.1.0&projectid=19
With InterXpress for Firebird you have guaranteed access to
Firebird and all its features. The driver comes in two versions:
– Desktop Edition
– Server Edition
All versions come with a full year of support and maintenance
updates. The support period can be extended at a reduced price
after the first year.
fbsql: Clean client-libraries for Firebird and Interbase databases
I’ve written this quite some time ago (and it didn’t receive much love since then, but it’s functional and should be bug-free), but I just noticed I haven’t mentioned it on my blog: fbsql is a clean C-API that can be used to create bindings for other languages (such as Python or Ruby). It’s much simpler to use than the raw Interbase/Firebird API and it uses IBPP internally. So it’s basically just forwarding the function calls to IBPP and abstracting the IBPP classes to a C interface that is straight forward and intuitive.
Firebird Adapter included in Sequel
Here is the discussion with the new inclusion in Ruby Sequel (Sequel is a lightweight database access toolkit for Ruby)
Top 4 Free Embedded Databases
I need an embedded database for my next project. During the last few days I’ve done a lot of virtual leg-work researching and comparing the various alternatives, trawling through documentation and forums. The results are below. Hopefully, if you’re ever in the same situation, this list will make your life a bit easier.
New IBProvider allows comprehensive work in Unicode applications, enhanced work with NONE encoding, and supports charset markers.
New IBProvider v.3.0.0.6600 RC3
- All the detected problems that prevented comprehensive work with Firebird and Interbase from UNICODE applications have been eliminated.
- Supports charset markers in SQL queries.
- Supports exclusions processing when working with Interbase and Firebird via ADODB.
- Supports working with database object names containing national symbols for connections with NONE charset.
- Enhanced work with metadata schemes when working with database via NONE charset.
- Advanced testing allowed detection and elimination of errors.
- ISO8859_15 charset support.
Please read details on the Firebird driver homepage.
Two simple Python scripts showing how to connect to Firebird using wxPython.
Below are two simple Python scripts (not involving dabo) just showing how to connect to Firebird and do a simple task using wxPython.
http://dabodev.com/wiki/Firebird
(1) The first script lets the user go into the File menu and select a Firebird database, and then it displays (do-nothing) buttons in a wxPython Sizer object down the left side of the window, one for each table (and view) in the database.
(2) The second script is hard-coded to open a particular Firebird database and display a particular table in a grid. (Before running, you will need to go into this script and change the hard-coded sections so they are appropriate for your system. You’ll need to change the host and database parameters and the SQL statement – and maybe also the user and password parameters. Look for the lines preceded by a comment starting with ###.)
German translation of Firebird security article
There’s an article on the Firebird Documentation web-page about Firebird File and Metadata Security. Since this is an interesting topic to our customers, I took the time to translate it to German.
The article describes the fundamental problems in securing network connections. One of the biggest problem is key management. Since the Firebird server is usually controlled by and installed at the client’s site, you don’t have any control over it. So, theoretically, someone could always build his own Firebird server to spy on the password. But that’s only one of the problems discussed.
Many thanks to Geoff Worboys, the author of the original article, and Paul Vinkenoog for publishing it on the official web-site.
New Sinática Monitor 1.2
Sinática has just release Sinática Monitor 1.2.
This version brings:
– an improved and much more useful Start Page
– Sweep Alarms to warn you if your sweep configuration is not ideal
Read the complete announcement.
Download Sinática Monitor 1.2 now!
web2py – RoR like python framework with Firebird support
The examples are very clean compared with what i have seen in cake or other RoR inspired frameworks