Re: Arduino SQL Connector - Mailing list pgsql-general

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@ll.mit.edu> wrote:
> Steve Spence <greentrust@gmail.com> 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.