Dungeons & Data: Bestiary of Antipatterns and How to Defeat Them

on YouTube ↗28m

" summary

Covers common SQL database antipatterns, schema and table design challenges that cause performance, scalability and data integrity issues, and presents concrete tools, patterns and practical advice to avoid and fix those problems. Targets developers with basic SQL knowledge and focuses on pragmatic design improvements rather than big data topics.

AI-written summary · about

" chapters (9)

1. 0:00Welcome
2. 1:04Data and antipatterns intro
3. 6:24Container horror antipattern
4. 8:10Goblin admin antipattern
5. 10:58Lottery table antipattern
6. 13:43JWalking antipattern
7. 17:58Anti-pattern magic tricks
8. 21:29Databases as code
9. 22:31Q&A and final thoughts

" related talks

• 51mThe Lost Art of Database DesignMatt Yonkovit · Percona Community Live 2022
• 48mThe DB tamerIlya, Fedor Sazonovy · JPoint 2024
• 45mBest Practices for Optimizing Database ProjectsVinicius Coimbra · DevDay 2018
• 37mSpring Data JPA: Testing Antipatterns and Database Test RecipesSemen Kirekov · TestDriven Conf 2022
• 28mMongoDB Patterns and Anti-PatternsJoe Karlsson, Lauren Schaefer · ConFoo 2021
• 17mTop 10 transactional database mistakes, and how to avoid themAaron Felton, Rae Ellingham · SQLBits 2024
• 01h 02mDesign Good Schemas - Get a Better DatabaseNuri Halperin · NDC Oslo 2023
• 01h 00mWhen SQL Server Best Practices Don’t WorkDenys Reznyk · .NET Fest 2019