Using Postgres to locate the best coffee near you!
Presented by:
Varun Dhawan
Varun Dhawan is a Principal Product Manager in the Azure Postgres team at Microsoft, specializing in PostgreSQL. With over two decades of experience, he has deep expertise in database systems like PostgreSQL, SQL Server, and Oracle. Varun leads initiatives aimed at enhancing cloud database technologies, improving developer experience and empowering businesses to leverage the full potential of open-source databases.
Before joining Microsoft, Varun was a DevOps Engineer at Target Corp. and a Database SRE at McKinsey&Company, where he focused on improving database performance and driving cloud technology adoption. His passion for sharing knowledge is evident through his writing on his personal blog - https://data-nerd.blog/ and Azure Database for Postgres Blog, where he explores database management insights and best practices.
You can follow him on twitter @iVarund or connect on https://www.linkedin.com/in/varundhawan/
No video of the event yet, sorry!
Using Postgres to locate the best coffee near you!
The talk combines PostgreSQL with spatial and vector data to enable natural language queries for precise results, such as asking, "Where's the nearest coffee shop?" Vector data will be explained as a tool that enhances PostgreSQL's ability to manage geographical information. The session explores how to integrate spatial and vector data using PostGIS and pgvector extensions.
A hands-on demonstration will show how to set up PostgreSQL to handle these types of queries, store geographical data, and create queries that respond to natural language inputs. A practical example will involve finding the best nearby coffee shops using these technologies.
Participants will leave the session equipped to apply similar GIS features in their own applications, making them more intuitive and user-friendly.
- Date:
- Duration:
- 45 min
- Room:
- Conference:
- PGConf India, 2025
- Language:
- Track:
- Application Developer
- Difficulty:
- Medium