Hi Michael, We want to switch since it is part of the deal with one of our clients. We will be integrating Fineract with our other products and they need to be database agnostic depending on the client's preference.
Yes we will try it out for ourselves and share the procedure if we are successful. Thanks again! Joseph On Mon, Oct 21, 2019 at 2:27 PM Michael Vorburger <m...@vorburger.ch> wrote: > On Mon, 21 Oct 2019, 07:53 Joseph Cabral, <joseph.cabra...@gmail.com> > wrote: > >> Hi everyone, >> >> I see that there is an ongoing project of migrating Fineract CN from >> MySQL/MariaDB to PostgresSQL. Is there a similar initiative for Fineract >> 1.x? >> > > Not that I know of, no, I don't think so. > > But if your business has a strong interest to use PostgresSQL instead > of MySQL/MariaDB with Fineract 1.x, you could of course always just try it > out for yourself.. replace the JDBC driver JAR, change the JDBC connection > URLs, and see what happens... I'm sure there are some queries that need > some tweaks etc. > > I'm curious why you would want to switch? > > If the motivation here is just for performance, then I suspect that a few > well placed additional indices and playing with some DB parameters on > MySQL/MariaDB will be more efficient than spending time on switching to an > entirely different DB. > > If so, is there a guide for this? >> > >> Regards, >> >> Joseph >> >
