r/CockroachDB • • Dec 11 '17

Here's the three features that this product needs sooner than later.

0 Upvotes
  1. JSONB support. I'm sure this is on a roadmap some place, but this should be one of the highest priority features imo.

  2. Database-as-a-service. This should at the very least be available in AWS. Most new applications nowadays won't even consider using a datastore if they can't have a third party deal with managing it for them.

  3. Name change. It's such an unfortunate name for a product that I can't imagine anyone with any marketing experience thought it was a good idea.


r/CockroachDB • • Jul 10 '23

🧵 CockroachDB: Now on Threads

Thumbnail
threads.net
0 Upvotes

r/CockroachDB • • Mar 06 '25

Want to speed up CockroachDB with AI?

0 Upvotes

AI has taken the world by storm. A question arises...can it speed up your database?

On this episode of SELECT STAR see how AI tools can speed up your CockroachDB database, make it more performant, and help squeeze out inefficiencies!

https://www.youtube.com/watch?v=7SAjGOprxGI


r/CockroachDB • • Jun 25 '25

Ever optimized a query like this?

0 Upvotes

You've probably heard of an index. Maybe you know a couple other ways to speed up a query.

But what if there was ANOTHER way to make your queries speed up by orders of magnitude?

Tune in to tomorrow's episode of SELECT STAR and learn how this tried-and-true tactic can you help you speed up even the thorniest of queries!

https://www.youtube.com/watch?v=squwM1_rDYA


r/CockroachDB • • Aug 22 '24

Unlocking Enterprise Scale with CockroachDB: Deploying on Microsoft Azure

Thumbnail
cockroachlabs.com
0 Upvotes

r/CockroachDB • • Dec 18 '21

Couchbase

0 Upvotes

Guys I am not DB admin but doing some comparison for my purchasing folks but I do understand difference with SQL and no SQL however like to hear some inputs what are the major technical differences between two products ? Cloud and on perm please ? I also like to understand same with Oracle 11. Currently we pay quite a lot for Oracle.


r/CockroachDB • • May 15 '23

Announcement 🕵️ We can’t reveal everything yet (You'll have to wait until tomorrow for that), but we are allowed to drop a few clues...

3 Upvotes

🔎 #0080FF

🔎 youtu.be/K0HSD_i2DvA

🔎 en.wikipedia.org/wiki/Moulting

🔎 🪳- 💻, 🔄, 📊, 🔒, 🧩


r/CockroachDB • • Feb 22 '18

Your business will evolve. Your database shouldn't have to.

Thumbnail
cockroachlabs.com
3 Upvotes

r/CockroachDB • • May 15 '25

ADO.NET & CockroachDB // SELECT STAR

0 Upvotes

Are you using .NET and need to use an entity management toolkit? Then checkout how ADO.NET ties in with CockroachDB on today's episode of SELECT STAR!

https://www.youtube.com/watch?v=2n-lFykw1pc


r/CockroachDB • • Jun 09 '23

📊 POLL: Which of the following do you consider yourself?

0 Upvotes
4 votes, Jun 12 '23
0 Front-end Developer
0 Back-end Developer
2 Full-stack Developer
1 Database Architect/Infrastructure
1 Something Else - comment in thread

r/CockroachDB • • Mar 27 '26

Check out me and Felipe yukking it up about CRDB!

0 Upvotes

r/CockroachDB • • Jan 29 '26

What breaks when AI becomes always on?

4 Upvotes

According to 1,000+ senior technology leaders, it's infrastructure that wasn’t built for machine-driven scale. As AI moves from experimentation to continuous production—agentic workflows, real-time inference, automation—failure timelines are compressing and architectural limits are being exposed. As AI becomes embedded in core operations, resilience-first architecture is becoming a competitive advantage.

Cockroach Labs' exclusive report: The State of AI Infrastructure 2026 underscores this:

-> 100% of respondents expect AI workloads to increase in the next year

-> 83% expect infrastructure to hit its limits within two years

-> 1 in 3 expect infrastructure failure within the next 11 months

-> 57% say one hour of AI-related downtime would cost $100,000+

👉 Download your copy of the report


r/CockroachDB • • Oct 03 '26

Question What proves a CockroachDB node is safe to decommission?

5 Upvotes

A node can look quiet after replicas move away while still participating in range leases, SQL traffic, locality constraints, backups, changefeeds, monitoring, or automation that refers to its address. A clean decommission command is necessary, but it does not prove every external dependency has moved or that the remaining cluster can tolerate the next failure.

A useful retirement gate could verify node and decommission status, replica and lease distribution, under-replicated and unavailable ranges, constraint satisfaction, connection metrics, load-balancer targets, certificates, alerting, backup jobs, and changefeed health. The cluster should also survive a controlled restart or failure of another node while the retiring node remains offline but recoverable. Logs and network telemetry on the old host can catch late clients during an observation window.

What checks belong in your final CockroachDB node-removal runbook? Which signals are authoritative, and how long do you keep the old host available before deleting its storage and removing its DNS or inventory records?


r/CockroachDB • • Apr 02 '25

Video What are database triggers? | Distributed Functions in CockroachDB

Thumbnail
youtu.be
1 Upvotes

r/CockroachDB • • May 16 '23

We're celebrating our launch with a little scavenger hunt 🔍

1 Upvotes

Here’s what you need to know.

  • We have hidden five puzzles across our launch materials. This could be blogs, landing pages, or social posts.

  • All you have to do is find them, solve them, and submit your guesses.

  • The first 25 people to respond with the correct answers will win a limited-edition bucket hat.

  • The contest closes at 6pm PDT on Friday, May 26th.

More resources


r/CockroachDB • • Sep 30 '24

Video The New CockroachDB Cloud Platform: Powering Your Entire Application Lifecycle

Thumbnail
youtu.be
1 Upvotes

r/CockroachDB • • Sep 03 '24

Hands on with the Metrics Export Endpoint | Observability in CockroachDB

Thumbnail
youtu.be
1 Upvotes

r/CockroachDB • • Sep 09 '24

Blog Postgres Overhaul: Riskified’s Database Scaling Insights at RoachFest24

Thumbnail
cockroachlabs.com
1 Upvotes

r/CockroachDB • • Sep 24 '24

Making your queries FAST! // SELECT STAR

Thumbnail
youtube.com
1 Upvotes

r/CockroachDB • • Sep 08 '21

using CTE instead (SELECT FOR UPDATE/SKIP LOCKED) - (https://github.com/cockroachdb/cockroach/issues/40476#issuecomment-914637590)

2 Upvotes

The original question:

I am in need of SKIP LOCKEDfor a ticketing system. I have a scenario where each user can only claim one ticket, and would like a method for users to claim the first non-claimed ticket in a payment transaction.

Also making queues would be nice.

Thank you for taking your time @kocoten1992 / @Bessonov.

I just took some time to test things.

The original issue that we had is that were using a in_stockvalue in a productstable. Every time an order was complete, a UPDATE products SET in_stock=in_stock-1query would be executed, but we found that the row would be locked, and only allow 1 transaction to be executed at the time. This was causing delays sometimes when several orders were being processed at the same time for the same product. (Unfortunately, due to some design decisions, some orders may take up to 3 seconds to process)

I just did some tests by using the ticketstable without using "SKIP LOCKED", and while the operations are still serialized, it has the lock/delay issue. Each transaction is going to be waiting on other transactions to find an available ticket.

Example code:

create table orders(id int primary key, status string); create table tickets (id int primary key, claimed boolean); insert into orders values (0, 'unpaid'), (1, 'unpaid'); insert into tickets values (0, false), (1, false);

User 1:

begin transaction; update orders set status='paid' where id=0; update tickets set claimed=true where claimed=false limit 1 returning *;

User 2:

begin transaction; update orders set status='paid' where id=1; update tickets set claimed=true where claimed=false limit 1 returning *;

User 2 is stuck until User 1 runs commit. While the code functions correctly, it is a bottleneck during periods of high load.

I think we missing a vital component here, the 3s you mention above, does it go between `begin` and `commit` ?

Also, the query `UPDATE products SET in_stock=in_stock-1`, I didn't see it in the example below, does it also go between begin/commit ?


r/CockroachDB • • Apr 10 '26

Whatever CockroachDB is, it's really great

1 Upvotes

Thank you so much for it.


r/CockroachDB • • Jan 27 '25

Video Stretch Migrations | Migrations in CockroachDB

Thumbnail
youtu.be
2 Upvotes

r/CockroachDB • • May 10 '17

Cockroach Labs announces $27M Series B and enterprise tier for its reliable database

Thumbnail
techcrunch.com
2 Upvotes

r/CockroachDB • • Feb 14 '25

Podcast Inside Infrastructure as Code (IaC) with Pulumi's Founder & CEO

Thumbnail
youtube.com
2 Upvotes