Re: Arduino SQL Connector

Bottom posted

On 18/04/2014 15: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.
>
>
>
> Steve Spence, KK4HFJ
> Director, Green Trust
> http://www.green-trust.org
> Http://arduinotronics.blogspot.com
>
>
> On Fri, Apr 18, 2014 at 10:04 AM, Robin <robinstc(at)live(dot)co(dot)uk
> <mailto:robinstc(at)live(dot)co(dot)uk>> wrote:
>
> 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
>
>
Whoops - I wasn't aware that I had to explain the relationship between
Arduino and the Raspberry Pi - its pretty well exploited.

R+C