Analyzing PostgreSQL Compatibility: Amazon Aurora, Spanner, YugabyteDB and CockroachDB
Presented by:
Alexandra Elchinoff
Yogesh Mahajan
Yogesh has spent two decades leading distributed data products. First with VMWare GemFire (acquired by VMWare; now Apache Geode), where he helped architect and lead the direction of a first-of-its-kind distributed in-memory data grid for highly concurrent and low latency apps. Later within VMWare/Pivotal, he integrated the technology with the Spring framework, virtualization, and CloudFoundry, growing its footprint to hundreds of customers. As part of the leadership team within Pivotal, he helped define the vision for a new unified data fabric – a unified clustered platform that brought stream processing, transactions and analytics together to eliminate the Lambda architecture complexity and deliver Google-like speeds for complex analytic queries. This became the foundation for SnappyData, where he was the seed PM since company's incubation. At SnappyData, he worked on hybrid translytical processing in distributed memory using techniques like vectorization using spark’s catalyst engine and approximate query processing. Most recently, he leads the Database PM team at Yugabyte.
No video of the event yet, sorry!
Join Yugabyte Sr. Director Product Management, Yogesh Mahajan, for a discussion of key criteria that you can use to evaluate PostgreSQL compatibility in databases. We will apply this comparison framework to analyze four distributed SQL databases: Google Spanner, Amazon Aurora, CockroachDB, and YugabyteDB.
Compatibility with a widely-adopted SQL API is no longer an option for distributed SQL databases. Just recently, Google Spanner announced support for PostgreSQL, validating the importance of such compatibility. However, leading distributed SQL databases have taken radically different approaches to the topic. This has major implications for developers and the modern applications they are building.
The different approaches to PostgreSQL compatibility
- Wire Compatibility
- Feature Compatibility
- Syntax Compatibility
- Runtime Compatibility
You will be able to understand how each approach impacts the degree of compatibility and why these differences matter when building real-world, modern applications
- Date:
- 2022 April 7 15:00 PDT
- Duration:
- 20 min
- Room:
- Ballroom
- Conference:
- Silicon Valley 2022
- Language:
- Track:
- Yugabyte Distributed SQL Summit
- Difficulty:
- Medium