Screenshots

SQLite is used by Mac OS X software such as NetNewsWire and SpamSieve. When you download SQLite and build it on a stock Mac OS X system, the sqlite tool has a very primitive command-line editing. Installing SQLite on your Mac is pretty straightforward. Just follow these steps: Head over to SQlite.org and download the C source code file, named sqlite-autoconf-3130000.tar.gz or similar, from. SQLite is included in macOS and Mac OS X by default. It is located in the /usr/bin directory and called sqlite3. Using SQLite, users can create file-based databases that can be transported across machines, platforms, etc. The only thing needed to then view or edit these databases is the SQLite command line program, or another tool capable of. Download DB Browser for SQLite for Mac - Small open source application designed to further simplify the process of creating, browsing, editing and managing SQLite database files without using SQL commands. DB Browser for SQLite -.zip (no installer) for 64-bit Windows; DB Browser for SQLite - PortableApp; Note - If for any reason the standard Windows release does not work (e.g. Gives an error), try a nightly build. Nightly builds often fix bugs reported after the last release. Our latest release (3.12.0) for macOS: DB Browser for SQLite.

Description

Base is an application for creating, designing, editing and browsing SQLite 3 database files. It's a proper Mac OS X application. Fast to launch, quick to get in to and get the data you need.
Base starts with all the basic features you need:
• Schema viewing
• Table contents viewing/editing
• Custom SQL queries
• Command logging
Then makes it all even better:
• 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 & constraints to your heart's content, maintaining or moving the original data within them.
• Quick data find & filter. Build lengthy SELECT statements with a few clicks, previewing results as you go.
• Easy SQL editing, with clear syntax highlighting and useful SQL autocompletion
• 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

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

A great SQLite application that has been built for Mac OS from the ground up

I use SQLite (mainly through CoreData) in my Mac OS and iOS applications, and also in the development enviroments of my Ruby on Rails applications. Base allows be to quickly and easily view and edit these SQLite databases, through a very clean and simple 'Apple' like UI. All of the other alternative SQLite applications that I have tried, have had a very clunky 'cross platform' feel to them, and don't have the feature set of Base. Since I have started to use base, I haven't had to resort to the command line once to inspect or edit my SQLite databases.

Great but needs an update

Trying to edit my iPhone add database with Base is fine. It lets you get the job done which is the main thing. But it's not a pleasure to use. If you've sorted a table by a column and then edit some text in the large text pop-up window and press 'Save'… boom… the record you were working on has jumped somewhere off screen and the sort on a field you had has been forgotten. It's really frustrating.
Apart from that it has let me do everything I want and it's definitely better than editing the database through the command line.
Base is no 'Sequel Pro' for usability or basic features. I'm definitely donating £20 to Squel Pro after having paid for Base.

Much much better since update

Latest Version Of Sqlite For Mac

This new updated versions really brings this app to life.
Much much better, now considerably more user friendly than the much more expensive alternatives.
I have SQLiteManager (expensive multi-platform alternative) and it isn't nearly as refined as this.
Great app.

Information

macOS 10.14 or later, 64-bit processor

Sqlite For Macbook

Supports

• Family Sharing

  Up to six family members will be able to use this app with Family Sharing enabled.