If you’re using SQLite for your small apps then using GUI interface for database creation can be handy. There is no official GUI tool for manipulating SQLite database. There are some 3rd party gui tools for sqlite. Few tools are either discontinued or are still packaged with old version of sqlite.
You can download SQLite administrator from this site. SQLite administrator is shipped with SQLite version 3.4. You’ll notice that this version is old and you’re having trouble using new version of sqlite with this tool. But if you’re looking for gui interface for your sqlite database that has no issue with old version of sqlite then this tool is beneficial for you.
SQLite administrator offers you to control the data with help of 3 tabs. First tab “SQL Query” allows you to type sql query and execute against the command line of SQLite. You’ll find the result of SQL query in “Results” tab. If you wish to manipulate table manually then “Edit” tab is useful.
Right clicking on table or database gives you menu options for creating: table, index and trigger. You’ll find this option saving lot of your time. You can also save your database in folder of your choice which is good feature if you wish to save your database in folder where your application resides.
You can also export your data in format available. There is also option for exporting the data in excel format. This feature is useful if you wish to make your database available in csv or excel format. There is also data import option available in data menu.
In comparison to SQLite maestro there are very less feature from this software. You’ll find that it’s good software but due to lack of updates it’s not worth to use for the production software development. I wish SQLite administrator developers update this software regularly. If you wish to use commercial alternative sqlite admin then SQLite maestro is very good and efficient alternative.