ANN: FBScanner Community Edition 2.5.3 – testers wanted

We are pleased to announce beta version of FBScanner Community Edition 2.5, free tool to monitor and manage connections and transactions.
With FBScanner Community Edition you can easily view instant snapshots of connections and SQL queries in Firebird 1.0-2.5 and InterBase 5.6-2009.
It is useful for administration tasks for Firebird Classic and SuperServer; for step-by-step debugging to view actual state of SQL-queries,
and even to reveal SQL-queries texts in close-sourced applications.

Please download it from here
http://www.ib-aid.com/free/FBScanner25Community.zip
Please be careful: this is not a production version, so do not use it at production systems.

Any feedback is welcome: fbs@ib-aid.com

Firebird2.1 moved from Debian experimental to sid (unstable)

Today i have installed Debian Lenny in an kqemu/kvm virtual machine (managed by virt-manager under  ubuntu jaunty )

firebird by default there is 2.0.4 so i wanted the latest firebird2.1 stable from debian so i just dist upgraded the lenny to sid

by replacing all lenny words from /etc/apt/sources.list with sid then i did from console

an apt-get update && apt-get dist-upgrade after that i have now access to firebird2.1 just released for sid

then in terminal apt-get install firebird2.1-super and after that  dpkg-reconfigure firebird2.1-super

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.

Read more

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.

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 ###.)

1 155 156 157 158 159 207