On Sun, Mar 17, 2013 at 11:21:54PM +0800, Neo Anderson scratched on the wall: > I'm trying to implement a VFS with encryption. I cannot find any detailed > documentation about some flags listed onĀ http://www.sqlite.org/c3ref/vfs.html > > For example: > > SQLITE_OPEN_MAIN_JOURNAL > SQLITE_OPEN_MASTER_JOURNAL > SQLITE_OPEN_SUBJOURNAL > > There is a minimal mention of these flags in source code, but no > detailed explanation what should implementation take care of them. > > Wher can I find detailed documentation about these flags?
I doubt there is any, beyond the source itself. As for what they do, the _MAIN_JOURNAL is a journal for a database. The _MASTER_JOURNAL is a control journal file that is used when a transaction spans more than one database (e.g. using ATTACH). It lives in the same location as the main database journals. I'm pretty sure _SUBJOURNAL is for statements and sub-queries. Some additional info can be found here: http://www.sqlite.org/tempfiles.html In the bigger picture, I assume you know that Hwaci (the company that employs the SQLite developers) offers an encryption extension: http://www.hwaci.com/sw/sqlite/see.html It is a paid product, but the license terms are extremely liberal. -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Intelligence is like underwear: it is important that you have it, but showing it to the wrong people has the tendency to make them feel uncomfortable." -- Angela Johnson _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users