Re:Everything I know about good system design
by bencornia on Saturday August 16, 2025 @12:12PM
(#44924692)
Views are great. Stored procedures are cursed.
[ Parent
| on HN ]
Re:Everything I know about good system design
by 0xDEAFBEAD on Sunday August 17, 2025 @05:13AM
(#44930100)
>Stored procedures are cursed.
Elaborate?
Re:Everything I know about good system design
by bencornia on Tuesday August 19, 2025 @10:55AM
(#44952286)
Stored procedures make sense if you are trying to make your backend less chatty with the database. The downsides are that they aren't version controlled. PLSQL and its variants can be inscrutable and difficult to debug. I guess you just have to decide what tradeoffs you are willing to make in your application. For me stored procedures take too much discipline for any potential upside. Sure you might have a wizard on your team that has it all in their head. But once they are gone it becomes a tar pit.
Re:Everything I know about good system design
by 0xDEAFBEAD on Tuesday August 19, 2025 @07:11PM
(#44957108)
Thanks!