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.