Native SQLite Manager 4+

This is a really useful reliable utility

I’ve been using this to manage and migrate data across many sqlite databases for app development. It lets you view the data edit the data, easily rename columns and entities via the UI, in addition to being able to run SQLite commands to select and modify data. It’s just really powerful, flexible and intuitive to use. Very well done. Saved me a lot of time and trouble.

And, not to detract from the solid indispensable utility it already provides, a great feature going forward, and I realize this is asking a lot, would be if the app was able to have multiple DBs open at once to make it easier to migrate tables and a data between databases.

But it *does* keep query tabs open when loading a new database, so you can retain the query output from one database when looking at another and switch between tabs to compare, so that’s a partial implementation of the ideal.

Developer Response ,

Thank you for your comment. You can have multiple database files open at the same time. After opening the first database, use the File -> Attach command. Each database will then have its own alias, which should be used before the table name. This way, you can retrieve data from multiple databases with a single query. You can also transfer data from one database to another using appropriate SQL commands.

Fun little app that kees getting better!

The developer is incrementally improving this app. He's giving it away for free which is such a great service to other developers. Improvements are that you can double click on a table name and it shows SELECT * and shows the entries in a standard table. Has anyone notice you can edit cells in the outpur? You can, so quick little fixes can be done by hand.

I'd add the keyboard editing doesn't conform to standard tabular navigatin. Arrow keys do go from cell to cell, but when text is selected the arrow keys will leave the cell. The behavior of the numbers app with filled cells would be good to emulate. I'd implement Command-C and Command-V for full lines or columns. An interesting addition would be for a paste into an insert command format the data so insert will take it, like quoting strings intelligently. Just some ideas. The app is my go to for quick checks on SQLITE3 files.

Very Handy and Great Updates

An extremely handy and versitile tool. I use for examaning sqlite tables generated by Core Data within apps that I am buildng.

Really appreciate the frequent and useful updates -- most recenty the ability to display numeric columns as a readable date (when the column contains date data as seconds since some time interval).