Stored procedures are one of those things that sound really good on paper and end up being...much less good.

Check out my Twitch, Twitter, Discord more at https://t3.gg

S/O Ph4se0n3 for the awesome edit 🙏

Denis Bolkovskis

Mental Health

Community Picks is a section on daily.dev where our community members share the most interesting and valuable content they've discovered online. From insightful articles to handy tools, every post is a gem curated by our dedicated coomunity. To contribute to Community Picks, you need to have at least 250 reputation points, ensuring that only active and trusted members can share their finds.

Community Picks

The post argues against putting functions in databases and discusses the negative consequences of doing so, including the concept of role security and its impact on API logic.

Please Stop Putting Functions In Your Database

I will never understand how people can just say “this one is good” … “this one is bad” … just because they don’t like it (and sometime it is sadly also because they do not understand it) …
Listen… there is no “bad pattern” … please.
A pattern exists to solve an issue according to a precise context; You have to choose the right one according to your business, your case, your need, your expertise … and that’s it …
If you really understand what you are doing, so you are using the right solution.
Please, there is no “bad pattern” … just bad engineers, bad habits and ideologies …