Comment by jasomill
2 years ago
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.
2 years ago
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.
Nope. Triggers and user defined functions don't help across processes either.