Yugabyte Meets Developer Demand for Comprehensive PostgreSQL Compatibility with New Release
Updates include support for foreign data wrappers, GIN indexes, collation, and read committed isolation level for transactions.
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 leading open source distributed SQL database company, has released YugabyteDB 2.11, with updates to extend PostgreSQL compatibility. These updates allow application developers to use powerful and familiar PostgreSQL features without compromising resilience, scale, or performance. These include foreign data wrappers (FDWs), GIN indexes, collation support, and read committed isolation level for concurrent transactions.
FDWs allow PostgreSQL databases to treat tables in remote databases as locally available tables. This enables developers to write queries that access data in an external data source as if they were coming from a table in the PostgreSQL database. For example, support for FDWs allows developers to write a JOIN query that accesses data in an external cloud native database.
Read Committed Transaction Isolation
PostgreSQL uses a technique called multiversion concurrency control to isolate concurrent transactions and ensure data consistency. The SQL-92 standard defines four levels of transaction isolation: serializable, repeatable read, read committed, and read uncommitted.
YugabyteDB already supports the two strictest isolation levels, serializable and snapshot (analogous to repeatable read). YugabyteDB 2.11 adds support for read committed transaction isolation, the default isolation level in PostgreSQL.
“For developers, PostgreSQL is the most familiar database. Being able to work within a similar framework is critical for productivity. What other distributed SQL databases get wrong is they cherry pick features, either providing good compatibility without true distributed SQL, or the reverse,” said Karthik Ranganathan, co-founder and CTO, Yugabyte. “We’ve heard from our community that true distributed SQL with complete PostgreSQL compatibility is the gold standard.”
Additional notable features of YugabyteDB 2.11 include:
- Generalized inverted indexes, or GIN Indexes. These speed up text searches across multiple columns in a table.
- Collation. This offers fine-grained control over the sort order and character classification behavior of data in adherence to different locales or languages.
- Support for This allows you to collects statistics about the contents of database tables, enabling efficient execution planning for queries.
- Support for Dapper and Mybatis ORMs. These simplify .Net and Java application
- Support for This is a popular query performance monitoring tool for PostgreSQL.
- Merge Joins. These offer faster, more efficient joins when input data is sorted on the join columns.
For more information about YugabyteDB 2.11, visit the Yugabyte blog.