OpenMRS should support PostgreSQL
- Mentors
- Daniel Kayiwa, Juliet Wamalwa
- Organization
- OpenMRS
PostgreSQL is an object-relational database management system (ORDBMS), unlike MySQL which is a Relational Database Management System(RDBMS). It is easy to setup and install and offers support for both SQL and NoSQL. While there are pros and cons of both of these database management systems, it ultimately boils down to your requirements.
Why use PostgreSQL for OpenMRS?
As stated in the project description there are a large number of implementations who would like using PostgreSQL instead of MySQL. There is also another category who have already invested in PostgreSQL servers, where requiring them to install and learn another type of database server would not only be an unnecessary waste of their time, but also a wastage of computer resource.