The Distributed SQL Blog

From Operational to Analytical: Unlock the Potential of YugabyteDB and Materialize Database Integration

From Operational to Analytical: Unlock the Potential of YugabyteDB and Materialize Database Integration

Learn how to integrate YugabyteDB Change Data Capture with the Materialize database in our detailed guide. Combine YugabyteDB and Materialize to create a robust data pipeline for operational and analytical workloads with low latency and high scalability. Unlock the potential to build scalable applications that cater to diverse use cases.

Read more

Enhance Your Security Strategy With the Latest Updates From YugabyteDB Managed

Experience the latest security innovations from YugabyteDB Managed, featuring custom RBAC, and new viewer roles, and encryption at rest with Customer-Managed Keys (CMK) on Google Cloud. Elevate your security strategy, ensuring utmost control and protection for your data in the face of ever-changing challenges.

Read more

Indexing for LIKE Queries in PostgreSQL

Indexing for LIKE Queries in PostgreSQL

Discover how the LIKE operator enables pattern matching with wildcards and indexing for specific access patterns, focusing on scenarios where the wildcard is at the beginning or end of the pattern. The examples and demonstrations are performed on YugabyteDB, a PostgreSQL-compatible database with variations in storage implementation.

Read more

Indexing JSON in PostgreSQL

Indexing JSON in PostgreSQL

When indexing JSON documents in PostgreSQL, you can add indexes for the access patterns just like with relational table columns. We will walk through an example of this using the Pokémon GO Pokédex as a dataset, utilizing YugabyteDB, a distributed SQL database compatible with PostgreSQL.

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