php - Pros and Cons of using API instead of direct DB Access -

-

i found myself in several discussions throughout week regarding web application under development , whether should leverage api being created.

here's situation. have php mvc web application mysql db several mobile apps being developed in house. mobile apps we're building rest api. big question why should php web application use rest api? i've expected use of api third party systems need interface database or systems built on different technology. web app not third party system , services in php. if api on different server web app guess considered third party system... has not been decided yet.

to me, seems strange leverage api web app since apis services going limited 50% of functions available in web app leaving me build other 50% unique web app. foresee performance hit web app stepping through service layer rather accessing db directly. on other side see more maintenance having code base web app hitting db , similar functions built api mobile apps.

has found in similar situation , can provide technical pros , cons why should use api or can point me solid case study?

pros:

  • what if 1 day decide move backend app machine? with api, app code won't need change.
  • what if 1 day grow, , need scale 10000 backend apps instead of 1? with api, app code won't need change.
  • what if 1 day decide swap out mysql mongo? with api, app code won't need change.
  • ^ enforced separation of concerns between data access layer (db) , application

cons:

  • more code front when writing app layer
  • more incremental work when need support new app layer feature api doesn't support yet

to me, pros win.


Comments

Post a Comment

Popular posts from this blog

html - Styling progress bar with inline style -

-
i trying set progress bar color red using inline style. need in way because have access <body> part of document. style need apply: progress { color: red } progress::-moz-progress-bar { background: red;} progress::-webkit-progress-value { background: red; } progress[aria-valuenow]:before { background: red; } i tried <progress style="background: red;"> incorrect effect, progress bar color turns blue red background. guide right direction desired style? thank in advance. here live example: https://jsfiddle.net/z36d3f6l/
Read more

java - Oracle Sql developer error: could not install some modules -

-
i have downloaded fresh copy of sqldeveloper ( sqldeveloper-4.1.3.20.78-no-jre ) oracle website. when unzip , lauch gui, keep getting following error message: warning - not install modules: dynamic module config - no module providing capability org.netbeans.netbinox found. my system: windows 7 32 bit hp probook. jdk 1.6 , 1.7, 1.8 available in java/jdk subdirectory. netbeans 8.0.2 installed finally got way out after dirty hours. extracted sqldeveloper zip in nested directory. i.e: e://a/b/c/sqldeveloper. starting sqldeveloper gui above directory threw erros. solution: go in c:\users**username**\appdata\roaming : delete sql developer , sqldeveloper folders extract sql developer zip in new non nested directory. i.e: e:// start , should work now reference: https://community.oracle.com/thread/3870680?start=0&tstart=0
Read more

How to use autoclose brackets in Jupyter notebook? -

-
this may sound silly question, how make use of autoclose brackets in jupyter notebook? example, when type print( jupyter notebook auto-closes brakets print() and places cursor inside. type argument, say print(1 + 1) now cursor between second 1 , right bracket ) . key navigate right of ) ? of course can press end or → or ) achieve this, not seem save time, purpose of brackets autoclose suppose? thanks in advance.
Read more