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.