How do you recommend I use Ash with ClickHouse. Through an extension?
Good question I haven’t tried it myself. There are definitely ways to do it even if you end up using manual or generic actions that call into some other library (Ecto adapter for click house?). Does click house support postgres protocol? If so you could just try using
AshPostgres
with the acknowledgement that there will be limits on the queries you can do.
Looking at their doc looks like there’s a way to make it pretend to be postgres
I am using ecto_ch
in production and it works well for our use-case!
I am using ecto_ch
as well here on this side project.
Sharing it in case it might be helpful.