From respected by DBAs to loved by Application Developers Craig - - PowerPoint PPT Presentation

▶
from respected by dbas to loved by application developers
SMART_READER_LITE
LIVE PREVIEW

From respected by DBAs to loved by Application Developers Craig - - PowerPoint PPT Presentation

Oct 14, 2022 154 likes •305 views

From respected by DBAs to loved by Application Developers Craig Kerstiens Microsoft Who am I? Product at Heroku Postgres, Citus Data, Microsoft Curate PostgresWeekly Postgres: It has good bones Postgres One of the most loved and Ranked 2017

slide-1
SLIDE 1

From respected by DBAs to loved by Application Developers

Craig Kerstiens Microsoft

slide-2
SLIDE 2

Who am I?

Product at Heroku Postgres, Citus Data, Microsoft Curate PostgresWeekly

slide-3
SLIDE 3

Postgres: It has good bones

slide-4
SLIDE 4

Postgres

One of the most loved and wanted databases in Stack Overflow’s 2019 Developer Survey Ranked 2017 and 2018 DBMS

  • f the Year

by DB-Engine

slide-5
SLIDE 5

Far from perfect

  • Hard to install
  • Expert to configure
  • HA/Replication… just nope

And most importantly How do you pronounce it?

slide-6
SLIDE 6

DBAs

  • It is good and principled
  • I trust it

Developers

  • It’s too hard
  • Doesn’t have new features
slide-7
SLIDE 7

Developers are the new kingmakers

https://thenewkingmakers.c

  • m/
slide-8
SLIDE 8
slide-9
SLIDE 9

We started learning

JSON? JSONB – B stands for better

slide-10
SLIDE 10

Moving beyond RDBMS

Liberal data types Rich indexing Permissive licensing Batteries included

  • Full text search
  • Geospatial support
  • Built-in insights

Kept the core stable but moving forward

slide-11
SLIDE 11

Why Postgres?

JSON B hstor e Array s GIN index PostGI S Concurrent indexing GiST index B-tree index MVC C Time series Safet y Proven track record SP-GiST index KN N BRIN index Listen/noti fy CTE s Window functions Transactional DDL Foreign data wrappers Extensio ns Fast column addition

slide-12
SLIDE 12

Preparing for the future

HyperLogLog TopN Foreign Data Wrappers hstore UUID PostGIS pg_cron ZomboDB Citus HypoPG

slide-13
SLIDE 13

Not always the best, but always good enough

Not the fastest, but it is fast Not the easiest to support, but it is easy Not the most secure, but it is secure Not the shiniest, but it is shiny Not the best every in all categories, but overall it is the most loved

slide-14
SLIDE 14

Why App Devs Love Postgres.

JSON B hstor e Array s GIN index PostGI S Concurrent indexing GiST index B-tree index MVC C Time series Safet y Proven track record SP-GiST index KN N BRIN index Listen/noti fy CTE s Window functions Transactional DDL Foreign data wrappers Extensio ns Fast column addition