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.

FLAP ( Firebird+Linux+Apache+PHPerl) is rather an operating platform than an application.

Linux can be of any common Linux distributions, but I prefer CentOS 5, and Firebird RDBMS is FirebirdSS 2.1.1 for Linux.

Since there are too many applications, really too many, to run on FLAP, it is impossible to list them all, or even impossible to list most of
them here, I just list the most commonly used FLAP applications here. If you are running any other FLAP applications, it would be a great
honour for me if I could have them listed/linked here.

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.

People Around Firebird – Daniel Albuschat

Today i have discovered this little gem on github , It’s an Asynchronous database-access for Qt and Firebird

So in this post i open an series of interviews or introductions with people around firebird

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.

IBProvider for Firebird and Interbase has been released.

Changes in IBProvider v2 (build 2.6.06.2688)

  • Addition of UTF-8 charset support
  • Loading of charset information for COLUMN and PROCEDURE_PARAMETERS metadata schemes from system tables.

Changes in IBProvider v3 (build 3.0.0.6327 RC3)

New IBProvider v3 offers the brand new method for working with text data charsets:

  • We added ctype_user property that allows setting the encoding of data coming to client irrespective of the encoding in which this data is coming from database server.
  • New algorithms of BLOB fields converting provide for quick work with flowing data, optimization of interaction with ICU library.
  • We added ctype_none property that allows setting the charset for working with text data in NONE encoding.
  • Other important changes.
  • Support of Firebird and Interbase charsets aliases.

See detailed information on working with new character set processor in Firebird and Interbase character sets.

Text columns size in Firebird 2.X

IBProvider started to control text columns size when working with Firebird 2 servers in Unicode mode. If the length of loaded data exceeds the text column size the exclusion will be generated.

1 7 8 9 10 11 18