Postgres Support for Frappe 🎉

Hello Community,

We have a pending pull request for Postgres support.

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.