Tag: sql
There are some in our industry who can read a schema and instantly see the joins. They dream in sets, write SQL queries routinely and reach for window functions without hesitation. And a...
Why is the IT industry obsessed with decoupling? Does breaking systems into smaller parts you can understand individually really make them easier to manage and scale? Today, we the of...
In my previous post - I introduced the idea that you can think of database queries as a series of loops. Let me take this ideas even further - introducing more complex database concepts in...
When designing database schemas, you may find yourself needing to create a property bag table that is in a 1-n relationship with an entity table. It isn't always viable to just add more a...