The website is not a dating site for developers. It’s neither a tale about SQL tables which fell in love. It’s all about the different types of SQL relationships between rows stored in SQL databases. They are quite easy to master. Once you get the idea and learn some basic strategies, it’s easy to implement each of them in real life projects. And believe me, they really make it easier to design databases which are maintainable in the long term.
Our goal is it to provide a useful resource for SQL developers which shows you everything you need to know about SQL relationships and how to handle them:
- different types of relationships
- examples for all relationships
- visualization of each relationship
- strategies that are used to implement relationships
We love MySQL and use it for the examples shown here. But the concepts and strategies can be implemented using every SQL database out there.