pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedSQL to PLC to diverter gate, can this be done?
2+ messages / 2 participants
[nested] [flat]
* SQL to PLC to diverter gate, can this be done?
@ 2003-11-07 03:31 Razorbak71 <razorbak71@yahoo.com>
2003-11-07 13:47 ` Re: SQL to PLC to diverter gate, can this be done? Christopher Browne <cbbrowne@acm.org>
0 siblings, 1 reply; 2+ messages in thread
From: razorbak71@yahoo.com @ 2003-11-07 03:31 UTC (permalink / raw)
To: pgsql-sql
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.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: SQL to PLC to diverter gate, can this be done?
2003-11-07 03:31 SQL to PLC to diverter gate, can this be done? Razorbak71 <razorbak71@yahoo.com>
@ 2003-11-07 13:47 ` Christopher Browne <cbbrowne@acm.org>
0 siblings, 0 replies; 2+ messages in thread
From: Christopher Browne @ 2003-11-07 13:47 UTC (permalink / raw)
To: pgsql-sql
Centuries ago, Nostradamus foresaw when razorbak71@yahoo.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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2003-11-07 13:47 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-11-07 03:31 SQL to PLC to diverter gate, can this be done? Razorbak71 <razorbak71@yahoo.com>
2003-11-07 13:47 ` Christopher Browne <cbbrowne@acm.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox