-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 09/26/2011 10:48 PM, Patrick Proniewski wrote: > but it won't work, because sqlite3 won't record any data until the iostat > command ends.
UNIX tools using the standard I/O library will show this. They detect that standard output is not a terminal and buffer up output. The buffer is likely to be 4 or 8kb. The buffer will be flushed each time it fills up. The SQLite's shell standard input is likely to be doing the same thing, as is awk. Some explanation here: http://www.pixelbeat.org/programming/stdio_buffering/ The easiest solution is to just be patient and accept the data will be a little delayed. Other solutions involve various helper programs such as using a pty so that the programs think they are using terminals: http://stackoverflow.com/questions/1000674/turn-off-buffering-in-pipe Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) iEYEARECAAYFAk6Ba3MACgkQmOOfHg372QTtygCePyL0cN/qdIowaXzAQp/YtOEA v0QAmgMr7ZXRWqaejJW3W5JYKLVwYkhb =r87o -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users