Base
By Menial
Open Mac App Store to buy and download apps.
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 in Version 2.3
• 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
• Updated to the latest version of SQLite at release (v3.7.11)
Screenshots
- $28.99
- Category: Developer Tools
- Updated: Mar 24, 2012
- Version: 2.3
- Size: 2.4 MB
- Language: English
- Seller: Menial Ltd
- © 2011 Menial Ltd
Requirements: OS X 10.6.6 or later
