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. Sorry if I came across with perceived attitude, but I explained what I was currently doing (and it works well), gave a working example link, showed the source code link that makes it work, but apparently had the audacity to think that Postgres would want to participate in a IOT phenomenon. I'm not asking for help porting my application, I'm suggesting that postgres would find hundreds of thousands of new fans if they chose to support this useful device in such a manner. The Arduino is very good at compiling includes written in C/C++. just need a .h and .ccp file with the correct syntax, but very compact. It used to be part of the fun making programs fit in 4-16k back in the day. I write my "business logic" in a php app that resides on the server that uses the data from the sensor table, creates graphs, outputs pdf reports and pushes control decisions back to the arduino through a jobs queue table. A simple "select * from" on the arduino picks up the control jobs and sets outputs accordingly. Steve Spence, KK4HFJ Director, Green Trust http://www.green-trust.org Http://arduinotronics.blogspot.com On Fri, Apr 18, 2014 at 6:53 AM, David Rysdam <drysdam@xxxxxxxxxx> wrote: > Steve Spence <greentrust@xxxxxxxxx> writes: >> Need a Team lead on this, and I'll collaborate as much as I can on the >> Arduino / Networking side. > > I don't understand why there is so much blowback to the idea that you > can just use the existing code. Why exactly wouldn't it work? It > compiles on that architecture already. The only possible issue is size. > > Take the libpq source and cross-compile it for the Arduino. I did this > back in 2008 or so for a stepper motor driver that didn't work how I > wanted. > > I wouldn't be surprised if the lame Arduino *IDE* won't do this, but > what does that matter? You can make the library by cross-compiling, > then include it in your Arduino sketch. > > That said, I agree with the other poster who questioned why you'd put > the DB client on the device anyway. Seems needlessly difficult and > limiting. Just put a simple serial writer on that end and have a tiny > serial->DB translator on the same machine you were going to put the DB > on. Done in about an hour and you can switch DBMSs without having to > touch the device. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
