SQLite Client by SQLPro 4+
sql and core data tool
Hankinsoft Development Inc
-
- £49.99
Screenshots
Description
SQLPro for SQLite is an advanced sqlite editor. It has an easy to navigate interface, with the ability to perform the most basic to advanced tasks.
Features include:
+ Syntax highlighting and query intellisense/auto-complete.
+ Advanced multi-query execution.
+ Pick from multiple included themes, or design your own.
+ Automatic external change detection reloads a database when modified outside of SQLPro.
+ Version integration. Mucked your database? Rollback to a previous version.
+ Runtime loadable extension support.
+ Semiautomatic dependency resolution.
+ Export your data to csv, mysql, xml or json.
+ Backwards compatibility with SQLite 2.
+ Fullscreen support.
+ Column reordering.
+ Inline filters allowing you to customize the way your data is displayed.
If you have any issues with this application, please see our support forum: https://sqlitepro.com/forum or send us a message on Twitter: @SQLProApp.
This product is an independent management tool for SQLite.
SQLPro for SQLite is not affiliated or endorsed by the SQLite development team.
What’s New
Version 2024.21
+ Fixed a crash that could occur when renaming columns. [#967](https://github.com/hankinsoft/SQLPro/issues/967)
Ratings and Reviews
Works for Core Data...
I need a tool to look at Core Data DBs which are based on SQLite - this app works for that and fills my needs well.
I had an issue (my issue not the apps!) where I needed a little bit of support from the developer and this was provided via email promptly and accurately. FWIW, my issue was with Security Scoped Bookmarks which is why I said its not app related.
A useful tool and I now own both SQLPro Studio from thsi developer as well...
Excellent App, brilliant Dev
I use it to run SQL queries on the DB for my (also great) accounting app. For my purposes I could not wish for better. SQL queries can be stored, edited and organised within the app, syntax highlighting colour scheme is excellent. Queries can be exported (I use .csv) so I can manipulate the data to produce the reports I need.
Maybe more importantly, Kyle Hankinson (the dev) is simply first rate. Support requests get friendly and skilful replies within hours at max, the occasional bug gets immediate attention. Wish all App Store devs were this driven and professional.
Huge strides since first version - now a great tool
After a rather dodgy first release, this app has improved dramatically to the point that I have now mostly switched from using Base to this tool for SQLite work.
One area where the app is still rather weak is the data insert mode - it pops up a dialogue and one has to click on each field name, click down ot the value field, enter the value then click up onto the next field name. (Base also make sme do this)
Far better would be to adopt the approach used by Sequel Pro (not the same app despite the similar names) - data entry there is in-row based making row creation and editing much, much quicker - however Sequel Pro currently only supports MySQL. Both SQL Pro and Base do support in-row editing of existing data, so presumably this approach could be added by the developers.
Note: contrary to an earlier version of my review, this app does support trigger and FK constraint editing - these options are accessed via the small icons on the index section of the schema view. Apologies to the dev for having stated otherwise.
App Privacy
The developer, Hankinsoft Development Inc, indicated that the app’s privacy practices may include handling of data as described below. For more information, see the developer’s privacy policy.
Data Not Linked to You
The following data may be collected but it is not linked to your identity:
- Usage Data
- Diagnostics
Privacy practices may vary based on, for example, the features you use or your age. Learn More
Information
- Provider
- Hankinsoft Development Inc
- Size
- 24.5 MB
- Category
- Developer Tools
- Compatibility
-
- Mac
- Requires macOS 10.13 or later.
- Languages
-
English
- Age Rating
- 4+
- Copyright
- © Hankinsoft Development, Inc
- Price
- £49.99
Supports
-
Family Sharing
Up to six family members can use this app with Family Sharing enabled.