Wait, so if connection 1 is doing VACUUM and connection 2 attempts INSERT/UPDATE/DELETE and connection 3 attempts SELECT all concurrently, what happens and how ACID will the DB be?
2015-07-03 20:07 GMT+07:00 Clemens Ladisch <clemens at ladisch.de>: > Simon Slavin wrote: > > On 3 Jul 2015, at 1:39pm, Rob Willett <rob.sqlite at robertwillett.com> > wrote: > >> is Vacuum the same as doing the .dump and restore or is it different? > > > > It's the same thing (more or less). > > The implementation is completely different. From the outside, the main > difference is that VACUUM works inside SQLite's transaction and locking > mechanisms, so it is safe against concurrent accesses, and against data > loss even if problems happen while the old database file is replaced > with the new one. > > >> We like the .dump as it gives us a nice easy to use backup :) > > In theory, a backup created with .backup is even easier to use; .dump is > more useful if you want a text file instead of a working database file. > > > Good for keeping many generations of archive around. > > ... and for creating diffs between them. > > > Regards, > Clemens > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >