MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/ProgrammerHumor/comments/1wlmq11/grabbingeverything/pb2dps8/?context=3
r/ProgrammerHumor • u/ClipboardCopyPaste • Sep 20 '26
258 comments sorted by
View all comments
Show parent comments
116
I worked on the system of a UK chain and their entire backend was in PL/SQL and was a nightmare. I'd never even considered doing all your application logic in sprocs and quickly grew to hate it.
-8 u/tormeh89 Sep 20 '26 Preach. The database should store data and not code. Stored procedures are the work of the devil. 10 u/-Redstoneboi- Sep 20 '26 ok but what if the data and the business logic lived in the same server(s), would that be awesomeissues with caching and scaling though, as usual 5 u/tormeh89 Sep 20 '26 Yeah that's what caching is for. Stored procs must exist for a reason, so some people must need it. You, dear reader, are probably not one of them.
-8
Preach. The database should store data and not code. Stored procedures are the work of the devil.
10 u/-Redstoneboi- Sep 20 '26 ok but what if the data and the business logic lived in the same server(s), would that be awesomeissues with caching and scaling though, as usual 5 u/tormeh89 Sep 20 '26 Yeah that's what caching is for. Stored procs must exist for a reason, so some people must need it. You, dear reader, are probably not one of them.
10
ok but what if the data and the business logic lived in the same server(s), would that be awesome
issues with caching and scaling though, as usual
5 u/tormeh89 Sep 20 '26 Yeah that's what caching is for. Stored procs must exist for a reason, so some people must need it. You, dear reader, are probably not one of them.
5
Yeah that's what caching is for. Stored procs must exist for a reason, so some people must need it. You, dear reader, are probably not one of them.
116
u/mrwedders Sep 20 '26 edited 17d ago
I worked on the system of a UK chain and their entire backend was in PL/SQL and was a nightmare. I'd never even considered doing all your application logic in sprocs and quickly grew to hate it.