Base
Base
2.5.2
3.8
0.0
Base free download for Mac

Base for Mac2.5.2

01 November 2020

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

What is Base for Mac

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.2:
  • Fixed a bug where exported SQL files would be empty
  • Fixed a bug causing CHECK constraints to not be editable
Try our new feature and write a detailed review about Base. All reviews will be posted soon.
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.
0.0
(0 Reviews of )
There are no reviews yet
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.
James
James
Mar 24 2012
2.3
0.0
Mar 24 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.
James
James
Feb 19 2011
2.0
0.0
Feb 19 2011
0.0
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.
Peternsteinmetz
Peternsteinmetz
Feb 19 2011
2.0
0.0
Feb 19 2011
0.0
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.
anonymous-gerbil-5319
anonymous-gerbil-5319
Aug 16 2010
1.4.1
0.0
Aug 16 2010
0.0
Version: 1.4.1
Nice app, does what is needs to do.
Hsoft
Hsoft
Aug 2 2010
1.4
5.0
Aug 2 2010
5.0
Version: 1.4
Does what I need, simple interface, cheap. It's a winner!
Xplicit
Xplicit
Apr 26 2010
1.4
5.0
Apr 26 2010
5.0
Version: 1.4
Fast, reliable, good interface, good features and a reasonable price. Excellent. What else is there to say?
Nascitur
Nascitur
Mar 8 2010
1.4
5.0
Mar 8 2010
5.0
Version: 1.4
Fast, easy and beautiful Mac-like UI. Love it.
Taoeffect
Taoeffect
Mar 7 2010
1.4
5.0
Mar 7 2010
5.0
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".
Guest
Guest
Mar 1 2010
1.3.3
1.0
Mar 1 2010
1.0
Version: 1.3.3
Useless. Can't modify tables after they are created. Looks like someone made this over the weekend.
Serkol
Serkol
Feb 21 2010
1.3.3
3.0
Feb 21 2010
3.0
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...
Vera-Tkachenko
Vera-Tkachenko
Jan 16 2010
1.3.3
4.0
Jan 16 2010
4.0
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.
barefeettom
barefeettom
Jul 26 2009
1.3.2
3.0
Jul 26 2009
3.0
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
Morgan4
Morgan4
Feb 23 2009
1.2
5.0
Feb 23 2009
5.0
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.)
Irvtheswirv
Irvtheswirv
Jan 16 2009
1.1
1.0
Jan 16 2009
1.0
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.
Bridgeyman
Bridgeyman
Nov 17 2008
1.0
5.0
Nov 17 2008
5.0
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!
$28.99Buy Now
3.8
0.0
App requirements: 
  • Intel 64
  • macOS 10.14.0 or later
License: 
PaidOne-Time Purchase

Downloaded & Installed 20,696 times

How would you rate Base?
Similar apps
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
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
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
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
SQLite
SQL database connection development library.
Is this app is similar to SQLite? Vote to improve the quality of this list.
Vote results
0
Upvotes
1
Total score
0
Downvotes