Thanks @angshuonline for the ideas.
What i actually plan to do is like your second idea.
That is to create a service that interacts directly with the database.
I need to provide a third-party payment collection system a rest json api that they can call to know the bill for a given patient and to update the patients record the amount paid.
So my plan was to generate a REST API for the ERP database and only expose the endpoints that are needed to retrieve a bill and update a bill.
PostgREST automatically generates a rest api for a postgre database but unfortunately it works for postgre version 9.3 and upwards.
This is why i asked if it was possible to upgrade the postgre from version 9.2 to 9.3.
I’m very new to Bahmni can you point me to links where i can get info on how to create an ERP module.
Will i be able to produce a REST API for the third-party to consume?
I don’t have control over the third-party and they may change their system whenever they wish.
So they just want me to give them rest api endpoints that they can use to get the bill of a patient and to update the patients bill with any amount that they collect.