Re:In Praise of PostgreSQL
by DemocracyFTW on Thursday August 05, 2021 @06:47PM
(#28081056)
you can write your own table-valued, aggregate and window functions when you use better-sqlite3 (see https://github.com/JoshuaWise/better-sqlite3/blob/master/doc... see Database#function(), Database#aggregate(), Database#table()) in JavaScript.
[ Parent
| on HN ]
Re:In Praise of PostgreSQL
by names_are_hard on Thursday August 12, 2021 @03:47PM
(#28160620)
This 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.