PostgreSQL Library | Page 11 of 16

Achieving 10x Better Distributed SQL Performance in YugabyteDB 2.1

February 25, 2020

Databases Distributed SQL Open Source Performance Benchmarks PostgreSQL YugabyteDB

Achieving 10x Better Distributed SQL Performance in YugabyteDB 2.1

When starting the YugabyteDB project, our founding thesis was to build a high-performance distributed SQL database for the cloud native era. Achieving high performance will always remain an ongoing initiative, especially when additional optimizations are required to support new features and new use cases. We are excited that the current YugabyteDB 2.1 release has a number of improvements that make Yugabyte SQL’s performance 10x better on average than the previous 2.0 release (from September 2019).

…

Getting Started with JetBrains DataGrip on a Distributed SQL Database

February 24, 2020

By Jimmy Guerrero

Distributed SQL How To PostgreSQL

Getting Started with JetBrains DataGrip on a Distributed SQL Database

If you’re a database developer, you know the time saving value of an IDE in helping you create and navigate database objects, plus query and edit data from single UI. DataGrip from JetBrains is a well-rounded, visual database tool that supports almost 20 SQL and NoSQL databases from a single interface. And because YugabyteDB is PostgreSQL compatible, getting DataGrip to work with a distributed SQL database is relatively simple. In this post we’ll show you how to get DataGrip connected to a YugabyteDB cluster,

…

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?

…

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.

…

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,

…

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.

…

PostgreSQL

When should I use JSON vs JSONB data types?

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

Explore Distributed SQL and YugabyteDB in Depth