[SOLVED]What would be the best way to have database support in my application.

ealione

Indeed, it should be faster too.

ealione

The location created from this command

    db_path = QDir(QStandardPaths::writableLocation(QStandardPaths::AppDataLocation)).filePath("database.db");

does not seem to actually exist in my system, moreover the copy command fails.

Is it normal that db_path returns a location that does not exist?

SGaist

What value are you getting ?

ealione

db_path has a value of "C:/Users/eali/AppData/Roaming/ealione/v002/database.db"

SGaist

Looks good

What is your problem with it ?

rturrentine

Maybe you think the folder doesn't exist because the "AppData" folder is hidden by default.

ealione

Looks correct indeed, the thing is that it does not exist (not simply hidden), and the copy command:

QFile::copy(":assets/database/database.db", db_path returns false.

rturrentine

Is ":assets" Android specific? Also should it be "assets:/datatbase...."

Leonardo

QStandardPaths returns a writable path for you. It doesn't guarantee you that it exists. If if doesn't, create it using QDir.mkpath()

As you know it's a writable location, it won't be a problem.

=========

@rturrentine is right also. ":assets" is for android. For Qt resources, you should use ":/database/database.db".

rturrentine

BTW, here is a link to a related post: