Base - SQLite Editor

Base is for creating, designing, editing and browsing SQLite 3 database files. It's small, powerful and comfortable - a proper macOS application that's fast to launch and quick to get you to the data you need. Base starts with all the essential features you need: • A clear schema inspector for visualizing table structures • Intuitive table contents viewing and editing • A powerful SQL editor with intelligent autocomplete and syntax highlighting • Command logging and query history Then makes it all even better: • A visual table designer - Create and modify tables without writing complex CREATE or ALTER statements. Add columns, define constraints, and organize your database structure through a clean, intuitive interface • Multiple database support - Work with multiple attached databases simultaneously for complex projects • Support for advanced SQLite features - Full support for WITHOUT ROWID tables, STRICT tables, partial indexes with WHERE clauses, named table constraints, and generated columns • Code Snippets - Store your commonly used SQL as reusable snippets • Comprehensive import & export - Import data from CSV and SQL files. Export to SQL, CSV, JSON, and Excel formats • Complete constraint support - View and edit ALL column- and table-level constraints, from simple default values to complex foreign key relationships Note: By default, Base 3 runs in "Free mode" where advanced features are not available. To unlock these advanced features, there is a one-time purchase fee. --- Legal notices Terms of use (EULA): https://www.apple.com/legal/internet-services/itunes/dev/stdeula/ Privacy: https://menial.co.uk/privacy/