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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
