Re: Arduino SQL Connector

From: Edson Richter <edsonrichter(at)hotmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Arduino SQL Connector
Date: 2014-04-18 18:00:20
Message-ID: BLU0-SMTP148CA4CE8C4914E8B172C52CF5D0@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Em 18/04/2014 13:30, Steve Atkins escreveu:
> On Apr 18, 2014, at 9:11 AM, Edson Richter <edsonrichter(at)hotmail(dot)com> 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Greg Sabino Mullane 2014-04-18 18:57:01 Re: Re: any way for a transaction to "see" inserts done earlier in the transaction?
Previous Message Adrian Klaver 2014-04-18 17:43:12 Re: Arduino SQL Connector