free sqlite tools

Question

looking for a free sqlite tool, any suggestions? I need a export, import functionality.

Thanks for the recommendation.

Answer 1

I've used the Arca Database Browser with good results, available here: http://xtras.tabuleiro.com/download/arca.htm.

Answer 2

SQLite Maestro sounds like it meets your needs.

Answer 3

SQLMaestro (http://www.sqlmaestro.com/products/sqlite/datawizard/) has a good range of bulk import/export with what looks like over 20 formats (but since I don't need bulk import/export, I haven't tried this program). Oops ... look like i missed the "FREE" part

I'm using the FREE Firefox plugin SQLite Manager (https://addons.mozilla.org/en-US/firefox/addon/5817) and it is really handy. It will handle a few import/export formats (CSV, SQL and XML)

SQLiteMan (http://www.sqliteman.com/) can import in half a dozen or so formats. Export doesn't seem obvious. Its free as well.

A few more FREE options (none of which I have tried include)

• SQLite Administrator(http://sqliteadmin.orbmu2k.de/)
• SQLiteStudio (http://sqlitestudio.one.pl/index.rvt)

Answer 4

I've used http://sqlitebrowser.sourceforge.net/ when I need to quickly browse/edit an sqlite database. There's a very long list of other such tools at http://www.sqlite.org/cvstrac/wiki?p=ManagementTools

Answer 5

Probably

SQLiteMan

is about the best and most well known.

I personally like:

SQLite Administrator

as it's very small and lightweight, but does have it's quirks. However, there's a whole list of SQLite tools (both free, open source and commercial) here:

Commercial and freeware Sqlite tools list

Answer 6

I love SQLite manager: https://addons.mozilla.org/en-US/firefox/addon/5817

Oddly enough, it's a firefox addon.

Answer 7

Now i use Lita - SQLite Administration Tool

it's a free applications developed in Adobe Air.

the only thing that disturbs me is that it sorts the columns when you query. Besides that it does what I want.