The Distributed SQL Blog

April 2, 2025

Creating a Powerful, Unified, Data Architecture With YugabyteDB and ClickHouse

Integrating YugabyteDB and ClickHouse creates a powerful, unified data architecture that optimizes performance, scalability, and real-time analytics. YugabyteDB ensures transactional consistency and high availability for OLTP workloads, while ClickHouse delivers lightning-fast analytical processing for OLAP workloads.
Discover how integrating YugabyteDB and ClickHouse creates a modern, hybrid data architecture that leverages the best of both transactional and analytical worlds.

Database Migration Assessment With YugabyteDB Voyager

March 28, 2025

By Aneesh Makala and Hemant Bhanawat

How To

Database Migration Assessment With YugabyteDB Voyager

YugabyteDB Voyager’s new assessment feature offers insights into two crucial areas: migration complexity and sizing and sharding guidance. This allows users to effectively plan migrations and avoid potential issues. This new blog post provides a technical deep dive into these two key areas.

Optimizing Correlated Subqueries with Semi Joins in PostgreSQL and YugabyteDB

March 20, 2025

By Mark Peacock

How To

Optimizing Correlated Subqueries with Semi Joins in PostgreSQL and YugabyteDB

Discover this real-world optimization scenario in YugabyteDB (and PostgreSQL), where a correlated subquery is executed inefficiently due to nested loop overhead. This blog details how PostgreSQL internally handles EXISTS clauses and highlights the importance of understanding Semi Join versus SubPlan.

Intelligent Database Insights With Agentic AI for YugabyteDB Metadata

February 26, 2025

By Balachandar Seetharaman

Intelligent Database Insights With Agentic AI for YugabyteDB Metadata

New Agentic AI for YugabyteDB Metadata brings the power of natural language processing to your database management workflow. This blog examines how Agentic AI for YugabyteDB Metadata transforms how organizations interact with their distributed SQL database by providing intelligent, real-time insights through natural language queries.

Latest Encryption in Transit Developments for YSQL

February 19, 2025

By Sanketh Indarapu

YugabyteDB

Latest Encryption in Transit Developments for YSQL

YugabyteDB stores important user and customer data for an organization on their systems. This means that encryption in transit is a common requirement for client-to-server communication. This blog explores new encryption in transit knobs available in Yugabyte 2.25 and compares them to the equivalent knobs from previous releases.

Enhanced Cron Job Resilience With pg_cron in YugabyteDB

February 12, 2025

By Hari Krishna Sunder

PostgreSQL

Enhanced Cron Job Resilience With pg_cron in YugabyteDB

The pg_cron extension serves as a building block for many important PostgreSQL extensions, and enables you to seamlessly schedule automated jobs to monitor and maintain your databases. This blog takes an in-depth look at the pg_cron extension and examines how it works in YugabyteDB.

Protecting YugabyteDB Data With Cohesity

February 4, 2025

By Yu-Shen Ng

Integrations

Protecting YugabyteDB Data With Cohesity

When integrated with Cohesity, YugabyteDB Anywhere delivers database data to Cohesity’s immutable target storage to achieve enhanced data security and protection. Discover the benefits of YugabyteDB Anywhere’s backup and restore capabilities, why you should consider Cohesity as a storage solution, and guidance on configuration.

PostgreSQL 15 Compatibility in YugabyteDB 2.25: Top 15 Features!

January 31, 2025

By Franck Pachot

Release Announcements

PostgreSQL 15 Compatibility in YugabyteDB 2.25: Top 15 Features!

The latest YugabyteDB preview release supports PostgreSQL 15. This represents a significant upgrade from the previous version. YugabyteDB 2.25 brings many new, long-awaited features, and this blog discusses the top 15 features (from PG12 to PG15) that will significantly benefit YugabyteDB developers.

Doubling Down on PostgreSQL Compatibility: YugabyteDB Levels Up with PG15 Features

January 30, 2025

By Anand Venkatesh

Release Announcements

Doubling Down on PostgreSQL Compatibility: YugabyteDB Levels Up with PG15 Features

The latest release of YugabyteDB delivers 15 key PostgreSQL 15 features, providing an industry-first zero-downtime PostgreSQL upgrade and downgrade experience. This gives users a truly cloud-native PostgreSQL solution. Discover how YugabyteDB 2.25 can help you confidently explore the latest PostgreSQL features and innovations while maintaining business continuity and minimizing risk.

Powering Innovation Through Partnerships

January 27, 2025

By Rohan Thomas

Partners

Powering Innovation Through Partnerships

We are excited to welcome a new VP of Global Partner Sales to Yugabyte. This blog shares why Rohan Thomas chose Yugabyte, and why he is excited to build on our existing successful partnerships to deliver a bright (distributed) future for customers.

The Distributed SQL Blog

Explore Distributed SQL and YugabyteDB in Depth