Database Modelization Anti-Patterns
Looks into three classic anti-patterns: the infamous EAV, using multiple values in a single column, and how using UUIDs might be an anti-pattern too.
Building On Solid Ground: Getting Postgres Foundations Right With pgbedrock
Managing user permissions in databases is hard. Developers can come and go. Other teams need to access the data for analytics and other purposes. This can quickly make permissions management a mess and no one dares to delete anything. Squarespace built a solution by syncing a YAML config to database permissions.
User-defined Order in SQL
This article looks into different way to implement user-defined order (such as a list of items where users can re-order them or insert new items).
The SaaS CTO Security Checklist
If you’re building a SaaS, look into this checklist. It’s designed to fit into many stages: seed, series A and post-series A.
That's it for this round, have a great day! If you like this newsletter, please tell the world, or
tweet about this