PostgreSQL Compatibility Library | Page 3 of 4

Using the PostgreSQL Recursive CTE – Part Two

March 1, 2021

Databases Distributed SQL How To PostgreSQL

Using the PostgreSQL Recursive CTE – Part Two

Computing Bacon Numbers for actors listed in the IMDb

YugabyteDB is an open source, high-performance distributed SQL database built on a scalable and fault-tolerant design inspired by Google Spanner. YugabyteDB uses its own special distributed document store called DocDB. But it provides SQL and stored procedure functionality by re-using the “upper half” of the standard PostgreSQL source code. This is explained in the two part blog post “Distributed PostgreSQL on a Google Spanner Architecture”: (1) Storage Layer;

…

Using the PostgreSQL Recursive CTE – Part One

March 1, 2021

By Bryn Llewellyn

Databases Distributed SQL How To PostgreSQL

Using the PostgreSQL Recursive CTE – Part One

Traversing an employee hierarchy

YugabyteDB is an open source, high-performance distributed SQL database built on a scalable and fault-tolerant design inspired by Google Spanner. YugabyteDB uses its own special distributed document store called DocDB. But it provides SQL and stored procedure functionality by re-using the “upper half” of the standard PostgreSQL source code. This is explained in the two part blog post “Distributed PostgreSQL on a Google Spanner Architecture”: (1) Storage Layer;

…

YugabyteDB: Reimagining the RDBMS for the Cloud

February 25, 2021

By Karthik Ranganathan

Community News Company News Databases Distributed SQL How It Works Open Source

YugabyteDB: Reimagining the RDBMS for the Cloud

Perspectives from 5 years of building a cloud native database

YugabyteDB just turned 5 years old, and I cannot help but reminisce about our journey in building this database over the last half-decade. I vividly remember the genesis of the YugabyteDB project, which started with Kannan, Mikhail, and myself meeting for lunch at a restaurant to discuss the future of cloud native databases. After iterating on the idea over a number of such discussions,

…

Effortless Database Installation: Unveiling the Compatibility of YugabyteDB and PostgreSQL

October 1, 2020

By Jimmy Guerrero

PostgreSQL YugabyteDB

Effortless Database Installation: Unveiling the Compatibility of YugabyteDB and PostgreSQL

Discover the seamless compatibility between PostgreSQL and YugabyteDB. Learn how the installation commands overlap, including connecting to databases, creating users, schemas, and executing files from the SQL shell.

Row Counts of Tables in a SQL Schema and Database: PostgreSQL vs. YugabyteDB

August 27, 2020

By Karthik Ranganathan

Compare and contrast PostgreSQL YugabyteDB

Row Counts of Tables in a SQL Schema and Database: PostgreSQL vs. YugabyteDB

Getting the total row counts of data in tables across various dimensions (per-table, per-schema, and in a given database) is a useful SQL technique to have in your toolkit. This blog post will guide you to obtain per-table row counts of all tables in PostgreSQL and YugabyteDB. This can serve as a first sanity check after migrating an application with pre-existing data from PostgreSQL to YugabyteDB.

This blog post also outlines how to get the following row counts broken down per table in a schema,

…

Oracle vs PostgreSQL: First Glance – Testing YugabyteDB’s Compatibility

May 14, 2020

By Jimmy Guerrero

Compare and contrast PostgreSQL YugabyteDB

Oracle vs PostgreSQL: First Glance – Testing YugabyteDB’s Compatibility

This post explores the compatibility of YugabyteDB with Oracle and PostgreSQL by examining 15 different Oracle features and their PostgreSQL equivalents highlighted in Roland Takacs’ blog post “Oracle vs PostgreSQL: First Glance.” As a PostgreSQL-compatible distributed SQL database, YugabyteDB offers a broad range of SQL features, making it an interesting choice for those looking to migrate from Oracle to a modern tech stack.

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.

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,

…

Four Compelling Use Cases for PostgreSQL Table Functions

December 16, 2019

By Bryn Llewellyn

How It Works PostgreSQL YugabyteDB

Four Compelling Use Cases for PostgreSQL Table Functions

Take a look at four realistic use cases that call for PostgreSQL user-defined table functions and see how each is met using complete, self-contained code examples.