[solved] manage sqlite database

[nhojyer07]

Hi! I just wanna ask if there's something like a SQLite manager included in the SDK? If not, can someone point me to one? Thanks!

[Eddy]

No Qt has no sqlite manager, but if you google you will find a lot of them, even cross platform ones. Here is a "link":http://sqlite.com/cvstrac/wiki?p=ManagementTools with lot's of details. If you let us know what you consider important and what OS you want it for, then maybe we could share what we experienced with one of them.

http://sqlite.com/cvstrac/wiki?p=ManagementTools

[nhojyer07]

I just want to see what's going on with the database created by the mobile game I am working on. I want to edit some records in the database for testing on the simulator.

[Rahul Das]

Are you looking for a database browser like "this":http://sqlitebrowser.sourceforge.net/screenshots.html

[nhojyer07]

I guess I'll use the one Rahul suggested. Thanks to the both of you.

[octal]

I found sqlitebrowser a little bit buggy sometimes.

Other tools you can use are "Sqliteadmin":http://sqliteadmin.orbmu2k.de/ or "Sqliteman":http://sqliteman.com/

[nhojyer07]

The problem is, I don't know where my game saves the database file so I can open it.

[octal]

Unfortunately, we won't be able to solve the problem for you :). Try to perform a research on some folders, you might be lucky and find your base. On windows, you could maybe try looking at %AppData% folder.

[nhojyer07]

I've been searching the file before. I just wanna know what file extension does the database have.

[Rahul Das]

@db.setDatabaseName(":memory:");@
If you gave database name like above, db file would reside in the memory.

@db.setDatabaseName("your_db_name");@
But , in this case,db will be created in the same folder where the executable is residing.

[Rahul Das]

Assuming, you are using QtCreator with "default" build settings (projectname_build_simulator), Db file can be found here,if you have given like
@db.setDatabaseName("your_db_name");@

[Rahul Das]

[quote author="nhojyer07" date="1313738720"]I've been searching the file before. I just wanna know what file extension does the database have.[/quote]

I guess you dont need to worry about this. There is no typical extension, other than the file name, unless you give one.

[andre]

Rahul, please stop replying to yourself. Just add to your previous message if you want to add more contents.

[Rahul Das]

Adre, i am sorry. I just wanted it to be separate and clear. Will do,next time.

[nhojyer07]

Thanks for the reply Rahul. You've been a great help.

EDIT: I tried using setDatabaseName() as you suggested though I just receive an error.

Result of expression 'db.setDatabaseName' [undefined] is not a function.

Using the "SQL Local Storage example":http://doc.qt.nokia.com/4.7-snapshot/declarative-sqllocalstorage.html as reference, where should I call the function?

[Rahul Das]

I am not really familiar with QML though, i suppose , you can still follow how we connect in a normal Qt application. :) ie,for example, in your main,
@int main(int argc, char *argv[])
{
QApplication app(argc, argv);
QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
db.setDatabaseName("db_name");@

Am sorry, :( dont know much about QtQuick :(

And don't forget to add sql module in *.pro file.

[nhojyer07]

So the reason why I can't find the database is its filename is composed of a combination of hexadecimal numbers. I finally found it at last. Thank you very much for the help guys. I guess this is completely solved.