Page 1 of 1
[Solved] Text management in a database?
Posted: Sun Sep 15, 2019 1:50 am
by 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.
Re: Text management in a database?
Posted: Sun Sep 15, 2019 2:22 am
by 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.