By using website you agree to our use of cookies as described in our cookie policy. Learn More


YugabyteDB 2.19 Bridges Application’s Journey from Lift-and-Shift Migration to Massive Scale

Update enables midsize applications running on single-node database instances to seamlessly move to a fully distributed database environment.

Note: TDWI’s editors carefully choose vendor-issued press releases about new or upgraded products and services. We have edited and/or condensed this release to highlight key features but make no claims as to the accuracy of the vendor's statements.

Yugabyte, a provider of modern transactional databases, has released YugabyteDB 2.19 featuring dynamic query execution and built-in cloud native connection management. Together, these capabilities expand the reach of distributed PostgreSQL to applications at every scale while simplifying application architecture and migration.

The new dynamic query execution capability of YugabyteDB enables lift-and-shift migration to a modern distributed database without the need to re-architect applications or worry about performance. Organizations modernizing their transactional databases have to choose between semi-distributed databases (e.g., Amazon Aurora and Google AlloyDB) and fully distributed databases (e.g., Google Spanner). Semi-distributed databases offer a simple lift-and-shift migration without the need to re-architect applications but are limited in scale, eventually forcing another migration when needs grow.

YugabyteDB 2.19 enables midsize applications running on single-node database instances to seamlessly move to a fully distributed database environment. The new co-located tables in YugabyteDB help ensure performance comparable to single-node PostgreSQL for midsize applications. Plus, as the app grows, YugabyteDB seamlessly shifts to a fully distributed mode to provide the massive scaling benefits of distributed SQL. Switching between data co-location at smaller scale and automatic data sharding and distribution at large scale, organizations may never have to worry about data migrations again.

YugabyteDB 2.19 also introduces highly scalable connection management capabilities built into the distributed database, eliminating the need for an external connection pooler. Together with YugabyteDB Smart Driver technology, these innovations allow developers to focus more time and energy on innovative and value-added services.

“Developers around the world turn to PostgreSQL for its familiarity and ease of use,” said Karthik Ranganathan, co-founder and CTO of Yugabyte. “YugabyteDB turbocharges PostgreSQL with built-in resilience and seamless scalability.”

Other YugabyteDB 2.19 updates include:

  • Simplified application architecture with connection pooling. YugabyteDB 2.19 delivers built-in connection management, turning a common PostgreSQL challenge into a New native connection pooling uses logical connections to seamlessly ensure applications are always connected to the database. When combined with our Smart Drivers, YugabyteDB greatly simplifies the application architecture and accelerates productivity. This delivers up to 10x more connections and up to 8x faster new connections than standard PostgreSQL.
  • Build generative AI apps faster. YugabyteDB 2.19 previews support for pgvector, a popular PostgreSQL extension. This enables vector similarity search and storing embeddings for applications that require these capabilities. Yugabyte is also incorporating generative AI for support and troubleshooting, SQL query generation, and database migration.

YugabyteDB 2.19 is available now. To learn more about Yugabyte, visit

TDWI Membership

Get immediate access to training discounts, video library, research, and more.

Find the right level of Membership for you.