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.
Tom Bluewater
|
Tom Bluewater
|
Features
- 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.
System requirements
- 10.11 (tested with 10.11.6), 10.12 (tested with 10.12.2 and 10.12.5)
- 64-bit system
Limitations
- 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.
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.
Just bought FireSQLView, about to return it.
Dragged a db in, and got “no readable table”.
Here’s the tables in the database (Manifest.db, from an iPhone backup):
SQLite3 database: MANIFEST.DB
Files
cid: type name
0 : TEXT fileID
1 : TEXT domain
2 : TEXT relativePath
3 : INTEGER flags
4 : BLOB file
Properties
cid: type name
0 : TEXT key
1 : BLOB value
Total: 14.2 MBs in 1 database
Argh, sigh.
Your darn product TOOK ME TO THIS PAGE WHEN I CLICKED “CONTACT SUPPORT”.
It *SHOULD* have taken me to a support contact page … I didn’t read the text
on this page closely enough to see that it was completely and totally the
wrong place to post.
Sorry … even though the major fault is yours, the minor fault is certainly mine.
Well, maybe it’s not so bad to post a support question here …
if I go to your main support info page, I get the run around. You basically have NO OTHER METHOD of letting me post a bug report. Since I bought it from Mac app store, you provided me a link to “support” there … there is none.
So, I’m posting here. Please see first post 🙂
And, MAKE YOUR PURCHASED SOFTWARE EASIER TO REPORT BUGS ON!
Suggestion: buy (and use) Carbon Copy Cloner … it has the best support contact system I’ve seen, and the best support, bar none. You absolutely could not do better than to try to emulate them.
I’m sorry not to get back with you sooner. I don’t know why you cannot read your database file. Please contact Mac App Store to get a refund.
Actually, I think you cannot read your database file with this application because you don’t have the primary key.
Trying to open files…..
One after another and none will open in Mac running Catalina……. Not sure what file types can be opened and no examples from your site. Keep getting error stating ‘ No readable table. Know-one knows what this means?????
We only have files that are created in Mac so if it doesn’t open Mac files then what is this app for????? Also not sure what extensions can be used in this app. Ex: .db .sql. .sqlite nobody here can get a single file to open….. If it doesn’t work then why leave it on the AppStore??
Hello,
I’m sorry to hear your difficulty. If you see an error message that says “The file you have selected does not contain a readable table”, it means that the application finds no SQLite tables in the file. The file extension is not important. The application can read an SQLite database file with or without a file extension. Meanwhile, this version is more than two years old. You may want to try its update version (FireSQLView 2). I leave it at Mac App Store because it still works, and I am able to open SQLite database files.