2023-03-07, 11:15–11:45, Auditorium
In this talk we will explore Tile38, FastAPI briefly, and how to combine them to create quick APIs for delivering geospatial data.
Parkopedia is the world's leading parking services provider. It provides parking related data products to companies ranging from Apple to VW.
Parkopedia products and features require fast geospatial queries to function, such as, accessing information about parking spaces along routes, and within an area. While Redis provides fast geospatial queries, and has good scalability, only point geometries can be stored and can only perform relatively simple queries. Databases such as Postgres with PostGIS and MySQL allow for more complex geospatial queries, however, they are relatively slow and have trouble scaling.
Tile38 is an in-memory database that supports advanced geospatial queries. Complete geometries can be stored, and it has the capability to perform intersects and within queries, as well as many more features. The queries retrieve the geometries as well as ancillary information. The performance and scalability is on another level in comparison to traditional relational database solutions, and on par with Redis.
FastAPI is a modern web framework for creating APIs with Python. It is fast in terms of both performance as well as development speed, is self documenting and in general is a pleasure to use.
In this talk we will explore these individual technologies, benchmark the performance against alternatives, and walkthrough creating a web API that wraps Tile38.