Re: [sqlite] What could happen if an app crashes while calling sqlite3_rekey_v2()?

2019-05-03 Thread Richard Hipp
On 5/3/19, Jens Alfke wrote: > > Thanks, Simon. So the rekey is expected to double the database file size? Database size should be the same before and after rekey. The rekey operation will generate journal file entries that are about the same size as the original database (actually slightly

Re: [sqlite] What could happen if an app crashes while calling sqlite3_rekey_v2()?

2019-05-03 Thread Pasin Suriyentrakorn
Thanks Simon, for the answer. David, sqlite3_rekey_v2() is a function to change the database encryption key - it's a SEE feature. On Fri, May 3, 2019 at 9:56 AM Jens Alfke wrote: > > > > On May 3, 2019, at 8:37 AM, Simon Slavin wrote: > > > > While rekey is working, the database temporarily

Re: [sqlite] What could happen if an app crashes while calling sqlite3_rekey_v2()?

2019-05-03 Thread Simon Slavin
On 3 May 2019, at 5:56pm, Jens Alfke wrote: > Thanks, Simon. So the rekey is expected to double the database file size? > That’s good to know. I don't know for sure. I believe that the rekeying is done block by block rather than for the entire database at one time. > After the call

Re: [sqlite] What could happen if an app crashes while calling sqlite3_rekey_v2()?

2019-05-03 Thread Jens Alfke
> On May 3, 2019, at 8:37 AM, Simon Slavin wrote: > > While rekey is working, the database temporarily contains both sets of some > data. Automatic crash recovery will see, this, recover the unconverted set, > and wipe the converted set. You do not need to take special precautions.

Re: [sqlite] What could happen if an app crashes while calling sqlite3_rekey_v2()?

2019-05-03 Thread J. King
lists.sqlite.org] On Behalf Of Simon Slavin Sent: Friday, May 03, 2019 11:38 AM To: SQLite mailing list Subject: Re: [sqlite] What could happen if an app crashes while calling sqlite3_rekey_v2()? On 3 May 2019, at 4:15pm, Pasin Suriyentrakorn wrote: What could happen if an app crash

Re: [sqlite] What could happen if an app crashes while calling sqlite3_rekey_v2()?

2019-05-03 Thread David Raymond
Message- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Simon Slavin Sent: Friday, May 03, 2019 11:38 AM To: SQLite mailing list Subject: Re: [sqlite] What could happen if an app crashes while calling sqlite3_rekey_v2()? On 3 May 2019, at 4:15pm, Pasin

Re: [sqlite] What could happen if an app crashes while calling sqlite3_rekey_v2()?

2019-05-03 Thread Simon Slavin
On 3 May 2019, at 4:15pm, Pasin Suriyentrakorn wrote: > What could happen if an app crashes while calling sqlite3_rekey_v2()? Is > there best practice to safely call sqlite3_rekey_v2()? While rekey is working, the database temporarily contains both sets of some data. Automatic crash recovery

[sqlite] What could happen if an app crashes while calling sqlite3_rekey_v2()?

2019-05-03 Thread Pasin Suriyentrakorn
Hello, What could happen if an app crashes while calling sqlite3_rekey_v2()? Is there best practice to safely call sqlite3_rekey_v2()? Thanks, Pasin ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org