BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//pretalx//talks.staging.osgeo.org//foss4g-europe-2025-workshops//s
 peaker//8MGXWG
BEGIN:VTIMEZONE
TZID:CET
BEGIN:STANDARD
DTSTART:20001029T040000
RRULE:FREQ=YEARLY;BYDAY=-1SU;BYMONTH=10
TZNAME:CET
TZOFFSETFROM:+0200
TZOFFSETTO:+0100
END:STANDARD
BEGIN:DAYLIGHT
DTSTART:20000326T030000
RRULE:FREQ=YEARLY;BYDAY=-1SU;BYMONTH=3
TZNAME:CEST
TZOFFSETFROM:+0100
TZOFFSETTO:+0200
END:DAYLIGHT
END:VTIMEZONE
BEGIN:VEVENT
UID:pretalx-foss4g-europe-2025-workshops-PM9MCX@talks.staging.osgeo.org
DTSTART;TZID=CET:20250714T090000
DTEND;TZID=CET:20250714T130000
DESCRIPTION:Ever wonder what it'll be like to "just" get APIs for your **Po
 stGIS** database? \nThis workshop is for people:\n- Have spatial data in P
 ostGIS\n- Want to store their spatial data in PostGIS\n- Want REST APIs ov
 er their data\n\n**Summary**:\nMost applications out there are just versio
 ns of **"CRUD on Data"** and spatial data is no different. While there are
  certainly a lot of things you can do with `spatial data`\, the CRUD part 
 remains the same.\nThe workshop will be divided in two parts:\n- Working w
 ith spatial data in PostGIS \n- Building APIs over PostGIS using PostgREST
 \n\n\n**Part 1:Working with PostGIS**\nIf you are well versed with PostGIS
  you can skip this section.\n- Introduction to postgres and the extension 
 PostGIS \n- Installation of PostGIS  \n   - Normal installation \n   - Ins
 tallation using Docker \n   - Other ways: Demo test server connected using
  Dbeaver\, pgAdmin etc \n- Storing PostGIS \n- Reading from PostGIS \n    
 - Connecting to QGIS\n    - Visualizing in the tool (Dbeaver & pgAdmin)  \
 n-  Updating the PostGIS data \n    - Standard SQL commands \n    - Useful
  functions like ST_Area  as generated columns \n- Deleting the data \n\n~~
  Break ~~ \n\n**Part 2: Working with PostgREST**  \n- Introduction to Post
 gREST\n- Installing PostgRest  \n   - Docker \n   - Demo server \n- Unders
 tanding PostgREST APIs \n- Basic Configuration \n- More granular control o
 ver data \n\n**Outro** \n- Where to go from here? \n- Q&A
DTSTAMP:20260525T112549Z
LOCATION:PA01
SUMMARY:Building REST API over your PostGIS database - json singh
URL:https://talks.staging.osgeo.org/foss4g-europe-2025-workshops/talk/PM9MC
 X/
END:VEVENT
END:VCALENDAR