From: | Robin <robinstc(at)live(dot)co(dot)uk> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Arduino SQL Connector |
Date: | 2014-04-18 14:04:23 |
Message-ID: | BLU0-SMTP181CC8E5DFDAF122B57D696E25D0@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I have bottom posted
On 18/04/2014 14:20, Steve Spence wrote:
> And that is the way I used to do it, before the Arduino MySQL
> connector came out. It was nice not to have to go though the double
> stepping any more. Hence my interest in a Arduino PostgreSQL Connector.
>
> Here is how it works today. slim and clean -
> http://www.green-trust.org/lmanco/find.php
>
> Steve Spence, KK4HFJ
> Director, Green Trust
> http://www.green-trust.org
> Http://arduinotronics.blogspot.com
>
>
> On Fri, Apr 18, 2014 at 8:15 AM, David Rysdam <drysdam(at)ll(dot)mit(dot)edu
> <mailto:drysdam(at)ll(dot)mit(dot)edu>> wrote:
>
> Steve Spence <greentrust(at)gmail(dot)com <mailto:greentrust(at)gmail(dot)com>>
> writes:
> > It's actually quite freeing, not complicating. I can put the values
> > right into the fields I need them to be in (or get values from the
> > database I need to control the Arduino), without going through a
> > intermediate process. If you have a serial process I can look at
> that
> > works with 1000 or more remote sensors all over the world to a
> hosted
> > database server, I'd love to look at it. Right now what I have
> works,
> > but I have no GIS functionality.
>
> I'm not going to claim this is a great design, but it's at least an
> order of magnitude easier than your proposal:
>
> Set up the simplest web server that will run PHP. Program the Arduinos
> to submit POST requests to it (which is just networking you say
> you can
> already handle), by which they submit their SQL strings. Write a PHP
> script that passes those to PostgreSQL.
>
> The webserver should be able to handle at least as much as what
> you were
> going to throw at the DB server, so there's no load problem.
>
>
Here is a workable solution to using Arduino with PostgreSQL -
http://wildraspy.blogspot.co.uk/2014/01/the-pi-as-postgresql-database-server.html
If you are controlling lots of devices around the world, you should
probably be clustering anyway.
Robin St.Clair
From | Date | Subject | |
---|---|---|---|
Next Message | Steve Spence | 2014-04-18 14:31:35 | Re: Arduino SQL Connector |
Previous Message | Ron Pasch | 2014-04-18 13:59:55 | Could use some advice on search architecture |