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.
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.126.96.36.19900 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.
Today i have discovered this little gem on github , It’s an
Firebirdnews.org is a great site! Added it to my RSS feeds, but I
wonder why I haven’t heard of it before. You need to do more
advertising! 🙂 Do you happen to know how many readers you are
ED:Maybe we should promote better the website , seems that now from alexa.com
stats we have a lot of hits from Italy, so we have to tune up to reach more markets 🙂
I’m glad that you included my translation of the Firebird Security
documentation, too, but I was a bit surprised to find it there without
being notified of it.
Regarding the TsSqlDatabase stuff: It’s something I’m doing for the
company I’m working at (Germany based Treesoft, see www.treesoft.de)
and it’s currently being extended by another employee. Which problems
I wanted to solve and the basic technique that I’m using to solve it
are described here:
The project is currently in a semi-working state. My co-worker is
working with Qt to create a searchable list-view that can handle HUGE
amounts of data with astounding user experience and without the quirks
that most SQL list implementations have.
I’m going to write up a new article on this topic with more details
maybe this weekend or next week, so stay tuned. I’ll contact you when
it is finished so you can put it up on firebirdnews.org.
This blog-post may also be an interesting read to you:
but with qt I started to like it
C++ is just one of the most cleanest languages that are around
(although it has many quirks and is not what I would really call
“clean”, but it’s still “one of the cleanest”). It’s the only language
that solved the resource allocation/deallocation problem in the best
possible manner. See RAII vs. Garbage collection here:
On an unrelated side note, have you ever used Sinática Monitor
yourself? It sounds like a cool product, but I’m wondering how it
works. I have a similar project in mind that would work as a
Firebird-“Proxy” and sniff the communication between the client
application and Firebird. But Sinática even has info on server and I/O
loads, that really cool.
ED: I will try it on my ubuntu box if possible with wine
Thanks for your mail,
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.
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 188.8.131.5227 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.