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.
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.
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.
This blog explores YugabyteDB’s ability to propagate client requests to surviving nodes when a node becomes unavailable. The behavior depends on factors such as client connection method, driver used, and connection pooling.
In this blog post, we explore client connections in YugabyteDB, their impact on scalability, and the role of connection pooling. We address common questions and provide insights for developers looking to design efficient interactions between their applications and the database.
In this blog post we will walk through, in five easy steps, how to integrate YugabyteDB Change Data Capture with Redpanda and why Redpanda might be a better solution than Kafka.
The Orafce extension for PostgreSQL can be used to quickly and easily generate random strings to fill in a text column. Let’s look at an example on how to use Orafce, on either your PostgreSQL database or on a PostgreSQL-compatible database, like YugabyteDB.
Setting the number of shards/tablets in your YugabyteDB cluster is dependent on your table size and activity, and while it is hard to gauge the exact number, here are some high-level suggestions.
This blog examines the geo-distributed deployment topologies offered with YugabyteDB that can future-proof your data infrastructure and support your app’s needs.
Source code versioning is important, but what about data? This blog covers how to use Flyway in conjunction with YugabyteDB xCluster replication to manage data version control across multiple data centers.
