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 [sqlite.com] 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

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.

Are you looking for a database browser like this [sqlitebrowser.sourceforge.net]

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

I found sqlitebrowser a little bit buggy sometimes.

Other tools you can use are Sqliteadmin [sqliteadmin.orbmu2k.de] or Sqliteman [sqliteman.com]

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

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.

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

Assuming, you are using QtCreator with “default” build settings (projectname_build_simulator), Db file can be found here,if you have given like

nhojyer07 wrote:

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

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

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

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

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 [doc.qt.nokia.com] as reference, where should I call the function?

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,

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

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