We stand with Ukraine to help keep people safe. Join us
All Apps
Best AppsReviewsComparisonsHow-To
When you purchase through links on our site, we may earn an affiliate commission

Base for Mac

Create, design, edit, and browse SQLite 3 database files.

$28.99
In English
Version 2.5.2
3.8
Based on 18 user rates

Base overview

Base is an application for creating, designing, editing, and browsing SQLite 3 database files. It's a proper OS X application. Fast to launch, quick to get in to and get the data you need. (The trial is limited to 15-minute sessions, and custom queries only return 5 rows.

Features:
  • Schema viewing
  • Table contents viewing/editing
  • Custom SQL queries
  • Command logging
  • Support for viewing and editing ALL column- and table-level constraints; from simple default values, to complex foreign keys, Base can handle it
  • Advanced table designing and altering; no need to manually type CREATE TABLE statements, from a single sheet you can add, edit and remove columns and constraints to your heart's content, maintaining or moving the original data within them
  • Quick data find and filter; build lengthy SELECT statements with a few clicks, previewing results as you go
  • Easy SQL editing, with clear syntax highlighting and useful SQL auto-completion
  • Store your commonly used SQL as snippets for easy re-use later
  • Easy import, comprehensive export; bring in data from CSV or SQL files; export to SQL, delimited text, XML, or Microsoft Excel-compatible formats

What’s new in version 2.5.2

Version 2.5.2:
  • Fixed a bug where exported SQL files would be empty
  • Fixed a bug causing CHECK constraints to not be editable

Base for Mac

$28.99
In English
Version 2.5.2
Write a detailed review about Base

Write your thoughts in our old-fashioned comment

MacUpdate Comment Policy. We strongly recommend leaving comments, however comments with abusive words, bullying, personal attacks of any type will be moderated.
3.8

(19 Reviews of Base)

  • Comments

  • User Ratings

Itistoday
Itistoday
Oct 18 2013
2.4.7
5.0
Oct 18 2013
5.0
Version: 2.4.7
My go to software for sqlite3. Fast, intuitive, well designed and stable. Priced a bit high IMO. Worthy of a MacUpdate pick (red highlight) IMO.
GymW
GymW
Mar 25 2012
2.3
0.0
Mar 25 2012
0.0
Version: 2.3
Not really. There are no ulterior motives. as the previous comment might suggest. I am just trying to communicate two things: - That users should not confuse this with another product of the same name. - To inform the developer by naming the product the same as another product that is under the umbrella of a megacorporation that is not known for altruistic acts, the developer could be risking a legal action. What do I get from this -- nothing. I am just trying to be helpful, reduce possible confusion from prospective customers, and help the developer avoid a potential lawsuit.
Steve-Cholerton
Steve-Cholerton
Feb 6 2012
2.2.1
4.0
Feb 6 2012
4.0
Version: 2.2.1
I really like this app. It' simple and functional. I occasionally have to switch to sqlite manager for something but that is rare. Great job dev :-)
goosesensor
goosesensor
Apr 7 2011
2.0.2
4.5
Apr 7 2011
4.5
Version: 2.0.2
Great app. 'Had been using MesaSQLite as a simple GUI for my occasional SQLite work. It worked, and was free, but was awkward and glitchy and wasn't compatible with newer SQLite formats. This app is nothing too crazy for fancy, but it's clean and intuitive and nice. It does just what I need and does it well. Good purchase.
Macgruder
Macgruder
Mar 4 2011
2.0
0.0
Mar 4 2011
0.0
Version: 2.0
Oops. Version 2 seems to have lost the ability to add a column to a table. Where there were 3 buttons to Add Index, Remove Index, and Add Column now the Add Column one is missing. I can only imagine this is a temporary oversight as it seems good software. If the ability is still there then there's a interface issue as it must be well hidden somewhere.
Itistoday
Itistoday
Oct 18 2013
5.0
Oct 18 2013
5.0
Version: null
JakeGoodwin3088
JakeGoodwin3088
Apr 30 2013
4.0
Apr 30 2013
4.0
Version: null
Steve-Cholerton
Steve-Cholerton
Feb 6 2012
4.0
Feb 6 2012
4.0
Version: null
ocq
ocq
Dec 11 2011
5.0
Dec 11 2011
5.0
Version: null
Hans_K
Hans_K
Aug 6 2011
2.0
Aug 6 2011
2.0
Version: null
goosesensor
goosesensor
Apr 7 2011
4.5
Apr 7 2011
4.5
Version: null
RkBob
RkBob
Dec 15 2010
2.0
Dec 15 2010
2.0
Version: null
Hsoft
Hsoft
Aug 2 2010
5.0
Aug 2 2010
5.0
Version: null
Xplicit
Xplicit
Apr 26 2010
5.0
Apr 26 2010
5.0
Version: null
Nascitur
Nascitur
Mar 8 2010
5.0
Mar 8 2010
5.0
Version: null
Taoeffect
Taoeffect
Mar 7 2010
5.0
Mar 7 2010
5.0
Version: null
Guest
Guest
Mar 1 2010
1.0
Mar 1 2010
1.0
Version: null
Serkol
Serkol
Feb 21 2010
3.0
Feb 21 2010
3.0
Version: null
Vera-Tkachenko
Vera-Tkachenko
Jan 16 2010
4.0
Jan 16 2010
4.0
Version: null
barefeettom
barefeettom
Jul 26 2009
3.0
Jul 26 2009
3.0
Version: null
Morgan4
Morgan4
Feb 23 2009
5.0
Feb 23 2009
5.0
Version: null
Irvtheswirv
Irvtheswirv
Jan 16 2009
1.0
Jan 16 2009
1.0
Version: null
Bridgeyman
Bridgeyman
Nov 18 2008
5.0
Nov 18 2008
5.0
Version: null