Distributed SQL Library | Page 27 of 34

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.

…

Distributed SQL Tricks and Tips – Jan 10, 2019

January 9, 2020

By Dorian Hoxha

Distributed SQL PostgreSQL

Distributed SQL Tricks and Tips – Jan 10, 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, Forum, GitHub or Stackoverflow. We’ll also review upcoming events, new blogs and documentation.

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

…

Getting Started with DbSchema on a Distributed SQL Database

January 7, 2020

By Jimmy Guerrero

Distributed SQL Ecosystem Integrations How To PostgreSQL

Getting Started with DbSchema on a Distributed SQL Database

If you’re a database developer, you know the time saving value of being able to visually design, document and query SQL and NoSQL databases from a single UI. DbSchema is a well-rounded, visual database tool that supports over 40 databases from a single interface. Because YugabyteDB is PostgreSQL compatible, getting DBSchema to work with a distributed SQL database is relatively simple.

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.

…

Announcing the Kafka Connect YugabyteDB Sink Connector

January 6, 2020

By Andrew Nelson

Distributed SQL Ecosystem Integrations Kafka

Announcing the Kafka Connect YugabyteDB Sink Connector

For customers that run Kafka for their streaming data platform, the Kafka Connect Sink plugin handles delivery of specific topic data to a YugabyteDB instance. As soon as new messages are published, the Sink manages forwarding and automatic addition to a destination table.

YugabyteDB is a high-performance, distributed SQL database built on a scalable and fault-tolerant design inspired by Google Spanner. Yugabyte’s SQL API (YSQL) supports most of PostgreSQL’s functionality and is wire-protocol compatible with PostgreSQL drivers.

…

Distributed SQL Tricks and Tips – Dec 20, 2019

December 20, 2019

By Jimmy Guerrero

Distributed SQL How It Works How To PostgreSQL

Distributed SQL Tricks and Tips – Dec 20, 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:

How can I update a JSONB document in YugabyteDB?

…

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.

…

YugabyteDB Community Update, Tricks and Tips – Dec 13, 2019

December 13, 2019

By Dorian Hoxha

Community News Databases Distributed SQL How It Works PostgreSQL

YugabyteDB Community Update, Tricks and Tips – Dec 13, 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, Forum, GitHub or Stackoverflow. We’ll also review upcoming events, new blogs and documentation. Ok, let’s dive right in:

How best to configure clusters across deployment types

Ava over on StackOverflow asked how to best setup configurations for different deployment models like single AZ,

…

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.

…

Getting Started with PostgreSQL’s Row Level Security in YugabyteDB

December 3, 2019

By Jimmy Guerrero

Distributed SQL How To PostgreSQL

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.

…

Distributed SQL

How can I update a JSONB document in YugabyteDB?

YSQL Changes

How best to configure clusters across deployment types

YugabyteDB 2.0.7 Release Notes

YSQL

Explore Distributed SQL and YugabyteDB in Depth