SQLite3 helper?

Question

Is there any application like SQL Buddy for SQLite3 for Mac. I am just starting with Ruby on Rails and have my environment set up on my Mac running Snow Leopard, I have used SQL Buddy before and I was wondering if anyone knows anything like that for SQLite3.

Answer 1

I've used this Firefox Plugin.

Answer 2

I use base on OS X. It costs £10.00 but it is easy to use and had a great interface.

Answer 3

SQLite Database Browser runs on OS-X, though it's a bit flaky.

Honestly the command line sqlite3 app is pretty solid for what it is (e.g. you can import/export to CSV). Type .help from the prompt for commands.

Answer 4

I also use Firefox SQLite Manager, or you can use the ruby GUI for SQLite available out there.

Answer 5

I use SQLiteManager. It's useful for importing/exporting data too. http://www.sqlabs.net/

Answer 6

MesaSQLite is free and works well on OSX.