Re: Arduino SQL Connector - Mailing list pgsql-general

From Jan Wieck
Subject Re: Arduino SQL Connector
Date
Msg-id 5350ABAE.5060801@wi3ck.info
Whole thread Raw
In response to Re: Arduino SQL Connector  (Steve Spence <greentrust@gmail.com>)
List pgsql-general
On 04/18/14 00:27, Steve Spence wrote:
> On 4/18/2014 12:21 AM, John R Pierce wrote:
>>
>> personal opinion:
>>
>> I don't think a terminal device like a PC or an embedded system should
>> be talking directly to SQL at all.   instead, they should be talking
>> to an application server which implements the "business logic", and
>> THAT talks to the database.
>>
>>
>>
>>
> When all we need to do is log sensor values, there's no business logic
> needed. It's scientific data collection, and direct to SQL works very
> nicely. It's fast and clean.

In that case you should be sending messages to a message bus or queue.

The bus/queue receiver will then push the data into the database or
whatever downstream system.


Jan


--
Jan Wieck
Senior Software Engineer
http://slony.info


pgsql-general by date:

Previous
From: Jan Wieck
Date:
Subject: Re: Arduino SQL Connector
Next
From: Gavin Flower
Date:
Subject: Re: Arduino SQL Connector