I started using CockroachDB [1] recently and I'm really impressed with it overall. The Postgres compatibility is genius in my opinion, and despite some hurdles it's been a joy to work with (I'm using xo [2] to generate Go code from custom templates). I've yet to deploy it in production, but the best part is that if the performance sucks I can simply deploy postgres instead. As someone who used to be a big RethinkDB supporter, this is my new favorite pet oss project.
edit: oh, and it's written in Go, my main language, which is definitely a plus if you're a gopher
I feel the same way regarding the importance of a migration back to Postgres if needed. I haven't been given a reason to doubt cockroachdb's stability, but you never know what could go wrong. The fact that I can have a break glass contingency plan to restore data to Postgres if I need to is huge. I doubt I'll ever need it, but the fact that it's an option made using a younger project like cockroachdb an acceptable risk.
Postgres compatibility? Really? Reference? I want to believe but are not you comparing apples to oranges?
Last time I checked the JSON datatype was not supported on Cockroach.
no, not even a JSON datatype is now supported. I cannot use a database without JSON for my use case https://github.com/cockroachdb/cockroach/issues/2969
An compatible interface is not compatibility and JSON as an example is not the biggest magic stuff inside PostgreSQL.
edit: oh, and it's written in Go, my main language, which is definitely a plus if you're a gopher
1: https://www.cockroachlabs.com/tags/acid/
2: https://github.com/xo/xo