Description
Name: Base – SQLite Editor
Version: 2.4.10
Release Date: June 10, 2015
Language: English
Developer: Menial
MAS Rating: 4+
Mac Platform: Intel
OS Version: OS X 10.8 or later
Processor type(s) & speed: 64-bit processor
Includes: K
Courtesy of Special [K]
Web Site: http://menial.co.uk/base/
Mac App Store: https://itunes.apple.com/app/base-sqlite-editor/id402383384?mt=12
Overview:
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.4.10:
Base 2.4.10 is a bug fix release. Changes include:
• Fixed a bug where dropping a table via right-click could drop the wrong table
• The description for pragma auto_vacuum now lists options in the right order
• Disabled sorting of columns in the table editor. This prevents altered tables from having the column orders swapped without notice.
• Fixed some speling and gramer mistakes
• Updated SQLite to 3.8.10.2
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. All in all, Navicat for SQLite has all the makings of a reliable SQLite administration app that can help you manage your databasea with minimal effort via a clean and intuitive graphical user interface. Query database Database manager SQLite manager Database Query SQLite Backup.
Introduction
SQLiteFlow is an SQLite editor for Mac & iOS which is intuitive, stable and reliable to use.
Platform
macOS 10.14+ / iOS 13.0+
Download
Version 4.7.0 | Nov 4, 2020 | Release Notes
Features
Query Editor
- Multi-query execution.
- Customize syntax highlighting.
- SQL auto-completion.
- Format query.
- Copy query with custom style.
- Paste recent query sessions.
- Explain query.
Query Editor - Multi-query Execution
Query Editor - Copy Query with Custom Style and It’s Setting
Data Editor
- View, edit or add table data.
- View table data with a convenient data filter.
- Edit blob as hex, show blob as image if possible.
- Copy data to CSV.
Data Editor
Table Schema
- View, edit or add table fields, indexes, foreign keys, checks.
- View triggers.
- View DDL.
- Preview the query that for altering table.
Alter Table - Fields
Alter Table - Preview
Import
- Supports import CSV data.
Import from CSV Text
Dark Mode
- Supports Dark Mode for macOS 10.14+.
Best Sqlite App For Mac
Database Statistics
- Display table counts and each table’s record count.
- Display total size of each table, size of each table’s content and size of each table’s indexes.
Database Statistics
Database Diff
- Supports generate SQL text that can let you transform a database into another.
- Supports show a summary of the differences between two databases.
Remote Connect
- Supports open remote SQLite database in iPhone or iPad with SQLiteFlow(iOS) installed.
Remote Connect
Attach Database
- Attach opened databases without any code. This is a very handy feature that could save lots of your time from writing ATTACH DATABASE commands.
Attach Opened Databases
Drag and Drop
- Drag and drop to open databases and sql scripts.
- Create multiple windows.
Sqlite App For Mac Windows 10
Inside Explorer
- Show inside data structure of SQLite database file, journal file, WAL file and WAL-Index file.
Inside Explorer
Sqlite App For Mac Windows 7
Handle Database File Name or Directory Changes
- For instance, this makes SQLiteFlow can work friendly with your SQLite databases in iOS simulator.
REGEXP operator
- Supports REGEXP operator for local databases when ‘REGEXP operator’ is enabled in Preferences.
Languages
- English | 简体中文 (Chinese, Simplified) | 繁體中文 (Chinese, Traditional)
Support or Contact
Have any questions or feature requests? Please feel free to create an issue.