4 ms·
> it will tie you to a specific database. There are a lot of reasons not to use stored procedures heavily and I personally wouldn’t even work for a company th
by scarface74 4y ago
> it will tie you to a specific database.
There are a lot of reasons not to use stored procedures heavily and I personally wouldn’t even work for a company that did, this is a relatively poor one.
This is like all of the people who think using Terraform gives them “cloud agnosticism” even how you do limits and bulk sql is different between the major databases.
- remram 4y agoBeing database agnostic is so hard. I have an app that I test on Postgres, MariaDB and SQLite, I thought I was doing well. Nope, turns out it doesn't work with MySQL or MsSQL and would need a big schema change to support them (something about diamonds in the cascade relationships).