4 ms·
What? So you think Java is not expressive enough for business logic, and you think it's better to move that logic to PLSQL? Seriously? Java may not be the best
by escoz 15y ago
What? So you think Java is not expressive enough for business logic, and you think it's better to move that logic to PLSQL? Seriously?
Java may not be the best language for some things, and that's why you use DSLs, but moving that to the place you store the data is probably the worst thing you can do 99% of the time.
- Ingaz 15y agoYes. Business logic as far as possible must be expressed in declarative way. Java have very poor facilities for declarative programming. SQL (not PL/SQL) on other side - is pure declarative language. It's already powerful DSL if you master it. And yes, I agree with you, that writing logic in PL/SQL (as in imperative language) is equally terrible as writing it in Java.
- escoz 15y agoOmg.. this is getting worse. SQL is a DSL to deal with sets of data. Unless the application you're writing is a database management app, you're pretty much doing it really wrong, I'm sorry to tell you that.
- Ingaz 15y ago>>SQL is a DSL to deal with sets of data What's wrong with this? Can you imagine process of billing campaign? Than try it in Hibernated database and in raw SQL. Pure SQL will be thousands times faster. ORMs are good only for smth like Django Admin