PureBasic Forum

Sorry, please ignore this, I just realized the approach won't even work for my situation, as multiple threads would be writing to the database at once, which introduces a major risk of corruption. Better to keep it separate. Sorry for the post.

Yeah, a big topic you touch on with so little words.
SQLite out of the box, does not support encryption. There is the paid SEE lib from the author for $2000.
If you download and install DB Browser for SQLite, it offers 2 exe's. One is "C:\Program Files\DB Browser for SQLite\DB Browser for SQLCipher.exe".
It supports encryption via "C:\Program Files\DB Browser for SQLite\sqlcipher.dll", an open source lib.
You can use PB's new UseSQLiteDatabase() command:

I would install DB Browser and start prototyping your tables and queries.
Then codify them in PB with the verified SQL.
A lot left out, but there are many examples in the forum for SQLite use.