direct access database vs web service [closed]

by

Direct database access couples you tightly to the schema. Any changes on either end affects the other. But it’s got the virtues of being simple and requiring one less network hop.

A web service means better abstraction and looser coupling via one additional level of indirection. A web service can act as the single steward of the data. You’ll get away with going directly against the database when it’s just your app, but if other apps come along and require the same data you’ll increase the chances that they’ll need schema changes some day. Those changes will affect your app as well. The cost is more latency.

A web service can be a good place to centralize authorization and security. A database can do this as well, so perhaps it’s a wash.

More Related Contents:

  1. Is storing a delimited list in a database column really that bad?
  2. Best way to store password in database [closed]
  3. What’s the Hi/Lo algorithm?
  4. Keep PostgreSQL from sometimes choosing a bad query plan
  5. In Firebase, is there a way to get the number of children of a node without loading all the node data?
  6. Advantages and disadvantages of GUID / UUID database keys
  7. Why should you use an ORM? [closed]
  8. Error in contrasts when defining a linear model in R
  9. Local Sql database support for Windows phone 7 [closed]
  10. Calculate distance between Zip Codes… AND users.
  11. PostgreSQL: Drop PostgreSQL database through command line [closed]
  12. Are foreign keys really necessary in a database design?
  13. GUID vs INT IDENTITY [duplicate]
  14. What is a sequence (Database)? When would we need it?
  15. Database optimization orders
  16. What is database pooling?
  17. In what way does denormalization improve database performance?
  18. Storing a small number of images: blob or fs?
  19. have address columns in each table or an address table that is referenced by the other tables?
  20. Minimum no of tables that exists after decomposing relation R into 1NF?
  21. How to unit test an object with database queries
  22. Populate Android Database From CSV file?
  23. Creating test data in a database [closed]
  24. When we need to use 1-to-1 relationship in database design?
  25. Adding a new value to an existing ENUM Type
  26. What’s the better database design: more tables or more columns?
  27. Should OLAP databases be denormalized for read performance? [closed]
  28. How can I import a .sql file into my Heroku postgres database?
  29. Predict next auto-inserted row id (SQLite)
  30. Best beginner resources for understanding the EAV database model? [closed]

Leave a Comment