Miki Lombardi
Covid-19 - A crowdsourced map for checking supermarket wait times worldwide
#1about 4 minutes
Addressing long supermarket queues during the COVID-19 lockdown
The global lockdown in 2020 created long, unsafe lines at essential stores, sparking the need for a solution to manage wait times.
#2about 5 minutes
Building a crowdsourced map to track wait times
The project's core idea was to use a map interface and user-submitted data to provide real-time estimates of wait times at local stores.
#3about 2 minutes
Prototyping the application on a Raspberry Pi
The initial version of the application was built with Python and Flask and hosted on a Raspberry Pi 3B for local testing among friends.
#4about 10 minutes
Migrating from local hosting to a cloud architecture
To handle viral traffic growth, the architecture was moved from a single Raspberry Pi to multiple VPS instances on OVH and Digital Ocean.
#5about 4 minutes
Leveraging Redis for geospatial data management
Redis and its geospatial index commands were critical for efficiently storing, querying, and managing location points and distances on the map.
#6about 5 minutes
Analyzing the project's minimal operational costs
The entire project was run on a very low budget, costing only about $25 per month for cloud services to support millions of user sessions.
#7about 3 minutes
Reflecting on the project's impact and open source
The open-source project successfully served over a million users and highlighted the power of community collaboration in solving real-world problems.
#8about 1 minute
Q&A: Tracking map usage against pandemic spread
User traffic on the map showed a strong correlation with the geographical spread of the pandemic, starting in Italy and moving to the Americas.
#9about 9 minutes
Q&A: Technical lessons and potential future applications
The project could be improved with better code optimization instead of relying heavily on caching, and its technology could be adapted for other use cases like conferences.
Related jobs
Jobs that call for the skills explored in this talk.
Featured Partners
Related Videos
47:1640 Minutes to Build a Serverless COVID-19 REST and GraphQL APIs
Maxime Beugnet
50:06Single Server, Global Reach: Running a Worldwide Marketplace on Bare Metal in a Cloud-Dominated World
Jens Happe
28:12Scaling: from 0 to 20 million users
Josip Stuhli
30:25Hate organising your photos? Try it with 5 Terabytes
Arto Liukkonen
1:05:44WeAreDevelopers LIVE - Vector Similarity Search Patterns for Efficiency and more
Chris Heilmann, Daniel Cranney, Raphael De Lio & Developer Advocate at Redis
43:11100 million days in Vienna: A story of APIs & AI in tourism.
Thomas Reiter
32:56Web development: where are we, and where are we going?
Laurie Voss
22:32Swapping Low Latency Data Storage Under High Load
George Asafev
From learning to earning
Jobs that call for the skills explored in this talk.
![Senior Software Engineer [TypeScript] (Prisma Postgres)](https://wearedevelopers.imgix.net/company/283ba9dbbab3649de02b9b49e6284fd9/cover/oKWz2s90Z218LE8pFthP.png?w=400&ar=3.55&fit=crop&crop=entropy&auto=compress,format)
Senior Software Engineer [TypeScript] (Prisma Postgres)
Prisma
Remote
Senior
Node.js
TypeScript
PostgreSQL
Angular Developer
Picnic Technologies B.V.
Amsterdam, Netherlands
Intermediate
Senior
RxJS
Angular
TypeScript
Senior Java Developer
Picnic Technologies B.V.
Amsterdam, Netherlands
Senior
Java
Spring
Amazon Web Services (AWS)
Full Stack Developer - AI Team (Global Digital)
Populous
Charing Cross, United Kingdom
€64K
API
CSS
GIT
REST
+19
(Senior) Desarrollador Full-Stack (Next.js / Node.js)
OKAPI: Orbits
Municipality of Madrid, Spain
API
GIT
Java
REST
WebGL
+14
Lead Software Engineer Python / PostgreSQL / Redis / Celery - Scale-up Fintech
WAKE IT UP
Paris, France
Senior
Redis
Python
PostgreSQL
Continuous Integration