3 ms·
The out-of-the-box tooling for debugging, maintaining, versioning, and testing code that lives in your database is not nearly as robust as what you have for mos
by dantiberian 11y ago
The out-of-the-box tooling for debugging, maintaining, versioning, and testing code that lives in your database is not nearly as robust as what you have for most other development environments.
This is the key point for me. I've seen SQL databases with 60k+ LOC in stored procedures, and functions (thankfully they avoided triggers). This code wasn't versioned, tested, or commented. While it's technically true that you can test and version SQL code that lives inside a database, I've never seen it done.
This is mostly a tools issue, although its also partly a cultural issue, where 'stuff that goes in the database' isn't seen to be subject to the same laws of entropy and software development that all other code is.
- zamalek 11y ago> I've never seen it done. See my comment[1]. We're doing it and it works beautifully. [1]: https://news.ycombinator.com/item?id=9485502 https://news.ycombinator.com/item?id=9485502
- dantiberian 11y agoAwesome, I'd love to try working in an environment like this to see how it works and experience the tradeoffs.