PostgreSQL Compatibility

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

August 27, 2020

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.

Implementing PostgreSQL User-Defined Table Functions in YugabyteDB

December 16, 2019

By Bryn Llewellyn

How It Works PostgreSQL YugabyteDB

Implementing PostgreSQL User-Defined Table Functions in YugabyteDB

Learn how to implement user-defined table functions, in all variants, using generalized use cases.

An Introduction to PostgreSQL Table Functions in YugabyteDB

December 16, 2019

By Bryn Llewellyn

How It Works PostgreSQL YugabyteDB

An Introduction to PostgreSQL Table Functions in YugabyteDB

Read through an introduction to PostgreSQL’s table functions and their use in distributed SQL databases. The blog series will cover the basics of table functions, the use of built-in SQL table functions, and the implementation of user-defined table functions.

Working with PostgreSQL Data Types in YugabyteDB

October 21, 2019

By Jimmy Guerrero

How It Works PostgreSQL YugabyteDB

Working with PostgreSQL Data Types in YugabyteDB

In this blog post we’ll be focusing on PostgreSQL data types, and test their compatibility with YugabyteDB. You can find a quick list of supported data types in our docs.

PostgreSQL Compatibility in YugabyteDB 2.0

September 17, 2019

By Jimmy Guerrero

ACID Transactions CockroachDB Distributed SQL How It Works PostgreSQL YugabyteDB