The Distributed SQL Blog

February 19, 2020

Developing Reactive Microservices with Spring Data and Distributed SQL

In 2016 in the keynote presentation of Spring One Platform, Juergen Hoeller announced Spring WebFlux, one of the most highly anticipated projects being worked on by the Spring Team due to the performance gains that reactive streams promised for web controllers. Subsequently, with Spring Framework 5.0, Spring Reactive MVC went GA along with the release of WebFlux API, making the reactive stream based web controller mainstream.

Fast-forward to 2020, Spring WebFlux MVC has gained wide adoption in cloud native applications,

…

Natural versus Surrogate Primary Keys in a Distributed SQL Database

February 18, 2020

By Bryn Llewellyn

Databases Distributed SQL PostgreSQL

Natural versus Surrogate Primary Keys in a Distributed SQL Database

There’s a subtle, but critical, difference between the two notions business-unique key and primary key in a relational database. For example, in a “users” table, the “user_id” could be the primary key while the “email_address” (which must be not null and unique) could be the business-unique key. The columns that implement each notion may or may not coincide. This post shows that,

…

Distributed SQL Tips and Tricks – Feb 14, 2020

February 14, 2020

By Jimmy Guerrero

Community News Databases Distributed SQL How To PostgreSQL

Distributed SQL Tips and Tricks – Feb 14, 2020

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 documentation and blogs that have been published since the last post. 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 get the JSON output of distinct columns?

…

Distributed SQL Tips and Tricks – Feb 7, 2020

February 7, 2020

By Dorian Hoxha

Databases Distributed SQL How To PostgreSQL

Distributed SQL Tips and Tricks – Feb 7, 2020

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 documentation and blogs that have been published since the last post. Got questions? Make sure to ask them on our YugabyteDB Slack channel, Forum, GitHub or Stackoverflow. Ok, let’s dive right in:

Does YugabyteDB have an in-memory storage engine?

…

Distributed SQL Tips and Tricks – Jan 31, 2020

January 31, 2020

By Jimmy Guerrero

Community News Databases Distributed SQL How It Works PostgreSQL

Distributed SQL Tips and Tricks – Jan 31, 2020

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 documentation, and blogs that have been published since the last post. Got questions? Make sure to ask them on our YugabyteDB Slack channel, Forum, GitHub, or Stackoverflow. Ok, let’s dive right in:

Can I specify the number of tablets I want a table to have?

…

YugabyteDB Engineering Update – Jan 29, 2020

January 29, 2020

By Jimmy Guerrero

Distributed SQL PostgreSQL YugabyteDB

YugabyteDB Engineering Update – Jan 29, 2020

We are pleased to announce that YugabyteDB 2.0.11 is now live! You can read the official release notes of this and previous versions here. These two releases shipped with a combined 30+ 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 API

Fix txn conflict issues due to absence of cotable ID in DocKey.

…

January 28, 2020

By Sid Choudhury

Compare and contrast Distributed SQL

Distributed SQL vs. NewSQL

In this post, we compare distributed SQL databases against NewSQL databases to better understand their differences and know when you should use either.

Distributed SQL Tips and Tricks – Jan 24, 2020

January 24, 2020

By Jimmy Guerrero

Community News Distributed SQL How To

Distributed SQL Tips and Tricks – Jan 24, 2020

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 documentation and blogs that have been published since the last post. Got questions? Make sure to ask them on our YugabyteDB Slack channel, Forum, GitHub or Stackoverflow. Ok, let’s dive right in:

What is the performance impact of deleting tombstones in YugabyteDB?

…

How to Migrate the Sakila Database from MongoDB to YugabyteDB with Studio 3T

January 23, 2020

By Jimmy Guerrero

Database Migration Databases How To MongoDB

How to Migrate the Sakila Database from MongoDB to YugabyteDB with Studio 3T

Data migration can be a complex and time-consuming task, but proper planning can help streamline the process. In this blog, we’ll demonstrate how to migrate a Sakila demo database from MongoDB to a YugabyteDB cluster using Studio 3T, highlighting the key steps and considerations involved in the process.

Distributed SQL Tricks and Tips – Jan 17, 2020

January 17, 2020

By Jimmy Guerrero

Community News Distributed SQL How It Works PostgreSQL

Distributed SQL Tricks and Tips – Jan 17, 2020

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 documentation and blogs that have been published since the last post. Got questions? Make sure to ask them on our YugabyteDB Slack channel, Forum, GitHub or Stackoverflow. Ok, let’s dive right in:

What’s YugabyteDB? It is an open source,

…

The Distributed SQL Blog

How can I get the JSON output of distinct columns?

Does YugabyteDB have an in-memory storage engine?

Can I specify the number of tablets I want a table to have?

YSQL API

What is the performance impact of deleting tombstones in YugabyteDB?

Learn More to Accelerate Your Retail Business