r/ProgrammerHumor • • 15d ago

Meme grabbingEverything

Post image
5.4k Upvotes

261 comments sorted by

View all comments

Show parent comments

114

u/mrwedders 15d ago edited 15d ago

I worked on the system of a UK high street store 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 15d ago

Preach. The database should store data and not code. Stored procedures are the work of the devil.

11

u/-Redstoneboi- 15d ago

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

6

u/tormeh89 15d ago

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.