Re: What's your experience with using Postgres in IoT-contexts?

Not sure about PG in that environment. Have you thought about something
like H2 java database? https://www.h2database.com/html/main.html

That is included as the standarDB in a vehicle tracking system we use,
although we have re[placed with PG.

On Mon, 5 Oct 2020 at 11:20, Thorsten Schöning <tschoening(at)am-soft(dot)de>
wrote:

> Hi all,
>
> TL;DR:
>
> Does anyone actually use Postgres with ARM based low performance
> hardware and only 256 MiB of RAM? What are your experiences in other
> stripped down environments? Is there some lower RAM limit with which
> using Postgres doesn't make any sense anymore? Is Postgres able to
> compete with SQLite regaridng lower performance boundaries or is there
> some point at which SQLite will be the better choice, because Postgres
> needs some more resources to work properly?
>
> Thanks!
>
> Background:
>
> I have some server side backend exposing web services and storing data
> in Postgres. The stored data are telegrams from smart metering
> devices, lots of them, mostly small. The provided web services take
> care of generating reports etc. based on those telegrams.
>
> It's now considered to put large parts of that backend onto some ARM
> based IoT device, simply because that device would do a lot of the
> same things. The available backend is Java-based, so it would simply
> be possible as well and I already ran things on some Raspi-like
> hardware and things worked pretty well. OTOH, the targetted hardware
> is less capable than some Raspi, we talk about only 256 MiB of RAM
> currently. The exact details of the hardware are not clear yet.
>
> In the easiest case, the newly created device would only need to store
> some hundreds of telegrams per day in some known time window and
> forward those telegrams afterwards. In most cases it would be those of
> the same day only, but might be those of the last X few days as well
> in case of problems. In the long term, though, that device should be
> able to store telegrams for years and might generate reports on it's
> own as well.
>
> I've already found some interesting infos like the following, but
> would be interested in other expereinces as well.
>
>
> https://www.postgresql.eu/events/pgconfeu2019/sessions/session/2781/slides/251/PostgreSQL%20for%20IoT.pdf
>
> Mit freundlichen Grüßen,
>
> Thorsten Schöning
>
> --
> Thorsten Schöning E-Mail: Thorsten(dot)Schoening(at)AM-SoFT(dot)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
>
>
>
>