GUI tool for sqlite3?

Question

Im using the bundled sqlite3 version for rails and i wonder if there is an equivalent to phpmyadmin?

How else am i going to see what is in the database?

Thanks

Answer 1

SQLite Manager

I've been using this one for a few months now. It's not perfect but it works well enough for most scenarios.

https://addons.mozilla.org/en-US/firefox/addon/5817/

It's a firefox plugin for some reason, but you point it at a .sqlite file and it does all the rest for you.

Answer 2

Check out:

• SQLite Browser

• SQLite Administrator

Both freeware, SQLite Browser also runs on Windows, Mac OS X, Linux etc.

Answer 3

This question has already been answered for OSX: http://stackoverflow.com/questions/100959/mac-sqlite-editor