Slide 1

Slide 1 text

HASURA CON 21 Recap Part 1 karszawa

Slide 2

Slide 2 text

@karszawa Engineering Lead at dinii Inc. TypeScript, React, GraphQL

Slide 3

Slide 3 text

Hasura Con 2 1 SQL Server subscriptions: Up and running Delivering real-time statistics for the 2 021 Olympics

Slide 4

Slide 4 text

GraphQL subscription Hasura WebSocket query Firestore onSnapshot Hasura onSnapshot

Slide 5

Slide 5 text

Delivering real-time statistics for the 2 0 2 1 Olympics The Washington Post non-Hasura AWS Step Function, Amazon Simple Queue Service, Pusher 
 Hasura with subscription Simple & Easy

Slide 6

Slide 6 text

KD KD

Slide 7

Slide 7 text

Hasura subscription 1 1 SQL WebSocket multiplexing 🤨 😄 っ select * 🤨 from orde r where customerId = xxx select * 🤨 from orde r where customerId = yyy select * 😄 from orde r wher e customerId = xxx O R customerId = yyy

Slide 8

Slide 8 text

KD 1 
 
 
 Cloud Run Hasura 50 10 Cloud SQL PostgreSQL CPU 90 60% 🤔 multiplexing 💡

Slide 9

Slide 9 text

multiplexing 😔 
 
 Cloud Run 80 80 250 WebSocket

Slide 10

Slide 10 text

WebSocket Cloud Run

Slide 11

Slide 11 text

Hasura NG 🙅 ⾒ Hasura DB 
 Cloud Run App Engine 
 Hasura Cloud っ DB GCP

Slide 12

Slide 12 text

KD 30 🤯 
 DB Hasura KD subscription 1,2s 30s 
 1,2s

Slide 13

Slide 13 text

Hasura 1 1 SQL 1 ⾒ Cloud SQL 


Slide 14

Slide 14 text

PostgreSQL 🎉 
 subscription 🙅 Hasura Haskell

Slide 15

Slide 15 text

👋 Hasura multiplexing っ 100 
 っ 1 っ 
 
 MySQL PostgreSQL MySQL