Distributed SQL

How to: PostgreSQL Fuzzy String Matching In YugabyteDB

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.

Read more

YugabyteDB Engineering Update – Oct 14, 2019

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,

Read more

2019 Distributed SQL Summit Recap and Highlights

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!

Read more

Recapping My Internship at Yugabyte – Jayden Navarro

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,

Read more

Getting Started with PostgreSQL Triggers in a Distributed SQL Database

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.

Read more

The Effect of Isolation Levels on Distributed SQL Performance Benchmarking

The Effect of Isolation Levels on Distributed SQL Performance Benchmarking

This post addresses a concern raised about a benchmarking result we recently published comparing the performance of YugabyteDB, Amazon Aurora and CockroachDB. It was pointed out that we unfairly used the default isolation level for each database rather than use serializable isolation level in all databases (even though serializable level was not required for these workloads). In addition, we are also happy to share additional results with the workloads run at YugabyteDB’s serializable isolation level.

Read more

Getting Started with TablePlus on a Distributed SQL Database

Getting Started with TablePlus on a Distributed SQL Database

If you’re a database developer, you already understand the importance of a tool to manage your databases. Whether it is for creating schemas, ad-hoc querying, backups, or diving deeper to troubleshoot a database issue, a database tool can make your life much easier and increase your productivity. In a previous posts we covered how to get started with DBeaver, PGAdmin, and SQL Workbench/J. in this post we’ll show you how to get up and running with YugabyteDB and TablePlus.

Read more

Explore Distributed SQL and YugabyteDB in Depth

Discover the future of data management.
Learn at Yugabyte University
Get Started
Browse Yugabyte Docs
Explore docs
PostgreSQL For Cloud Native World
Read for Free