Base
Base
2.5.1

4.5

Base free download for Mac

Base2.5.1

17 May 2020

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

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 Base

Version 2.5.1:
  • Fixed a bug where Base would crash part-way through exporting some files

Join over 500,000 subscribers.

Subscribe for our newsletter with best Mac offers from MacUpdate.

How would you rate Base app?

19 Reviews of Base

5
Itistoday
18 October 2013
Version: 2.4.7

Most helpful

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.
(2)
5
Itistoday
18 October 2013
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.
(2)
Jimw
24 March 2012
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.
(0)
Show comment (1)
4
Steve-Cholerton
06 February 2012
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 :-)
(0)
4.5
goosesensor
07 April 2011
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.
(0)
Macgruder
04 March 2011
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.
(0)
Show comments (3)
Jimw
19 February 2011
Version: 2.0
This product should not be confused with the Base database in OpenOffice.org and LibreOffice, both free packages that have most of the same features found in MicroSoft Office. Base is similar to Microsoft Access in OpenOffice and may be a copyrighted name by OpenOffice and/or Oracle. Calling this product "Base" in my opinion is a very bad choice of names since Base in Open Office is licensed under a GPL and may not be sold - only given away (nominal fees may be charged for distribution and support may be fee based). I would strongly suggest the developer remove this product from sale until the copyright issues regarding the name is determined or change the name immediately as Oracle does have a high powered legal staff that is not shy about lawsuits and collecting big bucks when an opportunity presents itself.
(3)
Show comments (2)
Peternsteinmetz
19 February 2011
Version: 2.0
This is NOT shareware. It is a demo, runs for limited time and has limited functionality. Shareware is where the user decides if and how much to pay for the product. It would be nice if MacUpdate actually insisted on people using the proper categorization.
(1)
Show comments (3)
anonymous-gerbil-5319
16 August 2010
Version: 1.4.1
Nice app, does what is needs to do.
(0)
5
Hsoft
02 August 2010
Version: 1.4
Does what I need, simple interface, cheap. It's a winner!
(0)
5
Xplicit
26 April 2010
Version: 1.4
Fast, reliable, good interface, good features and a reasonable price. Excellent. What else is there to say?
(1)
5
Nascitur
08 March 2010
Version: 1.4
Fast, easy and beautiful Mac-like UI. Love it.
(0)
5
Taoeffect
07 March 2010
Version: 1.4
A wonderful niche product with a beautiful UI. In the month or so that I've been reviewing this it has performed nicely. I'm a bit surprised by some of the low reviews, many of them seem unfounded. Personally, I haven't experienced any problems that would justify a low rating. One thing that I would like though, is for NULL to be highlighted in a different color so that when I make changes or look over results I can be certain that it really is NULL and not the string "NULL".
(1)
1
Keynesis
01 March 2010
Version: 1.3.3
Useless. Can't modify tables after they are created. Looks like someone made this over the weekend.
(0)
Show comments (2)
3
Serkol
21 February 2010
Version: 1.3.3
I bought and used Base for a couple of months. Recently I have decided to upgrade my ancient license of a competing app, and I switched back to it. The new version of the competing app turned out to be much better then version 1.3.4 of Base. Base version 1.3.4 has very limited set of features (almost no features, compared to the competition) and too many problems that took too much of my time to work around (import-export, clipboard, unicode, browsing large result sets, ...). I've emailed the developer a few times, back in December 2009. He said that he was going to release a new version in the beginning of 2010... I still don't see the new version, and I'm not waiting for it anymore...
(0)
Show comments (3)
4
Vera-Tkachenko
16 January 2010
Version: 1.3.3
I need to work with SQLite databases, especially after starting iPhone development. Command line sqlite takes much more time to perform some basic db browsing/editing etc. I've discovered lots of SQLite editors, and only Base has native Mac UI (not all this poor looking Java app). Maybe it has less features than other "monster" but if you need to do basic editing Base is a perfect choice.
(2)
3
barefeettom
26 July 2009
Version: 1.3.2
Base is a neat reliable SQLite GUI app. It's good to see tat the latest version has fixed a few problems, such as opening database files on AppleShare volumes and altering (add column or rename) of tables containing a space in the name. The syntax coloring is good (including known functions) but could be improved. The biggest drawback for me is that Base, like many other similar apps, doesn't facilitate editing of data in views. I'd also like to see: 1. The ability to drag entities into the SQL editor, since the entity browser is conveniently always visible. 2. A quick filter and/or search refinement for the entity list and the data viewer. 3. NULL showing as a blank cell but somehow distinct from text (eg a color or something to show it's different to an empty string). 4. Show triggers and indexes with the table/view that owns them. I've published a detailed comparison of Base and other SQLite GUI apps here: http://www.tandb.com.au/sqlite/compare/?mu
(0)
5
Morgan4
23 February 2009
Version: 1.2
I haven't needed to register yet because my needs haven't grown that far. But I did use the trial for a some quick changes to a REALbasic .rsd database, and it worked great. This would be a worth addition to a REALbasic developer's toolbox. It solves the chicken-end-egg problem, that your REALbasic DB app can't run until it has a database to load, yet it can't create a database until you run it! The solution is to code blind (no thanks) or enter some starter data externally--which is exactly what I did with Base. It's a simple app that fills a need. (I certainly don't see the justice in those who give it a low rating for the trial policy--that's not an honest rating of the actual product. And in my case, the trial was plenty.)
(3)
Show comment (1)
1
Irvtheswirv
16 January 2009
Version: 1.1
This looks exactly like something I would like to buy but the horrendously knobbled trial made me cancel and delete the app without even bothering. Shame, you've missed out on a sale. One which might have led to quite a few others too. Change it to a time limited (10 days) or something I might give it a go.
(1)
Show comment (1)
5
Bridgeyman
17 November 2008
Version: 1.0
I have been searching for a good, inexpensive sqlite manager for a while now. There are a few freeware options out there, but the ones I have tried have been extremely slow and difficult with limited features. Base on the other hand has a very nice interface and is fun to use. The developer is also very prompt. I had an issue with licensing and sent out a support email. Within half an hour the developer replied and an update was posted. Now that is service!
(2)
$28.99Buy Now

4.5

App requirements: 
  • Intel 64
  • macOS 10.14.0 or later
License: 
PaidOne-Time Purchase

Downloaded & Installed 20,567 times

Similar apps
SQLPro for SQLite
SQLPro for SQLite
Advanced SQL editor.
Is this app is similar to SQLPro for SQLite? Vote to improve the quality of this list.
Vote results
0
Upvotes
12
Total score
0
Downvotes
SQLEditor
SQLEditor
Create SQL databases graphically.
Is this app is similar to SQLEditor? Vote to improve the quality of this list.
Vote results
1
Upvotes
1
Total score
0
Downvotes
TablePlus
TablePlus
Modern, native tool for relational databases.
Is this app is similar to TablePlus? Vote to improve the quality of this list.
Vote results
1
Upvotes
1
Total score
0
Downvotes
Datum Free
Datum Free
Fast modern database viewer.
Is this app is similar to Datum Free? Vote to improve the quality of this list.
Vote results
0
Upvotes
1
Total score
0
Downvotes
SQLiteFlow
SQLiteFlow
SQL editor.
Is this app is similar to SQLiteFlow? Vote to improve the quality of this list.
Vote results
1
Upvotes
1
Total score
0
Downvotes