DB Browser for SQLite on OS X

If you would like a graphical user interface (GUI) to view and manage SQLite databases, you can use DB Browser for SQLite, which was originally developed by Mauricio Piacentini of Tabuleiro Producoes as the Arca Database Browser. The program was later modified to be compatible with SQLite 2.x databases and rleased into the public domain. In 2014, the project was renamed to "Database Browser for SQLite" at the request of Richard Hipp , the creator of SQLite. The software is available for Microsoft Windows, Apple OS X, and Linux systems.

To install and run the application on a system running Apple's OS X operating system, take the following steps:

Download the Apple Disk Image .dmg file from the SQLite website, then double-click on the downloaded file, which will open a window with an icon for sqlitebrowser.app
Open a Finder window and drag the sqlitebrowser.app icon from the window that opens when you double-click on the downloaded file into the Applications folder in the Finder window.

You can then open the program by double-clicking on the icon for it in the Applications directory. If you see a message like the one below, hold down the control key and right-click on the icon for the application then select Open.

"sqlitebrowser.app" can't be opened
because it is from an unidentified
developer.

Your security preferences allow installation of only
apps from the Mac App Store and identified
developers.

Firefox.app downloaded this file today at 4:18 PM.

When you right-click on the application while holding down the control key, if you see the message above, you will then see the following message:

"sqlitebrowser.app" is from an unidentified
developer. Are you sure you want to open
it?

Opening "sqlitebrowser.app" will always allow it to
run on this Mac.

Firefox.app downloaded this file today at 4:18 PM.

Click on Open to run the application.

The icon representing the program that you will see at the bottom of your screen will look like the one below:

The main window for the program will show the following:

You can open an existing database by clicking on Open Database and browsing to the .db file for the database.

To browse the records in a table in the database, click on Browse Data then select a table by clicking on the double-headed arrow to the right of "Table:", which is beneath "Database Stucture".

To add additional data to the table, click on New Record then click in a column for the new record to add data to it.

If you click once, you can type into the field in the Browse Data record. If you double-click in a field, i.e., column, an Edit database cell window will open that gives you a much bigger window in which you can type or paste your data.

If you need to reset a field to "Null", double click on the field and then click on the Clear button in the Edit database cell window then click on OK.

As you add data, if you select SQL Log from the right pane of the DB Browser for SQLite window, you will see the SQL commands that are being used appear, if Application is selected for "Show SQL submitted by", though question marks will be shown rather than the data you are entering into a field.

You can order the data in ascending or descending order by clicking on a column header. E.g., in the example below, the records are ordered on the "Approved" date in descending order by date with the newest date at the top.