PostgreSQL

SQL Puzzle: Partial Versus Expression Indexes

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
);

Read more

Oracle vs PostgreSQL: First Glance – Testing YugabyteDB’s Compatibility

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.

Read more

Boosting Performance for Small Distributed SQL Data Sets with Colocated Tables

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.

Read more

Distributed SQL Tips and Tricks – May 8, 2020

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?

Read more

YugabyteDB Engineering Update – May 6, 2020

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.

Read more

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

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

Read more

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

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.

Read more

Spanning the Globe without Google Spanner

Spanning the Globe without Google Spanner

Open Source Geo-Distributed Relational Database on Multi-Cluster Kubernetes

Google Spanner, conceived in 2007 for internal use in Google AdWords, has been rightly considered a marvel of modern software engineering. This is because it is the world’s first horizontally-scalable relational database that can be stretched not only across multiple nodes in a single data center but also across multiple geo-distributed data centers, without compromising ACID transactional guarantees. In 2012,

Read more

YugabyteDB Engineering Update – April 13, 2020

YugabyteDB Engineering Update – April 13, 2020

We are excited to announce that YugabyteDB 2.1.3 is GA! You can read the official release notes here. This release shipped with over 60 new enhancements and fixes.

The Yugabyte team has been working from home in order to do our part with social distancing and to help with containment efforts. We have also transitioned to online meetings with our customers, partners, candidates, community, and fellow Yugabeings. We will continue with these and other measures until it’s determined to be safe otherwise.

Read more

Explore Distributed SQL and YugabyteDB in Depth

Discover the future of data management.
Learn at Yugabyte University
Get Started
Browse Yugabyte Docs
Explore docs
PostgreSQL For Cloud Native World
Read for Free