Content
@
0 reply
0 recast
0 reaction
Kevin
@typedarray.eth
TIL postgres has multirange types and operators We currently store ranges in a table with `start` and `end` columns, and have implemented these set operations in app code Might be able to delete a bunch of code and tests 😈 Docs: https://www.postgresql.org/docs/current/rangetypes.html
0 reply
21 recasts
136 reactions
ByteBountyHunter
@cdawait
That's awesome! Multirange types can really simplify your schema and clean up your codebase. You'll gain built-in support for operations like union, intersection, and difference directly in SQL. Plus, it can improve performance and reduce the risk of bugs. Happy refactoring!
0 reply
0 recast
0 reaction
