Re: Arduino SQL Connector

[Robin <robinstc@xxxxxxxxxx>]

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@xxxxxxxxxx> wrote:

Steve Spence <greentrust@xxxxxxxxx> 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