SAPJRadioScanningDB: A Custom Python Database for Radio Scanning Enthusiasts.
Current Version = V5
Install / Setup:
1. Download SAPJRadioScanningDB -> Send me a message via the contact form.
2. Unzip to C:\SAPJRadioScanningDB
3. Open this folder and run "SAPJRadioScanningDB_V1.9.exe"
The full path is: "C:\SAPJRadioScanningDB\SAPJRadioScanningDB_V1.9.exe"
4. Enter the username as "user" and password as "user"
5. A demo record has been added, please use this as a guide of the correct way to enter loggings and data.
What is SAPJRadioScanningDB?
As a long-time radio scanning enthusiast, I’ve always looked for efficient ways to log the frequencies, channels, and key information I encounter during my monitoring sessions. Many existing solutions are great, but none quite met the specific needs I have as someone passionate about logging, sorting, and categorizing my findings effectively. This is what led me to develop SAPJRadioScanningDB, a Python-based database system designed specifically for logging radio scanning-related data.
SAPJRadioScanningDB is a specialized, Python-based tool created to simplify the process of logging frequencies, capturing details about channels, and organizing relevant data points. It’s a database designed from the ground up with the goal of helping radio scanning enthusiasts like me track, update, and reference the information they uncover. Rather than relying on generalized software, I wanted a system that would meet the nuances of radio logging in a low-cost, flexible way.
Key Features of SAPJRadioScanningDB
Efficient Frequency Logging: This tool was designed for streamlined frequency logging. SAPJRadioScanningDB allows me to add and sort frequency data, note down related signal strengths, locations, and other information I find useful during my scanning. It has a couple of shortcuts, which aid in data entry.
Middle Mouse Click = Open Edit Menu
Right Mouse Click = Set logged date to today. This has been added as it saves a lot of time when updating the last logged date.Customizable Entries: The flexibility of Python allows me to easily customize the fields and entries I want to track. Whether it’s band, frequency type, or even timestamped notes about specific broadcasts, I can add these fields as needed.
Sorting and Searching: One of the biggest advantages of a database like SAPJRadioScanningDB is the ability to search and sort information quickly. By applying filters, I can retrieve specific bands, channels, or frequencies, which makes revisiting past findings easier and more efficient.
Minimalist and Lightweight: In keeping with my interest in low-cost, low-footprint hobbies, SAPJRadioScanningDB is lightweight and doesn’t require heavy software to operate. It can be run on most systems without needing much in the way of resources, which is ideal for a clutter-free setup.
Built for Personal Use: Unlike some larger commercial databases, SAPJRadioScanningDB is designed for the individual user. This means I’ve avoided unnecessary complexity and focused on what’s most useful for logging and retrieving my personal scanning data.
Why Python?
Python was an obvious choice because it’s a highly versatile and accessible programming language with great support for data manipulation and storage libraries. It lets me easily build in functionality like exporting data, creating custom logging formats, and even generating reports if needed. Python also provides great flexibility for potential updates, meaning I can enhance SAPJRadioScanningDB with new features as my needs evolve.
In Summary, if you’re a radio scanning enthusiast looking for a customizable logging solution, SAPJRadioScanningDB could be the perfect addition to your toolkit. Designed specifically for those who love to keep track of radio discoveries, this Python-based system has made my logging process more organized and enjoyable.
- Updating Last Logged Date: By press spacebar on a selected record, it will automatically update to set the last logged date to the current date.
- CSV Export: By press the "Export to CSV button", a CSV file is created with the current date, with all records and data exported for external use and posting online.
- Edit Menu: The edit menu can now be accessed by right clicking on a selected record.
- Record Highlighting: Any records where the last logged date equals the current date will be highlighted in red, this makes it much easier to see what has been logged that day.
- Layout Changes: I have made some minor changes to the layout and colours, to improve usability.
Can you please remove the ID:xxx if possible. Or at least move the ID: the Freq: and Date: texts to the top in the frame so it doesn't have to be seen at each line. Allow trailing zeros in the frequency to make it look more uniform and have the date in front of the frequency in a standard way of day-month-year with two digits in each to keep it more clean. Also can you make the number of character the exact same to where a value are presented, so that the frequency always starts at the same place and the name text also starts at the exact same number of characters from the left margin. It would help to make it more easy to read.
ReplyDelete