Blog
Product
DASH: How to evaluate Kubernetes-native databases
Cloud-native application architectures help developers deliver amazing experiences to their customers around the world. They do this by taking advantage of billions in cloud provider investments, which provide nearly unlimited and on-demand resources spread across hundreds of data centers globally.
Nate Stewart
July 29, 2021
Product
How to get started with CockroachDB Dedicated
Distributed, cloud-native databases are the future, but setting one up is complicated, right? It doesn’t have to be! In fact, you can register for free and set up a new CockroachDB Dedicated database in the time it takes to make a bowl of ramen:
Charlie Custer
July 28, 2021
Case Studies
Tutorials
How to do a Postgres database migration: Tips from LaunchDarkly
What’s the best way to do a database migration? It’s a challenging question. No single approach is going to be the best fit for every use case. However, after speaking with LaunchDarkly Senior Distributed Systems Engineer Justin Caballero in a recent webinar, we think LaunchDarkly’s migration from Postgres and MongoDB to CockroachDB presents some great database migration best practices.
Charlie Custer
July 26, 2021
Product
Sell globally, manage locally with distributed SQL
Retailers often function in distributed application environments, with data squirreled away in databases around the country, or even the globe. It’s totally common to use different solutions for different workloads — for example, Cassandra for fast data reads with Oracle as the primary system of record. Often these different apps each do their specific job well, but getting them to talk to each other? Not so good.
Michelle Gienow
July 23, 2021
Product
3 ways to master stateful apps in Kubernetes
Kubernetes adoption has massively accelerated, leading the way to a new, cloud-native approach to building and delivering the software that businesses need to make users happy and employees successful. Slow and heavy lifting has been replaced with interchangeable, self-contained software objects that can be configured by a simple configuration and scaled through automated replication. If an object fails, it is replaced. To deliver new software, objects are replaced while still in motion.
Sean Loiselle
July 22, 2021
How to identify and tune a problematic query with SQL EXPLAIN
As a developer, you are often faced with the question: why is my application slow? You may have already identified the database as the bottleneck (even this process can take some troubleshooting), and you then find yourself asking: Which queries are slow? Which queries should I be troubleshooting? The query troubleshooting journey starts by first isolating the offending query that is issued by your application.
Kevin Ngo
July 21, 2021
applications
Spatial data tutorial with Hibernate and CockroachDB
CockroachDB has gained powerful spatial data capabilities since the 20.2 release. One of the great things about this is that the spatial features are compatible with the excellent PostGIS spatial data extension for PostgreSQL (with some caveats). In my opinion, PostGIS is the gold standard for spatial data management. I’m the maintainer of Hibernate-Spatial: an optional module which extends Hibernate with spatial capabilities. I was asked by Cockroach Labs to write a spatial dialect for CockroachDB. This dialect was introduced in version 5.4.30.Final.
Karel Maesen
July 16, 2021
Kubernetes
How to run a database in Kubernetes
About 75 percent of container orchestration is done in Kubernetes. But the popularity of the k8s platform doesn’t mean it’s easy to use in all scenarios. Kubernetes can have a steep learning curve, especially when it comes to managing state and storage. In a recent episode of “The Cockroach Hour”, Director of Product Marketing Jim Walker sat down with Keith McClellan, one of Cockroach’s Solutions Engineers, to chat about the storage and data challenges that you’ll encounter deploying Kubernetes, and how running it with CockroachDB can simplify those challenges.
Charlotte Dillon
July 15, 2021
Case Studies
Choosing a MySQL alternative to build HA product inventory
AllSaints is a 27-year-old global fashion retail business headquartered in the UK. We have brick and mortar locations all over the world and historically the business has depended massively on brick and mortar sales. And so it came as a surprise and relief to me that our customers were so willing to shift their behaviors during the pandemic and shop online, which helped us maintain healthy revenue numbers.
Andy Dean
July 15, 2021