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

Поиск
Список
Период
Сортировка
От Tony Shelver
Тема Re: What's your experience with using Postgres in IoT-contexts?
Дата
Msg-id CAG0dhZBGdqMr7Dzhxh4wnvz1=JWV-=FE-b3jNptCfwZVdjH7yg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: What's your experience with using Postgres in IoT-contexts?  (Thorsten Schöning <tschoening@am-soft.de>)
Список pgsql-general
Everything is sent tot he cloud from the vehicle.  The trackers we currently run don't have the power to be able to do much.
There are a few vehicle devices we have access to (hub systems with a central computer / cpu / storage) which could handle a database, but in terms of our business requirements, everything is needed at the cloud / server level for analysis.


On Wed, 7 Oct 2020 at 08:28, Thorsten Schöning <tschoening@am-soft.de> wrote:
Guten Tag Tony Shelver,
am Dienstag, 6. Oktober 2020 um 16:33 schrieben Sie:

> Each vehicle reports position to the database at least every 30 seconds
> when moving, along with any other data as it happens.  So it's quite a bit.

> H2 seemed to handle it fine for a limited number of vehicles, but we moved
> it to PG once we moved to production.

But where does Postgres run in your setup? :-) On the tracked vehicle
itself with limited resources most likely or do you simply send things
over network to some cloud/server/...? Your first paragraph reads like
the former, but the second like the latter. :-)

If it's on the vehicle, I would be interested to somewhat know which
hardware you use, to compare what I have in mind. Thanks!

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 по дате отправления:

Предыдущее
От: John the Scott
Дата:
Сообщение: rum index supported on pg13?
Следующее
От: Allan Kamau
Дата:
Сообщение: Re: Does the work made by vaccum in the current pass is lost when interrupted?