Download for Free

The Distributed SQL Blog

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

Generate SQL Script in PostgreSQL

Generate SQL Script in PostgreSQL

DBAs often need to generate SQL statements using SQL queries and then execute them. PostgreSQL has many features that can help. Let’s walk through an example using YugabyteDB, which is Postgres-compatible and provides the same SQL language and catalog views.

Read more

Learn More to Accelerate Your Retail Business

Ready to dive deeper into distributed SQL, YugabyteDB, and Yugabyte Cloud?
Learn at Yugabyte University
Learn More
Browse Yugabyte Docs
Read More
Join the Yugabyte Community
Join Now