> The Licensor may make an Additional Use Grant, above, permitting limited production use.
See the text of the Additional Use Grant for CockroachDB [1]:
> Additional Use Grant: You may make use of the Licensed Work, provided that you may not use the Licensed Work for a Database Service.
> A “Database Service” is a commercial offering that allows third parties (other than your employees an contractors) to access the functionality of the Licensed Work by creating tables whose schemas are controlled by such third parties.
We do have compatibility gaps -- some big, some small. But I would still call it compatible because it's definitely close enough to use a PostgreSQL driver with it in production. I would be curious to hear your opinion on which incompatibilities are most important to address.
There certainly are pain points. I don't work on this myself, but one of our other engineers wrote this blog post [0] that discusses the experience of running CockroachDB in k8s and why we chose to use it for our hosted cloud product. Another complication mentioned in there is about how to deal with the multi-region case.
Our goal is to make switching over from PostgreSQL easy. For Ecto in particular, we have a tracking issue that shows the items in our backlog that would improve compatibility: https://github.com/cockroachdb/cockroach/issues/33441
Thanks! I do think that a columnar on-disk representation would likely help with large analytical queries. But I would imagine they would negatively affect performance of point transactions in an OLTP workload. Note that this vectorized engine we built will only be used on a given query if our SQL planner estimates that a large number of rows will be read.
See the text of the Additional Use Grant for CockroachDB [1]:
> Additional Use Grant: You may make use of the Licensed Work, provided that you may not use the Licensed Work for a Database Service.
> A “Database Service” is a commercial offering that allows third parties (other than your employees an contractors) to access the functionality of the Licensed Work by creating tables whose schemas are controlled by such third parties.
(disclaimer: I work at Cockroach Labs)
[1] - https://github.com/cockroachdb/cockroach/blob/master/license...