json singh
I have worked as a developer in Open Source GIS domain in multiple startups for the past 6 years and built many applications from scratch to production, managed teams, hired people and wore many other hats.I had the honor of working with companies from all over the world including Japan, Switzerland, Australia, US and more.
Now I am volunteering at OSGeo, giving back to the community that has given me access to the whole wide world.
Sessions
Ever wonder what it'll be like to "just" get APIs for your PostGIS database?
This workshop is for people:
- Have spatial data in PostGIS
- Want to store their spatial data in PostGIS
- Want REST APIs over their data
Summary:
Most applications out there are just versions 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.
The workshop will be divided in two parts:
- Working with spatial data in PostGIS
- Building APIs over PostGIS using PostgREST
Part 1:Working with PostGIS
If you are well versed with PostGIS you can skip this section.
- Introduction to postgres and the extension PostGIS
- Installation of PostGIS
- Normal installation
- Installation using Docker
- Other ways: Demo test server connected using Dbeaver, pgAdmin etc
- Storing PostGIS
- Reading from PostGIS
- Connecting to QGIS
- Visualizing in the tool (Dbeaver & pgAdmin)
- Updating the PostGIS data
- Standard SQL commands
- Useful functions like ST_Area as generated columns
- Deleting the data
~~ Break ~~
Part 2: Working with PostgREST
- Introduction to PostgREST
- Installing PostgRest
- Docker
- Demo server
- Understanding PostgREST APIs
- Basic Configuration
- More granular control over data
Outro
- Where to go from here?
- Q&A