‹ BackHN Continuity

Thread

We need to stop using Stored Procedures

17 points · 32 comments · snikolaev

  1. calvinmorrison · · focus · HN ↗
    I am uneasy about databases being used in general how they are today. Nobody writes SQL to read and write records directly. it's all pumped through business logic. Then you write a stored procedure to update x-on-y and the business logic breaks, in a scenario that is impossible for the business logic to produce.

    additionally the logic is very far away from the data in many cases, obfuscated through layers of data modelling.

    If there was a way to bring these closer, that would be nice.

Open on Hacker News to reply ↗

Unofficial Hacker News client; not affiliated with Y Combinator.