Databases Library | Page 27 of 34

Implementing PostgreSQL User-Defined Table Functions in YugabyteDB

December 16, 2019

Distributed SQL How It Works How To PostgreSQL

Implementing PostgreSQL User-Defined Table Functions in YugabyteDB

Welcome to part two of a three-part series of posts on PostgreSQL’s table functions. These functions can be easily leveraged in a distributed SQL database like YugabyteDB, which is PostgreSQL compatible.

In part one I gave a brief introduction to PostgreSQL’s table functions. Part three will cover some realistic use cases. I’ll introduce this second post by quoting that paragraph:

A regular language plpgsql user-defined function is implemented using the plain return statement.

…

An Introduction to PostgreSQL Table Functions in YugabyteDB

December 16, 2019

By Bryn Llewellyn

Distributed SQL How It Works How To PostgreSQL

An Introduction to PostgreSQL Table Functions in YugabyteDB

Welcome to the first of a three-part series of posts on PostgreSQL’s table functions. These functions can be easily leveraged in a distributed SQL database like YugabyteDB, which is PostgreSQL compatible.

This series follows on from my “Using Stored Procedures in Distributed SQL Databases” post. In this series of posts we’ll cover:

What table functions are and why they’re useful
Demonstrate the use of some built-in SQL table functions
Introduce how you can implement a user-defined table function,

…

YugabyteDB Community Update, Tricks and Tips – Dec 13, 2019

December 13, 2019

By Dorian Hoxha

Community News Databases Distributed SQL How It Works PostgreSQL

YugabyteDB Community Update, Tricks and Tips – Dec 13, 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. Ok, let’s dive right in:

How best to configure clusters across deployment types

Ava over on StackOverflow asked how to best setup configurations for different deployment models like single AZ,

…

YugabyteDB Engineering Update – Dec 9, 2019

December 9, 2019

By Jimmy Guerrero

Community News Databases Distributed SQL PostgreSQL YugabyteDB

YugabyteDB Engineering Update – Dec 9, 2019

We are pleased to announce that YugabyteDB 2.0.7 is live! You can read the official release notes of this and previous versions here. This release is shipping with almost 30 new enhancements and bug 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

YugabyteDB 2.0.7 Release Notes

YSQL

Transparent read restarts for general queries.

…

Getting Started with PostgreSQL’s Row Level Security in YugabyteDB

December 3, 2019

By Jimmy Guerrero

Distributed SQL How To PostgreSQL

Getting Started with PostgreSQL’s Row Level Security in YugabyteDB

In this blog post we are going to introduce you to how PostgreSQL’s row level security feature works in the latest YugabyteDB 2.0.6 release. YugabyteDB supports RLS and a host of other security and encryption features “out-of-the-box,” as part of the open source distribution.

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) and drivers are PostgreSQL wire compatible.

…

Using Stored Procedures in Distributed SQL Databases

December 2, 2019

By Bryn Llewellyn

Distributed SQL How It Works How To PostgreSQL

Using Stored Procedures in Distributed SQL Databases

These days, most monolithic SQL databases support stored procedures. This support first emerged in commercially available offerings in the late nineteen eighties. However, stored procedure support is not yet standard in distributed SQL databases. In fact, YugabyteDB is just one of two in this category—supporting stored procedures written in PostgreSQL’s PL/pgSQL. (Aurora also supports stored procedures.) This post recaps the case for stored procedures that motivated their introduction all those years ago. And it describes a performance experiment that measures one of the benefits brought by using stored procedures: the reduction in client-server round trips for multi-statement business transactions.

…

YugabyteDB Engineering Update – Nov 27, 2019

November 27, 2019

By Jimmy Guerrero

Community News Distributed SQL PostgreSQL YugabyteDB

YugabyteDB Engineering Update – Nov 27, 2019

We are pleased to announce that YugabyteDB 2.0.6 is live! You can read the official release notes of this and previous versions here. This release is shipping with almost 30 new enhancements and bug 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) and drivers are PostgreSQL wire compatible

YSQL changes

Transparent read restarts for general queries.

…

How Plume Handled Billions of Operations Per Day Despite an AWS Zone Outage

November 26, 2019

By Karthik Ranganathan

Databases Distributed SQL How It Works PostgreSQL

How Plume Handled Billions of Operations Per Day Despite an AWS Zone Outage

Enterprises deploy YugabyteDB clusters across multiple availability zones (AZs) in order to ensure continuous availability of their business-critical services even when faced with cloud infrastructure failures like zone outages. On November 12, 2019, there was one such outage of an entire availability zone in the eu-central-1 region of AWS. This was reported on the AWS status page on that day, along with an official update.

In this post, we are going to look at how a Yugabyte Platform customer,

…

YugabyteDB Community Update, Tricks and Tips – Nov 22, 2019

November 22, 2019

By Dorian Hoxha

Community News Distributed SQL How It Works PostgreSQL

YugabyteDB Community Update, Tricks and Tips – Nov 22, 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, the Forum, GitHub or Stackoverflow. We’ll also review upcoming events, new blogs and documentation that has been published since the last update. Ok, let’s dive right in:

How do data compactions work in YugabyteDB?

…

YugabyteDB Engineering Update – Nov 20, 2019

November 20, 2019

By Jimmy Guerrero

Community News Distributed SQL PostgreSQL YugabyteDB

YugabyteDB Engineering Update – Nov 20, 2019

We are pleased to announce that YugabyteDB 2.0.5 is live! You can read the offical release notes of this and previous versions here. This release is shipping with over 40 new enhancements and bug 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. YugabyteDB’s SQL API (YSQL) and drivers are PostgreSQL wire compatible

YSQL changes

Change HINT text for unsupported “alter procedure/function”.

…

Category: Databases

Learn More to Accelerate Your Retail Business