Yugabyte unveiled significant architectural enhancements to its flagship database, YugabyteDB, with powerful new features that fully evolve PostgreSQL to a distributed database for modern applications. These new capabilities — collectively called enhanced Postgres compatibility — enable a broader range of Postgres apps to run on YugabyteDB, making it the perfect database for companies building cloud-native applications and modernizing existing applications to a cloud-native RDBMS.
PostgreSQL remains the most popular database among developers due to its mature feature set, powerful extensions, open-source community, and support for most popular programming languages. However, Postgres’ limited resilience and scalability are stumbling blocks for enterprise and business-critical applications. This is particularly challenging for apps that need to stay online through planned or unplanned outages, scale quickly to meet demand, or keep data in multiple regions.
YugabyteDB retains all the power and familiarity of PostgreSQL by pairing its trusted API with an enterprise-grade distributed architecture. It reuses the PostgreSQL query engine to achieve PostgreSQL runtime compatibility, ensuring features including transactional semantics, retry logic, error codes, system catalog, information schemas, and change data capture behave exactly like Postgres. In addition, users can utilize Yugabyte’s open-source migration tool to streamline modernization from PostgreSQL and legacy databases to YugabyteDB.
Also Read: Catalogic Expands CloudCasa with New Volume Support & Integration
The latest version of YugabyteDB goes beyond functional compatibility and delivers on Yugabyte’s promise to enable lift-and-shift modernization of Postgres applications with minimal changes. Today’s announcement includes two key innovations:
- Adaptive Cost-Based Optimizer: PostgreSQL’s built-in cost-based optimizer (CBO) is critical for handling multiple and diverse workloads. YugabyteDB’s new Adaptive CBO extends the range of PostgreSQL’s CBO for high-scale and multi-region applications. It determines an optimal query plan that considers whether data is co-located, automatically sharded, or even distributed across zones or regions. It also implements core Postgres capabilities such as extended table statistics, parallel plans, and bitmap scans.
- Smart Data Distribution: Distributed SQL databases typically federate data and query processing across nodes. While this enables workloads to scale, it can degrade the performance of applications built for a traditional database, forcing developers to choose between lower latency and more scalability. YugabyteDB eliminates this forced choice by automatically determining whether to store tables together in a colocated manner for lower latency, or shard and distribute them to achieve massive scale.
To showcase how easy it is to migrate from PostgreSQL to YugabyteDB, Yugabyte has launched its App Century Challenge. This new program invites members of the YugabyteDB Open Source Community to help migrate 100 popular open source Postgres applications to YugabyteDB. In return, Yugabyte will give participants exclusive swag and the experience of working on a cool project that tests the limits of YugabyteDB’s Postgres compatibility.
“We’re thrilled to share this significant milestone on our journey to make YugabyteDB a truly distributed PostgreSQL database for modern applications at any scale,” said Karthik Ranganathan, co-founder and co-CEO at Yugabyte. “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 these enhanced features and improved compatibility, YugabyteDB further empowers developers and enterprises in their digital transformation journeys.”
SOURCE: Businesswire