Sqlite App For Mac
Getting Started with SQLite on macOS / Mac OS X. SQLite is a compact, cross platform, self-contained relational database management system that is available in the public domain. SQLite is included in macOS and Mac OS X by default. It is located in the /usr/bin directory and called sqlite3. I have been developing an Excel + VBA app that uses sqlite to store data. Communication with the database happens via ODBC (read and write) and querytable objects, to send SQL statements. This Excel + VBA app is to work both on Windows and Mac. I have tried several ODBC drivers: C.H. Werner (free) ActualTech (paid) Devart (paid).
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
/how-to-uninstall-spotify-app-on-mac.html. Dark Mode
- Supports Dark Mode for macOS 10.14+.
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
Sqlite App For Mac Shortcut
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.
Sqlite App For Mac Os
Attach Opened Databases
Drag and Drop
- Drag and drop to open databases and sql scripts.
- Create multiple windows.
Inside Explorer
- Show inside data structure of SQLite database file, journal file, WAL file and WAL-Index file.
Inside Explorer
Handle Database File Name or Directory Changes
Sqlite Manager For Mac
- 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
Mac Sqlite Tool
Have any questions or feature requests? Please feel free to create an issue.