Re: Arduino SQL Connector

Em 18/04/2014 13:30, Steve Atkins escreveu:
> On Apr 18, 2014, at 9:11 AM, Edson Richter  wrote:
>
>> Em 17/04/2014 09:00, Steve Spence escreveu:
>>> I'm using a MySQL library on my arduino that allows me to directly
>>> connect to a MySQL database and perform SQL queries on the Arduino.
>>>
>>> I need something similar for Postgres. Anyone have the knowledge and
>>> interest to work with me?
>>>
>>> Here is a sample of what I'm doing currently, and the results:
>>>
>>> http://arduinotronics.blogspot.com/2014/04/arduino-based-sql-queries.html
>>>
>>> http://green-trust.org/lmanco/find.php
>>>
>>>
>>> Steve Spence, KK4HFJ
>>> Director, Green Trust
>>> http://www.green-trust.org
>>> Http://arduinotronics.blogspot.com
>>>
>>>
>> Is Arduino capable of running Java apps?
> It's a microcontroller, with significantly less functionality than
> my wristwatch. The big configurations have something like 8k
> of RAM and a few hundred k or flash. The regular ones have
> a couple of k of RAM and a few tens of k of flash.
>
> There's no OS, just a single running application.
>
> I'm pretty sure it'd be possible to implement a cut down version
> of the PG protocol for it (though for the use case the original
> poster mentioned it's a terribly idea, for system security reasons
> as much as anything else). It'd be an interesting Saturday
> afternoon project, at least.
>
> But running virtual machines on it, or doing naive ports of
> a full featured API isn't going to work - there's just not
> enough space on the chip, for either code or storage.
>
> Cheers,
>    Steve
>
>
>
Ok, in that case (and based on my experience with old Z80 tiny devices I 
used to program 30 years ago), the best solution that would fit with any 
database (not only with PostgreSQL or MySQL, but also making possible to 
run other devices than Arduino) is to send data over TCP using 
streamlined protocol to a server app - much faster and capable of 
handling thousands of devices, and a correctly streamlined protocol will 
be hundreds of times faster than any database protocol (a specific piece 
of code is always faster than a generic purpose one).

All other's arguments about security, pooling, stability, etc, would be 
easily addressed using this combination of customized protocol + custom 
receiver server: with a "plus" - you don't have to upgrade your devices 
if you want to upgrade database libraries, change schema structure (very 
common after a while: change schemas to increase performance or opmize 
storage), or similar adjustments that would happen after your app is 
running.

That's my 2c,

Edson.