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.
+ 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.
+ Fix for query history not persisting between app launches.
+ Fix for decimal rounding and truncations not appearing correctly.
Ratings and Reviews
Does what’s on the tin, but leaves me wanting
To inspect and manage SQL databases this app works great. The “reloading database” feature holds this app back the most:
- When the DB changes, the app pops itself up and says “reloading database”. Pops itself up from the bottom of my window stack to just behind my foremost window—still very visually distracting.
- While it’s “reloading database” the app is completely hung: can’t keep working on my SQL query; can’t resize the window; completely hung.
- You can turn this feature off; but it will run all your SQL queries against a cached version of the database instead of the live one.
I rarely write unfavorable reviews, but I just lost a couple of hours worth of work because the app wasn’t saving my changes, and I didn’t discover this until closing and re-opening the file. Hard to trust a database editor that silently ignores saves.
Query warning! Beware
I was trying to import a dump file with the query page. It kept failing, after looking into it here, they are executing all the queries at once! Beware! Caused a lot of headaches trying to clean up after that mess. Eventually went back to the commandline to get it to work.
With Family Sharing set up, up to six family members can use this app.