Mac os sqlite editor

SQLiteFlow — SQLite Editor 4+

Снимки экрана

Описание

Two-week free trial! So you can purchase SQLiteFlow after you know you like it!
SQLiteFlow is an SQLite editor for Mac & iOS which is intuitive, stable and reliable to use.

It includes the following 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.

Data Editor
• View, edit, add or remove records.
• View table data with a convenient data filter.
• Edit blob data as hex and show it as image if possible.
• Copy data to CSV.

Table Schema
• View, edit or add table fields, indexes, foreign keys, checks.
• View triggers.
• View DDL.
• Preview the query that for altering table.

Remote Connect
• Supports open remote SQLite databases on SQLiteFlow(iOS).

Database Statistics
• Display tables count and each table’s records count.
• Display total size of each table, size of each table’s content and size of each table’s indexes.

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.

Import
• Supports import CSV data to a table.

Export
• In Data Editor, supports export data from a table/view to a CSV file.
• In Query Result, supports export data from query result or query message to a CSV file.

Dark Mode
• Supports Dark Mode for macOS Mojave.

Drag and Drop
• Open databases and SQL scripts.
• Create multiple windows.

Handle Database File Name or Directory Changes
• For instance, this makes SQLiteFlow can work friendly with your SQLite databases in iOS simulator.

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.

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

Inside Explorer
• Show inside data structure of SQLite database file, journal file, WAL file or WAL-Index file.

Database Encryption
• Supports handle encrypted SQLite databases which are encrypted by SQLCipher library.

Access Apple simulator
• Supports access Apple simulator. So users can open their app’s Documents directory more easily when developing their apps.

Источник

Base — SQLite Editor 4+

The SQLite Editor

Menial

Screenshots

Description

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

• Fixed a bug where exported SQL files would be empty
• Fixed a bug causing CHECK constraints to not be editable

Ratings and Reviews

Overall a great app, but need M1 update

Don’t want Rosetta 2 just for this — paid user — can you give recompiling a try?

Can’t reliably edit data in a record

After I open a database, sometimes I can double-click a data record to open an edit window so I can change data, but usually usually I can’t. Double-clicking only selects the text under the mouse as if I’m copy/pasting. It’s very unpredictable. Going through the “Alter” process for the record also does not let me change the data. The SQL database was originally created by the PhatNotes iPhone/iPad app, which is quite old and no longer supported, perhaps this has something to do with this issue? However, other SQL editors I’ve tried on MacOS don’t have any trouble accessing and modifying record data in this database. I haven’t tried this function with any other SQL databases. The reason I bought this app was specifically to deal with the above-mentioned iPad/iPhone database, which is critical to me and which I was forced to migrate to MacOS. FYI, I used iFunBox on Windows to retrieve the SQL file from the PhatNotes sandbox on the original iPad, since the data transmission facilities in PhatNotes had stopped working following an iOS upgrade.

Can’t import

Purchased this to ease transition from a number of Numbers spreadsheets into SQLite. Every time I try the import function into a New table, it gives and error and aborts. Tried creating a table to match the spreadsheet and import into existing table. Does nothing. Not at all what I was looking for and not worth the price.

App Privacy

The developer, Menial , has not provided details about its privacy practices and handling of data to Apple. For more information, see the developer’s privacy policy.

No Details Provided

The developer will be required to provide privacy details when they submit their next app update.

Источник

SQLite Database Manager 4+

Qiang Li

• • 449,00 ₽
  • Включает встроенные покупки

Снимки экрана

Описание

Browser Sqlite Database data with Sqlite Database Manager, you can view data easily with Filter, Sort, Paging. With the In-App Purchase ‘Edit Data’ and ‘DB Creator’ you can edit it directly on your Mac, create new databases and new tables.

* View table data with paging list
* 10+ data view UI control (include Map, Date Time, Checkbox, Rating, Color . )
* Filter/Search table data on column
* Sort table data by click on the column header
* Choose tables to show and columns to show
* Drag drop rearrange column order and change column width in main table
* Zoom data via change data font size
* Open multiple database at same time
* Full screen view data
* CSV View and export
* Html View with customisable template
* Works great with companion mobile app ‘Sqlite Database Manager’ for iPhone and iPad

Photo collection view:
If table data have photo/image field, you can switch to photo collection view by click on toggle C/T button next to page control buttons.

In-app Purchase ‘Edit Data’ Features:
* 10+ data edit UI control (include Map, Date Time, Checkbox, Rating, Color Picker,Dropdown, Multi-select. )
* Update table row data
* Delete table row data
* Add table row data
* Cross table ID,Value single or multi-select using the Data Picker

In-app ‘DB Creator’ Features:
* Create Database
* Create Table
* Create contacts table by import Contacts
* Import CSV Data

In-app Purchase ‘Map View’ Features:
* View Geolocation on map
Support two format:
1. Latitude and Longitude column data;
2. any column contain this format geolocation:
* Auto update Geolocation by search address
Select address column to search, and select save to column to save the found geolocation.
Please select the column which have enough length to save Latitude and Longitude.

In-App Purchase ‘Instant Web Server’ Features:
* Publish data on local network with one single click, view and add data on any web browser from mobile devices or computers
* Easy setup template for list page and detail page
* Build-in form to add data
* Configable URL Path, template and server port
* Build-in 10+ Html Table Template

In-App Purchase ‘App Builder’
* Build customised User Interface for your database
* Bind database table row data to user control
* Support Rows Table List, Row detail data controls, search field

Источник

Base — SQLite Editor 4+

The SQLite Editor

Menial

Screenshots

Description

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.

Источник

Base — SQLite Editor 4+

Menial

Снимки экрана

Описание

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.

Источник