Now we can schedule a cron job to run this script on regular intervals, I’m going to set it to run once every hour running this commands on a system terminal:

#! /usr/bin/env Rscript # Data adquisition output <- read.csv( text = system( command = 'speedtest -f csv -output-header -accept-license', intern = TRUE ) ) results <- ame( stringsAsFactors = FALSE, time = as.POSIXct( Sys.time()), ip = system( 'curl ', intern = TRUE), # This field is no longer provided on the new CLI version ping = output $latency, download = output $download * 7.629395E-6, # Convert to Mbps upload = output $upload * 7.629395E-6, # Convert to Mbps isp = 'movistar' # This field is not provided on CSV format ) # Data storing con <- dbConnect( drv = odbc :: odbc(), driver = 'PostgreSQL ANSI', server = 'localhost', database = 'internet', # Name of the database on the sql server port = 5432, uid = Sys.getenv( 'MY_UID'), pwd = Sys.getenv( 'MY_PWD'), encoding = 'utf8') DBI :: dbAppendTable( conn = con, name = 'speed_test', # Table name on the sql server value = results ) odbc :: dbDisconnect( conn = con) # Cleaning log files unlink( x = '*.log', force = TRUE) In the next lines, I’m going to show you how to do this from R and get the results in the form of nice plots you can tweet to your ISP to annoy them a little bit. In reality, you end up getting far slower download speeds than advertised, and ISPs (Internet Service Providers) get away with this because they only test download speed with you once when they install the service (suspiciously it works great at that moment) and most people don’t bother to keep track of their download speeds over time because it would be impractical to manually perform speed tests every short period of time, luckily there is a better way, Ookla’s Speedtest service provides a Command Line Interface (CLI) that allows you to perform tests from your system terminal enabling you to set up automated scripts to collect connection performance data.

Rm3J2J2Cdz- Andrés Castro Socolich January 16, 2020 If it makes you feel better, it could be worse if you lived in another country, trust me, I know. I thought this only happened in my country (Perú), but it turns out it happens to people around the globe, you contract an Internet Service Plan that offers up to X Mbps, where X is an impressive value (relative to each country’s context), but the catch is in that word, Up to.

Ookla packet loss