The Distributed SQL Blog

Using the PostgreSQL Recursive CTE – Part One

March 1, 2021

Databases Distributed SQL How To PostgreSQL

Using the PostgreSQL Recursive CTE – Part One

Traversing an employee hierarchy

YugabyteDB is an open source, high-performance distributed SQL database built on a scalable and fault-tolerant design inspired by Google Spanner. YugabyteDB uses its own special distributed document store called DocDB. But it provides SQL and stored procedure functionality by re-using the “upper half” of the standard PostgreSQL source code. This is explained in the two part blog post “Distributed PostgreSQL on a Google Spanner Architecture”: (1) Storage Layer;

…

YSQL Development Fundamentals Training Recap – Feb 25, 2021

February 26, 2021

By Jimmy Guerrero

Community News Databases Distributed SQL

YSQL Development Fundamentals Training Recap – Feb 25, 2021

Yesterday we delivered our free “YSQL Development Fundamentals” community training and certification class. A special thanks to Karen Tamrazyan and a variety of Meetup groups for hosting and helping promote the event! If you weren’t able to make it, here’s what you missed…

Course Content

In this 90 min training aimed at beginner and intermediate SQL developers, we’ll covered the following topics:

YugabyteDB Architecture Review
Local 3-Node Installation
Basic Administration
Installing a Sample Database
Configuring Graphical SQL Development Tools
Working with the YSQL Shell
Schemas and Databases
Table Management
Data Types
Data Manipulation
Queries
Joins

We worked through almost 80 exercises that showed how developers can immediately leverage their PostgreSQL knowledge and apply it to YugabyteDB.

…

YugabyteDB: Reimagining the RDBMS for the Cloud

February 25, 2021

By Karthik Ranganathan

Community News Company News Databases Distributed SQL How It Works Open Source

YugabyteDB: Reimagining the RDBMS for the Cloud

Perspectives from 5 years of building a cloud native database

YugabyteDB just turned 5 years old, and I cannot help but reminisce about our journey in building this database over the last half-decade. I vividly remember the genesis of the YugabyteDB project, which started with Kannan, Mikhail, and myself meeting for lunch at a restaurant to discuss the future of cloud native databases. After iterating on the idea over a number of such discussions,

…

Achieving GDPR Compliance with YugabyteDB

February 23, 2021

By Cyrus Wadia

Community News Databases Distributed SQL How It Works

Achieving GDPR Compliance with YugabyteDB

Editor’s note, this is the second post in the series:

Part 1: Achieving Compliance with YugabyteDB
Part 2: Achieving GDPR Compliance with YugabyteDB (this post)

This is the second in a series of posts about how different compliance and regulatory frameworks work and how YugabyteDB can be an essential part of a company’s compliance efforts. This installment focuses on the EU’s General Data Protection Regulation (GDPR),

…

Measuring the Performance Impact of TLS Encryption Using TPC-C

February 22, 2021

By Taylor Mull

Databases Distributed SQL How To Performance Benchmarks

Measuring the Performance Impact of TLS Encryption Using TPC-C

Organizations need to protect their data, especially the personal data entrusted to them from their users and customers. In order to do so, the data transferred by a database over the network needs to be secure. This is often accomplished using TLS encryption, an encryption protocol that secures communication across a network. When secured by TLS, a communication between a client and a server can enable the two parties to identify one another (preventing any impersonation),

…

February 19, 2021

By Sanket Kedia

Community News Company News Databases Distributed SQL

The Average Dreamer

Editor’s note: Yugabyte is hiring! See all the job openings and consider applying.

Intro

Does any of this ring familiar to you:

“I don’t think that I am making any contribution to the overall growth of the organization.”

“It’s not only about the growth of the organization, it’s about your growth. Both go hand in hand. These tasks might seem trivial to you but they are very important so that you get comfortable.”

Ever heard these words from your manager?

…

February 17, 2021

By Cyrus Wadia

Community News How It Works

Achieving Compliance with YugabyteDB

This is the first in a series of posts about how different compliance and regulatory frameworks work and how YugabyteDB can be an essential part of a company’s compliance efforts. This installment is an overview of the different international compliance frameworks companies encounter on their journeys with customers.

What’s the Purpose of a Compliance Framework?

A compliance framework is a set of guidelines, baselines and best practices used by companies to establish internal controls to meet regulatory requirements,

…

February 10, 2021

By Amey Banarse

Community News Company News Databases Distributed SQL Release Announcements

Announcing YugabyteDB 2.4

Run mission-critical applications at scale with enterprise-grade SLAs and security

Our mission at Yugabyte is to build the default distributed SQL database for cloud native applications in a multi-cloud world. We have been accelerating on this mission by bringing new features, growing our user base, and making our software as robust as possible. Today we are excited to announce the general availability of YugabyteDB 2.4 which includes major enhancements and provides enterprise-grade stability allowing you to deploy YugabyteDB in production environments.

…

How We Learned to Stop Guessing and Love Low P-Values

February 8, 2021

By Rob Sami

Databases Distributed SQL How To Performance Benchmarks

How We Learned to Stop Guessing and Love Low P-Values

“I don’t think it’s quite fair to condemn the whole program because of a single slip up, sir.” Famous last words from Kubrick’s 1964 classic Dr. Strangelove, as a forlorn general realizes his negligence is about to lead to nuclear apocalypse. This may feel relatable to any engineer who has immediately regretted pushing the big red “release” button only to later find themselves putting out fires late into the night.

…

February 4, 2021

By Eric Pratt

Databases Distributed SQL How To

Secondary Index Migration in YugabyteDB

Introduction

YugabyteDB has a great feature in strongly consistent secondary indexes. I have been asked a few times now about how to modify existing indexes. These can range from adding another column to the index or adding another column to the INCLUDE clause. The big question at the end of the day is: how to do this without having to take downtime on the indexes? In this blog post, using the Yugabyte CQL API we will look at how to switch a live running application from using one index to another without a performance hit during the transition,

…