[Lazarus] Embedded/small database

[Kostas Michalopoulos]

Sqlite can be very fast, but it needs the proper setup for that (which may
not be relevant in all cases).

Beyond that, Sqlite has a lot of high profile users (not to make a piss
match, but i couldn't see any big users in Firebird's site and even those
didn't seem to mention if it was embedded or client/server):

https://www.sqlite.org/famous.html

There are other less known uses of course, like the Fossil VCS and AFAIK
Apple also uses it for the time capsule and FS versioning.

Honestly, i wouldn't put down Sqlite :-).

However you need to make sure that Sqlite is what you are looking for.
After all in their site they say that  "SQLite is not designed to compete
with Oracle. SQLite is designed to compete with fopen()." (or AssignFile in
Lazarus' case :-P).

To put it differently, if i wanted to make an application to associate tags
and colors with images (for fast theme lookup), i'd use Sqlite. If i wanted
to make a bookstore chain application, i'd probably use PostgreSQL.

I wouldn't use Sqlite for configuration since this is what INIs are for :-P


On Tue, Feb 17, 2015 at 6:26 PM, Graeme Geldenhuys <
mailinglists at geldenhuys.co.uk> wrote:

> On 2015-02-17 14:54, leledumbo wrote:
> > It has much easier setup, though. Even easier than embedded firebird.
>
> Firebird's setup is pretty easy. I've deployed Client/Server and
> Embedded firebird under Windows, Linux and FreeBSD. For embedded I
> simply shipped the DLL/SO files needed and it all worked like a charm.
>
> Something else to comment on - I have no clue about this for Sqlite.
> Firebird has loads and loads of 3rd party tools like Flamerobin etc to
> view, query and analyse your database. In recent Firebird versions you
> also have server side tracing support which is awesome for debugging SQL
> calls.
>
> Regards,
>   - Graeme -
>
> --
> fpGUI Toolkit - a cross-platform GUI toolkit using Free Pascal
> http://fpgui.sourceforge.net/
>
> --
> _______________________________________________
> Lazarus mailing list
> Lazarus at lists.lazarus.freepascal.org
> http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lazarus-ide.org/pipermail/lazarus/attachments/20150217/f01527e5/attachment-0003.html>