FireSQL 4 4+

Create SQLite database files and browse records of an SQLite database

FireSQL 4 is a new version of the FireSQL series that is totally redesigned with the SwiftUI framework. The main purpose of using FireSQL 4 is still to browse the content of an SQLite database table and records under the selected table. Originally, FireSQL was designed to let you view the content of blob data. Also, it was originally designed to let you create an SQLite database file. When creating a database file, you can now set tab-separated values as initial records to any of tables.

- Features -

1. Drag and drop an SQLite database file (with or without a file extension of any kind) onto the drop symbol and select a table to work with from a drop-down menu.
2. The sidebar of the database view has a tab view with two tabs. On top of the tab view, the sidebar tells you how many fields the selected table contains with or without a primary key.
3. The Table info tab of the sidebar shows a list of fields, giving you details about each field: What is the data type, whether it comes with a default value or not, whether or not it has a primary key.
4. Use a sorting drop-down menu and select a field with which to sort records.
5. Click on the Asc tab to sort records ascendingly. Or click on the Dsc tab to sort records descendingly.
6. Tap the ‘Go to row’ label with your mouse pointer and enter a row number in the number field to the right in order to jumpt to a specific row of the record list.
7. Select a row and right-click and choose Copy Row to copy the entire record of the selected row as tab-separated values.
8. Select a row and click on the Share button to share the entire ecord of the selected row as tab-separated values with other applications.
9. Click on the JSON toolbar button to save the entire database data as a JSON file.
10.Click on the XML toolbar button to save the entire database data as an XML file.
11.Click on the TSV toolbar button to save the entire database data as an TSV file as in tab-separated values (.tsv).
12.If the table you have selected contains a field with a primary key, run a search as many as three keywords with fields specified on each.
13.View the records of a blob field as images, provided that there is another field with image data sizes.
14.Save the blob image as an PNG file to disk. And share the blob image with other applications.
15.Create an SQLite database file with as many tables as you neeed.
16.Configure a database field, specifying its data type with or without a primary key, with or without autoincrement and so forth.
17.Select a TSV (tab-separated values) file and give the selected table initial records to go with.
18.Save progress as an SQLite creation model. Drag and drop an SQLite creation model file directly onto the table list and recover progress.
19.Click on the view button under the table list and see the records of tab-separated values you have given to a table.
20.Languages: English only.
21.Application file size: 7.4 MB.
22.The application comes with a built-in 23-page quick guide. Click on the Quick guide button at the at the startup screen.

- System requirements -

1. macOS 13.5 (Universal) or higher with an Intel chip or an Apple chip (M1, M2, M3)

- Limitations -

1. Whether or not FireSQL 4 can open a table of the database depends on several factors. (1) How many fields does it contain with how many records? (2) How much memory is your machine equipped with and what CPU does it have? Sometimes, it can open a database table with several millions after waiting for a few minutes. Sometimes, a wait is longer than 10 minutes.
2. When you explore an SQLite database table, FireSQL 4 lets you read as many as 100 records without an ‘Unlimited records to browse’ in-app purchase.
3. When you explore an SQLite database table, the search feature is only available if the table has a field with a primary key.
4. When you create an SQLite database file, one is restricted to have one table without an ‘Unlimited database creation’ in-app purchase.