3 ms·
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 ove
by gregw2 12d ago
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.
- joeblubaugh 9d agoBesides CI, what benefits were you getting from writing the logic as a stored procedure?
- murphomatic 9d agoI 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?
- mgkimsal 8d agoI haven't looked in to this in ... decades, but I seem to remember stored procs executed measurably faster 20+ years ago. That was one reason a project I was on pushed them. And the benchmarks they showed... it wasn't unreasonable. But we have faster networks, more memory, ssd, etc - I'm unsure if speed is a big reason any more. IIRC cached execution plans was a big win back then, but may not be as a win today. I'm thinking about sybase and mssql from the late 90s when I was first getting in to this topic. But... over the years, I've seen push to sprocs where the logic was never version controlled or subject to the same level of testing the regular app source code was. The DBA folks had total control and were treated as a separate class of engineer than mere 'app' engineers, which caused all sorts of problems...