Take the 2-minute tour ×
Ask Different is a question and answer site for power users of Apple hardware and software. It's 100% free, no registration required.

I am looking for a preferably free SQLite frontend to use under OS X.

Something similar to MySQL Workbench will do. Put separate suggestions in separate answers.

share|improve this question
2  
There is a similar questions on StackOverflow here. You might find some additional answers. –  a blue marker Jan 9 '13 at 13:29
add comment

8 Answers

up vote 7 down vote accepted

SQLite Database Browser

SQLite Database browser is a light GUI editor for SQLite databases, built on top of Qt. The main goal of the project is to allow non-technical users to create, modify and edit SQLite databases using a set of wizards and a spreadsheet-like interface.

share|improve this answer
    
I'll second this. I use it and it works as advertised, plus it's free. –  user479 Jun 5 '11 at 22:14
add comment

SQLite Manager Firefox Add-on

Not native OS X app, but it will do the work!

share|improve this answer
    
It seems that everything is integrated into Firefox these days. That's a really weird use of a browser, IMO. Completely different from something such as phpSqLite. –  Jason Salaz Jun 6 '11 at 7:45
    
It's free! And I find it is better SQLite Database browser in providing copy/edit usability, colour for readability, and sidebars for quick access. The only downside that it has from SQLite Database browser is that it requires Firefox. –  James Feb 12 at 19:46
add comment

There are also the Navicat brand of SQL editors, including Navicat for SQLite, which are available in the Mac App Store (http://itunes.apple.com/us/app/navicat-for-sqlite/id424161923?mt=12).

I've not used their SQLite tool, but have used their MySQL product, and found it to work well for most tasks.

share|improve this answer
add comment

Navicat SQLite ($49/$99)

Navicat for SQLite is a powerful Database administration and development tool for SQLite. It works with SQLite version 2 and 3 and supports most of the SQLite features including Trigger, Index, View, and so on.

It's a good product but IMHO expensive.

share|improve this answer
add comment

It's a far cry from the other graphical tools mentioned here, but I've found that I prefer interacting with my SQLite databases with the built-in command line tool, sqlite3:

$ sqlite3 test.db
SQLite version 3.6.12
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> create table test (a, b);
sqlite> insert into test values (2, 3);
sqlite> insert into test values (4, 3);
sqlite> insert into test values (4, 5);
sqlite> select * from test where a<b;
2|3
4|5
sqlite> .schema
CREATE TABLE test (a, b);

The best part is that it's built into Mac OS X and is completely, 100% free. (No seriously, the code is in the public domain)

share|improve this answer
    
Facepalm. It took me an hour of searching to find out it was already installed on my machine. –  Rob van der Veer Jul 31 '13 at 12:25
add comment

Base ($32.99 USD / £19.99)

Native OSX app for interacting with SQLite databases. Base isn't free, but I've found it to be useful. You can buy it through the Mac App Store.

share|improve this answer
add comment

SQLite Professional is another SQLLite editor for OS X. It is no longer free, however if you follow the instructions here, you can get a free promo code.

Features Include:

  • Version integration. Mucked your database? Rollback to a previous version.
  • Automatic reloading if the database gets modified outside of the app.
  • Column reordering.
  • Export (or import) data with csv, mysql, xml or json.
  • Backwards compatibility with SQLite 2.
  • Fullscreen support.
  • Inline filters allowing you to customize the way your data is displayed.
  • Semiautomatic dependency resolution.
share|improve this answer
    
Please have a look at the faq, especially the part about self-promotion. As there is no "best" tool for everybody, could you also add a list of unique features your tool has? –  patrix Apr 22 '13 at 13:14
add comment

You can try Valentina Studio http://www.valentina-db.com/en/valentina-studio-overview 14 Feb 2013 in the 5.0 version added support of SQLite, as well as, MySQL, PostgreSQL. It is FREE. Works on Mac, Win and Linux. Includes not only db management but powerfull reports that work again on 3 OS.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.