[prev in list] [next in list] [prev in thread] [next in thread]
List: sqlite-users
Subject: Re: [sqlite] smartest way to exchange a sqlite3 database with another empty
From: Petite Abeille <petite.abeille () gmail ! com>
Date: 2016-10-03 10:05:38
Message-ID: F941D223-1AC7-4557-868B-978A0BC31039 () gmail ! com
[Download RAW message or body]
> On Oct 3, 2016, at 11:18 AM, Luca Ferrari <fluca1978@infinito.it> wrote:
>
> What is the right way to do it without having to stop the application
> (and therefore without knowing when a new I/O operation will be
> issued)?
You could use the attach/detach [1] functionality to transparently roll the logs over.
Something like main -> attach current -> insert current.log
Every now and then, change what ‘current' points to.
[1] https://www.sqlite.org/lang_attach.html
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic