IU7IWT my projects and my hobbies

Hi everyone!
I’d like to share with the community a web tool I developed to visualize my VarAC traffic activity in real-time.
It's called VarAC Log Mapper - Terminal Edition. The idea was to create a dashboard that looks like it came straight out of an 80s computer (Green Phosphor CRT monitor style), but packed with modern monitoring features.
Here are the main features of the software:
1. Live Log Mapping
The system reads the local VarAC.db file directly (client-side within the browser for privacy, no data is uploaded to external servers).
Visualizes both Confirmed QSOs (Red) and Heard Stations (Cyan) on the map.
The Last 5 stations received pulse in bright green for immediate identification.
Includes a "Last 5" summary table showing Time, Call, Grid, and SNR.
2. DXer Toolkit
Beyond the map, I’ve integrated several useful tools into a single screen:
HF Propagation Monitor: Real-time solar data (SFI, Sunspots, A/K Index) fetched from HamQSL, indicating conditions (Good/Fair/Poor) per band (Day/Night).
NCDXF Beacons: A synchronized panel showing exactly which beacon is transmitting at that specific second across all bands (14.100, 18.110, etc.) and highlighting it on the map.
Greyline & Astro: Visualizes the terminator line, sun/moon position, and moon phase/illumination.
World Clocks: UTC, Rome, NY, Tokyo, etc.
PSK Reporter: A quick query feature to check spots for your callsign on PSK Reporter (last 15 mins).
3. Security & Access
Since this runs as a web page on a server, I implemented a Secure Login System.
Access to the map is protected by a "Terminal Style" authentication screen requiring a Call and Password (verified against a local file on the server) to keep the log private.
4. "Retro" Design
The entire interface is designed to be eye-friendly (Total Dark Mode) and recreates the "Scanline" effect of old monitors, using the VT323 monospaced font.
How does it work technically?
It is a PHP/HTML5 page that uses Leaflet for mapping and SQL.js to read the SQLite VarAC database directly from the browser. You simply select the .db file, and the page auto-refreshes every 5 seconds looking for new spots.
I hope you find it interesting and perhaps it can serve as inspiration for your own projects!
If you have any feedback or would like to try it, let me know in the comments at this mail: iu7iwt@gmail.com

Note to all radio operators: enter your grid locator in the VarAC software info. This is required for correct mapping in various software. Try not to leave this parameter blank.

Here is the link to try the software: https://www.curiositaastronomiche.it/varac_db/index.php

Use these credentials to try the software:
call: user
password: demo

At this link you can find the software instructions(English version): https://www.curiositaastronomiche.it/va ... manual.pdf


At this link you can find the software instructions(Dutch version): https://www.curiositaastronomiche.it/va ... ual_nl.pdf




Youtube video tutorial: https://youtu.be/dDY19jaDQi0


A big thanks to my friend OM Andrea IU7LVA who helped me testing the VarAV Log Mapping.

73 de IU7IWT

New changes included: added waterfall signal, s-meter and graphical interface color change and show today's spots only options

Info new release v.141.

A. Standard Mode (Default)
In this mode, markers appear in different colors based on the event type:
· GREEN (Pulsing): Indicates the last 10 signals received (the most recent
activity).
· RED: Indicates "Heard" signals (decoded but not connected).
IMPORTANT NOTE ON RED MARKER SIZES:
In Standard Mode, all red circles are programmed with a fixed size. However, you
may notice that some red spots appear larger or brighter than others.
This is a visual effect caused by overlapping: if you have logged many QSOs with
stations located in the same Grid Locator, the software draws multiple circles
stacked on top of each other at the exact same point. The accumulation of borders
and "glow" effects creates the illusion of a larger, more intense circle, visually
indicating an area with high contact density.
B. "ALL DYNAMIC SPOTS" Mode
By activating the "ALL DYNAMIC SPOTS (SNR SIZE)" switch in the configuration
panel, the visualization changes radically:
· Single Color: All markers become Cyan (Light Blue).
· Variable Diameter (SNR): The size of the circle is no longer fixed but
changes dynamically based on the received Signal-to-Noise Ratio (SNR):
o Strong Signal (High dB): The circle will be larger.
o Weak Signal (Low dB): The circle will be smaller.
o This allows you to instantly recognize which geographic areas are
coming in with the strongest signals.

Link to web page of VarAC log Mapper v.1.41 : https://www.curiositaastronomiche.it/VARAC_DB/index.php

Use these credentials to try the software:
call: user
password: demo

user manual of v.1.41: https://www.curiositaastronomiche.it/va ... V.1.41.pdf

73 de IU7IWT

Update: modified OS-style graphical interface with moveable windows, added the QSO window with the last 10 listened contacts.

Updated several features and improved browser stability, fixed several bugs, and added broadcast reception. 73 by IU7IWT

The application runs in your browser and is very easy to launch:
When you launch it, you must log in with the following credentials:

call: user
password: demo

Once you've logged in, load the VarAC database from the c:/Varac/varac.db folder, and the application will start automatically. You can find descriptions of the various functions in the instruction manual, which is constantly updated.

Application link:
https://www.curiositaastronomiche.it/varac_db/index.php

Added new Qrz mini Browser function: now it is possible to activate a small pop-up relating to the last call listened to and keep it always updated.

Link to the new instructions: https://www.curiositaastronomiche.it/va ... ERSION.pdf



73 de IU7IWT

New updates:

- Added a new column to the window for the last 15 QRZs received, identifying the type of CQ. The beacon will be shown in green, and the CQ will be shown in red.

- Added a graphic effect that draws attention to the CQ call.

- Added a new window displaying the maximum distances traveled during the day or in the database.

New added functionality: QSO logbook

-consultation of the log book of all database

New changes: visualizing weather conditions

- close the mouse point with a green mark of the last 5 calls as you can see the weather conditions of the station

73 de iu7iwt