[Solved] Text management in a database?

[Dude]

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.

[skywalk]

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:

Code: Select all

CompilerIf #SQLITE_USE_DLL  ;-! USE sqlite3.dll
  #SQLITE_DLL_FNPATH$ = "C:\Program Files\DB Browser for SQLite\sqlcipher.dll"
  UseSQLiteDatabase(#SQLITE_DLL_FNPATH$)
...

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.