The Distributed SQL Blog

October 29, 2019

The Benefit of Partial Indexes in Distributed SQL Databases

If a partial index is used, instead of a regular one, on a nullable column—where only a small fraction of the rows have not null values for this column—then the response time for inserts, updates, and deletes can be shortened significantly. As a bonus, the response times for single row selects shorten a little bit too. This post explains what a partial index is, shows how to create one, describes the canonical use case that calls for a partial index,

…

How YugabyteDB Scales to More than One Million Inserts Per Second

October 22, 2019

By Karthik Ranganathan

How It Works Performance Benchmarks YugabyteDB

How YugabyteDB Scales to More than One Million Inserts Per Second

YugabyteDB is engineered to scale beyond 1 million inserts per second. It achieves this high level of performance through sharding and horizontal scaling, allowing it to support applications and services that need rapid data insertion and retrieval.

Working with PostgreSQL Data Types in YugabyteDB

October 21, 2019

By Jimmy Guerrero

How It Works PostgreSQL YugabyteDB

Working with PostgreSQL Data Types in YugabyteDB

In this blog post we’ll be focusing on PostgreSQL data types, and test their compatibility with YugabyteDB. You can find a quick list of supported data types in our docs.

YugabyteDB Community Engineering Update, Tricks and Tips – Oct 18, 2019

October 18, 2019

By Dorian Hoxha

Community News How It Works How To Week in Review

YugabyteDB Community Engineering Update, Tricks and Tips – Oct 18, 2019

Welcome to this week’s community update where we recap a few interesting questions that have popped up in the last week or so on the YugabyteDB Slack channel, the Forum, GitHub or Stackoverflow. We’ll also review upcoming events, new blogs and documentation that has been published since the last update. Ok, let’s dive right in:

Running yb-ctl status does not give node information

Question

AndrewLiuRM over on the forums asked why the yb-ctl command doesn’t give node information when issued after a manual deployment onto a Docker container.

…

9 Techniques to Build Cloud-Native, Geo-Distributed SQL Apps with Low Latency

October 17, 2019

By Sid Choudhury

Distributed SQL Geo-Distribution How To

9 Techniques to Build Cloud-Native, Geo-Distributed SQL Apps with Low Latency

This post is an in-depth look at the various techniques that applications needing low latency and high availability can leverage while using a geo-distributed SQL database like YugabyteDB so that the negative impacts of a high-latency, unreliable Wide Area Network (WAN) are minimized.

How to: PostgreSQL Fuzzy String Matching In YugabyteDB

October 15, 2019

By Jimmy Guerrero

Distributed SQL PostgreSQL

How to: PostgreSQL Fuzzy String Matching In YugabyteDB

Before analyzing a large dataset that contains textual information, it’s important to scrub it and eliminate duplicates when necessary. To remove duplicates, you may need to compare strings referring to the same thing, but that may be written slightly different, have typos or were misspelled. Alternatively, you might need to join two tables on a column (let’s say on company name), and these can appear slightly different in both tables.

Fuzzy String Matching (or Approximate String Matching) is the process of finding strings that approximately match a pattern.

…

YugabyteDB Engineering Update – Oct 14, 2019

October 14, 2019

By Jimmy Guerrero

Community News Distributed SQL Week in Review YugabyteDB

YugabyteDB Engineering Update – Oct 14, 2019

We are pleased to announce that YugabyteDB 2.0.1 is live! You can read the release notes of this and previous versions here. This release is shipping with 36 new enhancements and bug fixes.

What’s YugabyteDB? It is an open source, high-performance distributed SQL database built on a scalable and fault-tolerant design inspired by Google Spanner. Yugabyte’s SQL API (YSQL) and drivers are PostgreSQL wire compatible

[#1851] YSQL: Support for Pushdown of Aggregate Queries

With the YCQL API,

…

2019 Distributed SQL Summit Recap and Highlights

October 2, 2019

By Jimmy Guerrero

Amazon Aurora CockroachDB Community News Distributed SQL Google Spanner PostgreSQL

2019 Distributed SQL Summit Recap and Highlights

Well, that’s a wrap! Yugabyte would like to extend a special thanks to JD and Amanda from the Postgreconf.org team, and to all the speakers from Facebook, Google, Amazon, Pivotal, Salesforce, Narvar, Plume Design and others that presented at the first-ever Distributed SQL Summit on Sept 20, 2019.

If you couldn’t make it out to this year’s event, have no fear!

…

Recapping My Internship at Yugabyte – Jayden Navarro

October 1, 2019

By Jayden Navarro

Distributed SQL How It Works

Recapping My Internship at Yugabyte – Jayden Navarro

It was a warm day in early October, and two large white tents occupied the lawn that sits between the Gates, Hewlett, and Packard buildings. Companies pasted the word “AI” in big bold letters across their banners, and students formed long lines, resumes in-hand, eager to learn about the Next Big Thing and how often the company cafeteria serves Poké.

Six months prior I had made the decision to leave my comfortable job as a Software Engineer in the networking industry and pursue a Masters degree in Computer Science at Stanford,

…

Getting Started with PostgreSQL Triggers in a Distributed SQL Database

September 24, 2019

By Jimmy Guerrero

Distributed SQL How It Works How To PostgreSQL

Getting Started with PostgreSQL Triggers in a Distributed SQL Database

Triggers are a basic feature that all monolithic SQL systems like Oracle, SQL Server and PostgreSQL have supported for many years. They are very useful in a variety of scenarios ranging from simple audit logging, to advanced tasks like updating remote databases in a federated cluster. In this blog, we’ll look at examples of INSERT, UPDATE and INSTEAD OF triggers in Yugabyte DB.

What’s Yugabyte DB? It is an open source, high-performance distributed SQL database built on a scalable and fault-tolerant design inspired by Google Spanner.

…

The Distributed SQL Blog

Running yb-ctl status does not give node information

Question

[#1851] YSQL: Support for Pushdown of Aggregate Queries

Explore Distributed SQL and YugabyteDB in Depth