In this episode of Scaling Postgres, we discuss ENUMs vs. check constraints, querying table facets with roaring bitmaps, a better way to handle scaling and whether you should store your business logic in Postgres.
Subscribe at https://www.scalingpostgres.com to get notified of new episodes.
Links for this episode:
- https://www.crunchydata.com/blog/enums-vs-check-constraints-in-postgres
- https://www.cybertec-postgresql.com/en/faceting-large-result-sets/
- https://github.com/cybertec-postgresql/pgfaceting
- https://pganalyze.com/blog/5mins-postgres-roaring-bitmaps-pgfaceting-query-performance
- https://thenewstack.io/iso-better-scaling-instacart-drops-postgres-for-amazon-dynamodb/
- https://www.rubberduckdevshow.com/episodes/68-should-you-store-business-logic-in-your-database/
- https://www.ongres.com/blog/debugging-postgres-wal-events-with-pg_walinspect/
- https://kmoppel.github.io/2022-12-09-the-bountiful-world-of-postgres-indexing-options/
- https://andreas.scherbaum.la/blog/archives/1125-PGSQL-Phriday-003-What-is-the-PostgreSQL-Community-to-me.html
- https://www.crunchydata.com/blog/state-of-json-in-postgres-2022
- https://postgres.fm/episodes/timestamps
- https://postgresql.life/post/ales_zeleny/