access SQlite from Qt (Windows & Linux)

[ChrisW67]

You can get a basic command line tool to manipulate Sqlite databases from the Sqlite site:
http://sqlite.org
This tool can be very useful when you first start an Sqlite database project.

You can also create and manipulate databases within the code of your Qt application. As others have pointed out you only need to use a Qt library built with Sqlite support (e.g. any of the Qt Creator SDK downloads).

[jpujolf]

If you want a "graphical interface" can also use this one.

SQLiteman

Made with Qt, so works in Linux/Unix, Win, Mac...

[Qt Coder]

I had installed SQLIteman.

created one database and one table in it.

Nos how to connect to this database from Qt?????

[jpujolf]

Take a look at this

Also you can look at here or here

And from now on, before asking so basic things :

- Read at least Qt's documentation here
- Google a little or search Qt centre ( I've done a simple search : sqlite connect and got me 24 results )

And please, please, please : don't open TWO threads asking the same and don't ignore the answers people gently gives to you ( as here )

Thanks.

[Qt Coder]

When I created a new database in sQLiteman.then first it asked me to store one file .

I hav attached that file herewith.......

Now my question is ,how my qt application would recognize where my database is located...

Do I hav to place this at path executable resides.....

[nish]

please man... take a look at qtassistant... search for qt sql module... its very easy task

[SunnySan]

If you want a "graphical interface" can also use this one.

SQLiteman

Made with Qt, so works in Linux/Unix, Win, Mac...

thanks for the link Sqliteman is a great open source SQL application.