[CALUG] Database question
strredwolf at gmail.com
Mon Aug 21 10:46:15 CDT 2006
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
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
More information about the lug