CockroachDB ?

[travisdh1]

Interesting concept. I like that it's open source, and they prominently display the free version. From the 30 seconds I took to look at it, it looks good.

[scottalanmiller]

Looks like a relational database built in this era, that's pretty much needed!

[scottalanmiller]

So like Spanner, Cockroach DB is not a relational database, but uses SQL. It never mentions what it is because so many people use "SQL database" as an inappropriate hipster buzz word proxy for relational that because CockroachDB and Spanner both use SQL, but are not relational, they just call themselves SQL databases and let customers imply whatever they want to hear. Good marketing. Tricks the foolish, doesn't trick people who know what they are doing.

In reality 99% of relational deployments don't need to be relational, and that's how this works. It allows a SQL query layer to non-relational data. But unlike most systems that do this, SQL is its only query language, not a secondary one.

[Emad R]

@scottalanmiller said in CockroachDB ?:

Cockroach DB

So no foreign key support ?

[scottalanmiller]

@emad-r said in CockroachDB ?:

@scottalanmiller said in CockroachDB ?:

Cockroach DB

So no foreign key support ?

Foreign Keys are supported. Not all relational databases support those.

Relational databases are a specific database type, not indicative of specific features.

[Emad R]

@emad-r

Loving the admin UI

Installing on Centos is simple as :

wget -qO- https://binaries.cockroachdb.com/cockroach-v2.0.5.linux-amd64.tgz | tar  xvz
cp -i cockroach-v2.0.5.linux-amd64/cockroach /usr/local/bin

cockroach start --insecure \
--host=YOURIP

[Emad R]

@emad-r said in CockroachDB ?:

@emad-r

Loving the admin UI

Installing on Centos is simple as :

wget -qO- https://binaries.cockroachdb.com/cockroach-v2.0.5.linux-amd64.tgz | tar  xvz
cp -i cockroach-v2.0.5.linux-amd64/cockroach /usr/local/bin

cockroach start --insecure \
--host=YOURIP

This was developed by an EX Google guy that was working with Spanner

Also joining other nodes reminds me of GlusterFS method

[scottalanmiller]

that is definitely a great UI, very nice.

[Emad R]

@scottalanmiller said in CockroachDB ?:

that is definitely a great UI, very nice.

I just added 3 nodes cluster in 2 mins, very easy too.

Bumping up my capacity

Definitely worth more research.

[Emad R]

@emad-r said in CockroachDB ?:

@scottalanmiller said in CockroachDB ?:

that is definitely a great UI, very nice.

I just added 3 nodes cluster in 2 mins, very easy too.

Bumping up my capacity

Definitely worth more research.

The only real pitfall currently is no admin tool GUI to manage it and create DB with it, all third party and all with errors when connecting.

You can only use there native cli which works for developers, that wish to create new apps with it, but not existing users.