Hacker News new | ask | show | jobs
by kreelman 57 days ago
This is great!! .....

But I'd love it if it could run in SQLite3. The stored functions and procedures here are neat, but I wonder if they could be turned into views and combinations of built in functions...

I think triggers can do nearly everything that a stored procedure does, perhaps with a little bit more fiddling. I sometimes make "parameter tables" where I insert all the necessary data and a trigger does what effectively a stored proc does.

Maybe there'd need to be a few imported functions? I wonder if an AI could be persuaded...