[freetds] [ freetds-Patches-1746864 ] new -w option for bsqldb(1)

James K. Lowden jklowden at freetds.org
Fri Dec 28 14:50:30 EST 2007


SourceForge.net wrote:
... 
> -w n   This option instructs bsqldb(1) to pause or wait
>        for n seconds between each request (or GO). This
>        option allows developers to send a batch of
>        requests to a server but pause for each request,
>        perhaps to monitor the wire protocol or examine
>        ends of the communication.
...
> >Comment By: Frediano Ziglio (freddy77)
> Date: 2007-12-28 15:56
...
> The only problem I see is that /dev/tty is not so portable... at least
> not work under windows...

Much as I like getting patches, I have my own doubts about the value of
this idea.  It seems to me it's easier and more flexible to do something
like this:

	while read L
	do 
		if [ "$L"  = 'go' ] 
		then  
			echo take your time >&2
			sleep 5
		fi
		echo $L
	done < input.sql \
	| bsqldb -S ....

We could add a "delayed_cat"[1] script or something to the samples that
does that, so you could do:

	delayed_cat -w 5 input.sql | bsqldb -S ....

That would be more of a unix tools approach.  It would work with any SQL
utility, and it could do everything (and more) that a go-slow mode in
bsqldb could do.  

Medi, you're the one who came up with this.  What do you say?  

--jkl

[1] alternative names: sloth, snail, bus, kitten.  



More information about the FreeTDS mailing list