10 comments

[ 3.1 ms ] story [ 40.4 ms ] thread
A small project to monitor your home internet speed with a Raspberry Pi and Google Sheets. I don't think this is a novel idea at all but still want to share.
Little projects like these make me happy so keep it up - thank you!
The discrepancy could be due to where the Pi is located as Wifi signal can vary dramatically and different chips handle things better. I thought my ISP was to blame till I tried connecting to the router via Ethernet. I got myself a 5Ghz router as there was a lot of noise on shared channels with neighbors. I went from ~15Mbps to 108Mbps.
My pi is connected to the router directly with an ethernet cable. The port is rated for 100Mbps as far as I can tell.
One suggestion: You could have used

https://github.com/librespeed/speedtest-cli

It is command line client of https://librespeed.org/ . Librespeed by default is privacy respecting and hence maybe safer than ookla . Also, it lets you to host backend servers if you want to (By default, it has number of servers available)

Looks good, if I ever revisit this with a newer pi, I will use it.
If you’re going to self hosting iperf is worth a look too
You could have just interacted with sheets directly. No firebase.

https://github.com/burnash/gspread

You're right. In fact I could have just created a csv in the first place, and copied it over to g drive. But I was curious about fire store so I may have used it without thinking too hard about it.