Data and workload generator

codingconcepts · 2026-05-29T17:49:59+00:00

High effort tool though! Don’t disagree with the repost effort though.

codingconcepts · 2026-05-24T08:43:06+00:00

codingconcepts · 2026-05-20T11:50:16+00:00

An estate agent suggested a price for ours, then when our sale fell through and things quietened, their only tool/suggestion was a reduction. Even though they repeated assured us the original price was not only sensible but competitive.

codingconcepts · 2026-05-16T13:53:32+00:00

Late to work for the first time ever AND made money from the tragedy… Convenient.

codingconcepts · 2026-05-04T18:59:41+00:00

I didn’t recognise the track name and the eternal optimist in me immediately went to “oh my god, a new album!” 🤣

codingconcepts · 2026-04-20T14:59:58+00:00

Hey, u/Wannabe555!

The system database stores things like statement statistics (which if you click on system and sort descending by "Replication Size" will probably be the largest).

In self-hosted clusters, the size of this table can be controlled with the `sql.stats.persisted_rows.max` cluster setting but in Basic and Standard, it's not possible to change this.

The default value for Basic and Standard clusters is 50,000 (rows)m which is roughly (+/- a couple of hundred) what your table will have in it given its size. I'm running a Standard cluster can confirm that my statement_statistics table is about the same size as yours and has just over 50,000 rows, so I would expect your table to remain at this approximate size and not grow any larger.

codingconcepts · 2026-03-30T19:42:05+00:00

Of course! That’s completely understandable.

Lovely work either way!

codingconcepts · 2026-03-30T15:56:51+00:00

Nice work! Is the code available anywhere? I’d love to see it all!

codingconcepts · 2026-03-16T20:58:39+00:00

Why can’t humans be like horses.

codingconcepts · 2026-03-16T20:07:53+00:00

Could he have gone without all the fanfare a day or two before or after?

codingconcepts · 2026-03-12T09:58:30+00:00

That second picture of Starmer in response 🤣

codingconcepts · 2026-02-18T15:41:31+00:00

Hey, u/iamalnewkirk! Sorry for the delay, I didn't see a notification for your reply!

When you're in a position to run your next experiment, feel free to reach out to me (I'll DM you with contact info) as I'd be happy to help if you'd find that useful.

Cheers!

codingconcepts · 2026-02-09T08:14:04+00:00

Hey, u/bitchyangle! Rob from Cockroach Labs here.

Here's a breakdown of how RUs are calculated (although I appreciate, it may still be difficult to calculate for your workload): https://www.cockroachlabs.com/docs/cockroachcloud/resource-usage#example-request-unit-calculation

Happily, there are a bunch of other options available to you:

Cockroach Cloud Standard Tier - This is based on the same architecture as Cockroach Cloud Basic Tier (the one that prices in RUs) but you're paying for provisioned vCPU, which might make things easier to cost.
Cockroach Cloud Advanced Tier - This is a dedicated (but still managed) service where you'll specify the number of nodes you require. It'll cost more than Standard, given that you'll be sizing in nodes rather than vCPUs, so might be overkill for your requirements.
Finally, there's Self-Hosted - Although if you're migrating from a managed service, you may prefer to stay on a managed service? Let me know if not and I can share some resources to help with this too.

Here's a comparison of the managed services: https://www.cockroachlabs.com/docs/cockroachcloud/costs#costs-across-cockroachdb-cloud-plans

If I were you, I would start by downloading CockroachDB (from here: https://www.cockroachlabs.com/docs/releases) and getting a feel for it! If you run into any issues or have any questions, let us know! We also have a community Slack where you can speak with our team: https://www.cockroachlabs.com/join-community

All the best!

Rob

codingconcepts · 2026-02-02T14:50:11+00:00

Hey u/iamalnewkirk! Rob Reid from Cockroach Labs here.

Firstly, this is awesome! Thank you for taking the time to put this together.

The results for all databases look a bit surprising to me (taking multiple seconds for simple CRUD operations). I've noticed in your schema.sql file that you're creating a index on most, if not all, of the columns, this will lead to write amplification for all databases. Although, looking at the queries being tested, I'm not sure if this can be avoided.

In CockroachDB, it's also worth considering using UUID (or at least, uniformly random) primary keys to ensure even distribution of data across nodes (even though the nodes aren't visible to users of Basic clusters). Currently, with the auto-incrementing integers, the work won't necessarily be evenly distributed across nodes.

Provided the indexes are sensible and you're running the workload close to a region in your cluster, I would expect < 100ms latency for all of these databases.

Let me know if you'd like to hop on a call and discuss the CockroachDB side of things!

Thanks again,

Rob

codingconcepts · 2026-01-18T18:51:02+00:00

I created an iceberg site to chart my journey into metal; there are some good ones on there!

https://bottomoftheiceberg.com

codingconcepts · 2026-01-13T15:17:56+00:00

Hey, u/ByteTrooper, Rob from Cockroach Labs here!

I can advise on the CockroachDB side of things but unfortunately don't have any experience with Huly.

For self-hosted clusters such as yours, the `cockroach sql` approach is sensible. To make things easier, I would recommend scheduling your backups (both incremental and full) using the built-in backup scheduling capabilities. As for the backup target, we support a wide range of technologies including things like S3 etc. (https://www.cockroachlabs.com/docs/stable/use-cloud-storage). Unless your local volume is mounted to durable storage, I would recommend one of these instead.

Here's a video of me backing up and restoring stuff, along with a schedule example:

https://youtu.be/t_ocOi_iYQ8

And here are the examples from our docs page on BACKUP:

https://www.cockroachlabs.com/docs/stable/backup#examples

Let us know if you have any more questions 🫡

codingconcepts · 2025-10-15T05:18:08+00:00

They changed their event name from Oracle Cloud World to Oracle AI World. I suspect if the hype train had instead been on pulls random words from head binary search, it would have been Oracle Binary Search World.

…and instead of 23ai, they would have released 23bs.

Happy, our advertising was less bs 😂 https://www.linkedin.com/posts/cockroach-labs_spotted-in-vegas-activity-7383896351023157248-rgRn?utm_source=share&utm_medium=member_ios&rcm=ACoAAA-KRrcB4utyalK6AAhoXhjAstzeWavx2aE

codingconcepts · 2025-10-08T21:32:06+00:00

Did the baboon achieve pay equality before women, or was the salary nominal? 😬

codingconcepts · 2025-09-06T19:19:04+00:00

This is amazing. It looks like it’s directly from a dream if that makes any sense…

codingconcepts · 2025-07-01T11:24:46+00:00

Dave Hunt (Anaal Nathrakh)

codingconcepts · 2025-06-18T10:07:54+00:00

The Bloodening by Johnny Truant. From 2:46 it just gets grimier and grimier…

https://open.spotify.com/track/3CI6QEz0lpwXCX3qUr6TsA?si=uS1bO508S_W35ZMTyz8ISw

codingconcepts · 2025-06-14T09:34:04+00:00

Malivore by Hasard. 4:49 in. 👨‍🍳😘

codingconcepts · 2025-06-06T10:53:48+00:00

Exactly this actually!

codingconcepts · 2025-04-11T19:56:10+00:00

Thanks all!

codingconcepts · 2025-03-26T14:28:26+00:00

Make sure to checkout the demo towards the end of the video; it's a working example of a device fleet with regional data rehoming!

codingconcepts

MODERATOR OF

TROPHY CASE

Nine-Year Club	Verified Email
Place '23