FreeTDS Development Group

["James K. Lowden" <jklowden AT freetds.org>]

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.