Any idea....
-----Original Message-----
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Raghavendra Thodime
Sent: Tuesday, December 15, 2009 10:15 AM
To: sqlite-users@sqlite.org
Subject: [sqlite] BACK API Questions
Hi,
I am using in-memory db where I will execute only inserts. Periodically, I
am trying to backup my in-memory db to file based db. But as soon as I backup,
I want to clear up the in-memory db so that I will have enough memory for
subsequent inserts. So next time when I back up I want to back up only the
newly written records. Is there a simple way to accomplish it? Right now, I
can't execute delete on in-memory because it will reflect on file db when I
back up which is what I don't want.
What I tried was, as soon as I back up, I close the current in-memory db and
open a new one for the subsequent inserts. But next time when I tried to back
up to the same old file db, backup operation is overwriting all the its old
contents. Is there a way to append to old DB instead of overwriting?
Help will be appreciated...
Thank You
Raghu
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
