Postgresql Support in next version of frappe framework

Install / Update Deployment
1

Hello,

we envisage to build an application based on frappe framework and if possible using posgresql as the main database.
we prefer to use postgresql for intern support reason and to integrate database modules like pgvector,gis, fuzzysearch.

Currently we understand that postgresql support is not complete for frappe framework ( we had to patch some queries to let it work on our POC) but will the support of postgresql be integrated in the next versions ?

Thanks a lot

2

A bit late to the party, but here’s the current state:

Frappe Framework: Supports PostgreSQL, but it’s still officially experimental. MariaDB remains the recommended/first choice. Confirmed by a maintainer here.

ERPNext: PostgreSQL support was added ~6 weeks ago, but only on the development branch (unreleased v17). As far as I can tell, v15 and v16 do not support PostgreSQL.

Other (official) Frappe apps (CRM, HRMS, Helpdesk): No PostgreSQL support today, and the same goes for most apps in the wider ecosystem.

Bottom line: Unless you plan to use only the Frappe Framework and build everything else yourself, you’re effectively forced onto MariaDB. And in an enterprise setting where long-term support matters, I’d stick with MariaDB regardless.

3

I had to make a lot of changes to Framework to get ERPNext Postgres supported. I’d say its almost there.

Since those 2 heavily rely on each other, yeah, almost there. I don’t think anything is pending anyways.

2 Likes
4

Thanks.
After some POCs will Frappe Framework, Insights,.. we decided to use MariaDB a it’s officially supported by Frappe ecosystem.

5

Thanks a lot @mihir-kandoi for your efforts in this big task :+1:

1 Like