~/talk

NORM: No ORM Framework

Talkat PGConf NYC 2021 · 2021-12-02..12-03· [databases, developer-experience]
slides:none on file

Claims an ORM causes many tiny round trips and replaces it with NORM — No‑ORM Framework that maps application model and database model to a JSON transport contract, implemented as PostgreSQL user‑defined types and stored functions. Examples and code at https://github.com/hettie-d/NORM show creation, search, update and delete working in one call, an array_transport to JSON text used to return strong‑typed payloads, and a reduction from hundreds of DB calls per page to single optimized queries.

AI-written summary · about

  1. 0:00Introduction
  2. 1:43What is NORM
  3. 3:13Response time matters
  4. 9:47CONTRACT
  5. 12:13Postgres
  6. 20:35Functions
  7. 26:46Examples
  8. 33:04Additional Considerations
~/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.