Hacker News new | ask | show | jobs
by jasomill 693 days 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.

1 comments

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.