Vertabelo Blog

Learn how to design and use database models
 
 
RSS
 
 
 
 
 
New SQL Course! Learn how to process trees and graphs in SQL, and how to effectively organize long SQL queries. View course Discover our other courses:
 
Lukas Eder 19th Jan 2016

We’ve had tremendously positive feedback on my recent article that talked about the awesomeness of SQL. However, not everyone agreed to the Fallacy #5: The database is the wrong place for business logic. Why is this such a controversial topic? In what situations is the database the right place, and in what situations isn’t it the right place for such logic?

 
Lukas Eder, Data Geekery GmbH 6th Oct 2015

The following fallacies are things that I hear all the time: “SQL is legacy. Why can’t we work with more modern tech?”, or “SQL is low level, like assembler. Would you prefer to work with assembler or with Java? Similarly, would you prefer to work with SQL or with Hibernate?” It’s time we move on and realize that with SQL, we can be incredibly productive and write awesome data logic in only a few lines of code.