PostgreSQL Library | Page 4 of 15

YugabyteDB Integrates with Arctype SQL Client

January 25, 2022

By Yugabyte Team

Databases Ecosystem Integrations PostgreSQL YugabyteDB

YugabyteDB Integrates with Arctype SQL Client

PostgreSQL has eaten the world. And so Yugabyte set out to build the most Postgres-compatible, scalable, and resilient database. YugabyteDB is not only wire compatible with PostgreSQL, it is code compatible by reusing the upper half of PostgreSQL. Thanks to this compatibility, YugabyteDB can connect to the vast majority of database tools that integrate with Postgres.

In a previous blog post, Yugabyte Developer Advocate Franck Pachot showed how to connect YugabyteDB in Arctype.

…

YugabyteDB Savepoints: Checkpointing Work in Distributed Transactions

January 21, 2022

By Rob Sami

Databases Distributed SQL PostgreSQL

YugabyteDB Savepoints: Checkpointing Work in Distributed Transactions

Yugabyte brings best-in-class performance, scalability, and availability to YugabyteDB, a fully PostgreSQL-compatible SQL database. Because YugabyteDB’s architecture uses PostgreSQL at the SQL layer, we get a long-tail of PostgreSQL compatibility for free. But implementing savepoints requires deeper integration into YugabyteDB’s distributed persistence and transaction layers.

In this blog post, we’ll discuss why you should care about savepoints. We’ll also examine how we built savepoints into YugabyteDB’s distributed transaction layer,

…

December 13, 2021

By Yogesh Mahajan

Databases Distributed SQL PostgreSQL

Using GIN Indexes in YugabyteDB

At Yugabyte, we are committed to complete PostgreSQL compatibility. Similar to PostgreSQL, YugabyteDB supports the following three container column types. These three data types are extremely useful in various cases:

jsonb – Makes it useful for schema-less data use cases
tsvector – Supports full text search through a sorted list of distinct lexemes
array – Gives the flexibility to store a large composite variable-length value in a single field

Each data type’s utility is severely limited without an efficient way to index them.

…

$A SQL Stopwatch Utility for YugabyteDB or PostgreSQL as an Alternative for “\timing on”$

September 15, 2021

By Bryn Llewellyn

How It Works PostgreSQL YugabyteDB

A SQL Stopwatch Utility for YugabyteDB or PostgreSQL as an Alternative for “\timing on”

In this blog post, you’ll learn how to implement a timer for multi-statement operations using SQL with YugabyteDB or PostgreSQL. These tools are commonly used for various tasks, but their native timing feature only times individual SQL statements and doesn’t support end-to-end timing or output to spool files.

Connecting to YugabyteDB with Arctype, a Collaborative SQL Client

July 23, 2021

By Franck Pachot

Distributed SQL How To PostgreSQL

Connecting to YugabyteDB with Arctype, a Collaborative SQL Client

YugabyteDB is PostgreSQL compatible. It uses the same protocol and SQL layer as PostgreSQL. This makes YugabyteDB compatible with a majority of database tools, because PostgreSQL is the most popular open source database on the planet. Here is an example with Arctype, a user-friendly collaborative SQL client to query and visualize data.

Setting up a database connection

1. I went to https://arctype.com/ and downloaded the client for Windows.

2.

…

Using the PostgreSQL Recursive CTE – Part Two

March 1, 2021

By Bryn Llewellyn

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 Fundamentals Training Q&A – Jan 28, 2021

January 29, 2021

By Jimmy Guerrero

Community News Databases Distributed SQL How It Works PostgreSQL

YugabyteDB Fundamentals Training Q&A – Jan 28, 2021

Yesterday we had almost 200 folks show up for the latest “YugabyteDB Fundamentals and Certification” training session. We had a lot of questions during the session and weren’t able to get to them all! In this blog I have compiled the majority of them and provided answers in a simple Q&A format.

Missed yesterday’s training? You can catch our next training session, “YugabyteDB YSQL Development and Certification and Training” on Feb 25 by registering here.

…

Using PostgreSQL Aggregate Functions in YugabyteDB to Analyze COVID-19 Data

December 1, 2020

By Bryn Llewellyn

Databases Distributed SQL How To PostgreSQL

Using PostgreSQL Aggregate Functions in YugabyteDB to Analyze COVID-19 Data

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; and (2) Query Layer.

…

November 12, 2020

By Karthik Ranganathan

Community News Company News Databases Distributed SQL PostgreSQL Release Announcements

Announcing YugabyteDB 2.5

Support for Geo-Partitioning and Enterprise-Grade Security Features

Our mission at Yugabyte is to build the default distributed SQL database for cloud native applications in a multi cloud world. To further that mission, this release brings major enhancements to multi-region deployments, performance, and security features offered by the database – while simultaneously improving on high availability, horizontal scalability, and ease of managing the database.

Enhanced multi-region capabilities with geo-partitioning and follower reads: The YugabyteDB 2.5 release adds row-level geo-partitioning capabilities as well as follower reads to the extensive set of multi-region features that YugabyteDB already had.

…

PostgreSQL

Setting up a database connection

Computing Bacon Numbers for actors listed in the IMDb

Traversing an employee hierarchy

Support for Geo-Partitioning and Enterprise-Grade Security Features

Explore Distributed SQL and YugabyteDB in Depth