Distributed SQL Blogs | Page 10 of 13

June 10, 2021

Distributed SQL Tips and Tricks – June 10th, 2021

Welcome back to our bi-weekly 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 recently. Got questions? Make sure to ask them on our YugabyteDB Slack channel, Forum, GitHub, or Stack Overflow. Let’s dive in:

Connection Pooling with YugabyteDB

When looking to pool your connections with YugabyteDB many users take a look at PgBouncer,

…

Distributed SQL Tips and Tricks – May 17th, 2021

May 17, 2021

By Marko Rajcevic

Databases Distributed SQL How To

Distributed SQL Tips and Tricks – May 17th, 2021

Welcome back to our bi-weekly 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 recently. Got questions? Make sure to ask them on our YugabyteDB Slack channel, Forum, GitHub, or Stack Overflow. Let’s dive in:

Setting Firewall Rules for Cloud Deployments

When deploying a YugabyteDB cluster on a cloud,

…

April 21, 2021

By Marko Rajcevic

Databases Distributed SQL How To

Distributed SQL Tips and Tricks – April 21, 2021

Welcome back to our bi-weekly 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 recently. Got questions? Make sure to ask them on our YugabyteDB Slack channel, Forum, GitHub, or Stack Overflow. Let’s get into it:

Importing a Large Table Using Smaller Transactions

When first playing around with YugabyteDB many users import existing data from other databases,

…

April 7, 2021

By Marko Rajcevic

Community News Databases Distributed SQL How To

Distributed SQL Tips and Tricks – April 7, 2021

Welcome back to our bi-weekly 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 Stack Overflow. Let’s dive right in:

How to create client certs and propagate those on the yb-nodes using the YSQL API

There was a behavior change for the YSQL API after YugabyteDB version 2.5.2 where client certs are no longer required to authenticate to a TLS enabled cluster.

…

Distributed SQL Tips and Tricks – Oct 16, 2020

October 16, 2020

By Dorian Hoxha

Databases Distributed SQL How To PostgreSQL

Distributed SQL Tips and Tricks – Oct 16, 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 to use joins in UPDATE statements

Sometimes,

…

Apache Airflow DAGs for Migrating PostgreSQL Data to YugabyteDB

May 21, 2020

By Jimmy Guerrero

Ecosystem Integrations How To

Apache Airflow DAGs for Migrating PostgreSQL Data to YugabyteDB

In this blog, we’ll build an Apache Airflow workflow that will migrate data between PostgreSQL and YugabyteDB.

Deploying YugabyteDB for Apache Airflow on Google Cloud

May 20, 2020

By Jimmy Guerrero

Ecosystem Integrations How To

Deploying YugabyteDB for Apache Airflow on Google Cloud

Choosing YugabyteDB for Apache Airflow deployments streamlines database management and enhances system reliability. Its high availability and fault tolerance features negate the need for complex failover strategies associated with PostgreSQ. In this blog you will lean how to configure Airflow to use YugabyteDB.

Why We Built YugabyteDB by Reusing the PostgreSQL Query Layer

April 24, 2020

By Sid Choudhury

How It Works PostgreSQL

Why We Built YugabyteDB by Reusing the PostgreSQL Query Layer

Opting for PostgreSQL’s native query layer in YugabyteDB, instead of building a new one from scratch, proved to be a key decision. Our initial attempt at creating a PostgreSQL-compatible layer showed that this approach was essential for developing a top-tier cloud-native RDBMS efficiently.

Getting Started with Distributed SQL on YugabyteDB Managed

February 27, 2020

By Jimmy Guerrero

Databases Distributed SQL Google Cloud Platform How To PostgreSQL YugabyteDB YugabyteDB Aeon

Getting Started with Distributed SQL on YugabyteDB Managed

With the release of YugabyteDB 2.1 earlier this week, we introduced many exciting new features: performance optimizations, 2DC and read replica support, and more. We also announced that YugabyteDB Managed (formerly Yugabyte Cloud) is now officially in Beta! In this blog post we’ll show you how to quickly get up and running with a YugabyteDB cluster on YugabyteDB Managed, build a sample database, and connect to it with JetBrain’s DataGrip database administration tool.

…

YugabyteDB 2.1 is GA: Scaling New Heights with Distributed SQL

February 25, 2020

By Sid Choudhury

Databases Distributed SQL GraphQL Open Source PostgreSQL YugabyteDB

YugabyteDB 2.1 is GA: Scaling New Heights with Distributed SQL

Team Yugabyte is excited to announce the general availability of YugabyteDB 2.1! The highlight of this release is that Yugabyte SQL (YSQL), YugabyteDB’s PostgreSQL-compatible API, has not only improved performance 10x since the 2.0 release in September 2019 but is also production ready for multiple geo-distributed deployment scenarios. For those of you who are new to distributed SQL, YugabyteDB is a Google Spanner-inspired, cloud native distributed SQL database that is 100% open source.

…

Distributed SQL

Connection Pooling with YugabyteDB

Setting Firewall Rules for Cloud Deployments

Importing a Large Table Using Smaller Transactions

How to create client certs and propagate those on the yb-nodes using the YSQL API

How to use joins in UPDATE statements

Explore Distributed SQL and YugabyteDB in Depth