FRLogger - Querying FRLogger Data

FRLogger uses SQLite databases. SQLite is free, fast and many tools are avaiable to work with it.

I've had a few requests to allow people to do their own SQL to query the database. Unfortunately, the task I'm not willing to undertake is to provide a nice SQL interface when there are tools available, for free, that do an amazing job.

The tool I would recommend to snoop around in and query the FRLogger database is DB Browser for SQLite. The tool is free and available from:

DB Browser for SQLite

A couple of key items before you download, install, and start querying data:

  • FRLogger opens and closes the database as required. It is doing this fairly often so it is important that any external tool not lock the database.
  • Most of the data in FRLogger databases is benign and just there as storage. But there are some fields that FRLogger relies on. If you change them you could cause strange functionality.

After downloading and installing it, and running it you will see a blank window that looks like this:

Before you open the FRLogger database you need to decide what you are planning to do. If you are just querying data and looking around then DB Browser allows you to open the database in read-only mode. This is HIGHLY RECOMMENDED

If you plan to make changes then I suggest the following:

  • Shutdown FRLogger
  • Make a copy of the database and save it so you can go back to it easily if you don't like your changes
  • Now open the database in DB Browser and make your changes
  • When you re done, close DB Browser and reopen FRLogger

When you open the FRLogger database you will see this kind of window in DB Browser:

Note that three tables are shown: QsoLog, _EFMigrationsHistory, and sqlite_sequence. I strongly suggest that you do not muck around in the _EFMigrationsHistory and sqlite_sequence tables unless you really know what you are doing. Your log data exists in the QsoLog table so that is where you should be focused.

One of the reasons I like DB Browser for this purpose is the display below. DB Browser when you select the QsoLog database and go to the browse tab gives you like an excel spreadsheet look at your data.

In this spreadsheet like view you can sort by clicking on column headers. You can filter by putting in text into the filter boxes on each column. And you can even make small changes if you have the database open for write.

For example, if you have the database open for write and you want to fix say an RST. Find the record using the filters. Go to the RST column you want to change and click on the data. You will be given a chance to enter new data. After you have made your changes you will need to use the file menu to write your changes back to the database.

For those power users that know SQL you can go to the SQL tab and execute your own SQL queries, including data updates from this tab.

Have fun browsing. Just remember that if you make changes you need to be very sure of what you are doing and always have a backup.