The best developer's or admin's GUI tool for Sqlite3 (sqlite) in the world. No joking here (or just a bit only) - it contains the most complete feature set of all tools available. Visit project homepage for more info, bugtracker, documentation, etc
Downloaded 1.2.2 on Ubuntu 14.05 LTS yesterday via the software center. Most will probably want to use the windows version. Decidedly for those who know SQL rather well, soft9000.com found that sqliteman is a must-have tool for those in-the-know. For the novice, sqliteman would be perfect for those who have just learned the SQL basics of views, select statements, as well as table creation. One should also be aware of the shorter list of abbreviated data types. Ultimately, I found that sqliteman's ability to allow us to keep a running list of select-and-run statement to be very addictive. Surely the perfect tool for the Sqlite enthusiast - Keep up the good work!