YugabyteDB evolves into a distributed PostgreSQL database for apps that need resilience and scale – SiliconANGLE

High-performance database startup Yugabyte Inc. is unveiling significant updates to its flagship platform, YugabyteDB, with a clear focus on developers who favor the open-source PostgreSQL database. This latest iteration marks a pivotal shift, as YugabyteDB evolves from being merely Postgres-compatible to establishing itself as a fully distributed PostgreSQL database.

Enhanced Migration Tools and Features

Accompanying this transformation is the introduction of an innovative tool known as the Voyager Modernization Co-Pilot. This AI-driven solution aims to streamline the migration process, enabling developers to seamlessly transfer critical data from existing PostgreSQL systems into YugabyteDB.

While YugabyteDB may not yet rival PostgreSQL in popularity, it has carved out a niche as a high-performance distributed structured query language database capable of operating across various environments, including public and private clouds as well as Kubernetes. The platform is particularly well-suited for applications that demand low query latency, exceptional resilience to failures, and global data distribution.

Among its standout features are a robust document store, auto-sharding capabilities, and per-shard distributed consensus replication, all of which ensure atomicity, consistency, isolation, and durability. Perhaps most notably, YugabyteDB uniquely integrates both SQL and NoSQL functionalities, allowing it to handle both structured and unstructured data. This versatility enables enterprises to consolidate their critical business workloads onto a single, highly distributed database, thereby reducing the complexity of managing multiple systems.

Despite these compelling attributes, YugabyteDB remains a relatively niche offering, currently positioned at 108th place in the rankings by DB-Engines, compared to PostgreSQL, which holds the esteemed fourth position globally. PostgreSQL’s widespread adoption can be attributed to its mature feature set, extensive extensions, a vibrant open-source community, and support for numerous programming languages. However, it is not without its challenges; issues related to resilience and scalability can hinder its effectiveness for applications requiring continuous uptime, rapid scaling, and multi-region data management.

By positioning itself as a true PostgreSQL database, YugabyteDB offers developers the best of both worlds: the familiar power of PostgreSQL combined with the resilient, distributed architecture that Yugabyte provides. The company has ensured that YugabyteDB maintains PostgreSQL runtime compatibility by reusing its query engine, guaranteeing that essential features such as transactional semantics, retry logic, error codes, system catalogs, information schemas, and change data capture function identically to their PostgreSQL counterparts.

Co-founder and co-CEO Karthik Ranganathan emphasized the significance of this update, stating that YugabyteDB now stands as the first genuinely distributed PostgreSQL database. He noted, “The latest version continues to push the boundaries of performance, scalability, and simplicity for enterprises embracing cloud-native architectures, while harnessing the power of the world’s most popular database.”

With the Voyager Modernization Co-Pilot, developers can now execute straightforward lift-and-shift migrations from traditional PostgreSQL databases to YugabyteDB. Furthermore, Yugabyte has not only mirrored PostgreSQL’s capabilities but has also enhanced them in this latest release. The introduction of the Adaptive Cost-Based Optimizer represents a significant improvement over PostgreSQL’s built-in cost-based optimizer, which is crucial for managing diverse workloads. According to Yugabyte, this adaptive version broadens the scope of PostgreSQL’s CBO to accommodate high-scale and multi-region applications, optimizing query plans based on data locality, automatic sharding, or distribution across regions.

Tech Optimizer
YugabyteDB evolves into a distributed PostgreSQL database for apps that need resilience and scale - SiliconANGLE