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.
YugabyteDB’s compatibility with Postgres and Cassandra allows seamless integration with popular third-party tools and integrations, such as visualization tools like pgAdmin, DBeaver, and ArcType, as well as Kafka, Spark, Flyway, and drivers and ORMS, due to the decision to reuse the Postgres query layer (YSQL) and recreate Cassandra using C++ (YCQL).
Despite advancements in public clouds, region and zone outages still occur once or twice a year. This blog offers best practices to improve performance and reduce latencies in a multi-region deployment.