Re:Squeeze the hell out of the system you have
by porridgeandrice on Saturday August 12, 2023 @12:23AM
(#37097032)
Yeah, I like doing this too. Not _always_, but for a few things. I use it to emulate partial functions.
In a show hosting/ticket booking app for example, I never want in any case user facing search/by-id endpoints to serve a show from 2 months ago. So I create a view `select * from shows where time > now`. I can now use this as a 'table' and apply more filters and joins to this if I wish.
In a show hosting/ticket booking app for example, I never want in any case user facing search/by-id endpoints to serve a show from 2 months ago. So I create a view `select * from shows where time > now`. I can now use this as a 'table' and apply more filters and joins to this if I wish.