[solved] manage sqlite database
-
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.
-
Are you looking for a database browser like "this":http://sqlitebrowser.sourceforge.net/screenshots.html
-
I found sqlitebrowser a little bit buggy sometimes.
Other tools you can use are "Sqliteadmin":http://sqliteadmin.orbmu2k.de/ or "Sqliteman":http://sqliteman.com/
-
[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.
-
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.