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.
- The user can rename and delete existing tables. Insert new tables to the selected database.
- Alter records manually. The user can also change blob data with a new picture of their selection.
- View blob data as a picture.
- Run a search for partial matches by selecting a field.
- Let the application store SQL statements for creating SQLite database files.
- Delete a record of your selection.
- It’s finally a Cocoa application. ViewSQL Pro wasn’t.
- Drag and drop an SQLite database file directly onto application’s main window to read data.
- Rename and delete tables.
- Insert new tables to your database.
- Delete the record of your selection.
- Create and save an SQLite database file to your disk. Apply data contraints such as primary key, not null, auto increment, unique to fields.
- Store database creation settings with an outline view.
- Edit a database record manually.
- View blob data as a picture. Save blob data as a picture your disk.
- Change blob data with a picture of your selection.
- Find out which data constraints apply to fields for the selected table.
- Write the entire dataset of the selected table as a text file in the XML format to your disk.
- Select a field to run a case-sensitive search to look for partial matches.
- 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.
- The application supports the fullScreen mode.
- The application supports the retina screen. (tested with 2014 2.6 GHz 13″ MacBook Pro)
- Languages: English only.
- Application file size: 24.2 MB.
- The application comes with a built-in 24-page user guide. Choose Show Quick Tour under FireSQL 3 whenever you need to see it.
- 10.8 (tested with 10.8.5), 10.9 (untested), 10.10 (tested with 10.10.5), 10.11 (tested with 10.11.1)
- 64-bit system
- 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.
- 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 3.0.4 (Released on March 11, 2016)
- 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.
- When the user deletes a record, the application will now selects the next record automatically when possible.
- 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.
- A new page is added to Quick Tour that covers the search field over the toolbar menu.
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.
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.