Re: Arduino SQL Connector
Adrian Klaver <adrian.klaver <at> aklaver.com>
2014-04-18 17:43:12 GMT
On 04/18/2014 09:39 AM, Tomas Vondra wrote:
> On 18 Duben 2014, 17:01, Adrian Klaver wrote:
>> On 04/18/2014 07:53 AM, Jan Wieck wrote:
>>> On 04/18/14 10:31, Steve Spence wrote:
>>>> Not a thing in that document about the Arduino. Just how to install
>>>> Postgres on a Raspberry Pi. My Postgres is on a hosted server at a ISP.
>>> You intend to have thousands of Arduino devices, incapable of doing any
>>> sort of encryption or other means of secure IP connections, directly
>>> connect to a database, that is hosted on a publicly accessible VPS?
>>> Maybe it is just me, but to me that design has DISASTER written in bold,
>>> red, 120pt font all over it.
>> It is already established you do not like any part of this idea. Beating
>> the dead horse really does not accomplish anything.
> I don't think pointing out weaknesses of a proposed solution is equal to
> beating a dead horse.
Well the point is that the OP is already doing this with MySQL as the
backend. He just wants to move to Postgres if possible.
> I see two potential issues here - security and excessive number of
> connections. Security, because while you can reasonably authenticate the
> client (e.g. using MD5 authentication), there's no way of encrypting the
> traffic. But if the data is not sensitive, this might be sufficient.
> Excessive number of connections, because if you keep one connection from
> each arduino device, and you have 1000s of devices ... you get the idea.
> But this might be resolved using pgbouncer + transaction pooling or so.
Valid concerns whether MySQL or Postgres or some other data store is
used. Though as of now, from what I gather there are only 2 Arduinos
adrian.klaver <at> aklaver.com
Sent via pgsql-general mailing list (pgsql-general <at> postgresql.org)
To make changes to your subscription: