Module connect to Clickhouse DB

Hello everyone, i want to know how to connect to Clickhouse DB by Frappe. There is module for that?

There is not. You would have to write your own integration.

1 Like

Can we connect to external database of any type from init.py file of the custom app?

Use Virtual DocType if you wish to connect to different data sources.

Check this as mongodb example: MongoDB Powered DocTypes in Frappe Framework | Frappe Blog

RQ Job is also virtual doctype that interacts with python-rq.

2 Likes

You should use virtual doctype to connect other databases.