Last week I came across a Twitter thread about using stored procedures or in other words, user defined functions in databases. Every myth about them has already been debunked like 13 years ago in this excellent post: Mythbusters: Stored Procedures Edition. I can completely get behind it, but also like some personal thoughts and share […]
This is the second post in the series of From relational databases to databases with relations. Check the link to find all the other entries, too. The source code for everything, including the relational dataset is on GitHub: https://github.com/michael-simons/bootiful-music.The post has also been featured in This Week in Neo4j. To feel comfortable in a talk, […]
In the summer of 2018, I joined Neo4j. This seems odd at first, my “love” for relational databases and SQL is known. I didn’t have this slide in my jOOQ presentation for two years now without reason. But: Looking at the jOOQ and SQL talks from the perspective of early 2000s, they also seemed odd […]
Ich komme immer wieder durcheinander, wenn ich die ER Notation vom Oracle Case (“Krähenfüsse”) in die Min/Max Notation anderer Tools “umrechnen” muss. Bin da auf ein ausführliches PDF der Uni Gießen gestoßen, dass nebenbei auch noch mal ausführlich alle sinnvollen Relationen auflistet: Oracle Designer I: ER-Diagrams