Skip to content

Instantly share code, notes, and snippets.

View Lef-F's full-sized avatar
👾

Lef Filippakis Lef-F

👾
View GitHub Profile
@Lef-F
Lef-F / 0-speedtest-sqlite-python.md
Last active July 12, 2022 08:06
Perform a speedtest on your internet connection and store the results in a sqlite db table, using python.

Home internet speedtest

Wanna log your internet speed smoothly over time?

No worries, with the help of Python, speedtest-cli and SQLite you can run the following Python script in e.g. a cronjob and store the resuts one row at a time in the speedtest table of your speedtest.db.

Every time you execute speedtest.py it will add a new row to your speedtest table in your SQLite database.

python3 run_speedtest.py --db-path /path/to/my/speedtest.db --speedtest-exec-path /path/to/my/speedtest-cli/executable