[Lazarus] Embedded database for Lazarus/Linux

[Henry Vermaak]

On 17 June 2010 10:30, Joost van der Sluis <joost at cnoc.nl> wrote:
> On Thu, 2010-06-17 at 09:39 +0200, Luca Olivetti wrote:
>> En/na Michael Van Canneyt ha escrit:
>>
>> > I don't know where you read it, but it's definitely false.
>> > or outdated. firebird embedded works on linux, windows, mac.
>> >
>> > I've been using it since years; version 2.0 and 2.1. Works very well
>> > with FPC, and unlike sqlite, it offers the possibility to work with
>> > full-blown client/server architecture without change in program code.
>>
>> I don't know if it's outdated but overall I think this is a fair comparison:
>>
>> http://www.sqlite.org/cvstrac/wiki?p=SqliteVersusFirebird
>>
>> In my case the deciding factor was the last one:
>>
>> "Concurrency
>>
>> SQLite allows multiple programs to be connected to the same database
>> simultaneously. The embedded version of Firebird does not. If you run
>> Firebird in client/server mode, it allows concurrent access with
>> fine-grain locking. But in embedded mode, only one program can connect
>> to the database at a time."
>
> Yes, but read this forum-thread. (This applies to the used dataset
> offcourse)
>
> http://www.lazarus.freepascal.org/index.php/topic,9504.0.html

So firebird _does_ support accessing the same database from different
host programs in version 2.5.  This version has a release candidate,
so presumably a release won't be long.  Good to know.

Henry