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
