I have seen a few posts mentioning PostgreSQL but I am not quite sure yet if ERPNext has full support for PostgreSQL backend or if it’s still experimental. I have seen 5 years old posts about future Postgres implementation or recent bug/error reports.
I am considering implementing ERPNext in our organization but we also deal heavily with all sorts of geospatial data. In that matter, PostgreSQL/PostGIS is MUCH more powerful than MySQL, hence the need for it.
My organization is actually in the process of installing ERPNext to use internally, as well as exploring the possibility to create an integration with our product (and offer it to customers that might not have an ERP currently).
For our next major release we are moving to PostgreSQL as our main DB, and as such would love to have ERPNext support this.
How can I help to implement better PostgreSQL support in ERPNext?
Hi @felix, I think perhaps I wasn’t too clear in my post.
I was interested in @rmehta’s comment, specifically “If there is anyone willing to sponsor and use this in production, this is a project we can definitely invest time and effort.”
We are certainly willing to use this in production, and I’m willing to make any changes and create PRs for increasing PostgreSQL integration.
What would “sponsorship” entail? Also, is there anywhere that is tracking what is still remaining for the integration, as per the comment “here are 1300 queries that might need refactoring as of July 2019”? (I didn’t see anything in the issues or in https://github.com/frappe/erpnext/milestones)