From: | Tony Shelver <tshelver(at)gmail(dot)com> |
---|---|
To: | Thorsten Schöning <tschoening(at)am-soft(dot)de> |
Cc: | pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: What's your experience with using Postgres in IoT-contexts? |
Date: | 2020-10-09 09:34:30 |
Message-ID: | CAG0dhZBGdqMr7Dzhxh4wnvz1=JWV-=FE-b3jNptCfwZVdjH7yg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)am-soft(dot)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(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
>
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Allan Kamau | 2020-10-09 11:31:43 | Re: Does the work made by vaccum in the current pass is lost when interrupted? |
Previous Message | John the Scott | 2020-10-09 02:29:31 | rum index supported on pg13? |