Re: Is there a "Virtual" Lua table library?

[Joseph Stewart <joseph.stewart@...>]

Thanks for the responses!

I have been vaguely aware of dbm and it's spawn for years, but have
never actually written any code to use one. Perhaps as Mark mentioned,
careful inspection of keys and values will make this class of
libraries usable for my purposes.

I've gotten spoiled by sqlite's ability to keep all tables and indexes
in one file and it's ACID method of protecting data... so I'm looking
to either use the btree/pager modules from sqlite or find a dbm clone
that has the same features. One thing that I don't like about sqlite's
implementation is the fact that it locks the entire file for updates.

Take care everyone!

-joe


On Thu, 20 Jan 2005 09:54:44 -0800, Mark Hamburg <mhamburg@adobe.com> wrote:
> The caveat is that those are essentially string-to-string mappings and the
> databases sometimes impose harsh limits on string sizes. If you keep those
> limitations in mind and are prepared to pack and unpack strings, you can
> make them reasonably transparent for basic table access.
> 
> You can get around the size limitations either by playing encoding games in
> the keys or by kicking to separate files above some threshold. This can be
> kept transparent to the client.
> 
> If you are already using SQLite, I don't know how the performance of the
> simpler databases compares.
> 
> Mark
> 
> on 1/20/05 7:09 AM, Klaus Ripke at paul-lua@malete.org wrote:
> 
> > On Thursday 20 January 2005 15:54, Joseph Stewart wrote:
> >> not pervasive persistance, just the ability to set the metamethods for
> >> a table to use the disk/memory for paging huge tables.
> > for berkeley/dbm-style DBs which follow the key=value paradigma
> > this is trivial (very similar to a Perl hash tied to some xdbm).
> >
> > See gdbm, cdb and tdb at http://lua-users.org/wiki/LibrariesAndBindings
> >
> > cheers
> 
> 


-- 
Person who say it cannot be done should not interrupt person doing it.
 -- Old Scottish Proverb