Re: What's your experience with using Postgres in IoT-contexts? - Mailing list pgsql-general

From Thorsten Schöning
Subject Re: What's your experience with using Postgres in IoT-contexts?
Date
Msg-id 1846018396.20201010112242@am-soft.de
Whole thread Raw
In response to Re: What's your experience with using Postgres in IoT-contexts?  ("Peter J. Holzer" <hjp-pgsql@hjp.at>)
Responses Re: What's your experience with using Postgres in IoT-contexts?
List pgsql-general
Guten Tag Peter J. Holzer,
am Samstag, 10. Oktober 2020 um 10:56 schrieben Sie:

> Do you plan to move some of that reporting to the IoT devices? (Maybe
> equip them with a display with a dashboard, or something like that)

Not necessarily with a display, but something like a dashboard for a
web-UI on the device itself definitely needs to be kept in mind.
Though, some display has been considered as well.

> Because for simply storing a few hundred records which are written and
> read sequentially, an RDBMS of any kind seems overkill. I'd simply write
> them to files.

That's still considered as well and what's done right now. But at some
point we need to maintain individual logical devices where those
telegrams come from anyway. It as well has been considered to store
only metadata in the database and telegrams in files, but as telegrams
are small mostly, this doesn't seem worth it. And because telegrams
are small, we would need some kind of container format anyway to not
run out of inodes and stuff like that too easily.

Mit freundlichen Grüßen,

Thorsten Schöning

--
Thorsten Schöning       E-Mail: Thorsten.Schoening@AM-SoFT.de
AM-SoFT IT-Systeme      http://www.AM-SoFT.de/

Telefon...........05151-  9468- 55
Fax...............05151-  9468- 88
Mobil..............0178-8 9468- 04

AM-SoFT GmbH IT-Systeme, Brandenburger Str. 7c, 31789 Hameln
AG Hannover HRB 207 694 - Geschäftsführer: Andreas Muchow




pgsql-general by date:

Previous
From: "Peter J. Holzer"
Date:
Subject: Re: What's your experience with using Postgres in IoT-contexts?
Next
From: "Peter J. Holzer"
Date:
Subject: Re: How to migrate column type from uuid to serial