🔗 Things You Can Do With Ecto

I’ve been hard at work at my day job porting our analytics stack from Snowflake to Clickhouse. We’ve needed to port over our two existing query builders (one in Javascript, one Elixir) to one system. We’re heavy users of Ecto, so naturally we would prefer to use the excellent ecto_ch library to interact with Clickhouse. This mostly works, but we’ve run into a few limitations that have required us to get creative. Here are a few things I’ve learned along the way.