Category Archives: Software

An SQL query for unique SKCC numbers in CQRlog

As a follow-on to the MySQL server spawned by CQRlog article, I present a nice bit of SQL for your amusement.  This query is based on the storage of SKCC numbers being in the award column and in the format … Continue reading

Posted in Amateur Radio, Software | 3 Comments

Accessing the MySQL server spawned by CQRlog

Since version 1.0.0~alpha1 CQRlog has used the ubiquitous MySQL database.  By default MySQL is used as an embedded database and the individual databases are stored under ~/.config/cqrlog/database/  This is all well and good and has the advantage of removing the … Continue reading

Posted in Amateur Radio, Software | 1 Comment