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. Continue reading