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.
On Fri, Apr 18, 2014 at 8:15 AM, David Rysdam <drysdam@ll.mit.edu> wrote:
Steve Spence <greentrust@gmail.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.
