SerendipityNL

-- Upload to https://chart-studio.plot.ly/create
SELECT
    `date`,
    `amount` / `pageviews` AS `queries_per_page`
FROM
    `log_queries`;

SELECT
    `date`,
    AVG(`amount` / `pageviews`) AS `queries_per_page`

SerendipityNL

Extract a gzip file and import the result into a locally hosted database

function import_gzip_to_mysql {
  read "gzipfilename?gzip filename [~/Development/database.gz]: "
  gzipfilename=${gzipfilename:-~/Development/database.gz}
  read "database?Target database: "
  pv $gzipfilename | gunzip | mysql -u root --password=root $database
}

SerendipityNL

This is Ardziej's solution:

JS

$.AdminLTESidebarTweak = {};

$.AdminLTESidebarTweak.options = {
    EnableRemember: true,
    NoTransitionAfterReload: false
    //Removes the transition after page reload.