[CALUG] Database question

[Kelly Price]

On 8/21/06, Jason C. Miller <jason.c.miller at gmail.com> wrote:
> Basically, I'm looking to somehow pass the contents of a table into the
> database and have it sync between that and its stored table.  I
> know...sounds waaayyy too convenient, but ya never know.  :)  Are there any
> tricks to do something like this?
>

Not really.  If you're tracking all the inserts, deletes, and
flattening all updates so multiple updates on one row are put into one
update, then you're already doing as much as you can do.  There's no
mass table sync in the SQL language itself, and SQLite doesn't have
that feature.

Although... creating a second DB in SQLite that's located in memory
(/dev/shm anyone?) instead of handling it yourself may be better off.
If it's all good, copy it back to the disk/flash.

-- 
Kelly "STrRedWolf" Price
http://strredwolf.furrynet.com