SUNNYVALE, Calif.--(BUSINESS WIRE)--Yugabyte, the leading open source distributed SQL database company, today announced the general availability of YugabyteDB 2.11, with updates that extend PostgreSQL compatibility in the open source database. These updates allow application developers to use powerful and familiar PostgreSQL features without compromising resilience, scale, or performance. This release extends YugabyteDB’s lead as the most PostgreSQL-compatible distributed SQL database in the world.
The latest release brings widely used PostgreSQL features to YugabyteDB. These include Foreign Data Wrappers (FDW), GIN indexes, collation support, and read committed isolation level for concurrent transactions.
Foreign Data Wrappers allow PostgreSQL databases to treat tables in remote databases as locally available tables. This enables developers to effortlessly write queries that access data in the external data source as if they were coming from a table in the PostgreSQL database. Support for FDWs allows developers to write a JOIN query that accesses data in an external cloud native database.
This feature was built by YugabyteDB open source community contributor, Radek Gruchalski, Managing Director of German integration services company, Klarrio.
“At Klarrio, we use YugabyteDB but during work on a recent project ran into a hurdle when it came to Foreign Data Wrappers. Without them, our alternative was to build a one-off tool for initial data copy and bolt change data capture on (CDC) to synchronize further data changes. This would have been highly complex. Instead, we investigated a working solution for YugabyteDB and had it up and running in just a few hours. Being part of the Yugabyte open source community and working to make the database better served our own needs at Klarrio, but it also helped others do more, better. That’s the true spirit of open source.”
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.
“The biggest roadblock to database adoption is familiarity. 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 loud and clear from our community that true distributed SQL with complete PostgreSQL compatibility is the gold standard. That is what we are delivering.”
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 ANALYZE. 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 development
- Support for pg_stat_monitor. 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
“We’ve been on the journey to offer a distributed SQL database with complete PostgreSQL compatibility for some time. As a result, we already supported features that set us apart from the competition, such as stored procedures, triggers, user-defined types, a variety of indexes, constraints and joins,” said Ranganathan. “With the new features in this release, we’re making YugabyteDB the most familiar and developer-friendly distributed SQL database on the market.”
For more information on YugabyteDB 2.11 visit the Yugabyte blog.
- Read the post on the Yugabyte Distributed SQL blog that describes the feature in more detail: https://blog.yugabyte.com/announcing-yugabytedb-2-11/
- Read the blog post by database expert, Radek Gruchalski, detailing how to use foreign data wrappers with YugabyteDB: https://gruchalski.com/posts/2021-11-08-yugabytedb-postgres-foreign-data-wrapper/
Yugabyte is the company behind YugabyteDB, the open source, high-performance distributed SQL database for building global, cloud-native applications. YugabyteDB serves business-critical applications with SQL query flexibility, high performance and cloud-native agility, thus allowing enterprises to focus on business growth instead of complex data infrastructure management. It is trusted by companies in cybersecurity, financial markets, IoT, retail, e-commerce, and other verticals. Founded in 2016 by former Facebook and Oracle engineers, Yugabyte is backed by Lightspeed Venture Partners, 8VC, Dell Technologies Capital, Sapphire Ventures, and others. www.yugabyte.com