Base
Create, design, edit, and browse SQLite 3 database files.
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
Updated on Nov 01 2020
Version 2.5.2:
- Fixed a bug where exported SQL files would be empty
- Fixed a bug causing CHECK constraints to not be editable
Information
App requirements
- Intel 64
- macOS 10.14 or later
Try our new feature and write a detailed review about Base. All reviews will be posted soon.
(0 Reviews of )
There are no reviews yet
Comments
User Ratings
Oct 18 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.
Mar 24 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.
Feb 6 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 :-)
Apr 7 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.
Mar 4 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.
Feb 19 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.
Feb 19 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.
Apr 26 2010
Version: 1.4
Fast, reliable, good interface, good features and a reasonable price. Excellent. What else is there to say?
Mar 7 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".
Mar 1 2010
Version: 1.3.3
Useless. Can't modify tables after they are created. Looks like someone made this over the weekend.
Feb 21 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...
Jan 16 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.
Jul 26 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
Feb 23 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.)
Jan 16 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.
Nov 17 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!
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
SQLiteManager
Database manager for SQLite databases.
Is this app is similar to SQLiteManager? 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
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
New and Recently Updated