Miki Lombardi

Covid-19 - A crowdsourced map for checking supermarket wait times worldwide

See how a simple Python and Redis app, built on a Raspberry Pi, scaled to serve millions of users during a global crisis for just $25 a month.

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.

job ad

Saby Company
Delebio, Italy

Intermediate

d

Saby Company
Delebio, Italy

Junior

Matching moments

The technical journey of building the climate map
14:48 MIN

The technical journey of building the climate map

From Code to Cause: Building a Sustainable Future with Tech

An overview of the 2021 web developer survey
00:03 MIN

An overview of the 2021 web developer survey

Web development best practices in 2021

How crisis accelerated Python adoption in enterprise
00:53 MIN

How crisis accelerated Python adoption in enterprise

Enterprise Python: Software That Lives Long And Prosper

The challenge of making raw COVID-19 data usable
00:32 MIN

The challenge of making raw COVID-19 data usable

40 Minutes to Build a Serverless COVID-19 REST and GraphQL APIs

Introducing the "Make My Day" tourism prototype
00:21 MIN

Introducing the "Make My Day" tourism prototype

100 million days in Vienna: A story of APIs & AI in tourism.

Pandemic-driven tech adoption beyond the games industry
15:16 MIN

Pandemic-driven tech adoption beyond the games industry

We are all part of the game

Showcasing useful libraries and fun web games
47:02 MIN

Showcasing useful libraries and fun web games

WeAreDevelopers LIVE - Whats Nuxt and Next for app development, 20 years AJAX and more

Sustainable habits for developers beyond coding
31:50 MIN

Sustainable habits for developers beyond coding

Sustainable me. A tale of good design.

Featured Partners

Related Videos

See all videos
Single Server, Global Reach: Running a Worldwide Marketplace on Bare Metal in a Cloud-Dominated World50:06

Single Server, Global Reach: Running a Worldwide Marketplace on Bare Metal in a Cloud-Dominated World

Jens Happe

40 Minutes to Build a Serverless COVID-19 REST and GraphQL APIs47:16

40 Minutes to Build a Serverless COVID-19 REST and GraphQL APIs

Maxime Beugnet

Scaling: from 0 to 20 million users28:12

Scaling: from 0 to 20 million users

Josip Stuhli

Hate organising your photos? Try it with 5 Terabytes30:25

Hate organising your photos? Try it with 5 Terabytes

Arto Liukkonen

WeAreDevelopers LIVE - Vector Similarity Search Patterns for Efficiency and more1:05:44

WeAreDevelopers LIVE - Vector Similarity Search Patterns for Efficiency and more

Chris Heilmann, Daniel Cranney, Raphael De Lio & Developer Advocate at Redis

Web development: where are we, and where are we going?32:56

Web development: where are we, and where are we going?

Laurie Voss

Creating a routing app with Google Maps API from scratch55:39

Creating a routing app with Google Maps API from scratch

Germán Álvarez

100 million days in Vienna: A story of APIs & AI in tourism.43:11

100 million days in Vienna: A story of APIs & AI in tourism.

Thomas Reiter

Related Articles

View all articles
LM
Luis Minvielle
Developers share the most interesting tech they ever built
Most people's first thoughts about Hacker News revolve around venture capital, stock prices, company valuations, and $1499 dongles. But what if we told you that Hacker News could also be a place for pure, consummate, wholesome content that tackles ho...
Developers share the most interesting tech they ever built
CH
Chris Heilmann
All the videos of Halfstack London 2024!
Last month was Halfstack London, a conference about the web, JavaScript and half a dozen other things. We were there to deliver a talk, but also to record all the sessions and we're happy to share them with you. It took a bit as we had to wait for th...
All the videos of Halfstack London 2024!
LM
Luis Minvielle
10 Developer Websites in 2023
As a web developer, you're always investigating how to level up your skills and streamline your workflow. That's why we've gathered a collection of 10 innovative tools that are guaranteed to boost your productivity, enhance your coding abilities, ele...
10 Developer Websites in 2023

From learning to earning

Jobs that call for the skills explored in this talk.