| I doubt that they actually built this on top of Postgres. They probably just integrated the WiredTiger[1] storage engine used by Mongo with their Aurora storage subsystem. I am however really hoping Amazon provides a MySQL 8.0 compatible version of Aurora with full support for its new hybrid SQL and Document Store interfaces[2] courtesy of the X DevAPI[3] and lightweight "serverless" friendly connections courtesy of the new X Protocol. That way your don't have to choose just one approach, and you can have your data in one place with high reliability and durability. My ultimate pipe dream would be that they also provided a redis compatible key/value interface that allows you to fetch simple values directly from the underlying innodb storage engine without going thru the SQL layer, similar to how the memcached plugin currently works[4] 1. https://github.com/wiredtiger/wiredtiger 2. https://mysqlserverteam.com/mysql-8-0-announcing-ga-of-the-m... 3. https://dev.mysql.com/doc/x-devapi-userguide/en/devapi-users... 4. https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached.htm... |
X DevAPI and X Protocol/X Plugin could team up and map K/V style access to the server internal InnoDB API instead of using a SQL service as it is currently done. They could try to do it "transparently" or let you set hints. Whatever is desired from an application standpoint.