TOKYO (MacHouse) – There was a desktop application called ViewSQL Pro that was distributed through Apple‘s Mac App Store till a few years ago. Personally, I still use it to examine SQLite data though it’s outdated. It’s stable and runs under Yosemite with no problem. It’s a pity that it doesn’t let you alter records. Hmm… Maybe, I can upgrade ViewSQL Pro. So I’ve spent the last 10 days or so working on a major upgrade. I’ve also changed the name. What I submitted to Mac App Store several hours ago is called FireSQL 3.

Source: Tom Bluewater

Source: Tom Bluewater

FireSQL 3 is a successor to ViewSQL Pro and lets you view and edit SQLite database. There have been a number of changes and improvements.  

Available at Mac App Store

What’s New?

1. The user can rename and delete existing tables. Insert new tables to the selected database.
2. Alter records manually. The user can also change blob data with a new picture of their selection.
3. View blob data as a picture.
4. Run a search for partial matches by selecting a field.
5. Let the application store SQL statements for creating SQLite database files.
6. Delete a record of your selection.
7. It’s finally a Cocoa application. ViewSQL Pro wasn’t.

Features

1. Drag and drop an SQLite database file directly onto application’s main window to read data.
2. Rename and delete tables.
3. Insert new tables to your database.
4. Delete the record of your selection.
5. Create and save an SQLite database file to your disk. Apply data contraints such as primary key, not null, auto increment, unique to fields.
6. Store database creation settings with an outline view.
7. Edit a database record manually.
8. View blob data as a picture. Save blob data as a picture your disk.
9. Change blob data with a picture of your selection.
10. Find out which data constraints apply to fields for the selected table.
11. Write the entire dataset of the selected table as a text file in the XML format to your disk.
12. Select a field to run a case-sensitive search to look for partial matches.
13. The user will edit a database in a non-destructive manner. When a change is made to a database, the main application window enters an edited state. No change will be made to the actual database until the user chooses Save SQLite Database under File.
14. The application supports the fullScreen mode.
15. The application supports the retina screen. (tested with 2014 2.6 GHz 13″ MacBook Pro)
16. Languages: English only.
17. Application file size: 24.2 MB.
18. The application comes with a built-in 24-page user guide. Choose Show Quick Tour under FireSQL 3 whenever you need to see it.

System requirements

1. 10.8 (tested with 10.8.5), 10.9 (untested), 10.10 (tested with 10.10.5), 10.11 (tested with 10.11.1)
2. 64-bit system

Limitations

1. In order to view blob data as a picture, there must exists a field in the same table that holds the size of the picture.
2. In order to edit data, there must be at least one field with the primary key that returns a unique record for a query.

Version history

Version 3.0.4 (Released on March 11, 2016)

1. Fix: When the user chose Save Picture As under View to save blob data as a picture to their disk, the application did not optimize the picture for the retina display.
2. When the user deletes a record, the application will now selects the next record automatically when possible.
3. When the user renames a table, the application will now select the last table under the left pane and the last record under the right pane.
4. A new page is added to Quick Tour that covers the search field over the toolbar menu.

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.






Video tutorial

There is no video tutorial at this time.






FireSQL 3 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.