Alternative Database to Self-Host (like Supabase)

ERPNext
, , ,
1

Hello everyone,

I just discovered these products and they seem great. I’m excited to deploy them on my local servers and try them out.

I see that MariaDB (and Redis) is standardized across the platform. Is there a precedent for a business or individual self-hosting the Frappe products, but using an alternate database vs. MariaDB?

We use Supabase, and are currently in the process of moving to a Redis alternative since they are no longer an open source licensed product.

Any feedback is appreciated. Thank you.

1 Like
2

Hi @fakebizprez:

Frappe Framework (not ERPNext) supports Postgres v9 and above.

Just use this at site creation.
bench new-site <site-name> --db-type postgres

Hope this helps.

2 Likes
3

Thanks, @avc .

I’m OK with ERPNext and HRMS running on MariaDB.

If I want the CRM app to run on Postgres, do I have to create a totally new site?
What would the syntax be to target just the CRM?

4

Hi @fakebizprez:

Can’t use both database engines for the same site. Should create different site for CRM …

1 Like