3 ms·
Um, PL/PGSQL and et al for stored procedures exist, OOP is optional.
by Avamander 7y ago
Um, PL/PGSQL and et al for stored procedures exist, OOP is optional.
- revscat 7y agoSo? Stored procedures suck. There are good reasons they have never seen serious traction and are infrequently used to the point of being irrelevant.
- jevgeni 7y agoMajor international banks have entire payment systems implemented in PL/SQL. I’m talking 2-3kloc procedures and thousands of them.
- Avamander 7y agoThat'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.
- mannykannot 7y agoOOP 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.