Tag Archives: Database

Updated GHCN Load Scripts & Reduced Warnings

Posted on 14 May 2019 by E.M.Smith

And inproved version of the MariaDB / MySQL database and data loading scripts, with run times and discussion. Many warnings removed and one data loading bug fixed. Continue reading →

Posted in NCDC - GHCN Issues, Tech Bits | Tagged , , , , | 12 Comments

Some Benchmarks For SBCs

Posted on 30 April 2019 by E.M.Smith

I run some sysbench benchmarks on various computers and SBCs I have. Continue reading →

Posted in Tech Bits | Tagged , , , , , | 24 Comments

A GHCN Temperature Database Install Script

Posted on 6 April 2019 by E.M.Smith

A couple of scripts to do all the database installation, Python install, table creating, table loading et. al. with minimal steps. It does not include the FORTRAN data preparation steps that are only done once but are documented in other postings. It does bring together bits and pieces from several postings in one place so you don’t need to search all over to find the bits. Continue reading →

Posted in NCDC - GHCN Issues | Tagged , , , , , , | 4 Comments

GHCN in MYSQL quick and easy

Posted on 31 August 2015 by E.M.Smith

A short ‘How To’ on having a GHCN V3 database ( in MySQL or similar) up and running on your computer in about 15 minutes. Continue reading →

Posted in NCDC - GHCN Issues | Tagged , , , | 19 Comments