If( false = query.exec( 'create table person (id integer primary key, firstname varchar(20), lastname varchar(30), age integer)' ) ) QDebug() << _FUNCTION_ << ' Error: Could not establish destination storage: ' << db.lastError().text() QSqlDatabase db = QSqlDatabase::addDatabase( 'QSQLITE' ) ĭb.setDatabaseName( QString::fromStdString( sDestinationFile ) ) Here's how I create a database in local storage that I would expect a SQL viewer could NOT view without the same username/password combination (but unfortunately it can.) QString qsUsername = 'test-name'
I'm specifying a username and password via the Qt API as I think I'm supposed to be using it, and SQLITE has supported username/password protection for roughly 10 years or so - ergo, I expect I'm just using it wrong.
There's a question in the forums about this, with an indefinite answer - does anyone involved using SQLITE and Qt (via the Qt driver) know definitively if there's a way to protect the database?
