Frappe ORM Oracle database support

has anyone tried to use ORACLE as a database with frappe framework or Erpnext ?

do you have an idea on the volume of work required to make Frappe orm compatible with Oracle ?

Where are the SQL connection and queries located in frappe source code ?

Thanks

1 Like

As per my understanding, Frappe is not truly taking the full advantages of ORM, and it only focus on MariaDB. We will not be able to use MySQL or Percona, which are very much similar as Percona is direct replacement of MySQL, and same is for MariaDB.

Percona supports encryption at rest. Will be nice if we are able to use it.

How much MariaDB specific things are used, and if we avoid that and only uses ORM way of things, will that cause many side-effects which over-weight the benefit of using any database for the backend?

Like Django supports 5 databases officially:

  1. PostgreSQL
  2. MariaDB
  3. MySQL
  4. Oracle
  5. SQLite