|
|
|
|
|
|
by Akronymus
917 days ago
|
|
|
> If you operate at the scale where you consider the performance implications of foreign keys, you probably are not ok with anyone accessing the database or running just any query against it. I used to work on an application where ALL database accesses were via stored procedures. Genuinly the best dev experience, to me, so far. |
|
|
I found such an environment to be simply terrible.
In general, I think stored procs certainly have their place, but if ALL access is through stored procs, you better have a schema that’s basically set in stone otherwise dev will turn into a nightmare.