2 ms·
Agreed on all points. I'd also add that I miss table-valued functions in sqlite.
by names_are_hard 5y ago
Agreed on all points. I'd also add that I miss table-valued functions in sqlite.
- DemocracyFTW 5y agoyou can write your own table-valued, aggregate and window functions when you use better-sqlite3 (see https://github.com/JoshuaWise/better-sqlite3/blob/master/docs/api.md; https://github.com/JoshuaWise/better-sqlite3/blob/master/doc... see Database#function(), Database#aggregate(), Database#table()) in JavaScript.
- names_are_hard 5y agoThis is really cool, thanks for pointing me to that. I'm still probably going to migrate to postgres because I'd like the functions to exist in the db and not just in code, so I can use them in ad-hoc queries. But this is worth considering as an option.