Interesting, that's a requirement for an out of band tailing tool.
Maybe a user defined function bound to an INSERT trigger. But I believe that functions are also connection specific which is fine for the tail tool, but what happens when the user defined function connection goes away.
Write a program using
https://www.sqlite.org/c3ref/update_hook.html
On a PDP-11, run this program via telnet, rsh, or rexec.
If you're more ambitious, porting SQLite to 2.11BSD would be a fun exercise.
Update hook doesn't trigger if the write happened from a different process.
Interesting, that's a requirement for an out of band tailing tool.
Maybe a user defined function bound to an INSERT trigger. But I believe that functions are also connection specific which is fine for the tail tool, but what happens when the user defined function connection goes away.
1 reply →
`watch -n 5 sqlite3 logs.db "select log from logs" | grep whatever`
Just what I wanted, additional overhead and a five-second delay.