New Discovery - CockroachDB

Over the weekend, I discovered something new. Being a person that is always interested in scale-out architecture, I discovered something new. CockroachDB. Its a SQL database designed to be hard to kill. (Yes I know the name gets the idea across, but ...) Anyway, I wanted to explore it.

I fired it up in a container, and sure enough it just comes write up. Instructions are here. I then wanted to be able to setup data, if nothing existed, also not to bad. I setup a new Dockerfile, and created some scripts to check and see if the data exists, and if not, create it. To do this, check out this github project.

Seems to work well enough. I love the management screen.

After getting this working, I now have moved on, and looks like I can use pg_restify, to expose CockroachDB as a RESTful API. This requires, that I can the database "public", because of the way schema's are named in cockroach.

Next step, is to put a CRUD using the restful api. The try a pet set in Openshift. :)

Great job, Cockroach Labs.

For a quick executive overview slideset on cockroach, check these out.