¿ªÔÆÌåÓý

ctrl + shift + ? for shortcuts
© 2025 Groups.io
  1. Nodered-Hamradio
  2. Topics

Another Idea HRD DB Query

 

Has anyone consider a database query for HRD?

In working?6M, I want to check if I need a grid number quickly.? I know I can do this with HRD, but it isn't a simple operation.

Mike va3mw
 

¿ªÔÆÌåÓý

Depending upon which database engine you have your HRD se to use, it appears there is a node-red interface to it.

?looks to be for the the Microsoft engines. No doubt a similar one exists for MySQL.

I do not use HRD but with a database schema it should not be too hard to figure out the query.?

So are you looking for a way to issue the query with the grid to alert you? I am also curious if you are getting into the arena of JTAlert and could leverage that to do the alert¡ªjust curious of your use case.

Regards,

Tom NY4I


On Aug 24, 2020, at 10:29 AM, Michael Walker <va3mw@...> wrote:

Has anyone consider a database query for HRD?

In working?6M, I want to check if I need a grid number quickly.? I know I can do this with HRD, but it isn't a simple operation.

Mike va3mw
 

This might be what you are looking for,

MariaDB [(none)]> use mysql
MariaDB [(mysql)]>
SELECT COL_BAND, COL_CALL, COL_GRIDSQUARE, COL_MODE
FROM mysql.table_hrd_contacts_v01
WHERE COL_BAND='6m' and COL_MODE='ft8' and COL_GRIDSQUARE like 'EN54%';

73,
Brent N9BC
 

¿ªÔÆÌåÓý

Isn¡¯t the question first which database HRD is using? Or do later versions all use MySQL? I thought that was an option to pick your engine.

Tom NY4I

On Aug 24, 2020, at 2:26 PM, Brent Crier <bcrier@...> wrote:

This might be what you are looking for,

MariaDB [(none)]> use mysql
MariaDB [(mysql)]>
SELECT COL_BAND, COL_CALL, COL_GRIDSQUARE, COL_MODE
FROM mysql.table_hrd_contacts_v01
WHERE COL_BAND='6m' and COL_MODE='ft8' and COL_GRIDSQUARE like 'EN54%';

73,
Brent N9BC

 


You are correct. By default it uses MS Access I believe. But there is an option to convert to MySql to get performance boost which is fairly easy to do. But it was my assumption that Mike was geeky enough? to do just that. :)

-Brent N9BC

1 - 5 of 5