News for hackers. Stuff that matters.
Re:What ORMs have taught me: just learn SQL (2014) by Avamander on Friday September 20, 2019 @10:17PM (#21033081)
Um, PL/PGSQL and et al for stored procedures exist, OOP is optional.
Re:What ORMs have taught me: just learn SQL (2014) by mannykannot on Saturday September 21, 2019 @10:03AM (#21035434)
OOP is optional, but if your program has any concept of structured data, then, regardless of whether that structure can be expressed syntactically within the programming language, you will necessarily have a mapping between that and the database. It might be as simple as a 1:1 mapping between relations and ADTs, with collections of references being used within the program to represent the keyed relationships that exist within the database scheme.
Re:What ORMs have taught me: just learn SQL (2014) by revscat on Saturday September 21, 2019 @12:14AM (#21033473)
So? Stored procedures suck. There are good reasons they have never seen serious traction and are infrequently used to the point of being irrelevant.
Re:What ORMs have taught me: just learn SQL (2014) by jevgeni on Saturday September 21, 2019 @01:40AM (#21033707)
Major international banks have entire payment systems implemented in PL/SQL. I’m talking 2-3kloc procedures and thousands of them.
Re:What ORMs have taught me: just learn SQL (2014) by Avamander on Saturday September 21, 2019 @10:10AM (#21035470)
That's what you think not having any knowledge of them. Many of the best and huge systems I've seen have been implemented in stored procedures.