Reading from Standard In/Writing to Standard Out? (on Solaris)

[Walter Vaughan]

/* I meant to send this this morning. Tim's made progress, but the topic
    is still valid */

Tim Fischer wrote:
> 2) I need to be able to update in FilePro as well as in mysql (mostly web).
> Therefore, this needs to be on a record by record basis.

Actually this may be possible today with postgreSQL.

<quoted>
You can run shell commands in server functions via untrusted procedural 
languages such as perlpu and also plsh. In perlpu you could do the 
following:

	create or replace function do_readpipe(text) returns text as '
	        my $command = shift;
	        return `$command`;
	'
	language 'plperlu';
	
	create or replace function do_shell(text) returns int as '
	        my $command = shift;
	        return system $command;
	'
	language 'plperlu';

In plsh, the functions would be similar, for example:

	create or replace function do_shell (text) returns text as '
		return ` $1 `;
	' language 'plsh';
</quoted>

If you can move from MySQL to PostgreSQL, and host it your Solaris box,
then you might be able to run filepro each time a record changes on the
PostgreSQL database.

Hum.

MySQL is years away from supporting triggers and stored procedures
at the level that postgreSQL does today. Or perhaps there could be
a patch applied to MySQL 5.1 that would be friendly to do things
like this.

Hum.

This is interesting.

--
Walter