Design Good Schemas - Get a Better Database

Discover how to design effective table schemas for relational databases in this NDC Oslo 2023 conference talk. Learn why proper schema design is crucial for application performance and maintainability, especially in CI/CD environments. Explore the concept of adopting a relational mentality, covering aspects of modeling, mapping models to tables, and delving into data types and fields. Gain insights on fitness criteria, the differences between models and schemas, and the impact of changes. Address common pitfalls such as over-normalization, improper use of indexes, and relying solely on ORMs. Examine practical examples, including catalog item scenarios, and learn techniques to fix data types, handle denormalization, and implement effective primary keys. Understand the importance of migration scripts and adhering to best practices in database design for improved application flexibility and performance.