Start Now

Simplify data migration and embrace a cloud native architecture with YugabyteDB Voyager!

Learn More

Author: Jimmy Guerrero

YugabyteDB Tricks and Tips – Dec 6, 2019

YugabyteDB Tricks and Tips – Dec 6, 2019

Welcome to this week’s tips and tricks blog where we recap some distributed SQL questions from around the Internet. We’ll also review upcoming events, new blogs and documentation that has been published since the last blog. Got questions? Make sure to ask them on our YugabyteDB Slack channel, Forum, GitHub or Stackoverflow. Ok, let’s dive right in:

Do you have any plans to support UTF8MB4 like MySQL does?

Read more

Getting Started with PostgreSQL’s Row Level Security in YugabyteDB

Getting Started with PostgreSQL’s Row Level Security in YugabyteDB

In this blog post we are going to introduce you to how PostgreSQL’s row level security feature works in the latest YugabyteDB 2.0.6 release. YugabyteDB supports RLS and a host of other security and encryption features “out-of-the-box,” as part of the open source distribution.

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.

Read more

YugabyteDB Engineering Update – Nov 27, 2019

YugabyteDB Engineering Update – Nov 27, 2019

We are pleased to announce that YugabyteDB 2.0.6 is live!  You can read the official release notes of this and previous versions here. This release is shipping with almost 30 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

YSQL changes

  • Transparent read restarts for general queries.

Read more

YugabyteDB Engineering Update – Nov 20, 2019

YugabyteDB Engineering Update – Nov 20, 2019

We are pleased to announce that YugabyteDB 2.0.5 is live!  You can read the offical release notes of this and previous versions here. This release is shipping with over 40 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. YugabyteDB’s SQL API (YSQL) and drivers are PostgreSQL wire compatible

YSQL changes

  • Change HINT text for unsupported “alter procedure/function”.

Read more

YugabyteDB Engineering Update – Oct 30, 2019

YugabyteDB Engineering Update – Oct 30, 2019

We are pleased to announce that YugabyteDB 2.0.3 is live! You can read the release notes of this and previous versions here. This release is shipping with 50 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. YugabyteDB’s SQL API (YSQL) and drivers are PostgreSQL wire compatible

[#1845] YSQL: Support for TLS Server to Server Encryption

TLS encryption is now supported between yb-master and yb-tserver processes.

Read more

Working with PostgreSQL Data Types in YugabyteDB

Working with PostgreSQL Data Types in YugabyteDB

In the world of databases, data types restrict what can be considered as valid values in a table’s column. For example, if we want a column to store only integer values, we can specify that the column be an int column. Enforcing what type of data can go into a column has the added benefit of helping with storage and in some cases, query performance.

Generically, SQL data types can be broadly divided into following categories.

Read more

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

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

Learn More to Accelerate Your Retail Business

Ready to dive deeper into distributed SQL, YugabyteDB, and Yugabyte Cloud?
Learn at Yugabyte University
Learn More
Browse Yugabyte Docs
Read More
Join the Yugabyte Community
Join Now