[TangerineSDR] Personal Space WX Station Central Control System Database

[Tom McDermott]

Hi Bill - thanks for putting this together !

I will be installing a magnetometer hopefully soon to start taking data to
understand how the magnetometer compares to other references.
I've setup mariaDB in a docker container on my server, and exposed port
3306 to access it.   I have DBeaver on
my Linux workstation, it is able to access and manage that remote container
via a GUI interface.

Question:  Is there value in having the structure of that magnetometer-only
local database in some particular
format so that at a later time it might be easy to merge into the central
server database?  If so,
what would you advise?

-- Tom, N5EG





On Fri, Nov 6, 2020 at 8:05 AM Engelke, Bill via TangerineSDR <
tangerinesdr at lists.tapr.org> wrote:

> To all:                            *Personal Space WX Station Central
> Control System Database*
>
>
>
> Please find attached :
>
>    - A PowerPoint layout showing database structure
>    - An Excel file listing my current understanding of what fields we
>    need in each table
>
>
>
> Note that I have configured third normal form for several fields, to
> improve efficiency.
>
> Fields that should be indexed are denoted with *, although I have marked
> several fields as indexed when they would also be linked (i.e., foreign
> key), so maybe unnecessary.
>
>
>
> This is a work in progress..    any feedback is most welcome – 73 – Bill
> AB4EJ
> --
> TangerineSDR mailing list
> TangerineSDR at lists.tapr.org
> http://lists.tapr.org/mailman/listinfo/tangerinesdr_lists.tapr.org
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.tapr.org/pipermail/tangerinesdr_lists.tapr.org/attachments/20201106/a751ae29/attachment.html>