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.
Yes, it has the basic features you need:
Table schema? Check.
Table contents? Check.
Custom queries? Logging? Check.
Base fully supports the display and editing of all column- and table-level constraints.
Seriously. Everything from simple default values, through to complex foreign key constraints, Base can handle it.
Advanced table designing & altering
No need to muck about with long-winded 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 filtering
Easily find the data you want using the new filtering system.
Build complex queries with minimal typing in a familiar spotlight-like view.
You can even export the filter to SQL to save later!
Easy import, comprehensive export.
Quickly bring in existing CSV or SQL from dump files, then export your tables and custom queries to SQL,
delimited text, XML or Microsoft Excel-compatible
SQL editing made easy
On top of the standard syntax highlighting, Base can now autocomplete commonly-used SQL commands.
Even better, you can store your commonly used SQL snippets for quick re-use later on.
Need help? Right this way…