TOKYO (Tom Bluewater) – I use the SQLite database to store every bit of user-defined information like window positions & sizes, checkbox status, the default open-folder & save-folder paths. So it’s very important for me to make sure that an application under development is writing to its database files. Although I have a desktop application called FireSQL 3, I don’t really need to edit database tables. All I need is something that allows me to view the database table content. And I keep using an old application called ViewSQL Pro. Although Mac App Store got rid of it a few years ago, it’s still robust enough to run under Sierra. Well, this ViewSQL guy is almost 7 years old! It’s time for a regime change. So what I need is something similar to FireSQL 3 that just lets me view the content of the SQLite database table. Voila! I submitted a new desktop application to Mac App Store. This new release is called FireSQLView.
FireSQLView works with an unencrypted SQLite multi-table database file and lets you view the content of a table you select. It reads pragma info on the database table you select. So you can of course see the data type of each table field. The most important feature of this application is the ability to view blob data as a picture. You must have a field with data sizes corresponding to a blob field, though.
- Read the content of an SQLite database table you select.
- View blob data as a picture.
- Save the selected record as a text file to your disk. A resulting text file has tab-separated strings containing field names and text values for the selected record.
- Save blob data as an image file to your disk.
- See which field has the primary key.
- See the data type of each field.
- See the default value of each field.
- The fullScreen mode is supported.
- The application supports the retina screen. (tested with 2014 2.6 GHz 13″ MacBook Pro)
- Languages: English only.
- Application file size: 21.6 MB.
- The application comes with a built-in 11-page user guide. Choose Show Quick Tour under FireSQLView whenever you need to see it.
- 10.11 (tested with 10.11.6), 10.12 (tested with 10.12.2 and 10.12.5)
- 64-bit system
- The table content must not be encrypted.
- In order to view blob data as an image, there must be a field under the same table containing text or integer values as data sizes corresponding to the blog field.
Nothing so far…
Click here to download a trial version. This trial version will remain fully functional for 7 days, starting from the very moment you first launch it. If you are running this trial version under macOS 10.12 Sierra, you need to quit the application right after the first launch to evade a Sierra bug.
There is no video tutorial at this time.
FireSQLView is a product of Tom Bluewater.
Apple and the Apple logo are trademarks of Apple Inc., registered in the U.S. and other countries. Mac App Store is a service mark of Apple Inc.