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.Schema viewing
Base starts with all the basic features you need:
Table contents viewing/editing
Custom SQL queries
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.
Base 2.4.2 is a bugfix release.Fixed a crash-on-launch bug for users on Mac OS 10.7 (Lion)
Changes from Base 2.4:
New SQL logging system - includes fast log filtering
Execution time can now be shown for custom SQL statements
Source list filtering now uses unanchored searching (it doesn't only match the start of entity names)
Enabled sandboxing (Mac App Store version only)
Updated to latest version of SQLite (3.7.15)
Removed third-party libraries in favour of system-provided interface elements
Schema display no longer breaks when a negative number is set as a default value
Custom SQL execution no longer reports only two statements completed
Removed an internal framework - Base is slightly smaller and faster
Plugged two memory leaks
Base (uk.co.menial.base) is a Mac software application that has been discovered and submitted by users of Software.com.
Operating System: Mac
Minimum OS version: 10.8
Bundle Information: 2.4.10, (c) 2015 Menial
Copyright: Copyright (c) 2008-2015 Menial Ltd.