2 ms·
Besides giving the world a great piece of tech, Hipp seems to be such a great, levelheaded guy too. SQLite was my gateway drug to data analysis, because I didn
by isoprophlex 2y ago
Besides giving the world a great piece of tech, Hipp seems to be such a great, levelheaded guy too.
SQLite was my gateway drug to data analysis, because I didn't know any better I just started using that for automated tasks that were done in excel up to that point. It was the basis of my career in data, after I decided to get out of academia.
Anyway.
I've recently built a SQLite extension that bakes Lua into SQLite. You can do
SELECT lua('return some_business_logic(...)', col1, col2 FROM some_table;
It's very much a V0.01 alpha thing, but it's feasible.
The idea allows running complex business logic directly inside the SQLite process. This all for speed and efficiency as you don't schlep data in and out of your language calling SQLite, and for better testability as it seems the sweet spot in terms of decoupling business logic from the query writing.
I've been at it on my own too much, I can't really reason about it anymore.
So, dear HN, is this idea completely idiotic or am I onto something that the world would benefit from?
- thunderbong 2y agoI personally think it's a fantastic idea. Please share it with world. I'm sure the HN crowd will appreciate it. But overall, anything that gets SQLite to be adopted more is a win in my view.
- isoprophlex 2y agoYour comment means a lot to me, thanks! I'll polish up the turd, build some ready-to-go extension people can download from github instead of having to compile their own, and submit a Show HN. Stay tuned!
- tazu 2y agoDefinitely release it! I had the same idea for embedding AWK into SQLite, but haven't gotten around to it.