Hi,

I'm searching for an embeddable database for small devices to use with fpc. It should be

- fast
- small in code size (loading takes long)
- usable for different languages
- statically linkable

I'd use DBase if I could rule out potential problems (no utf8 or the like).

Can someone speak up on this matter and give some hints?

TIA,
Marc

Not sure about Firebird RDBMS. I haven't used it as an embedded database, but I know it supports it. Also not sure about small devices? What is that, like PDA's?
Anyway, I am sure Google will can tell you more about possibly using Firebird or not.

Graeme.

Graeme Geldenhuys wrote

Not sure about Firebird RDBMS. I haven't used it as an embedded database, but I know it supports it. Also not sure about small devices? What is that, like PDA's?

Sort of, it'll run on a small board having a Geode-CPU (266MHz) loading it's OS and program from flash memory (CF).

The only task is to read and write two tables (for now), so in principle dbase would be nice. But since the program has to become localized to at least three or four languages using special chars I'm not really sure that it would fit.

Anyway, I am sure Google will can tell you more about possibly using Firebird or not.

I'll look out for it, I remember having heard about an embedded version of firebird. Currently my mental upper limit is around 1 MB in size (on disk) ...

Thank you,
Marc

Marc Santhoff wrote

The only task is to read and write two tables (for now), so in principle dbase would be nice. But since the program has to become localized to at least three or four languages using special chars I'm not really sure that it would fit.

Why would dbase have problem with it? Isn´t dbase type for strings simply a array of bytes? You could just pass a utf-8 string to it. I´m sure dbase isn´t doing any kind of string transformation with the date it receives (or am I wrong?).

I'll look out for it, I remember having heard about an embedded version of firebird. Currently my mental upper limit is around 1 MB in size (on disk) ...

You could also try sqlite. According to it´s website:

Small code footprint: less than 250KiB fully configured or less than 150KiB with optional features omitted.

It can´t be statically linked without some effort (because it´s made on c), but has only one external library to be deployed.

Am Samstag, den 25.11.2006, 22:56 -0200 schrieb Felipe Monteiro de Carvalho:

I'm not sure either, only want to rule out. But I do remember some problems with programs using utf8 internally and dbase tables.

Problems come into sight when accessing the data with ohter programs than my own. When someone changes data from a windows system, he'd have to watch out for encoding flaws.

Sounds very nice, dynamically linking is okay if the rest fits. And there are several language bindings usable with fpc - I think this is it.

Many thanks,
Marc

maybe this helps:

http://sotu.berlios.de/Firebird-Embedded-Linux-HOWTO.html

http://www.firebirdsql.org/manual/ufb-cs-embedded.html#ufb-cs-embedded-deploy