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/

Added: - Base now provides a Quick Look preview extension, showing a list of tables, views, indexes and triggers in previewed databases - The Geopoly and RBU SQLite extensions are now enabled for use Fixes: - The numpad enter key can now be used to execute queries - The selected row in the data browser jumps around less when editing data - Data browser table headers no longer overlap row numbers when scrolling - Table headers no longer get out-of-sync with columns when switching between tables - Fix a crash which occured when adding a filter in the data browser - Fix a crash which occurred when removing certain columns in the table editor - Fixed overlapping text in SQL query results Changes: - The 'page_size' database option is now a dropdown instead of text field - Update SQLite to v3.51.2

信息

卖家

Menial Ltd

类别

Developer Tools

版本

3.3.0

需要

iOS 15.0+

大小

18.0 MB

年龄评级

4+