On Thu, Jul 8, 2010 at 10:50 AM, Alexey Pechnikov <pechni...@mobigroup.ru>wrote:

> 2010/7/8 Richard Hipp <d...@sqlite.org>
>
> > In the current implementation, if you call "PRAGMA wal_checkpoint" just
> > prior to closing the database, the WAL file will be deleted
> automatically.
> > But it keeps the database in WAL mode, so the WAL is recreated the next
> > time
> > you open and write to the database.
>
>
> It's not helpful for backward compability. How about version downgrade of
> the Android or some other mobile OS and as result impossibility to open any
> SQLite database?..
>

Presumably the version downgrade comes with a script.  (Otherwise, other
changes such as schema changes would go uncorrected.)  That script merely
has to run

     PRAGMA journal_mode=DELETE;

on every database.  Problem solved.


>
> --
> Best regards, Alexey Pechnikov.
> http://pechnikov.tel/
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>



-- 
---------------------
D. Richard Hipp
d...@sqlite.org
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to