On Wed, Jan 19, 2011 at 12:15 PM, Dustin Sallings <dus...@spy.net> wrote: > This isn't a question so much about value judgment (I've already > argued that some, though mentioning maintenance tools is helpful > there, too). It comes down to whether reliability of SQLite itself > would be reduced if a WAL existed on a different partition -- whether > there are any assumptions WAL makes that would be invalid across > a filesystem boundary.
You either would have to hack the filesystem namespace to look like you want it to look using mount tricks, or modify SQLite's VFS (or write your own) to accomplish what you want. Since you cannot trust the contents of the database itself, you would need to provide some means of specifying the alternate location in code. The biggest concern I would have would be whether there are subtle atomicity guarantees which are served by being on the same filesystem which cannot be served by being split across multiple filesystems. -scott _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
