YugabyteDB Library | Page 12 of 16

January 14, 2020

Four Data Sharding Strategies We Analyzed in Building a Distributed SQL Database

A distributed SQL database needs to automatically partition the data in a table and distribute it across nodes. This is known as data sharding and it can be achieved through different strategies, each with its own tradeoffs. In this post, we will examine various data sharding strategies for a distributed SQL database, analyze the tradeoffs, explain the rationale for which of these strategies YugabyteDB supports and what we picked as the default sharding strategy.

…

YugabyteDB Engineering Update – Jan 8, 2020

January 8, 2020

By Jimmy Guerrero

Community News Distributed SQL PostgreSQL YugabyteDB

YugabyteDB Engineering Update – Jan 8, 2020

We are pleased to announce that YugabyteDB 2.0.9 launched over the holidays and YugabyteDB 2.0.10 is now live! You can read the official release notes of this and previous versions here. These two releases shipped with a combined 36 new enhancements and 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) is PostgreSQL wire compatible.

…

YugabyteDB Engineering Update – Dec 19, 2019

December 18, 2019

By Jimmy Guerrero

Community News Distributed SQL How It Works How To PostgreSQL YugabyteDB

YugabyteDB Engineering Update – Dec 19, 2019

We are pleased to announce that YugabyteDB 2.0.8 is live! You can read the official release notes of this and previous versions here. This release is shipping with 12 new enhancements and 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) is PostgreSQL wire compatible.

YSQL Changes

Enable client-to-server TLS encryption for the postgres process in case use_client_to_server_encryption is set to true.

…

Four Compelling Use Cases for PostgreSQL Table Functions

December 16, 2019

By Bryn Llewellyn

How It Works PostgreSQL YugabyteDB

Four Compelling Use Cases for PostgreSQL Table Functions

Take a look at four realistic use cases that call for PostgreSQL user-defined table functions and see how each is met using complete, self-contained code examples.

Implementing PostgreSQL User-Defined Table Functions in YugabyteDB

December 16, 2019

By Bryn Llewellyn

How It Works PostgreSQL YugabyteDB

Implementing PostgreSQL User-Defined Table Functions in YugabyteDB

Learn how to implement user-defined table functions, in all variants, using generalized use cases.

An Introduction to PostgreSQL Table Functions in YugabyteDB

December 16, 2019

By Bryn Llewellyn

How It Works PostgreSQL YugabyteDB

An Introduction to PostgreSQL Table Functions in YugabyteDB

Read through an introduction to PostgreSQL’s table functions and their use in distributed SQL databases. The blog series will cover the basics of table functions, the use of built-in SQL table functions, and the implementation of user-defined table functions.

YugabyteDB Engineering Update – Dec 9, 2019

December 9, 2019

By Jimmy Guerrero

Community News Databases Distributed SQL PostgreSQL YugabyteDB

YugabyteDB Engineering Update – Dec 9, 2019

We are pleased to announce that YugabyteDB 2.0.7 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) is PostgreSQL wire compatible

YugabyteDB 2.0.7 Release Notes

YSQL

Transparent read restarts for general queries.

…

YugabyteDB Engineering Update – Nov 27, 2019

November 27, 2019

By Jimmy Guerrero

Community News Distributed SQL PostgreSQL YugabyteDB

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.

…

YugabyteDB Engineering Update – Nov 20, 2019

November 20, 2019

By Jimmy Guerrero

Community News Distributed SQL PostgreSQL YugabyteDB

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”.

…

YugabyteDB Engineering Update – Oct 30, 2019

October 30, 2019

By Jimmy Guerrero

Community News Distributed SQL PostgreSQL YugabyteDB

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.

…

YugabyteDB

YSQL Changes

YugabyteDB 2.0.7 Release Notes

YSQL

YSQL changes

YSQL changes

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

Explore Distributed SQL and YugabyteDB in Depth