Dear Community,

As I mentioned a couple of mails back, it would be awesome if Fineract
could support PostgreSQL because of the performance gain it could bring.

The first milestone in this process was to make the database migrations
MySQL independent and switch from Flyway to Liquibase. That's done, thanks
for reviewing and merging the changes.

Now, I'm planning to continue on this path slowly but surely. In the
upcoming days/weeks I'm going to be filing new PRs to make Fineract as
independent as possible from MySQL and rely on standard SQL tools. Just as
an example, MySQL supports the IFNULL function but PostgreSQL doesn't.
However, IFNULL can be easily replaced by the ANSI SQL COALESCE function
which is supported both by MySQL and PostgreSQL.

The JIRA I'm using for creating the commits is FINERACT-984
<https://issues.apache.org/jira/browse/FINERACT-984>.
Also, the first PR has landed already in develop: PR link
<https://github.com/apache/fineract/pull/2039>

Best,
Arnold

Reply via email to