PostgreSQL Library | Page 8 of 16

June 29, 2020

Community News Databases Distributed SQL How To PostgreSQL

Distributed SQL Tips and Tricks – June 29, 2020

Welcome to this week’s tips and tricks blog where we recap some distributed SQL questions from around the Internet. We’ll also review upcoming events, new documentation, and blogs that have been published since the last post. Got questions? Make sure to ask them on our YugabyteDB Slack channel, Forum, GitHub, or Stackoverflow. Ok, let’s dive right in:

Regular expression queries (or pattern matching queries)

YugabyteDB inherits PostgreSQL upper layer,

…

Polymorphism in SQL part two – variadic functions

June 25, 2020

By Bryn Llewellyn

Databases Distributed SQL How To PostgreSQL

Polymorphism in SQL part two – variadic functions

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.

…

Polymorphism in SQL part one – anyelement and anyarray

June 24, 2020

By Bryn Llewellyn

Databases Distributed SQL How It Works PostgreSQL

Polymorphism in SQL part one – anyelement and anyarray

The term “polymorphism”, and its inflections, has various meanings in the context of programming languages in general. Roughly, it means “chameleon-like”. Of course, Wikipedia has something to say about it, here. PostgreSQL uses it with this meaning: “Parametric polymorphism: when one or more types are not specified by name but by… symbols that can represent any type”.

The term “variadic” has a universal meaning,

…

SQL Puzzle: Partial Versus Expression Indexes

June 18, 2020

By Karthik Ranganathan

Databases Distributed SQL PostgreSQL

SQL Puzzle: Partial Versus Expression Indexes

Here is an intriguing SQL puzzle we came across in the context of a real-world use case. This post shows the power of advanced RDBMS features such as partial indexes and expression indexes.

Let us assume we have a table in PostgreSQL named users, where each row in the table represents a user. The table is defined as follows.

CREATE TABLE users (
id SERIAL PRIMARY KEY,
email VARCHAR DEFAULT NULL,
name VARCHAR
);

…

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.

Boosting Performance for Small Distributed SQL Data Sets with Colocated Tables

May 12, 2020

By Neha Deodhar

Databases Distributed SQL How It Works Open Source PostgreSQL YugabyteDB

Boosting Performance for Small Distributed SQL Data Sets with Colocated Tables

In YugabyteDB v2.1, we released a new feature in beta: colocated tables. And we were excited to announce the general availability of colocated tables, along with many other exciting new features, in YugabyteDB 2.2. In this post, we’ll explain what colocated tables are in a distributed SQL database, why you would need them, and how to get started.

May 8, 2020

By Dorian Hoxha

Community News Databases Distributed SQL How To Open Source PostgreSQL

Distributed SQL Tips and Tricks – May 8, 2020

Welcome to this week’s tips and tricks blog where we recap some distributed SQL questions from around the Internet. We’ll also review upcoming events, new documentation, and blogs that have been published since the last post. Got questions? Make sure to ask them on our YugabyteDB Slack channel, Forum, GitHub, or Stackoverflow. Ok, let’s dive right in:

How can I connect YugabyteDB with Apache Spark?

…

May 6, 2020

By Jimmy Guerrero

Community News Databases Distributed SQL Open Source PostgreSQL YugabyteDB

YugabyteDB Engineering Update – May 6, 2020

YugabyteDB Release Updates

We are excited to announce that YugabyteDB 2.1.5 is GA! The 2.1.5 release shipped with over 40 new enhancements and fixes. Also, yesterday we hit a milestone that we are very proud of–we welcomed our 1000th member to the YugabyteDB community Slack channel! Congrats to Rob Sami for being the 1000th member, and thank you to the entire YugabyteDB community for your contributions and support along the way.

…

Bringing Truth to Competitive Benchmark Claims – YugabyteDB vs CockroachDB, Part 2

May 4, 2020

By Karthik Ranganathan

CockroachDB Compare and contrast Distributed SQL Performance Benchmarks PostgreSQL

Bringing Truth to Competitive Benchmark Claims – YugabyteDB vs CockroachDB, Part 2

In part 1 of this blog series, we highlighted multiple factual errors in the Cockroach Labs analysis of YugabyteDB. In this second post we provide the next layer of detail behind YugabyteDB’s architecture, with an emphasis on comparing it to that of CockroachDB’s.

Contents of this post

TLDR
Query layer – reusing PostgreSQL
Storage layer – engineered for performance at scale
A deep dive into performance at large data sizes
Detailed YCSB results
Understanding performance in distributed SQL
- Large vs small data sets
- Range vs hash sharding
Conclusion

TLDR

Yugabyte SQL is based on a reuse of PostgreSQL’s native query layer.

…

Bringing Truth to Competitive Benchmark Claims – YugabyteDB vs CockroachDB, Part 1

May 4, 2020

By Karthik Ranganathan

CockroachDB Compare and contrast Distributed SQL PostgreSQL

Bringing Truth to Competitive Benchmark Claims – YugabyteDB vs CockroachDB, Part 1

At Yugabyte, we welcome competition and criticism. We believe these aspects are essential to the wide adoption of a business-critical, fully open source project like YugabyteDB. Specifically, constructive criticism helps us improve the project for the benefit of our large community of users. Engineers at Cockroach Labs posted their analysis of how CockroachDB compares with YugabyteDB a few months ago. We thank them for taking the time to do so.

…

PostgreSQL

Regular expression queries (or pattern matching queries)

How can I connect YugabyteDB with Apache Spark?

YugabyteDB Release Updates

Contents of this post

TLDR

Explore Distributed SQL and YugabyteDB in Depth