On Mon, 21 Oct 2019, 08:34 Joseph Cabral, <joseph.cabra...@gmail.com> wrote:
> 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. > IMHO "database agnostic" is AKA "do much performance related work N instead of 1 times"... ;-) Yes we will try it out for ourselves and share the procedure if we are > successful. > Cool - best of luck! 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 >>> >> Mifos-developer mailing list > mifos-develo...@lists.sourceforge.net > Unsubscribe or change settings at: > https://lists.sourceforge.net/lists/listinfo/mifos-developer