C++ SQLite3 encrypted DB

MrLibya

Hallo

I've encrypted my SQLite3 db by Navicat ! : alt text

So my code:

QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
    db.setDatabaseName(QApplication::applicationDirPath()+ QDir::separator() + "test.db");

and db.login() return true ;

but my trying to execute a query :

QSqlQuery q("SELECT * FROM test");
    while(q.next())
        qDebug()<<q.value(0).toString();
    qDebug()<<q.lastError().text();

so i got :

"file is encrypted or is not a database Unable to execute statement"

i've also try to

db.setPassword("mypass");

but also didn't work

SGaist

Hi,

SQLite is not encrypted by default so you should check with the Navicat folks whether they are using SQLCipher for that.

AFAIR, there are instructions available to build a plugin for Qt using SQLCipher so it's worth checking.

MrLibya

@SGaist i've checked they use wxSQLite3 for encrypet , Qt dosen't supoort it right ? so i need to include the wxSQLite3 library in my project and use it ?

SGaist

Looks like you might be lucky. QtCipherSqlitePlugin.might be what you need.

MrLibya

@SGaist thx :)

Ryna

@sgaist said in C++ SQLite3 encrypted DB:

QtCipherSqlitePlugin

As far as I understand QtCipherSqlitePlugin is not an open source. Do we have something in open source which encrypt the data in database? I tried SQLCipher from https://www.zetetic.net/sqlcipher/open-source/ but I am unable to use it as an usual external library in Qt. Isn't it possible? Can you please give me some suggestion on which database i can use, which provides encryption, is open source and can get easily get integrated in Qt?

Christian Ehrlicher

@ryna said in C++ SQLite3 encrypted DB:

As far as I understand QtCipherSqlitePlugin is not an open source.

Why not? It's LGPL 2.1

Bharath Ram

This post is deleted!

Solved C++ SQLite3 encrypted DB