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.
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.
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.
That FireFox extension looks pretty nice. I've used SQLite Browser in the past and it did the job.
I like the cross-platform SQLite Database Browser. It's simple and fast.
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.
MesaSQLite is the best I've found so far.
http://www.mesamysql.com/?realmesa_home
Looks very promising indeed.
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/
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.
I've published a detailed comparison of Base and other SQLite GUI apps here: http://www.tandb.com.au/sqlite/compare/?so
Tom
BareFeet
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.
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.