Base
Base
2.4.15

4.5

Base free download for Mac

Base

2.4.15
01 December 2019

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.4.15:
  • Base now only runs on macOS 10.14 (Mojave) or higher
  • Added support for Dark Mode
  • Row numbers in the data browser now stick to the left edge correctly
  • Fixed a bug which caused logged SQL to not show the correct font or syntax colouring
  • Enabled macOS sandboxing

Join over 500,000 subscribers.

Subscribe for our newsletter with best Mac offers from MacUpdate.

19 Base Reviews

See all

Rate this app:

Itistoday
18 October 2013

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.
Like (2)
Version 2.4.7
Itistoday
18 October 2013
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.
Like (2)
Version 2.4.7
Jimw
24 March 2012
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.
Like
Version 2.3
1 answer(s)
Xplicit
Xplicit
28 September 2012
Please reply at the appropriate place and do not open new threads to post a reply to an earlier discussion. No one will know what you're talking about. Some might even think you are a person with a serious attention deficit.
Like (8)
Steve-Cholerton
06 February 2012
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 :-)
Like
Version 2.2.1
goosesensor
07 April 2011
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.
Like
Version 2.0.2
Macgruder
04 March 2011
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.
Like
Version 2.0
3 answer(s)
Macgruder
Macgruder
04 March 2011
I finally tracked down that there is a 'alter...' dropdown in the area to the left (the area visually for the database as a whole rather than the individual table), but selecting it brings up the same dialogue box as clicking the + symbol to its left so no luck there. I wonder what happened to the add column icon. Weird. Sure it'll be fixed soon.
Like
Macgruder
Macgruder
04 March 2011
Ha, Seems the Cog > Alter... does work after all. Seems that there's a small bug that manifests itself with certain tables, and that previously didn't work for me. That said, I'm not sure why the developer hid the "Add Column" away from where it was before.
Like
Menial
Menial
05 March 2011
Since the table creation/editing code & UI have had an overhaul for Base 2.0, I thought it best to remove the add column button in favour of a more consolidated UI. Sorry the change threw you off track a bit. - Ben
Like (1)
Jimw
19 February 2011
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.
Like (3)
Version 2.0
2 answer(s)
Xplicit
Xplicit
01 April 2011
who cares
Like (4)
Pripyat
Pripyat
24 March 2012
You sure like to sound important, do you?
Like (1)
Peternsteinmetz
19 February 2011
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.
Like (1)
Version 2.0
3 answer(s)
Menial
Menial
19 February 2011
Base is shareware, although I personally dislike the term. Most people I've spoken to typically define shareware as an app that runs without payment, but is limited in some fashion. This limit could be in terms of features, run time, or number of launches. Base takes a middle ground, in that it can be launched an unlimited number of times, but quits with a notice after 15 minutes. It also limits the results returned from a custom query. I took this approach so that casual users could use the app with little hindrance, but professional/heavy users would need to register. Lastly, MacUpdate lets you categorise software as one of the following: Free, Demo, Shareware, Updater or Commercial. I think Shareware fits the bill better than any of the others. Hope this clarifies matters. - Ben
Like (1)
Xplicit
Xplicit
01 March 2011
The term shareware means only, that you can share the software, that is pass it on to other users. No one ever said anything about "free".
Like (1)
Strider72
Strider72
10 July 2015
No, what you describe is "Donationware". Shareware you have to pay for. The name hearkens back the the pre-Internet days before you could just download everything; as Shareware was intended to be, in part, distributed by users who shared the installers with each other on disks. (As opposed to a lot of corporate product at the time that would copy-protect the disks to explicitly prevent sharing.) The term is a bit meaningless these days, actually. They should probably just call it demo-ware; it's a demo until you pay for it.
Like
Detlevski
16 August 2010
Nice app, does what is needs to do.
Like
Version 1.4.1
Hsoft
02 August 2010
Does what I need, simple interface, cheap. It's a winner!
Like
Version 1.4
Xplicit
26 April 2010
Fast, reliable, good interface, good features and a reasonable price. Excellent. What else is there to say?
Like (1)
Version 1.4