It is currently Fri Jan 22, 2021 4:17 am

All times are UTC + 1 hour




Post new topic Reply to topic  [ 2 posts ] 
Author Message
 Post subject: [Solved] Text management in a database?
PostPosted: Sun Sep 15, 2019 1:50 am 
Offline
Addict
Addict

Joined: Mon Feb 16, 2015 2:49 pm
Posts: 1907
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.


Last edited by Dude on Sun Sep 15, 2019 4:38 am, edited 1 time in total.

Top
 Profile  
Reply with quote  
 Post subject: Re: Text management in a database?
PostPosted: Sun Sep 15, 2019 2:22 am 
Offline
Addict
Addict
User avatar

Joined: Wed Dec 23, 2009 10:14 pm
Posts: 3377
Location: Boston, MA
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:
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.

_________________
The nice thing about standards is there are so many to choose from. ~ Andrew Tanenbaum


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 

All times are UTC + 1 hour


Who is online

Users browsing this forum: No registered users and 28 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  

 


Powered by phpBB © 2008 phpBB Group
subSilver+ theme by Canver Software, sponsor Sanal Modifiye