Open Source SQL Database CockroachDB Hits 1.0 (infoworld.com) 80
An anonymous reader quotes InfoWorld:
CockroachDB, an open source, fault-tolerant SQL database with horizontal scaling and strong consistency across nodes -- and a name few people will likely forget -- is now officially available. Cockroach Labs, the company behind its development, touts CockroachDB as a "cloud native" database solution -- a system engineered to run as a distributed resource. Version 1.0 is available in both basic and for-pay editions, and both boast features that will appeal to enterprises.
The company is rolling the dice with its handling of the enterprise edition by also making those components open source and trusting that enterprises will pay for what they use in production.
The company is rolling the dice with its handling of the enterprise edition by also making those components open source and trusting that enterprises will pay for what they use in production.
And remember (Score:5, Funny)
Especially in these times.
This one will still work when all the other SQL-Databases have died a nuclear death.
No, not shards (Score:3, Informative)
No, not according to the the FAQ [cockroachlabs.com], which says (emphasis mine):
Re: (Score:3)
How well does it work in practice and at scale? The marketing claims are 'cute' but they stay marketing claims until independently verified. I have tried other 'distributed' SQL' DBs such as crate and you can paint me unimpressed with the performance and, pun intended, bugs.
Re: (Score:2)
But is it web scale?
Re: (Score:2)
But is it web scale?
Only if it's run by Mongo-scale cockroaches.
Re: (Score:2)
Re: (Score:1)
And bundled with "Twinkie SQL"
Cockroach Labs makes CockroachDB. (Score:3)
From the article: "CockroachDB may sound like a joke project..."
Re: (Score:2)
Small subset of SQL (Score:3, Insightful)
From their FAQ [cockroachlabs.com] (emphasis mine):
It may be a really cool software package, but, I gather, if you allowed for only a "small subset" of SQL to be supported, you could have MySQL, PostgreSQL, Oracle, and Sybase as "fault tolerant" and with "strong consistency".
So they give you SELECT and call it "SQL" (Score:1)
Hey, now you can have that same thing in a "next gen" (or "3.0" or whatever term you like) software package, free from all that "legacy" code, well-tested over decades. I'm sure it makes sense if you grew up with MySQL and PHP and thought those were really good bits of software.
Me, I think I'm going to take their name at face value and break out the professional grade pest poisons.
Re: (Score:1)
It may be a really cool software package, but, I gather, if you allowed for only a "small subset" of SQL to be supported, you could have MySQL, PostgreSQL, Oracle, and Sybase as "fault tolerant" and with "strong consistency".
CockroachDB is based on the Spanner paper. [google.com] Within Google Spanner has had a huge impact (apparently? it's discussed in the paper.). The impact is in efficiency, fewer failure modes, and API simplicity over the tools they had before it (internal versions of Cloud Bigtable and Datastore). Both the paper and informal discussions with Googlers attribute most of this impact to the core ideas introduced with it, the ideas which inspired CockroachDB [wikipedia.org]. Therefore, while CockroachDB guys could still fumble it, I'v
Re: (Score:3)
A lot of the source code is written in Go [github.com], which is interesting and probably not a bad choice. The code is clean and easy enough to understand. Its primary weakness is poor organization, which is also the primary weakness of their documentation. Both would benefit from the concept of "topic sentence, supporting sentences," so when I approach and ask, "what are the most important points here?" the answer is i
Re: (Score:3, Informative)
You mean ANTSY SQL
Re: (Score:2)
"Cockroaches check in... but they don't check out!"
Be careful or you'll get sued by The Eagles.
Re: (Score:2)
Sooo... Bugs are a feature now? (Score:1)
What's the target platform?
Re: (Score:2)
Re: (Score:2)
Windows. It likes having other bugs around.
Can't get past the name... (Score:5, Funny)
Re: (Score:2)
What happens when I make a formal commitment to Satan?
Wrong SATAN, Santa.
https://en.wikipedia.org/wiki/Security_Administrator_Tool_for_Analyzing_Networks [wikipedia.org]
Re: (Score:2)
"Satan comes to us on his own. Many times, we can feel him. He comes to guide us "
Shut up, Steve Bannon!
Re: (Score:2)
Satan, that is the leaders and owners of the military-industrial complex that lobby and pay the people in governments to start wars, so their weapons can be sold and used.
Satan, that is the bankers who want to take away our cash and financial freedom, and want to destroy any non-western bank in order to establish their own and get all countries under their contro
Re: (Score:2)
/. should hold a collection and enroll you for this course:
https://www.masterclass.com/cl... [masterclass.com]
Re: (Score:2)
/. should hold a collection and enroll you for this course:
That would be a waste. Comedy requires intelligence and the ability to play the fool. The AC has neither.
Oracle will kill this (Score:2)
They need a decent marketing dept... (Score:5, Insightful)
... because the men in suits who sign the cheques are really not going to go a bundle over something called Cockroach. No doubt it sounded amusing after a few beers on a friday night, but I'm struggling to think of any current IT products with a worse name.
Re: (Score:2)
... because the men in suits who sign the cheques are really not going to go a bundle over something called Cockroach. No doubt it sounded amusing after a few beers on a friday night, but I'm struggling to think of any current IT products with a worse name.
So, worse than Gimp & Git?
Re: (Score:2)
Fair point, though neither of them are marketed products. I'm guessing wrt the latter, Torvalds learnt american english and so never found out that in british english "git" is a somewhat unpleasent insult.
Re: (Score:2)
Actually, as Torvalds is from Finland, he likely learned british english, like most of the world.
I'm German, and did not know as well that 'git' means 'idiot'. Seems to be a rarely used word, in that context.
But good to know.
Actually, I don't even know what the long term is behind the acronym git. Well, I always assumed it is an acronym.
Re: (Score:2)
It doesn't mean idiot. It's a rather generic insult, which is why it's often clarified by adding an adjective - stupid git, lazy git, fat git ...
Re: (Score:2)
Re: (Score:3)
Yorkshireman here, fuck off and stop talking shite.
Re: (Score:2)
Reminds me when I suggested to my company around 1997 to build a refactoring and fast forward generator based IDE for C++ and Java. I wanted to call it Rapid Application Programming Environment. RAPE.
One of the CEOs was from Australia and suggested I should consult a dictionary to see what "rape" means.
Re: (Score:2)
Blackadder uses it all the time
Re: (Score:2)
I'm guessing wrt the latter, Torvalds learnt american english and so never found out that in british english "git" is a somewhat unpleasent insult.
Torvalds knew the meaning of git at release time and quipped: "I'm an egotistical bastard, and I name all my projects after myself. First 'Linux', now 'git'."
Re: (Score:3)
Bill Gates did the same when he named MicroSoft
Re: (Score:2)
Fair point, though neither of them are marketed products. I'm guessing wrt the latter, Torvalds learnt american english and so never found out that in british english "git" is a somewhat unpleasent insult.
I looked up the company's staffers and the founders are Spencer Kimball & Peter Mattis, the UCBerkeley roommates who gave us GIMP. Guess their sense of humor hasn't changed since their salad days.
Re: (Score:2)
Slightly better than Gimp and Git nut on the same level as Subversion and subversive.
Re: (Score:2)
And it did eventually get a name upgrade: SAS [wikipedia.org].
Another fifteen years from now, after another transport remake, it will probably be called LAPP or HED or VD4U.
Re: (Score:2)
... because the men in suits who sign the cheques are really not going to go a bundle over something called Cockroach. No doubt it sounded amusing after a few beers on a friday night, but I'm struggling to think of any current IT products with a worse name.
Look up "Adobe" in Spanish.
According to RAE [dle.rae.es], it means bricks made out of clay (and sometimes straw). Soft mixed clay, sometimes with straw, molded in the form of a brick and dried in the air, which is used in the construction of various types of walls.
I would add that adobe is typically sun-dried, not just air-dried, but the point is that they are not fired.
Re:They need a decent marketing dept... (Score:4, Insightful)
If your marketing pitch is fault-tolerance, cockroach is a good way to convey that it's hard to kill.
Re: They need a decent marketing dept... (Score:2)
Chocolatey nuget?
Dev Tools (Score:1)
moderately difficult to setup timings (Score:3)
Re: moderately difficult to setup timings (Score:2)
Interesting. Spanner works through custom hardware with atomic clocks. The whole point of cockroach was to not require something like atomic clocks
Re: moderately difficult to setup timings (Score:2)
No but time in a vm is not very accurate. If you are using kvm/qemu this becomes even worse due to lack of fine grained scheduling compared to xen,VMware. In my experience, kvm can lose time due to runaway I/O on the hypervisor. Try this experiment again with the vms using tmpfs or otherwise minimizing disk writes.
If I can contact you through your blog, I will follow up directly. Your project sounds interesting :)
-dk
Re: (Score:2)
Customer relations (Score:2)
So, what are you going to run our website on?
We decided on "CockroachDB" greatest thing since sliced...
Sorry, uhm, sad to say we decided to go with your, well, competitor
Re: (Score:2)
It is basically one big bug, likes having other bugs around and gets hunted by debuggers?