Overview
Examples
Screenshots
Comparisons
Applications
Download
Documentation
Tutorials
Bazaar
Status & Roadmap
FAQ
Authors & License
Forums
Funding Ultimate++
Search on this site
Search in forums












SourceForge.net Logo
Home » U++ Library support » U++ SQL » Sqlite encryption
Sqlite encryption [message #60164] Tue, 19 September 2023 17:37 Go to previous message
forlano is currently offline  forlano
Messages: 1185
Registered: March 2006
Location: Italy
Senior Contributor
Hello,

I have seen many methods like IsEncrypted(), ChangePassword(), Open(..., cypher)...
so it seems that the db can be encrypted. I need not to let the user to open the db with some external tool like DB for Sqlite Browser and performs unwanted operations.
I would like to have a very short example of:

1. how to create a db in some encrypted way;
2. how to read/write data while it is being used by my U++ client (if the queries need some special flag).

From what I read so far it seems that should be enough to open the database in this way:

if(!sqliteVT.Open( dbname, some_password, Upp::Sqlite3Session::CIPHER_CHAHA2020_DEFAULT )) {
...
}


all the rest remain the same. Can you confirm?

Many thanks in advance.
Luigi

[Updated on: Tue, 19 September 2023 19:38]

Report message to a moderator

 
Read Message
Read Message
Read Message
Previous Topic: How to make a copy not crypted of a Sqlite db
Next Topic: SqlPerformScript bug: Not doing anything if script starts with "BEGIN;" and ends with "END;"
Goto Forum:
  


Current Time: Thu May 16 05:13:01 CEST 2024

Total time taken to generate the page: 0.02321 seconds