ERPNext Foundation ERPNext Cloud User Manual Blog Discuss Frappé* Donate

Postgres Support for Frappe 🎉

postgres

#1

Hello Community,

We have a pending pull request for Postgres support.
https://github.com/frappe/frappe/pull/5919

Major changes include:

  • Abstraction of few core database functionalities.
  • Abstracted database exception handling.
  • Removed quotes from SQL which were incompatible with Postgres.
    eg. Postgres doesn’t support double quotes around the literal values, So any such occurrences in raw SQL in the codebase were removed.
  • Other few incompatibilities which couldn’t be replaced by standard queries were managed by our new API frappe.db.multisql

Please do check it out.

We’d love to hear your feedback on this.

Thanks.