~/talk

Map Mastery – Spatial Tips for Your Laravel App

Talkat Laracon EU Online 2021 · 2021-01-18..01-22· [databases, web-platform]
links:none on file
slides:none on file

Shows concrete tactics: use geojson casts in Laravel 7+ to pass features, prefer Leaflet/OpenStreetMap over costly Google or Mapbox tiles, extract EXIF with Intervention Image to auto-fill locations, store either lat/long numeric fields for fast, simple queries or PostGIS spatial types for polygons, add spatial indexes (GIST can cut common queries up to ~200%), and prefer a bounding box scope for nearby queries (100k points from ~200ms to <10ms in his benchmark) and lazy-load maps and tiles to avoid surprise bills.

AI-written summary · about

  1. 0:00Start
  2. 0:07Map Mastery Tips & Tricks for working with Spatial Data in Laravel
  3. 2:56Pick your mapping provider Careful of the costs
  4. 3:28Map the Minimum
  5. 3:39Simplify your base map
  6. 4:33Hide all the controls
  7. 5:49Scale
  8. 15:53Turning a collection of models into GeoJSON
  9. 17:27Enable EXIF extension
~/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.