Qt and databases save and open them

Question

I have an app that handles multiple databases which the users edits and i would also like it to open them from a specified path (like i get the path using QFileDialog).

Also I saw that it saves the databases files where the executable file is but is there a way i can make it to save them in another place?

user1092803 · Accepted Answer · 2012-02-13 11:19:57Z

3

If you are working with sqlite, then you just need to pass to db.setDatabaseName(file_name) (where db is the connection) the path to the file, that you can select with QFileDialog.

If you are working with other database, then you probably just connect to a database server.

answered Feb 13, 2012 at 11:19

user1092803

3,3072 gold badges36 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Neox · Accepted Answer · 2012-02-13 12:42:23Z

1

First of all which database are you working with; MySQL, SQLite. In case you are working with SQLite this is really easy. You specify a filename when you add the database. So for example:

//get the database file with QFileDialog
QString fileName = QFileDialog::getOpenFileName(this,
 tr("Open Database"), "/home/yourhome", tr("SQLite Database Files (*.sqlite)"));

//add the new database
QSqlDatabase db = QSqlDatabase::addDatabase("SQLITE");
db.setHostName("localhost");
db.setDatabaseName(fileName);
//now your database will be stored in fileName

answered Feb 13, 2012 at 12:42

Neox

2,00413 silver badges12 bronze badges

Collectives™ on Stack Overflow

Qt and databases save and open them

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related