Rafael Pérez 🌱Mar 24

Software developer Petar Ivanov from the T-Shaped Dev blog shares a checklist of things one should go through mentally while working on a new database design, and when tuning a database due to performance issues.

"Database Design Doesn't Start With Table. It Starts With Consequences"

https://thetshaped.dev/p/database-design-foundations-backend-engineers-mistakes-and-lessons

#programming #sql #postgresql #databasedesign

Show threadurigMar 24
And not a word about Entity Relationship Modeling? 🤔
Show threadgovinda hari dasa
@urig There is a lot missing there. I suppose they didn't want to write a long essay.
And it's one thing to talk about ''should'', but having executive management that has some understanding of the need for the ''should'' is a whole 'nother story.
Mar 25 at 12:26amWeb
Show threadRafael Pérez 🌱Mar 25
@govinda_hari @urig I agree it's not an exhaustive checklist.
Show threadurigMar 25
@rperezrosario @govinda_hari it's fine. For me ERM is a basic skill that come before quite a few of the techniques mentioned, but opinions may differ I suppose.
Show threadRafael Pérez 🌱Mar 25
@urig @govinda_hari I agree. ERM just comes as second nature after a while.