Featured Blog Texture

Blog

View all

SQLSmith Header IMG 2 copy

Product

Single sign-on: Connect your IdP to CockroachDB

There are two different ways to use CockroachDB as a managed service and enjoy DBaaS benefits: CockroachDB Dedicated is a fully managed single-tenant service used by companies to store their data while adhering to their enterprise compliance requirements. CockroachDB Serverless offers automatically scalable service for building new and nimble applications while paying for only what you use.

Abhinav Garg

July 18, 2022

selective-encryption

CockroachDB CMEK: User-controlled encryption for data protection

CockroachDB Dedicated and CockroachDB Serverless — CockroachDB’s fully managed DBaaS offerings — allows global organizations to focus on building groundbreaking applications and let the database handle their transactional data at required scale, with high availability and multi region disaster proofing capability. These customers trust CockroachDB to store their data in a secure manner with guardrails similar to what they would implement in their own infrastructure.

Abhinav Garg

July 14, 2022

automated-rebalance-by-rebekka-dunlap

Product

Tech trends and challenges in the retail industry

Tomorrow, as you undoubtedly know, is day-one of an annual two-day retail event known as “Amazon Prime Day”. Two days of frenetic consumerism that stress Amazon’s architecture in much the same way that Black Friday and Cyber Monday stress the whole retail industry. In 2018 Amazon’s site served a 404 error for hours on Prime Day. But there’s no need to pick on Amazon…J. Crew, Macy’s, H&M, Lowes and others have all endured costly downtime during peak traffic. Three years of masks and stay-at-home mandates forced users to online shopping and forced retailers to scale their online operations to serve unprecedented customer volume. Some even had to establish their first-ever digital presence in order to survive widespread lockdowns that shuttered physical retailers. Survivability established, next came the need to meet equally unrelenting customer demands for fast and personalized user experiences across a vast spectrum of digital devices and platforms. Now elastic scalability, sophisticated personalization, and a seamless omnichannel experience are simply table stakes for modern retail organizations. That’s why choosing the right database infrastructure has become a business imperative. Not just to support surging high-transaction workloads, but also to ensure survival in the face of several dire trends facing retailers today.

 Michelle Gienow

Michelle Gienow

July 11, 2022

distributed-sql

Product

SQL vs. NoSQL: Which is right for your workload?

In simple terms, a relational (SQL) database stores structured data that conforms to a predefined schema. A document-model (or NoSQL) database stores documents that may contain unstructured data without a schema. At least, that’s the way that these two database storage models have traditionally been discussed.

jim

Jim Walker

July 7, 2022

rails app

applications

How to build a complete web app with Rails and CockroachDB

To show how easy it is to use CockroachDB in a real-world project, we’re going to build and deploy a production-ready application with basic CRUD functionality. Together, we’ll build a Ruby on Rails application that simulates a game leaderboard, using Active Record to talk with our CockroachDB Serverless database. Cockroach Labs maintains the ActiveRecord Adapter Gem, a direct extension of the PostgreSQL adapter. This makes it very straightforward to switch from a default option to CockroachDB. We’ll be using Ruby 3.0 to build a Rails app running Rails version 6.1.4. At the end of the tutorial, we’ll deploy the application to the internet on Heroku, which is running on AWS behind the scenes.

Rain Leander

July 6, 2022

sqlsmith header img 2

Community

Culture

4 beginner-friendly coding livestreams to learn programming

These past two years have been a kind of golden age code livestreams. Stuck at home, developers took to their OBS setups to share their coding projects with their peers. And viewers tuned in to watch a fellow developer struggle through a programming issue, get stuck, google things, and eventually figure things out, and found their coding communities in the process.

Amruta Ranade

Amruta Ranade

June 30, 2022

sqlsmith header img 2

Product

What is the best price for performance CPU in 2022: AMD vs. Intel

One of the most interesting questions we get to dig into in our annual Cloud Report is which CPUs offer the best performance – and more importantly, the best price for performance – for large OLTP workloads. To answer that question (among others) we test dozens of instance types across the three major public clouds – AWS, GCP, and Azure.

charlie

Charlie Custer

June 29, 2022

django-tutorial

applications

How to build a multi-region Python app with CockroachDB, Django, and K8s

Learn how to make your Python application multi-region. And then learn how to domicile data at the row level for better application performance and compliance with regulations.

Mike Bookham

June 27, 2022

blog4 (1)

System

What is SELECT FOR UPDATE in SQL (with examples)?

Relational databases are great for transactional workloads. But things can get messy when multiple transactions start trying to access the same data at the same time. Luckily, in many SQL databases there’s a solution for that: SELECT FOR UPDATE.

charlie

Charlie Custer

June 27, 2022

Page 38 of 86

Get started for free

bg callout one