Datasette is 5 today: a call for birthday presents

Datasette is great for non-technical people to explore a sqlite database via a web interface.

My two recent Datasette use cases:

1) My sales team had to come up with a list of potential clients (businesses) that owned a certain number of vehicles, transported a certain kind of cargo, and operated in certain geographies etc. Excel could not be used, since the filesize was a couple of GBs. With Datasette, the sales team was able to create multiple filters without knowing SQL. It also created great looking interactive maps.

2) An elderly friend of mine wanted to explore his apple watch heart rate (EKG) data, since he was experiencing an irregular heartbeat. After importing apple health kit data into Datasette, my friend was able to ascertain the period where he had an irregular heartbeat. He also exported data for that time period and shared it with his doctor.