2015-04-16 Developers Forum

How to Join

Agenda

• Quickly review previous meeting minutes (5 min)

• OpenMRS 2.x Android Client

• Converting to MariaDB or PostgresDB

• Review next meeting agenda

Minutes

View at notes.openmrs.org

OpenMRS Developers Forum 2015-04-16

Recording: http://goo.gl/OTgieh (Audio) https://connect.iu.edu/p75p855e1xu/ (Adobe Flash)

Attendees

• Burke Mamlin

• Michael Downey

• Tim Nicholson

• Ada Yeung

• Rafal Korytkowski

• Wyclif Luyima

• Ryan Yates

• Kamil Kalfas

• Sara Armson

• Milan Karunarathne

• Tomasz Mueller

• Paul Biondich

• Willa Mhawila

• Daniel Kayiwa

• Suranga Kasthurirathne

• Tharunya

Agenda/Notes

• Review old TODOs

• TODO: Notify presenters about their dev forum topics

• TODO: Re-schedule Android Client presentation

• OpenMRS 2.x Android Client

• http://om.rs/android

• Questions

• so information syncing is via xform instance data processing? 

• Using REST API for queries

• Submitting data using XForms

• http://www.hl7.org/FHIR/

• Are there examples of use in productions?

• Not yet. But people are expressing interest.

• Converting to MariaDB or PostgresDB

• Background

• By using MySQL, we may be putting OpenMRS at risk in the long run, since MySQL isn't fully controlled by an open source community.

• http://www.computerworld.com.au/article/457551/dead_database_walking_mysql_creator_why_future_belongs_mariadb/

• http://db-engines.com/en/ranking

• Darius unable to join, so shared his thoughts here <https://talk.openmrs.org/t/converting-to-mariadb-or-postgresql/1701>

• "I think the most valuable first thing we can do in this area is to have CI setups which test doing a from-scratch install of the reference application, against other DBs (mariadb and postgresql being the obvious ones)."

• We're using Hibernate & Liquibase, so they should work with popular DBs, the problem may lie with modules.

• How many distributed modules are not using hibernate + liquibase?

• Goal:

• OpenMRS should be able to run atop PostgreSQL, MariaDB, MySQL, Oracle, and SQL-Server

• Rather than doing all at once, we should prioritize these:

• 1: MariaDB 10.1 (https://mariadb.com/kb/en/mariadb/mariadb-vs-mysql-compatibility/)

• 2: PostgreSQL

• 3: Oracle

• 4: SQLServer

• Action items

• TODO: Get MariaDB support on the roadmap <http://om.rs/roadmap>

• TODO: enumerate which of our distributed modules (those in the 2.2 refapp <https://openmrs.atlassian.net/wiki/x/rg1IAQ>) are not hibernate and/or liquibase

• TODO: Set up CI builds for MariaDB, PostgreSQL, and SQLServer, Oracle

• We assume these will not be green lights

• TODO: Create tickets to address problems that occur

• TODO: Schedule sprint(s) to address tickets

• How many times in the past have we raised this topic? :-)

• 4.6