Thanks for the support Myrle, Sendoro and Awasum. I just created a corresponding issue <https://issues.apache.org/jira/browse/FINCN-103> and have pushed the work done on the PostgreSQL core component to this repository <https://github.com/Izakey/fineract-cn-postgresql>.
PostgreSQL came along with it's PgJDBC driver, its default port number being *5432*, default database instance being *postgres* and default host being *localhost*. The HibernateJpaVendorAdapter was replaced with OpenJpaVendorAdapter and the Hibernate dialect for MySQL was replaced with the OpenJPA dictionary for PostgreSQL. I'm still unclear about whether users need to employ a specific password as was done with MySQL given that best practice says it shouldn't be so. For now, developers would have to ensure they're logged into their *postgres* account for connection to databases to work. These are just the basics and I'm uncear about the specific workings of BoneCP with PostgreSQL. Maybe the constants used have to be modified. @Markus, @Myrle, @Awasum, Please I await your feedback on what needs to be improved upon here. @Myrle, if you think it's time to transfer this repository <https://github.com/Izakey/fineract-cn-postgresql> to Apache infra, please let me know. At Your Service, Isaac Kamga. On Sat, Nov 3, 2018 at 11:14 PM Awasum Yannick <[email protected]> wrote: > Brilliant Idea, Isaac. > > Maybe it will be a good idea to create an issue on JIRA for this. > > On Wed, Oct 31, 2018 at 8:58 AM Isaac Kamga <[email protected]> wrote: > > > Hello everyone, > > > > I'm following up on this thread because we still haven't made progress > with > > eliminating Category X dependencies in Fineract CN which Yannick evoked > > half a year ago. > > > > @Myrle and @Awasum, I've read through this thread and I second Sendoro's > > suggestion that we completely move Fineract CN's dependence on MariaDB to > > PosgreSQL instead. Besides MariaDB's license > > <https://mariadb.com/kb/en/library/licensing-faq/> being an inadmissible > > Category X dependency, PostgreSQL is Apache-compliant and is a good > > alternative for MariaDB. > > > > I think this will entail writing an equivalent library to > > fineract-cn-mariadb <https://github.com/apache/fineract-cn-mariadb> > which > > we can name *fineract-cn-postgresql*. It may use the OpenJPA ORM which > > replaces Hibernate and use PostgreSQL's PgJDBC driver. I've started > > dabbling with this and will share the link to the code base tomorrow. > > > > I want to work on this task and share my thoughts, challenges and > progress > > here with you too. > > > > What do you think about it ? > > > > Cheers, > > Isaac Kamga. > > > > On Wed, Apr 18, 2018 at 9:13 AM Myrle Krantz <[email protected]> wrote: > > > > > I think that's an excellent suggestion Sendoro. Would you like to > > > take the lead on that? I'd be happy to provide you with any help you > > > need to make it happen! > > > > > > Best Regards, > > > Myrle > > > > > > On Wed, Apr 18, 2018 at 9:47 AM, Sendoro Juma <[email protected]> > > > wrote: > > > > Dear Myrle, > > > > > > > > It may be irrelevant, but let me shoot anyway...!!!... please don't > > > through stones onto me. > > > > > > > > PostgreSQL is believe to have very/most liberal license... as matter > of > > > facts... it will avoid now and any future license conflict. > > > > > > > > The question is then, why don't we select PostgreSQL as our default > > DBMS? > > > > > > > > - is it related with our skill set? or > > > > - it is more just related to smooth transfer from MySQL to MariaDB? > > > > > > > > Taking into Finaract CN project take a revolution approach from its > > > predecessor Finaract; why also not take same approach on database? > > > > - after-all Fineract CN Architecture is decoupled from reliance on > > > particular database system... > > > > > > > > > > > > Refer > > > > https://www.postgresql.org/about/licence/ > > > > https://www.postgresql.org/list/ > > > > https://opensource.org/licenses/MIT > > > > > > > > > > > > Regards > > > > Sendoro > > > > ----- Original Message ----- > > > > From: "Myrle Krantz" <[email protected]> > > > > To: "dev" <[email protected]> > > > > Sent: Wednesday, April 18, 2018 9:44:13 AM > > > > Subject: Re: Moving Towards Apache Compliance for Fineract CN: > > Hibernate > > > to OpenJPA Migration. > > > > > > > > Thank you Sendoro, > > > > > > > > It's much appreciated. > > > > > > > > FYI: I've captured the MariaDB work items in 2 new tickets: > > > > https://issues.apache.org/jira/browse/FINCN-26 > > > > https://issues.apache.org/jira/browse/FINCN-27 > > > > > > > > Best Regards, > > > > Myrle > > > > > > > > On Mon, Apr 16, 2018 at 4:39 PM, Sendoro Juma <[email protected]> > > > wrote: > > > >> Hello Myrle, > > > >> > > > >> I got you. > > > >> > > > >> Let me know if there is any other component need to be checked! > > > >> > > > >> Cheers > > > >> Sendoro > > > > > >
