~/talk

Increasing Velocity with GraphQL and PostgreSQL

Talkat ReactiveConf 2019 · 2019-10-30..11-01· [graphql, databases]
slides:none on file

Combining GraphQL with PostgreSQL yields a generated GraphQL API from tables, indexes, functions and permissions so most CRUD surfaces emerge automatically, cutting repeated wiring by 80–90% boilerplate eliminated. Row-level security enforces per-row access declaratively (row-level security Postgres 9.5) and query planner improvements make it practical (Postgres 10 performance fix Oct 2017). Example: add a comments table plus grants and policies, write one client query line, and the feature exists with fewer round trips and predictable SQL.

AI-written summary · about

  1. 0:00Start
  2. 5:20Rails Migration
  3. 11:58Row-Level Security
  4. 13:09Create Policy
~/search
type to search 6,249 conferences, 138,987 speakers and 185,172 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.