The Distributed SQL Blog

Polymorphism in SQL part two – variadic functions

June 25, 2020

Databases Distributed SQL How To PostgreSQL

Polymorphism in SQL part two – variadic functions

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; and (2) Query Layer.

…

Polymorphism in SQL part one – anyelement and anyarray

June 24, 2020

By Bryn Llewellyn

Databases Distributed SQL How It Works PostgreSQL

Polymorphism in SQL part one – anyelement and anyarray

The term “polymorphism”, and its inflections, has various meanings in the context of programming languages in general. Roughly, it means “chameleon-like”. Of course, Wikipedia has something to say about it, here. PostgreSQL uses it with this meaning: “Parametric polymorphism: when one or more types are not specified by name but by… symbols that can represent any type”.

The term “variadic” has a universal meaning,

…

What’s New and Improved in YugabyteDB Docs

June 23, 2020

By Steve Bang

Databases Distributed SQL

What’s New and Improved in YugabyteDB Docs

Welcome to our first blog post focused on what’s new and improved in YugabyteDB Docs. We’re continually adding to and updating the documentation to give you the information you need to make the most out of YugabyteDB. This post covers recent content added, and changes made, to the YugabyteDB documentation. Before jumping into new content, the first section covers the efforts we’ve made to help you quickly find the answers you’re looking for.

…

SQL Puzzle: Partial Versus Expression Indexes

June 18, 2020

By Karthik Ranganathan

Databases Distributed SQL PostgreSQL

SQL Puzzle: Partial Versus Expression Indexes

Here is an intriguing SQL puzzle we came across in the context of a real-world use case. This post shows the power of advanced RDBMS features such as partial indexes and expression indexes.

Let us assume we have a table in PostgreSQL named users, where each row in the table represents a user. The table is defined as follows.

CREATE TABLE users (
id SERIAL PRIMARY KEY,
email VARCHAR DEFAULT NULL,
name VARCHAR
);

…

Real-Time Scalable GraphQL and JAMstack with Gatsby, Hasura, and YugabyteDB

June 17, 2020

By Vladimir Novick

Databases Distributed SQL GraphQL How To

Real-Time Scalable GraphQL and JAMstack with Gatsby, Hasura, and YugabyteDB

JAMstack is a new way of building websites and apps. It’s not a technology but rather an architectural pattern that is growing in popularity. In JAMstack, the JAM acronym stands for JavaScript, API, and Markup, and the main idea behind the technology is that web applications don’t have to rely on the application server to be fully functional and robust.

There are four primary benefits of adopting a JAMstack architecture.

Higher performance driven by efficient use of static assets and Content Delivery Networks (CDNs).

…

June 11, 2020

By Karthik Ranganathan

Community News Distributed SQL Open Source

100% Committed to Open Source, YugabyteDB Community Update – June 11, 2020

While it is still early days, it is exciting to see the YugabyteDB community hit some cool milestones! We wanted to share them with you, plus update you some additional community related news.

Our Commitment to Social Justice

First things first. Recent events that resulted in the death of George Floyd at the hands of police have been traumatic and painful for many of us, nationally and globally. It’s clear there is an overwhelming need for racial justice,

…

June 9, 2020

By Kannan Muthukkaruppan

Company News Distributed SQL

Yugabyte Raises a $30 Million Series B

It is my pleasure to announce that Yugabyte has raised $30 million in an oversubscribed Series B funding round led by 8VC, with participation from Wipro Ventures and existing investors, Lightspeed and Dell Technologies Capital. Bhaskar Ghosh from 8VC joins our board of directors along with Scott Yara, formerly of Greenplum and Pivotal Software. We are truly excited to partner with Bhaskar Ghosh and the dynamic team at 8VC,

…

Getting Started with Distributed SQL on Red Hat OpenShift with YugabyteDB Operator

June 4, 2020

By Nikhil Chandrappa

Company News Databases Distributed SQL How To

Getting Started with Distributed SQL on Red Hat OpenShift with YugabyteDB Operator

We are happy to announce that the YugabyteDB Operator is now certified and available as a Beta release on Red Hat OpenShift, a leading enterprise Kubernetes platform for deploying and managing cloud native applications. Achieving certification means that customers can deploy YugabyteDB on OpenShift with confidence because the YugabyteDB container image has been secured, validated, and is well-integrated to run on OpenShift. And the solution is backed by collaborative support between Red Hat and Yugabyte,

…

Highly Available Prometheus Metrics for Distributed SQL with Thanos on GKE

May 26, 2020

By Jimmy Guerrero

Databases Distributed SQL Google Cloud Platform How To Kubernetes

Highly Available Prometheus Metrics for Distributed SQL with Thanos on GKE

In the last few years, Prometheus has gained huge popularity as a tool for monitoring distributed systems. It has a simple yet powerful data model and query language, however, it can often pose a bit of a challenge when it comes to high availability as well as for historical metric data storage. Adding more Prometheus replicas can be used to improve availability, but otherwise, Prometheus does not offer continuous availability. For example, if one of the Prometheus replicas crashes,

…

Follow-up: Evaluating CockroachDB vs YugabyteDB Webinar

May 22, 2020

By Michelle Brinich

CockroachDB Compare and contrast YugabyteDB

Follow-up: Evaluating CockroachDB vs YugabyteDB Webinar

Earlier this week, Yugabyte CTO Karthik Ranganathan presented the live webinar: Evaluating CockroachDB vs YugabyteDB, with a spotlight on comparing PostgreSQL features, architecture, and the latest performance benchmarks between the two databases. We were delighted to see such interest in the topic, dive deeper into some of the topics we raised in parts 1 and parts 2 of the blog series, Bringing Truth to Competitive Benchmark Claims – YugabyteDB vs CockroachDB, and answer questions from the audience.

…

The Distributed SQL Blog

Our Commitment to Social Justice

Explore Distributed SQL and YugabyteDB in Depth