GSoC 2020 - OpenMRS Should Support PostgreSQL - Final Presentation

aman · August 29, 2020, 7:50pm

Project Title : OpenMRS Should Run on PostgreSQL

Primary mentor: Daniel Kayiwa
Backup mentor: Juliet Wamalwa
Student: Aman Mishra
Project Wiki: https://wiki.openmrs.org/display/projects/GSoC+2020+%3A+OpenMRS+should+run+on+PostgreSQL

Overview

Before work started on this project, OpenMRS only offered MySQL as its compatible database system. The main aim of this project was to extend the database support to PostgreSQL as well. This majorly involves extending the PostgreSQL support to OpenMRS Platform which forms the basis of all the different api’s and services used by different OpenMRS modules. Then subsequently extend this support to different Reference Application modules and ultimately to Reference Application itself. This is going to be a major feature to be released in the next iterations of both OpenMRS Platform as well as OpenMRS Reference Application.

Objectives

Add PostgreSQL support for OpenMRS Platform — Done
Add PostgreSQL support for OpenMRS Reference Application — Done
Create a CI build which breaks when liquibase changesets fail to run on PostgreSQL — Done

Contributions

OpenMRS-Core

HTML Form Entry Module

Calculation Module

IDGen Module

App Framework Module

AF-65 : https://github.com/openmrs/openmrs-module-appframework/pull/53

Provider Management Module

Metadata Mapping Module

Metadata Sharing Module

META-374 : https://github.com/openmrs/openmrs-module-metadatasharing/pull/57

Reporting Module

Reference Metadata Module

RA-1799 : https://github.com/openmrs/openmrs-module-referencemetadata/pull/53

Reference Demodata Module

RA-1797 : https://github.com/openmrs/openmrs-module-referencedemodata/pull/7

Appointment Scheduling Module

Address Hierarchy Module

EMR Api Module

Documentation Done: https://wiki.openmrs.org/display/docs/OpenMRS+Setup+On+PostgreSQL

Weekly Blogs

Resources

Talk Threads Initiated :

Final Project Demo Apologies for demo being a bit long but there was a lot to show

Future Works

Comparing with how MySQL is deeply rooted into the OpenMRS systems, what can be done is :

Although, I have done one round of testing on PostgreSQL for both Reference Application as well as OpenMRS Platform to ensure that all the features are working same as they work on MySQL, still much more extensive testing can be done to test the different possible scenarios.
Add PostgreSQL support as a part of OpenMRS SDK. This will be of great help to developers that work on OpenMRS day and night for rapid development and testing.

Thoughts on GSoC 2020

This project is my very first contribution to an open source community. The whole process, starting from community bonding period to the entire coding period, has been a huge learning experience from me. The regular scrum meets, insightful discussion with mentors, helping others in community and many such things will always remind me how work can be made interesting. And as long as you hold a will to learn, its never an end. Numerous good habits came out of GSoC for me-being punctual, admitting when you are wrong, being meticulous in your work; are some of them. I would like to thank the entire OpenMRS community for providing me with this opportunity, my mentors Daniel Kayiwa and Juliet Wamalwa for believing in me through out the process and at last Google for making this program happen even in such harsh situations.

jwnasambu · August 30, 2020, 6:03pm

@aman congratulations for this far and I wish you the best in your career path! I was so blessed working with you and hopefully we shall see you more often in the community. Thanks to @dkayiwa, @ibacher and @mksd who labored to make the project more clear from the beginning.