5 ms·

Security, decoupling calling code from db schema

• tracker1 7y ago
  Don't API services do that?
  • qaq 7y ago
    How do they do that in the context of ORM vs sps :)?
    • tracker1 7y ago
      Calling code is the front end... API services separate that calling code from the backend.
      • qaq 7y ago
        your backend is still storing data somewhere right?
        • tracker1 7y ago
          Yes, but I'm not sure I get the benefit of decoupling the schema, I'm still coupling to the stored procedure interfaces, and still have to deal with the shape of input and results.
          • qaq 7y ago
            If schema needs to be changed in many cases sp interface will stay the same e.g. I can do changes/optimizations to schema without changing the calling code.
            • tracker1 7y ago
              But, if it's a schema change where you have to update the SP, you still have to change code... it's that the code is in (PL/T)SQL vs in another language.. You still have to update code either way.