Base - SQLite Editor

Developer: Menial

Current Version: 2.5.1

Last Updated: 2 months ago

Download Size: 8.4 MB - Download


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.


Release Notes:

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


Most Helpful Reviews

Version 2.0
Review by mrosauer

Simple usable app for working with Core Data stores - I've been using this app to manage a database created by Core Data for packaging with my iPhone app. Works great. Very simple to use. Great app.

Found helpful by 9 out of 11 people
Version 2.4.12
Review by Pacaya44

Can't import - Purchased this to ease transition from a number of Numbers spreadsheets into SQLite. Every time I try the import function into a New table, it gives and error and aborts. Tried creating a table to match the spreadsheet and import into existing table. Does nothing. Not at all what I was looking for and not worth the price.

Found helpful by 4 out of 5 people