Geek Answers Handbook

MySQL / PHP / Java / AngularJS Application Architecture

Introduction: We are redesigning our application architecture, and we are going to make import design decisions.

Background and dependencies: All data is stored in distributed MySQL databases. We have two systems that access databases that perform common tasks programmed in Java and our web application - currently Apache2, PHP (Zend1 framework) and JavaScript (jQuery).
The Java application will not be modified, and the database must remain MySQL.
It is assumed that the web application will be changed to a REST API and a modern, fast, real-time AngularJS interface that communicates via JSON.
Since we have already programmed all the backend functionality in PHP, it probably makes sense to stick with PHP for the REST API, but this is not necessary if it will make future development easier, faster, and more reliable. The Java application and the web application have several MySQL queries.

Questions:

  • General MySQL queries: Should we implement them as a) MySQL procedures / views, b) separately in Java and PHP, c) an independent service (for example, another REST API)
  • Should we stick with Zend1 or, rather, use a more appropriate PHP REST framework (like Slim or Restler or something else)?
  • Should we stick with Apache2 / PHP for the REST API in general (maybe use Node.js instead)?

Thank!

+4
1

, , ... ...

. , , , .

, .

,

+7

More articles:


All Articles