How to Make sqlite database file not to open using any browser ?



  • Hi
    I am working on sqlite database in my app , where i need to hide the data in database using some encryption methods. Please suggest me some methods to encrypt data going in to database and decrypt the same. Database will have 6 months of data.And at any point of time i need to decrypt the same. And i need to make sure the database file i created should not be opened through any browsers as well to decode the data(Other than password protected Method).
    Please suggest me an right approach.

    Regards
    Bala B





  • Hi
    Thanks for the help.
    I have successfully installed sqlcipher on linux. But i am not sure how to encrypt the data that is inserted. Should i explicitely write functions for that or will sqlcipher handle ?

    Can you please suggest me.

    Regards
    Bala B



  • The tests of that library provide a nice example: https://github.com/sijk/qt5-sqlcipher/blob/master/test-shared/main.cpp in the end it just needs a pragma query db.exec("pragma key='myPassPhrase'");



  • Hi
    Thanks for the help.
    I did following things on terminal on linux.
    Created a database using

    sqlcipher comments.db and then inside sqlite->

    sqlite> pragma key='foobar';
    sqlite>create table foo (bar integer);
    sqlite>insert into foo values (42);
    and then
    sqlite> select bar from foo; it gives me a value 42.

    and i quit the database and logged in again to check the value

    sqlite> select bar from foo;
    it says file is encrypted or is not a database.

    sqlite>pragma key='foobar';
    sqlite> select bar from foo;

    still it shows the same error.

    Is this how it works ? Can you please correct me if i am wrong.

    Regards
    Bala B


Log in to reply
 

Looks like your connection to Qt Forum was lost, please wait while we try to reconnect.