I have previously used SQLite Manager, it had the usual database management features in the GUI. There was a window displaying tables, view, indexes etc. in an explorer style. Another window allowed display and editing of selected tables and display of database structure. Finally there was a tab allowing you to run SQL commands. This version seems to only have the command line feature. I cannot find any way to explore the database in the GUI. Having opened a database, nothing appears in the GUI window. I haven't tried the math or script functions as I couldn't easily perform basic editing of the database.

Not what i expected, THIS IS NOT THE ORIGINAL "SQLite Manager" so for a more powerful solution i switched to SQLiteStudio which works perfectly :)