Sqlite Manager
Regena Morguson
This program is not a visual shell for the sqlite command line tool, and doesnot require familiarity with SQL commands. It is a tool to be used by bothdevelopers and end users, and must remain as simple to use as possiblein order to achieve these goals.
Less expensive, fully featured manager. The author is very responsive to comments and bug reports, and publishes updates frequently. The flip side, if you look at version history, is that new releases seem to introduce new bugs, which are then fixed in sunsequent builds. The GUI is fine, very good for quickly designing new databases; a little less so for designing queries and working with large amounts of data. Main gripe: you can't see the schema while editing a query (without flipping tabs in the program).
If you want just CRUD operations on the sqlite database file, then SQuirreL is a very option as it has an auto complete feature which drastically improve the speed and efficiency of typing the sql queries.
This leads me to ask if I am going about this the correct way. I can see how some of my query logic (for search, sort) is probably better off being in a different "controller" type class and that all this manager class needs to do is handle the basic creation and deletion tasks, and just return a query object in response to a SELECT statement passed in as a string.
The source code and various scripts used in this project are hosted as a git repository at -manager.
The following command will create a clone of the project in your current directory:
git clone git://github.com/lazierthanthou/sqlite-manager.git
In case you would like to download the source without having to clone the repository,
- you can download the tarball
- or, you can download the zip
This is the best web-based SQLite manager I've used so far. It is very easy to install and can do basically anything you would ever want to do with a SQLite database. It supports both SQLite2 and SQLite3. It even says on its web site that its goal is to be the SQLite equivalent of phpMyAdmin.
One possibility is to use sqlite-manager to view the sqlite file. This is usually the way I view the data and debug my queries, although there are many other resources for viewing and querying SQL files.
35fe9a5643