Database Manipulation
- Create database, duplicate database, attach databases.
- Delete/ empty all tables within a database.
Create Table
Create a Table in many ways, in addition to a conventional column definition, SQLite+ also provides other 2 ways:
- parse JSON fields as table columns.
- Execute SQL to create the table.
Data Manipulation
The table data is displayed in pages, using the previous page, the next page, the first page, and the last page to navigate the data.
- The ability to add, modify, and delete records within a table.
- Magic data, a power function can auto-generate test data for the table.
- Track data changes with distinct colors, and press Command + S to save all changes.
- Multi-table browsing, display all opened tables on the tab page.
SQL Query
input SQL, query data, and export results.
- SQL input syntax highlighting, auto-completion.
- SQL execution history is saved.
- Query result data can be edited and exported.
Import & Export
Import and export various data formats, including SQL JSON CSV XML PList.
Code Generation
Generate table model and data access swift code , saving time for developing data-related projects. The code menu provides the demo project for users to download and test.
Contact
Any bugs and suggestions please email iosxtools at gmail.com