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.
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.
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.
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
Thanks for all the suggestions and support. I’m happy to share that we’ve made significant progress in integrating Frappe with Oracle DB. Most of the core functionality is working, and we’ve successfully enabled creating and saving Doctypes in Oracle. We haven’t made any UI changes so far, and while there are still a few issues we’re working through, the majority of the integration is complete.