The Distributed SQL Blog

Scaling a Hasura GraphQL Backend with Distributed SQL

April 7, 2020

Databases Distributed SQL GraphQL How To PostgreSQL

Scaling a Hasura GraphQL Backend with Distributed SQL

GraphQL is taking the modern development world by storm having been adopted by companies like Facebook, GitHub and Intuit because it solves many of the common problems developers encounter when working with REST APIs. For example, it solves issues like overfetching (getting more data than your response needs) and underfetching (having to make multiple fetches to get all the data you need), or when consolidating API responses on the client is necessary. When a developer follows the GraphQL spec,

…

April 3, 2020

By Dorian Hoxha

Databases Distributed SQL How To PostgreSQL

Distributed SQL Tips and Tricks – April 3, 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 save the results of YSQL commands to a file?

…

March 13, 2020

By Dorian Hoxha

Databases Distributed SQL Kubernetes PostgreSQL

Distributed SQL Tips and Tricks – March 13, 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 UPSERT multiple rows with an update?

…

March 6, 2020

By Dorian Hoxha

Databases Distributed SQL How To PostgreSQL Week in Review

Distributed SQL Tips and Tricks – March 6, 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 configure YugabyteDB for serialization isolation level?

…

5 Query Pushdowns for Distributed SQL and How They Differ from a Traditional RDBMS

March 4, 2020

By Karthik Ranganathan

Databases Distributed SQL

5 Query Pushdowns for Distributed SQL and How They Differ from a Traditional RDBMS

A pushdown is an optimization to improve the performance of a SQL query by moving its processing as close to the data as possible. Pushdowns can drastically reduce SQL statement processing time by filtering data before transferring it over the network, filtering data before loading it into memory, or pruning out entire files or blocks that do not need to be read. PostgreSQL is a highly optimized single-node RDBMS when it comes to pushdowns. Because Yugabyte’s YSQL API reuses the upper half of PostgreSQL,

…

Distributed SQL Tips and Tricks – Feb 21, 2020

February 21, 2020

By Dorian Hoxha

Databases Distributed SQL Google Spanner How To PostgreSQL

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

When should I use JSON vs JSONB data types?

…

Developing Reactive Microservices with Spring Data and Distributed SQL

February 19, 2020

By Nikhil Chandrappa

Databases Distributed SQL How To Spring

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,

…

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?

…

Search: yugabyte intern

Scaling a Hasura GraphQL Backend with Distributed SQL

Distributed SQL Tips and Tricks – April 3, 2020

How can I save the results of YSQL commands to a file?

5 Query Pushdowns for Distributed SQL and How They Differ from a Traditional RDBMS

Developing Reactive Microservices with Spring Data and Distributed SQL

Distributed SQL Tips and Tricks – Jan 31, 2020

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

Explore Distributed SQL and YugabyteDB in Depth