Hi everyone, I was scanning through some tickets and found FINERACT-984 <https://issues.apache.org/jira/browse/FINERACT-984>: Postgres support.
I'm glad this has been brought up already. I thought about some potential paths forward to support Postgres in Fineract, let me explain. First of all, I've gotta say Postgres would be a great addition to the current Fineract project because - at least from my experience - Postgres often outperforms MySQL performance-wise. At one of my previous projects - which was a completely different product from Fineract - we used AWS cloud to deploy the application and we were planning to use AWS Aurora to boost the performance but we weren't sure whether AWS Aurora MySQL or Aurora PostgreSQL is the way to go, so we decided to measure it. Aurora Postgre was way better than Aurora MySQL in terms of performance but I can't really share numbers. With that said, the first step in my opinion would be to try to do database-independent schema migrations for which we could use Liquibase instead of Flyway. With Liquibase we could write the schemas in a single format and in the future apply to either MySQL or PostgreSQL. In addition, Liquibase also supports native SQL migrations so we are not losing any functionality. I'm happy to take this work up and make the necessary changes to Fineract. Note: I'm not targeting 1.6 with this change but a later release. Note2: I've created a ticket as well to track this. FINERACT-1498 <https://issues.apache.org/jira/browse/FINERACT-1498> Let me know your thoughts. Best, Arnold
