What’s Coming Up Next? – Tom Bluewater Introducing FireSQLView for Mac OS X

Mac application FireSQLView






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.  

Mac application FireSQLView

Tom Bluewater
  Mac application FireSQLView

Tom Bluewater






Features

  1. Read the content of an SQLite database table you select.
  2. View blob data as a picture.
  3. 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.
  4. Save blob data as an image file to your disk.
  5. See which field has the primary key.
  6. See the data type of each field.
  7. See the default value of each field.
  8. The fullScreen mode is supported.
  9. The application supports the retina screen. (tested with 2014 2.6 GHz 13″ MacBook Pro)
  10. Languages: English only.
  11. Application file size: 21.6 MB.
  12. The application comes with a built-in 11-page user guide. Choose Show Quick Tour under FireSQLView whenever you need to see it.






System requirements

  1. 10.11 (tested with 10.11.6), 10.12 (tested with 10.12.2 and 10.12.5)
  2. 64-bit system






Limitations

  1. The table content must not be encrypted.
  2. 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.






Version history

Nothing so far…






Trial/Demo version

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.






Video tutorial

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.

This entry was posted in Apple & Mac. Bookmark the permalink.

Leave a Reply

Your email address will not be published.

Notify me of followup comments via e-mail. You can also subscribe without commenting.