Re: Making LuaSQL roar?

[Klaus Ripke <paul-lua@...>]

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.


regards