Episode 245 ENUMs vs Check Constraints, Faceting With Roaring Bitmaps, Better Scaling, In DB Business Logic

<p>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.</p> <p>Subscribe at https://www.scalingpostgres.com to get notified of new episodes.</p> <p>Links for this episode:</p> <ul> <li><a href= "https://www.crunchydata.com/blog/enums-vs-check-constraints-in-postgres"> https://www.crunchydata.com/blog/enums-vs-check-constraints-in-postgres</a></li> <li><a href= "https://www.cybertec-postgresql.com/en/faceting-large-result-sets/"> https://www.cybertec-postgresql.com/en/faceting-large-result-sets/</a></li> <li><a href= "https://github.com/cybertec-postgresql/pgfaceting">https://github.com/cybertec-postgresql/pgfaceting</a></li> <li><a href= "https://pganalyze.com/blog/5mins-postgres-roaring-bitmaps-pgfaceting-query-performance"> https://pganalyze.com/blog/5mins-postgres-roaring-bitmaps-pgfaceting-query-performance</a></li> <li><a href= "https://thenewstack.io/iso-better-scaling-instacart-drops-postgres-for-amazon-dynamodb/"> https://thenewstack.io/iso-better-scaling-instacart-drops-postgres-for-amazon-dynamodb/</a></li> <li><a href= "https://www.rubberduckdevshow.com/episodes/68-should-you-store-business-logic-in-your-database/"> https://www.rubberduckdevshow.com/episodes/68-should-you-store-business-logic-in-your-database/</a></li> <li><a href= "https://www.ongres.com/blog/debugging-postgres-wal-events-with-pg_walinspect/"> https://www.ongres.com/blog/debugging-postgres-wal-events-with-pg_walinspect/</a></li> <li><a href= "https://kmoppel.github.io/2022-12-09-the-bountiful-world-of-postgres-indexing-options/"> https://kmoppel.github.io/2022-12-09-the-bountiful-world-of-postgres-indexing-options/</a></li> <li><a href= "https://andreas.scherbaum.la/blog/archives/1125-PGSQL-Phriday-003-What-is-the-PostgreSQL-Community-to-me.html"> https://andreas.scherbaum.la/blog/archives/1125-PGSQL-Phriday-003-What-is-the-PostgreSQL-Community-to-me.html</a></li> <li><a href=