> > All you really need to do is splice your code between the VFS that > the SQLite engine sees and the native VFS layer that comes with the > distribution, adding a bit of extra code to xRead() and xWrite() to > munge the data. >
I implemented this approach once, it worked, VFS also so flexible you can even offset your data, for example write something unique seeding at the start of the file and shift the actual sqlite data to some offset. Although in this case xTruncate should be also adjusted. The only probable disadvantage of using VFS is that sqlite temp file (etilq ... on windows) are bypassed by the VFS as long as I noticed, so if in any case it is left in the system, the contents of temporary tables will be exposed. Although I also noticed some tricky method they (temp files) are created with, so even if I terminate the process unexpectedly they still dissappear afterwards. Max _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
