Serdar Yegulalp
Senior Writer

Open source SQL database CockroachDB hits 1.0

news
May 10, 20174 mins

Cockroach Labs is also offering its enterprise features as open source and trusting enterprises will pay for what they use in production

cockroach bug
Credit: Gary Alpert

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.

Highly available, highly distributable

Many of CockroachDB’s feature were inspired by the work underpinning Google Cloud Spanner, but CockroachDB is open source. It supports much of the functionality found in traditional SQL databases like MariaDB or PostgreSQL, such as SQL dialect support and  ACID transactions.

Cockroach Labs’ biggest claim is that CockroachDB can offer those features, plus scaling and resilience features similar to what’s found in NoSQL databases. A CockroachDB deployment with multiple nodes can serve not only reads but also writes, as long as at least three nodes are running somewhere.

Cockroach Labs’ long-term plans for this technology include what it calls geo-partitioning, where data can be replicated at the row level and moved to nodes where it will be closest to the customers that need it. In addition to providing a performance boost, Cockroach Labs is positioning this as a compliance solution, so data can be kept in the territories where it’s mandated to stay.

The commercial version, CockroachDB Enterprise, adds distributed and incremental backup and restore features. Many common blob storage systems are supported as back ends, such as AWS S3, and CockroachDB can run as a native presence in those cloud environments.

The enterprise honor system

Cockroach Labs’ approach to its enterprise edition is likely to raise eyebrows. In a phone interview, Cockroach Labs CEO Spencer Kimball noted that full source code will be available for the enterprise features in the same GitHub repository as the core project source code. Noncommercial entities, or those engaged in nonproduction use, can run the enterprise features “to their hearts’ content.” Enterprises that put the software into production have 30 days to negotiate a license and start receiving support.

Kimball said the company chose to do this both for the sake of getting customer feedback and to accelerate the product’s overall adoption. “Most early use cases aren’t in production,” he said. “This happens all the time in companies that adopt open source.” Later, when the product is put into production, the company can “come to grips” with the details of the licensing. 

There’s always the chance of abuse with an “honor system,” as Kimball characterized it. “If [a company] can use it by themselves, essentially in violation of the license, for a long time in production, and they’re a big company—that might happen. But ultimately I think it’s much better for us in the long term to have that permissiveness in the model.”

Kimball also doesn’t believe keeping software closed source provides protection against being imitated or flat-out ripped off. “The way you stay ahead of everyone else is to keep innovating,” he said.

Performance is one area where CockroachDB can continue to move things forward in the near term. Cockroach Labs co-founder Peter Mattis noted, in a Hacker News discussion, that while performance has been improving steadily up to the release of 1.0, “we still have a lot of work to do.” Mattis also noted that the emphasis thus far has been on scale and survivability, not performance. “CockroachDB 1.0 won’t be winning benchmarks, but that was never the goal,” he said.

Serdar Yegulalp

Serdar Yegulalp is a senior writer at InfoWorld. A veteran technology journalist, Serdar has been writing about computers, operating systems, databases, programming, and other information technology topics for 30 years. Before joining InfoWorld in 2013, Serdar wrote for Windows Magazine, InformationWeek, Byte, and a slew of other publications. At InfoWorld, Serdar has covered software development, devops, containerization, machine learning, and artificial intelligence, winning several B2B journalism awards including a 2024 Neal Award and a 2025 Azbee Award for best instructional content and best how-to article, respectively. He currently focuses on software development tools and technologies and major programming languages including Python, Rust, Go, Zig, and Wasm. Tune into his weekly Dev with Serdar videos for programming tips and techniques and close looks at programming libraries and tools.

More from this author