~/talk

osm2pgsql flex backend

Talkat State of the Map US 2023 · 2023-06-08..06-11· [databases]
links:none on file
slides:none on file

osm2pgsql’s new flex backend lets users define arbitrary tables and uses a per-object flex API to decide for each node way or relation where it goes so you can handle nodes ways relations multipolygons and then run phase-two processing to revisit ways after relations are read. It supports geometry ops (polygons→points merge split), a minutely-updated whole-planet DB workflow, raster-based generalization for merged landuse and an advanced tile expiration system to minimize re-renders.

AI-written summary · about

  1. 0:00Intro
  2. 0:19What is osm2pgsql?
  3. 1:12Middle and memory
  4. 2:02Different backends
  5. 4:36Simple node-only example
  6. 5:09More advanced usage
  7. 7:06Generalization
~/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.