Work with a toolset for editing, managing, creating, and otherwise processing SQLite 3 database content on your Mac. Check out the options for quickly selecting the existing data or inputting new materials manually or automatically. Add or remove elements at will.
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.
v2.3 [Aug 4, 2012]
- You can now view and edit pragmas for the main database without manually typing SQL
- Data tables now show line numbers
- Improved support for importing and exporting UTF-16 data
- Enabled more SQLite options (FTS4, Soundex and STAT3)
- The data editing sheet now has the editing area selected when it first appears
- Fixed a bug causing the first non-header row of CSV files to not be imported
- The app is now signed ready for Gatekeeper
- Updated to the latest version of SQLite at release (v3.7.11)Notes:
- Base 2.3 is a free update for all 2.x owners
- This is a paid upgrade for all 1.x owners
This is a tool to create, design and edit database files compatible with SQLite.
