| From: | Jan Wieck <jan(at)wi3ck(dot)info> |
|---|---|
| To: | Steve Spence <greentrust(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Arduino SQL Connector |
| Date: | 2014-04-18 04:35:58 |
| Message-ID: | 5350ABAE.5060801@wi3ck.info |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gavin Flower | 2014-04-18 05:04:53 | Re: Arduino SQL Connector |
| Previous Message | Jan Wieck | 2014-04-18 04:33:23 | Re: Arduino SQL Connector |