[Lazarus] Embedded database for Lazarus/Linux

[Joost van der Sluis]

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

Joost.