As a courtesy to our users, TravisTorrent provides both offline and online access options. No registration or subscription is required. Users are kindly asked to follow a fair-use policy of server resources.
Thanks to Google, we can provide a BigQuery interface to TravisTorrent. Everyone with a Google account gets a free monthly quota of one Terabyte on BigQuery to instantly start querying TravisTorrent!
Usage Instructions: If you are not fully signed-up for Big Query (you get an error saying Big Query is unable to find the TravisTorrent table when clicking the access link), follow Google’s instructions on how to set it up. Should you not already be in the query browser, click on the big red button on the top left that says Compose Query
. You can then input sample queries in SQL syntax and run them via CTRL+ENTER
. For example, SELECT AVG(tr_duration) FROM [travistorrent-bq:data.2017_01_11]
computes the average mean build time over all projects.
Update March 7, 2022: The links in the table below no longer work and is kept in-place only for archival purposes. Please download the TravisTorrent dump from Figshare, where it should be kept “forever”.
We distribute snapshots of our database as compressed SQL and CSV files. The SQL is generated from automatically reading in the CSV.
Tip: If you use R and CSV, loading the CSV via fread
from data.table
offers a significant speed-up over read.csv
.
Snapshot Revision | Date | Size |
travistorrent_8_2_2017.csv.gz | 11.1.2017 | 184M |
travistorrent_8_2_2017.sql.gz | 11.1.2017 | 181M |
archived: travistorrent_11_1_2017.csv.gz | 11.1.2017 | 190M |
archived: travistorrent_11_1_2017.sql.gz | 11.1.2017 | 193M |
archived: travistorrent_6_12_2016.sql.gz | 6.12.2016 | 178M |
archived: travistorrent_6_12_2016.csv.gz | 6.12.2016 | 175M |
archived: travistorrent_27_10_2016.sql.gz | 27.10.2016 | 78M |
archived: travistorrent_27_10_2016.csv.gz | 27.10.2016 | 78M |
archived: travistorrent_30_9_2016.sql.gz | 30.9.2016 | 78M |
archived: travistorrent_30_9_2016.csv.gz Includes changes to data types, e.g. TRUE instead of “true” |
30.9.2016 | 79M |
archived: travistorrent_7_9_2016.sql.gz | 7.9.2016 | 78M |
archived: travistorrent_7_9_2016.csv.gz | 7.9.2016 | 79M |
archived: travistorrent_5_3_2016.sql.gz | 5.3.2016 | 51M |
archived: travistorrent_5_3_2016.csv.gz | 5.3.2016 | 79M |
archived: travistorrent_28_8_2015.csv.gz | 28.8.2015 | 65M |
Update March 7, 2022: Access to raw build logs is no longer possible.
To allow a deeper analysis of project build logs, the 780 GB of build logs that our build log analysis (most entries prefixed with tr_
) depends on can be retrieved, too. Please be gentle with server bandwidth. Access the raw build logs. If you used these, please also cite or reference TravisTorrent properly.