Implementing PostgreSQL User-Defined Table Functions in YugabyteDB
Learn how to implement user-defined table functions, in all variants, using generalized use cases.
Learn how to implement user-defined table functions, in all variants, using generalized use cases.
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.
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.
YugabyteDB 2.0 is now generally available, featuring the production readiness of the PostgreSQL compatible Yugabyte SQL API (YSQL). In addition to Jepsen testing results, new performance benchmarks, and ecosystem integrations, YugabyteDB 2.0 offers a high degree of PostgreSQL compatibility, with plans for future support.
One of the flagship features of the Yugabyte distributed SQL database is the PostgreSQL-compatible YSQL API. Let’s take a look at the performance and scalability of YSQL and compare it to two other PostgreSQL-compatible databases—Amazon Aurora PostgreSQL and CockroachDB.
In this post we are going to walk you through how to download and install the PostgreSQL-compatible version of SportsDB onto the YugabyteDB distributed SQL database with a replication factor of 3.
YugabyteDB 1.2.12 is now live with 11 new enhancements and bug fixes. This release brings us closer to the 2.0 version, set for the end of summer, featuring the general availability of the YSQL API
We are pleased to announce that YugabyteDB 1.2.11 is live! You can read the release notes of this and previous versions here. This release is shipping with stored procedures support, plus 30 new features, enhancements and bug fixes. Here’s a few highlights from the 1.2.11 release.
YugabyteDB 1.2.9 is now available for download, featuring over 20 new updates, enhancements, and bug fixes. Check out the highlights in the release notes.
YugaByte has introduced YSQL, a PostgreSQL-compatible distributed SQL API in YugabyteDB’s 1.1 release. This architecture enables developer agility, operational simplicity, and scalability, addressing the needs of fast-growing online services and cloud-native deployments.