SQLITE Database in Project

mrjj

Hi
If small database, you can just copy
it to file system upon run and
open it.

Just override it each time.

I do not think its possible to have a db in qrc.

cawlfj

@mrjj yes , you are right . we can do as your way. but i think if the db file in inside the qrc file will be more safety than copy out.
Some time , some data , we don't want some body to get it .

mrjj

@cawlfj
Well its not impossible to still dig it out using a hex editor.
For dbs, something like
https://www.zetetic.net/sqlcipher/about/
might be better.
Maybe you can use the dump trick to upload to a :mem based db.
http://stackoverflow.com/questions/3826552/in-python-how-can-i-load-a-sqlite-db-completely-to-memory-before-connecting-to
Disclaimer: i never tried this.

EdgarDinz

Consider using QTemporaryFile::createNativeFile:

QTemporaryFile *QTemporaryFile::createNativeFile(QFile &file)
QTemporaryFile *QTemporaryFile::createNativeFile(const QString &fileName)

then you can pass a resource path as fileName.

an_auto

This post is deleted!