Sqlite Editor For Mac

All in all, SQLiteStudio is an open source and forthright application for OS X that enables developers to manage and edit SQLite databases via a friendly user interface and without having to having to perform overly complicated maneuvers in the process of doing it. SQLite editor SQLite. SQLite is used by Mac OS X software such as NetNewsWire and SpamSieve. When you download SQLite and build it on a stock Mac OS X system, the sqlite tool. Precompiled Binaries for Mac OS X (x86) sqlite-tools-osx-x.zip (1.35 MiB) A bundle of command-line tools for managing SQLite database files, including the command-line shell program, the sqldiff program, and the sqlite3analyzer program. Allows you to edit and delete records in any SQLite database on your phone. For root users, lists all installed apps which have local internal databases. You can then select an app and edit any of.

Introduction

SQLiteFlow is an SQLite editor for Mac & iOS which is intuitive, stable and reliable to use.

Platform

macOS 10.13+ / iOS 13.0+

Download

Version 4.6.1 | Sep 15, 2020 | Release Notes

Features

Query Editor

Sqlite Editor For Mac Catalina

  • 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

For

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+.

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.

Inside Explorer

  • Show inside data structure of SQLite database file, journal file, WAL file and WAL-Index file.

Sqlite Studio For Mac

Inside Explorer

Sqlite Editor For Mac Download

Handle Database File Name or Directory Changes

  • For instance, this makes SQLiteFlow can work friendly with your SQLite databases in iOS simulator.

Sqlite Editor Pro

REGEXP operator

  • Supports REGEXP operator for local databases when ‘REGEXP operator’ is enabled in Preferences.

Sqlite Editor Free

Languages

  • English | 简体中文 (Chinese, Simplified) | 繁體中文 (Chinese, Traditional)

Support or Contact

Sqlite Editor Linux

Have any questions or feature requests? Please feel free to create an issue.