[TangerineSDR] Personal Space WX Station Central Control System Database

[Tom McDermott]

HI Dave,  certainly useful.    I was trying to figure out what the
individual magnetometer records look like.
i.e. timestamp, x_meas, y_meas, z_meas, total_field,  as well as the field
types (e.g. uint16, time_t) etc.

I am not familiar with PostgresQL.   Does it expose a port with semantics
similar to mysql or mariadb for appending
records?  There are Python packages for connecting to remote databases and
manipulating them.

-- Tom, N5EG




On Sat, Nov 7, 2020 at 9:33 AM David Witten <wittend at wwrinc.com> wrote:

> On Thursday afternoon Nathanial set up a Linode virtual machine for us to
> use  as a rsync  repository for data logged from the magnetometers under
> test.  I'm having a bit of difficulty accessing it so far, but I have
> another instance running well.  There are seemingly some loose ends related
> to access,but that should be cleared up soon.  A database will reside on
> this node to keep track of what has been placed there.
>
> My plan was to use PostgresQL perhaps coupled with a time-series database,
> perhaps similar to that being used by Rob Robinett to experiment with
> different collection/retrieval strategies.  I intend to follow the database
> model proposed by Bill AB4EJ.  This will be available to all testors and
> give everyone an early opportunity to find out what works/breaks.
>
> Will this be useful for you as well?
>
> Dave Witten, KD0EAG
>
>
> From: Tom McDermott <tom.n5eg at gmail.com>
>> To: TAPR TangerineSDR Modular Software Defined Radio <
>> tangerinesdr at lists.tapr.org>
>> Cc: Cole <crobbins3 at crimson.ua.edu>, Laura <lemalis at crimson.ua.edu>,
>> Nicholas <nmuscolino at crimson.ua.edu>, "Atkison, Travis" <
>> atkison at cs.ua.edu>, "Engelke, Bill" <bill.engelke at ua.edu>
>> Bcc:
>> Date: Fri, 6 Nov 2020 09:03:57 -0800
>> Subject: Re: [TangerineSDR] Personal Space WX Station Central Control
>> System Database
>> 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
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.tapr.org/pipermail/tangerinesdr_lists.tapr.org/attachments/20201107/a6197ab9/attachment.html>