[solved] manage sqlite database
-
Are you looking for a database browser like "this":http://sqlitebrowser.sourceforge.net/screenshots.html
-
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":http://sqliteadmin.orbmu2k.de/ or "Sqliteman":http://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.
-
@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. -
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");@ -
[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.
-
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":http://doc.qt.nokia.com/4.7-snapshot/declarative-sqllocalstorage.html 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,
@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.
-
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.