-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

raf wrote:
>> printing error messages to stderr rather than ignoring
>> them shoulden't require an overhaul.

It does though.  You need to fix every place where an error can be
detected and take an appropriate action.  One extra printf is not the
entire solution.

>>> If you are only getting busy errors
>>> then try the .timeout command with a nice large value such as 15000.
> 
>> but that's my point.
>> i'm not getting any errors.
>> it's just failing silently.

Ok, if the shell internally is getting busy errors (and doing nothing
about it) then setting the timeout should help.  I suspect that setting
the timeout will make your problem go away, especially if it has a large
value.

>>> You may want to consider writing your own dump command that works
>>> exactly the way you want.  If you are generating textual output then you
>>> basically just call sqlite3_exec as appropriate.
> 
>> that seems like a waste of effort when there is already
>> a dump command in sqlite3. 

The point is that you can format the output exactly how you want
(quoting rules, handling of nulls) and error handling.  You can also
make the abort handle the way you want should some data already be
printed.  For example a non-zero exit may be sufficient, or you may want
to flush the output, emit a rollback command, and then have a non-zero exit.

>> i would much rather add some
>> print statements to sqlite3 itself so that others could
>> benefit as well.

That is fine too :-)

>> would a patch to do this be likely to be accepted?

DRH would need to chime in on that.  Generally patches are accepted
provided they don't break existing code (ie other people using SQLite),
benefit the majority of users and don't have a high cost (memory, CPU,
code maintenance etc).

You will also need to follow "Contributed Code" at
http://www.sqlite.org/copyright.html

Roger
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)

iEYEARECAAYFAkkVKOYACgkQmOOfHg372QTWFgCfSaABW/A9YE9jTijF016xs4Yq
FAkAoJDEalsAaKQFnDu7RX8YCtrpWjC2
=z/8f
-----END PGP SIGNATURE-----
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to