DBLog

DBLog is a super handy logging program designed for radio amateurs. It uses a relational database, which makes it easy to log your QSOs and export them in ADIF format. Pretty cool, right?

Getting Started with DBLog

The first step is to set up and test the database. The development was done using PostgreSQL, but no worries if you prefer MySQL or SQLite—they work too since they’re supported by Gambas.

Database Setup

When setting things up, I used the instruction "EXEC" instead of "FIND", but the SQL commands are pretty standard and should run smoothly on MySQL and SQLite as well. Just something to keep an eye on!

Create users and give them the right permissions. Then, make sure to create the tables for your database—let’s say you call it "LOG," but feel free to choose a name you like! Follow the instructions found in the subdirectory LOG.

CW Keyer & Connection

You’ll want to ensure that cwdaemon starts without any errors. If you run into issues, check out /etc/defaults/cwdaemon. Personally, I use device ttyS0 with a priority of -3.

Once that’s sorted, launch Gambas, load up DBLog, and connect using your username and password. Enjoy logging!

Logging Your QSOs

In RUN mode, the QSO start time (time_on) updates automatically when you enter a call sign. In S&P mode, you'll need to hit "Start QSO" to get the timer going. If you forget that step, don’t worry; it’ll log with whatever time was set.

Using SQL Commands

You can execute any SQL command in the SQL Request window—whether it's searching for something specific, modifying records, or deleting entries. Make sure to keep your SQL manual handy!

Exporting QSOs

The ADIF export function remembers the last exported QSO number too! You can adjust which range of QSOs you'd like to export whenever necessary.

Troubleshooting Tips

If you're not a fan of DMY date style, tweak the DataStyle subroutine as needed.

Caution with CAT Interface

The CAT interface is optimized for an IC-706 MKIIG radio. If you're using a different model, just modify those commands and serial parameters accordingly.

What’s New in This Release:

• This update is great for developers working on other HAM radio applications like digimodes or EME programs.


• The program now works as a 'Log server.' Another app can send commands via TCP on port 3164 to fill fields and log QSOs easily!


• If you've worked with a specific call before, DBLog will reply with 'Name' and 'QTH' information!