Is it possible to install the cockroachdb dialect for sqlalchemy, such that the
recorder plugin can use that instead of eg: postgresql?
I have tried adding a manifest.json to config/custom_components which includes
"dependencies": ["sqlalchemy-cockroachdb==1.3.2"] - and I see the conifg/deps/ directory now contains:
config $ ls deps cockroachdb sqlalchemy_cockroachdb-1.3.2.dist-info
which looks right, but when using a connection sting in recorder.db_url like ‘cockroachdb://’ I still get the following in the logs on restart:
2021-02-20 10:07:41 ERROR (Recorder) [homeassistant.components.recorder] Error during connection setup: Can't load plugin: sqlalchemy.dialects:cockroachdb (retrying in 3 seconds) ...
For the record I would like to use cockroachdb since I already have a large multi-machine cluster of it set up and would like to use it specifically. I am running the hass.io image on a raspberrypi 4, if that helps. Thanks in advance.