architectureresponsibility

Multipart application responsibility for database


I have a project consisting of a webapplication, a database and a program running in the background which processes rows created by the webapp. Both the programs work with the database and store their needed info (with tables both applications use).

To make the situation a bit clearer lets say I have a database (used by my applications exclusive) containing three Tables A, B and C.

You can think of the whole project this way:

  1. User places an order throu the webapp
  2. The webapp stores the order in the database
  3. The other program accesses the database and processes the order
  4. If errors occured during the processing these are stored in the database as well

That raises the following questions:

Some info on the side: DBMS is 9.3, webapp is using and accessing the database throu (currently managing the database using evolutions), and the other program is written in scala and acesses the database using .


Solution

  • Since nobody is providing a better solution I decided to manage the DB by hand as the structure of the database shouldn't change after my application goes live.