This is probably a language looking for a purpose before adding it to
the core.  Here's what I use it for; probably abusively too! Could use
untrusted perl to spawn system calls, but shell scripts are much nicer
for shell work not to mention transactional updates of structure and
control scripts make for minimall impact upgrade periods.

- On demand PDFs as generated by Docbook for offline reports initiated
by the database.  Ie.  Inventory updates to management every N sales
made or when stock is running low.
- Updating static HTML pages with Docbook HTML output when the stored
data changes.
- System provisioning initiation. Rollbacks don't work, but it's not
really important that things are undone immediatly, just that they're
initiated immediatly.  Using DB for this removes requirement of
middleware.

--
Rod Taylor

Your eyes are weary from staring at the CRT. You feel sleepy. Notice
how restful it is to watch the cursor blink. Close your eyes. The
opinions stated above are yours. You cannot imagine why you ever felt
otherwise.



Sat, 16 Mar 2002 11:56:05 -0500
"Rod Taylor" <rbt@zort.ca>
plsql as an officially supported language?

We have this in the TODO:

	o Add plsh server-side shell language (Peter E)

This is Peter's language that allows shell calls.  I think Peter wants
to add it for 7.3 and I think it is a good idea.

---------------------------------------------------------------------------

Rod Taylor wrote:
> This is probably a language looking for a purpose before adding it to
> the core.  Here's what I use it for; probably abusively too! Could use
> untrusted perl to spawn system calls, but shell scripts are much nicer
> for shell work not to mention transactional updates of structure and
> control scripts make for minimall impact upgrade periods.
> 
> - On demand PDFs as generated by Docbook for offline reports initiated
> by the database.  Ie.  Inventory updates to management every N sales
> made or when stock is running low.
> - Updating static HTML pages with Docbook HTML output when the stored
> data changes.
> - System provisioning initiation. Rollbacks don't work, but it's not
> really important that things are undone immediatly, just that they're
> initiated immediatly.  Using DB for this removes requirement of
> middleware.
> 
> --
> Rod Taylor
> 
> Your eyes are weary from staring at the CRT. You feel sleepy. Notice
> how restful it is to watch the cursor blink. Close your eyes. The
> opinions stated above are yours. You cannot imagine why you ever felt
> otherwise.
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
> 

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Mon, 18 Mar 2002 18:19:41 -0500 (EST)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: plsql as an officially supported language?