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.