SQLPro for SQLite - database and coredata manager
Developer: Hankinsoft Development Inc
Current Version: 1.0.105
Last Updated: 3 months ago
Download Size: 8.6 MB - Download
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 would like to try before you buy, you can also give our free Read-Only version a look!
If you have any issues with this application, please see our support forum: https://sqlitepro.com/forum or send us a message on Twitter: @SQLitePro.
This product is an independent management tool for SQLite.
SQLPro for SQLite is not affiliated or endorsed by the SQLite development team.
+ Fixed a performance issue some users were seeing when loading databases.
Most Helpful Reviews
Early review - Works well. Easy UI to get around. Seems well thought out. Intuitive. Snappy. No weirdo UI blocks like some Mac DB apps seem to have. Fewest clicks workflow for most tasks. I have installed and brought up this tool with one of my existing databases. It allowed me to easily modify the structures. It quickly created a JSON export file. I modfifed the databse and used the versioning to step back. Everything work, but I have NOT extensively tested it yet. I thought that the JSON export was a particularly nice idea. I may keep two versions of some databases going forward using this utility. The app seems very snappy. I loaded a DB with over 850,000 records in three table. Switching to browse mode there was a full second delay, but then all data snapped on the screen as I moved the scrollbar indicator rapidly. There were no delays paging through the records. The UI remained snappy. (I have a MBP With retina display &16 G RAM. ) Filtering data was easy to setup and gave snappy response. I will update my review as I learn more, but since it was untested or reviewed at this pont, I wanted to get my feedback out there. I think tis is well worth your time if you are doing anything with SQLite. You may even find some use in the idea of using it to create large JSON from SQlite. Creates MYSQL or SQLite scripts almost instantly. Update: Found a small bug. When a filter list was applied to the table list (left tree panel), the data on the right didn't always reflect the selection on the left. Unless I find more serious errors, this still seems like a good app and I imagine this is an easy UI fix. Most DB apps don't even provie a filter option there. Also, this may have something to do with the DB being rather large.
Updated: Still a long, long way to go before this is a usable app. - So far there's not much "professional" about this app. - I've tried creating a new database…what a chore! Have you tried it?? "GUI" -- not really. - Even if I could get it created…there is NO import capability. Am I supposed to type in every character of every field of every record?? Think I'll wait for an update before wasting any more time on this app. --------------- Well, I waited 3 months. Here's what I found: - An import capability now exists. It's not very intuitive, and doesn't seem to work. Ended up with a bunch of garbage records in the table. Don't have the time for lots of trial and error to see if it ever works. - Couldn't delete the garbage records caused by the unintuitive import process. Had to refer to an old saved copy (that feature actually worked). - Tried to create a few favorite queries. Couldn't change the name on any of them. So ended up with all the favorite queries named "NEW FAVORITE QUERY". - Wanted to create a new view…could not find a way to do it. Seriously. - So with all the issues I was having, figured it must be me, right? Went to Help menu, clicked on SQLite Professional Help and got a dialog that says "Help isn't available for SQLite Professional". Not very helpful. And not very professional. So where did all those 5-star ratings come from? I'm done waiting. I can't believe there is a price tag on this App. IMO, don't waste your money.
More Reviews for Current Version
Looks good, works great - I’ve used SQL databases and GUIs for more than 20 years. I’ve used a few SQLite GUIs. Some of them don’t support standard operating system features (like cut/paste!) without crashing. Some of them stopped working after an operating system upgrade. SQLPro works. It works with MacOS 10.12.3 (latest as of this review). It doesn’t crash. It looks good. It supports exports to CSV and json. I’ve used it for about 6 weeks and highly recommend it.
Lost data - 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.
Great app! - I bought this app to work on a SQLite database of my photography work. It works well and was simple to use.
Nice App! - I’ve been working with many different databases for many years now and this is a good gui for SQLLite. It’s simple, works well, and is easy to use.
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.