Relative Path Needed for db in SQLite

[CoreyWhite]

The following code always crashes when it tries to open the database. If I give it a full absolute path it runs fine. I can't expect my users to all have the same path. So what gives? Thanks.

#include <QApplication>
#include <QMessageBox>
#include <QtSql>
#include "mainwindow.h"
#include "ui_mainwindow.h"
QStringList db;

void load_db0(){

QSqlDatabase db_new = QSqlDatabase::addDatabase("QSQLITE");
QString dbPath = QCoreApplication::applicationDirPath() + "/mydb.db";
db_new.setDatabaseName(dbPath);
db_new.open();

QSqlQuery query;
if(query.exec("SELECT * FROM phictionphreak")){
    while(query.next()){
        db << query.value(0).toString();
    }

}

db_new.close();
}

[SGaist]

Hi,

Don't put that database in the application folder. Take for example Windows, normal users can't write to the application folder. What you should do is use QStandardPaths with QStandardPaths::AppDataLocation to retrieve a valid path to store that database. Doing so you'll ensure that your users will be able do use it no matter what the OS is

[CoreyWhite]

Thanks SGaist, but that isn't quite the answer I am looking for. Right now I am playing with these 3 functions to try to get the directory that my executable is in, wherever it is in. I want the user to store the database wherever he has my executable.

Could you tell me which of these 3 options is the best, or if you know another one?

1: QString path = qApp->applicationDirPath();
2: QDir::currentPath();
3: QDir dir;
dir.absolutePath();

Thanks a bunch!

[SGaist]

Number one is the correct solution but it will probably fail on OS X, that's why I'm suggesting the use of QStandardPaths