tags:

views:

23793

answers:

13
+22  Q: 

Mac SQLite editor

I am aware of CocoaMySQL but I have not seen a Mac GUI for SQLite, is there one?

My Google search didn't turn up any Mac related GUI's which is why I'm asking here rather than Google.

+13  A: 

SQLite Manager for FireFox

finnw
Hangs on slow running queries and had no cancel query button. I use RazorSQL.
wioota
+2  A: 

Try a versiontracker search instead. SqliteManager from SQLabs ($49, Mac & Windows) is the one I prefer, but I haven't really evaluated the other alternatives.

Hagelin
+4  A: 

That FireFox extension looks pretty nice. I've used SQLite Browser in the past and it did the job.

Bill Turner
SQLite Browser is kinda old but works just fine, and less of a commitment than firefox plugin (I use Safari, not use firefox)
Robert Gould
+3  A: 

I like the cross-platform SQLite Database Browser. It's simple and fast.

Adrian
+16  A: 

Base is younger than your question, and definitely feels like a 1.0, but the user experience is miles better than the experience of using any of the "cross-platform" apps on a Mac.

http://menial.co.uk/software/base/

I recommend you buy a license before the developer realizes he is charging too little for it.

benzado
I did :) It's very nice software.
Matthew Schinckel
I bought Base and I really love it. Perfect tool. Love all of the native controls.
Sam Soffes
+2  A: 

MesaSQLite is the best I've found so far.

http://www.mesamysql.com/?realmesa_home

Looks very promising indeed.

are you steve wozniak?
my vote goes to MesaSQLite too, not the best interface but it works
valexa
A: 

I found MesaSQL to be buggy. "Base" is simple, has a very mac-like GUI, and works very well IMO: http://menial.co.uk/software/base/

A: 

Sqliteman is my current preference: It uses QT, so it's cross-platform. Since I develop on Windows, Linux and OS X, it helps to have the same tools available on each.

I also tried SQLite Admin (Windows, so irrelevant to the question anyway) for a while, but it seems unmaintained these days, and has the most annoying hotkeys of any application I've ever used - Ctrl-S clears the current query, with no hope of undo.

Mike Houston
+9  A: 

I've published a detailed comparison of Base and other SQLite GUI apps here: http://www.tandb.com.au/sqlite/compare/?so

Tom
BareFeet

BareFeet
A: 

Razorsql can handle many kinds of databases.

+4  A: 

I've published instructions for how to run the Firefox SQLite Manager outside of Firefox, since FF hase become so bloated in the last few releases. It's really easy and I've even compiled a DMG for the sqlite gui if anyone wants it.

Jeremy Edgell
That works really well. Thanks!
Jeff Kelley
A: 

Here's a good comparison table: tandb.com.au

Kirk Ireson
A: 

I am using simple tool for basic sqlite operation called Lita

This tool is based on Adobe Air so that must be installed prior to use of Lita. Adobe air can be downloaded for free from Adobe site.

krishna