Slide 1

Slide 1 text

Will the era of specialized databases be over? Will the Era of Specialized Databases be Over? Álvaro Hernández @ahachete

Slide 2

Slide 2 text

Will the era of specialized databases be over? @ahachete ` whoami ` Alvaro Hernandez aht.es ● Founder & CEO, OnGres ● 20+ years Postgres user and DBA ● Mostly doing R&D to create new, innovative software on Postgres ● More than 140 tech talks ● AWS Data Hero ● Founder and President of the NPO Fundación PostgreSQL

Slide 3

Slide 3 text

Will the era of specialized databases be over? @ahachete How it all started

Slide 4

Slide 4 text

Will the era of specialized databases be over? @ahachete

Slide 5

Slide 5 text

Will the era of specialized databases be over? @ahachete Jeff Bezos – 2018 Letter to Shareholders We’re also optimistic about specialized databases for specialized workloads. Over the past 20 to 30 years, companies ran most of their workloads using relational databases. [...] data set sizes were often small enough [...] many applications are storing very large amounts of data – terabytes and petabytes. And the requirements for apps have changed. [...] the right tool for the right job saves money and gets your product to market faster. https://www.aboutamazon.com/news/company-news/2018-letter-to-shareholders

Slide 6

Slide 6 text

Will the era of specialized databases be over? @ahachete AWS: specialized databases

Slide 7

Slide 7 text

Will the era of specialized databases be over? @ahachete AWS: specialized databases

Slide 8

Slide 8 text

Will the era of specialized databases be over? @ahachete The Right Tool for the Right Job

Slide 9

Slide 9 text

Will the era of specialized databases be over? @ahachete The Right Tool for the Right Job? Yay ● Get the best performance ● Optimal mapping app:database Nay ● Learn many databases! ● Learn how to do many types of Ops!

Slide 10

Slide 10 text

Will the era of specialized databases be over? Databases evolution at AWS: do you spot the trend?

Slide 11

Slide 11 text

Will the era of specialized databases be over? Aurora ● 2014: MySQL ● 2017: Postgres Aurora Brief Launch Timeline Aurora Serverless v1 ● 2018: MySQL ● 2019: Postgres Aurora Serverless v2 ● 2022: MySQL & Postgres

Slide 12

Slide 12 text

Will the era of specialized databases be over? 2021: Adding SQL Server on top of Postgres https://babelfishpg.org/

Slide 13

Slide 13 text

Will the era of specialized databases be over? 2023: Amazon Aurora Limitless (PostgreSQL)

Slide 14

Slide 14 text

Will the era of specialized databases be over? Quantum Ledger Database: RIP

Slide 15

Slide 15 text

Will the era of specialized databases be over? Quantum Ledger Database: RIP https://aws.amazon.com/blogs/database/migrate-an-amazon-qldb-ledger-to-amazon-aurora-postgresql/

Slide 16

Slide 16 text

Will the era of specialized databases be over? Did you spot the trend? Is it limited to relational databases?

Slide 17

Slide 17 text

Will the era of specialized databases be over? Amazon DocumentDB (with MongoDB compatibility) https://news.ycombinator.com/item?id=18870397

Slide 18

Slide 18 text

Will the era of specialized databases be over? Brief departure (shameless plug) (but please bear with me)

Slide 19

Slide 19 text

Will the era of specialized databases be over? Dyna53.io

Slide 20

Slide 20 text

Will the era of specialized databases be over? Dyna53.io

Slide 21

Slide 21 text

Will the era of specialized databases be over? @ahachete Dyna53.io → Dynorora ???? ● What if Dyna53 writes to RDS/Aurora instead? ● After all, Postgres has very good JSON support… https://speakerdeck.com/ongres/can-postgres-scale-like-dynamodb

Slide 22

Slide 22 text

Will the era of specialized databases be over? @ahachete In reality… DynamoDB works on top of a RDBMS! Would it be MySQL if it were redesigned today?

Slide 23

Slide 23 text

Will the era of specialized databases be over? So why do we see this trend? Because AWS listens to customers

Slide 24

Slide 24 text

Will the era of specialized databases be over? Which database has been growing in this decade?

Slide 25

Slide 25 text

Will the era of specialized databases be over? What makes Postgres so unique? https://www.youtube.com/watch?v=EMldOiiG1Ko Extensions, Extensions, Extensions

Slide 26

Slide 26 text

Will the era of specialized databases be over? Postgres as a multi-purpose db https://www.timescale.com/blog/postgres-the-birdhorse-of-databases/

Slide 27

Slide 27 text

Will the era of specialized databases be over? Postgres is THE database for AI pgvector, pgvectorscale, pgcompute, pg_vectorize, … https://www.linkedin.com/pulse/generative-ai-augmented-recovery-generation-rag-its-data-sampaio-oll2f/

Slide 28

Slide 28 text

Will the era of specialized databases be over? Let me try to be the oracle

Slide 29

Slide 29 text

Will the era of specialized databases be over? AWS will eventually create a new Database to fill the missing gap: A Distributed Database which will be Postgres / Postgres-compatible

Slide 30

Slide 30 text

Will the era of specialized databases be over? Thank you!