News for hackers. Stuff that matters.
Re:Ask HN: What has been your experience with CockroachDB? by notmymainlogin on Sunday August 28, 2022 @02:57AM (#32626382)
(note the username!)

Check out Aerospike. It's the most robust and truly "zero effort scale" real time data platform I've ever seen. Properly configured and used, it whups everything in terms of TPS and performance/machine aka TCO. By a huge, huge, factor.

Downside is ... everything else. :/ Less polished developer experience, docs, &c. There are so many huge customers, but very few who are talking about it. Requires more of a time investment -- because you're learning a new platform, not using a drop in replacement for what you already know. But the reward is performance beyond anything else.

(the VLDB 2016 paper is a good high level overview of the architecture)

If you do check it out, be sure to use version 6.1 or later, in particular see what can be done combining secondary indexes with container data types.... A, uh, birdie told me that. :P

edit: Same birdie told me Aerospike has customers who replaced CockroachDB, when they found out it has trouble scaling past a point.

I really hope they can get their act together in terms of communication and marketing -- it's sadly "the most advanced solution you've never heard of".

Re:Ask HN: What has been your experience with CockroachDB? by prng2021 on Sunday August 28, 2022 @10:17AM (#32628561)
Thanks for your enlightening comment. Now myself and others not to never use Aerospike.

A 12 year old product that still has poor documentation? Plus you say TPS = TCO. That’s a good one!

Re:Ask HN: What has been your experience with CockroachDB? by geenat on Sunday August 28, 2022 @05:10AM (#32626894)
> Same birdie told me Aerospike has customers who replaced CockroachDB, when they found out it has trouble scaling past a point.

Elaborate?

Re:Ask HN: What has been your experience with CockroachDB? by notmymainlogin on Sunday August 28, 2022 @06:08AM (#32627140)
Nah, I'd rather be vague. ;-) The issue, I'm guessing, was that CockroachDB couldn't maintain the required latency bounds and availability past a certain point for the customer. Those are always where Aerospike wins (latency, availability, while scaling). milliseconds vs microseconds.

The limiting factor isn't how many operations the platform can handle, it's how many operations/transactions you can generate before the server will even break a sweat.

I'm just a lowly engineer, and while I'll say some stuff on a throwaway account, this is really the marketing department's purview.... Casual googling confirms it's public information that Schwab runs ... nearly everything on it, and it's a much smaller number of servers than you'd think.

Re:Ask HN: What has been your experience with CockroachDB? by paulryanrogers on Sunday August 28, 2022 @09:08AM (#32628116)
Wow, Schwab runs an AGPL database?! Guessing they've a commercial license.
Re:Ask HN: What has been your experience with CockroachDB? by olddustytrail on Sunday August 28, 2022 @09:25AM (#32628218)
Doesn't it seem equally likely they haven't made any changes to the codebase? Or have simply contributed them to the project?
Re:Ask HN: What has been your experience with CockroachDB? by paulryanrogers on Sunday August 28, 2022 @09:28AM (#32628238)
AGPL requires making 'full' source of a network service available to network users. Doubtful Schwab would do that.
Re:Ask HN: What has been your experience with CockroachDB? by olddustytrail on Sunday August 28, 2022 @09:35AM (#32628286)
If they haven't made any changes to the DB, that's just pointing them to the main website.
Re:Ask HN: What has been your experience with CockroachDB? by paulryanrogers on Sunday August 28, 2022 @11:14AM (#32629024)
AGPL considers use of unmodified copies a "covered work". And it requires source of the calling code to also be disclosed.

(IANAL)

Re:Ask HN: What has been your experience with CockroachDB? by speedgoose on Sunday August 28, 2022 @12:07PM (#32629450)
I read various interpretations of the AGPL and some people think it’s not the case.

MongoDB used to be AGPL and I believe most people didn’t interpret the license as everything calling the database must be AGPL, and then everything calling the thing calling the database too, that recursively until the entire world must be licensed under AGPL.

Re:Ask HN: What has been your experience with CockroachDB? by paulryanrogers on Sunday August 28, 2022 @01:43PM (#32630283)
We'll see when AGPL gets tested in court. Until then I suspect legal departments will continue to treat AGPL, and even GPL (because of on prem), as a viral license which could require disclosing all their source.
Re:Ask HN: What has been your experience with CockroachDB? by cvalka on Sunday August 28, 2022 @10:22PM (#32634172)
No
Re:Ask HN: What has been your experience with CockroachDB? by paulryanrogers on Sunday August 28, 2022 @11:28PM (#32634501)
No we won't see it tested in court? Or legal departments won't consider it a viral license?
Re:Ask HN: What has been your experience with CockroachDB? by olddustytrail on Monday August 29, 2022 @02:48PM (#32641939)
The latter. Every large company on the planet uses Linux which is GPL.
Re:Ask HN: What has been your experience with CockroachDB? by paulryanrogers on Monday August 29, 2022 @06:15PM (#32644252)
GPL is widely used in SAAS because network users of SAAS aren't entitled to source. AGPL is different.
Re:Ask HN: What has been your experience with CockroachDB? by loosescrews on Sunday August 28, 2022 @01:39PM (#32630259)
So you work at Aerospike?
Re:Ask HN: What has been your experience with CockroachDB? by ranguna on Sunday August 28, 2022 @05:44AM (#32627028)
I don't really see how this competes with cockroach.

Cockroach is meant to be sql compatible, whilst Aerospike is nosql.

Is that why you commented under a different username, because you are affectively spreading misinformation?

Re:Ask HN: What has been your experience with CockroachDB? by DiggyJohnson on Sunday August 28, 2022 @09:08AM (#32628120)
Reported for not assuming the best - or even reasonable - interpretation of the parent comment. Don’t be so insufferable.
Re:Ask HN: What has been your experience with CockroachDB? by addicted on Sunday August 28, 2022 @12:48PM (#32629824)
There is no reasonable interpretation that makes a comment suggesting an alternative which is nothing like CockroachDB, the entire point of the OP’s post, sound reasonable.

Especially when it’s so conspiratorial in nature and spreading information that is completely unverifiable.

Re:Ask HN: What has been your experience with CockroachDB? by notmymainlogin on Sunday August 28, 2022 @06:10AM (#32627147)
> I don't really see how this competes with cockroach.

I never said it did.

> Is that why you commented under a different username, because you are affectively spreading misinformation?

No, asshole. Because it's a small world, and it's not exactly the smartest thing to do to.... never mind. Obviously you're gonna assume ill intent regardless of what I say.

> "whilst Aerospike is nosql"

You obviously have no idea what you're talking about, and have never used it. If you had, you wouldn't think of it as "nosql".

It's... more like a real time data processing platform, I honestly don't know of an existing category or comparable software.

At first glance it looks like a kvs database with a lot of bells and whistles. After you learn more, though, you realize it's not "just" a database -- you write your application with the Aerospike client library, using expressions, data modeling, CDTs, &c. Not using it as a black box for storing data.

Re:Ask HN: What has been your experience with CockroachDB? by spywaregorilla on Sunday August 28, 2022 @08:52AM (#32628035)
Aerospike describes itself as a NoSql platform in the first sentence of it's front page.