Re: SQL to PLC to diverter gate, can this be done?

From: Christopher Browne <cbbrowne(at)acm(dot)org>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: SQL to PLC to diverter gate, can this be done?
Date: 2003-11-07 13:47:45
Message-ID: m3ekwk2su6.fsf@wolfe.cbbrowne.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Centuries ago, Nostradamus foresaw when razorbak71(at)yahoo(dot)com (Razorbak71) would write:
> First, I know nothing about PLC's, but I was wondering is there a
> way to extract data from a SQL database file, feed that to a PLC is
> some manner, and then have the PLC trigger a diverter gate based on
> the value in the table exceeding a certain value, to divert parts to
> another location.
>
> Am I off base, or is there something out there that will allow or
> help me to do this. Any help would be greatly appreciated.

It all depends on how you are able to program the PLC. They tend to
have pretty proprietary tools that are very much dependent on the
vendor.

My little brother works for Omron, and does some pretty fancy things
with their PLCs. But since the languages Omron uses aren't the same
as are used with similar products from (say) Siemens, knowing one
platform doesn't necessarily help with the other. (They commonly use
languages resembling BASIC...)

I think you need to know a LOT more about the PLC system in question,
and that knowledge is not likely to be found here. What you want is
probably feasible in some sense, although it's likely to be rather
fiddly.

And your use of the term "SQL database file" suggests some confusion
on your part as to how the SQL side would work. While PostgreSQL
implements tables in files, you don't read data from the files, but
instead ask the "postmaster" to give it to you. You might need to
drop the data into a separate file outside the database in order to
get it into a form that the PLC can get at...
--
If this was helpful, <http://svcs.affero.net/rm.php?r=cbbrowne> rate me
http://www3.sympatico.ca/cbbrowne/linux.html
"Microsoft is a cross between the Borg and the Ferengi. Unfortunately,
they use Borg to do their marketing and Ferengi to do their
programming." -- Simon Slavin in asr

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message George A.J 2003-11-07 13:53:35 Re: DateDiff in PostgreSQL
Previous Message Tomasz Myrta 2003-11-07 13:47:25 Re: DateDiff in PostgreSQL