How Can I provide Support of Oracle Database, Replacing Mariadb

Hello everyone,

I’m currently working on a project for one of my clients where we need to replace MariaDB with Oracle Database in Frappe. As this is a key requirement for the client, I am looking for guidance or collaboration on how to best approach this integration.

If anyone has experience or insights on how to modify Frappe to support Oracle DB, your expertise would be greatly appreciated. I’m also open to engaging in a paid collaboration for those who can assist in this endeavor.

Looking forward to your suggestions or offers to collaborate.

Best regards,

I don’t know much about the differences between mariadb and oracle, but I suspect this will be an absolutely massive project. You’ll be writing significant parts of the code over from scratch. This is not a realistic requirement for a client.

4 Likes

If anyone needs to connect oracle from frappe app for development, use this Custom docker-compose.yml for frappe_docker devcontainer ($2298024) · Snippets · GitLab

That can give you a base to play around with db from devcontainer, helps to develop apps that use oracle.

mariadb is the choice of db for most apps. AFAIK there is no official or community app that is CI tested on postgres. Same will be the situation for oracle.

3 Likes

I know that @revant_one is the KING of all things “Docker”, but when I saw the link (Custom docker-compose.yml for frappe_docker devcontainer ($2298024) I honestly thought that he was quoting a price for what it would take to connect to an entirely new database with no current support: $2.3 Million dollars

4 Likes

I absolutely agree with this statement

2 Likes

Thankfully Frappe already began to move away from MariaDB to PostgreSQL. Also nearly each feature have a test, so test part can be automated, mostly.

We’ve 2 options here.

  • We can extend the database layer to also support the Oracle.
  • There are some proxies like Oracle act like PostgreSQL.

We had an opportunity to add Oracle support for SQL Server based MES system. It may take time but it’s feasible in Frappeverse.

1 Like