[Date Prev][Date Next][Thread Prev][Thread Next]
- Subject: Re: Making LuaSQL roar?
- From: Klaus Ripke <paul-lua@...>
- Date: Mon, 15 Aug 2005 10:20:17 +0200
On Sun, Aug 14, 2005 at 06:58:26PM -0500, Javier Guerra wrote:
> > You'd only use a SQL DB if there is some good external
> > reason to do so, typically accompanied by some
> > table structure interface you have to match.
> > No?
> or when the underlying engine is really so good to offset the burden of SQL;
> lots people seem to think that's the case with SQLite (i haven't tried it,
> but i could believe it)
It is really excellent for what it does,
and if you need keys in a BTree for ordering or prefix search,
or need multiple keys,
or need some semi-structured persistant representation
to query by other tools, then SQLite is for you.
However, for direct access by a single key,
and storing in a plain byte array,
you can't beat the tdb hash.