If we extract "core callsign", prefix and suffix then copy them to separate columns in the DB, this would allow to return to indexed search. Of course, this is not what they teach you on "how to manage relational database".

I've run this query through "EXPLAIN QUERY PLAN" and it appears SQLite is ignoring indexes for it - thus making full, slow db scan. The problem lays in the LIKE '%CALL%' part - SQLite will not use indexes for such LIKE queries. No easy solution for Log4OM, as we probably need those double wildcards ...

/LH is a recognised prefix and sometimes suffix for Norway, using it for Lighthouse is not internationally recognised. Actually only prefixes allowed in Norway for CEPT-complaint visitors are LA/ or JW/ , see https://eng.nkom.no/leisure/radio-amateurs/radio-amateurs/information-for-visitors-to-norw...

With Lighthouse event running this weekend, there are plenty of station suffixed "/LH", so Log4OM puts them all in Norway... Could you please disable this "feature"? In my opinion, no software should not promote bad manners (ie. putting country in suffix, not prefix). Many will later recon that coun...

Hello, As I promised to Daniele, here are my few thoughts about the present paper QSL card handling features. I don't know how it's going to look like in V2, but maybe these ideas will be useful anyway. 1. First of all, I'd suggest to remove "QSL assistant" and make it a part of "Label printing" (pe...

Hi, I'm just exploring the Log4OM while trying to find the best logging software for myself. After I've imported an ADIF into Log4OM, I've browsed the "Recent QSO" list. It is nicely sorted by QSO time by default. If, however, one clicks "QSO start time" to re-sort the QSOs by time.. they get sorted...