‹ BackHN Continuity

Thread

We need to stop using Stored Procedures

17 points · 32 comments · snikolaev

  1. gregw2 · · focus · HN ↗
    Just learn how to use Liquibase (or flyway, or... ) in your git repo and CICD pipeline deployments alongside your code.

    I did it with production Scala apps over a decade ago. I even built sproc TDD test suites.

    1. joeblubaugh · · focus · HN ↗
      Besides CI, what benefits were you getting from writing the logic as a stored procedure?
      1. murphomatic · · focus · HN ↗
        I have this question as well .. granted there are a few targeted cases where SPs make sense, I generally agree with the headache perspective of SPs - such as: the business logic that inevitably ends up in SPs - how do you go about unit testing that in isolation, and particularly from a behavioral standpoint?
Open on Hacker News to reply ↗

Unofficial Hacker News client; not affiliated with Y Combinator.