ERPNext, Virtual Doctypes and MongoDB

Frappe Framework
, ,
1

Hii,

There are few ERPNext modules which we would like to use/power certain features of ours internally, with MongoDB as the database, since all our data is stored within Mongo.

The question then was, is this possible, or is Frappe/ERPNext completely locked with an SQL db - Maria, Postgres.

Then, came across this article that mentions “Virtual DocTypes” - MongoDB Powered DocTypes in Frappe Framework | Frappe Blog.
This is perfect for our usecase.

But this article was in 2022. And the question now, is this still valid? And has there been any more progress, features on Virtual DocTypes for which there’s newer available documentation?

What’re the limitations of virtual doctypes, if any? Any pros and cons…

Would like some help and understanding with regards to this.

Thank You : )

2

Based on that article we built app that syncs masters from mongodb.

https://castlecraft.gitlab.io/frappe-manual/frappe-mdm/introduction/

Source: castlecraft / Master Manager · GitLab

2 Likes
3

Hi @Ghostie:

Check the unvaluable (another one) stuff from @revant_one … In addition: We use this feature intensively with external databases (MSSQL, foreign MySQL, etc …) It works really well, many issues was solved from v14.

Virtual doctype
Pros:
Fully updated data, no sync delays.

Cons:
Some framework features won’t work directly (fetching, etc…)

Hope this helps.