How To Achieve Region-Level Fault Tolerance While Using Row-Level Geo-Partitioning?
This edition of the Distributed SQL Tips and Tricks blog looks at how to achieve region-level fault tolerance with row-level geo-partitioning.
June 8, 2023
The Distributed SQL Blog
June 7, 2023
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.
June 5, 2023
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.
June 2, 2023
What Is the Difference Between ‘Table Partitioning’ and ‘Sharding’ In a Distributed SQL Deployment?
In YugabyteDB you can use sharding and partitioning, so it can be confusing. In this blog post, we explore the differences (and similarities) between them and when each should be used.
May 31, 2023
DSS Europe 2023 Recap: An Event to Remember (Mark Your Calendar for Next Year!)
Distributed SQL Summit (DSS) Europe event, co-located at KubeCon + CloudNativeCon Europe in Amsterdam, addressed the challenges of KubeCon delegates building modern microservices. Discover more about the event, the issues that distributed SQL database’s overcome, and the interactive sessions with quizzes enjoyed by attendees!
May 30, 2023
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.
May 26, 2023
Will a Partitioned Table in YugabyteDB Also Be Sharded?
In YugabyteDB, every table and index is sharded across the cluster, with partitioning at the query level (YSQL) and sharding at the storage level (DocDB), enabling unique configuration concepts like row-level geo-partitioning.
May 24, 2023
Differences in Primary Key Usage Between Colocated and Non-Colocated Tables
In this blog post, we will explore the differences between colocated and non-colocated databases/tables and then dive into the syntax implications of primary key usage on colocated and non-colocated tables/databases.
May 23, 2023
Unlock Kubernetes and Simplify Operations: Introducing YugabyteDB 2.18
Introducing YugabyteDB 2.18! Accelerate data modernization with new cloud-native features, multi-region Kubernetes support, and simplified operations through YugabyteDB Anywhere’s enhanced automation and intelligence.
May 22, 2023
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.