brew install pgloader
brew install [email protected]
brew services start [email protected]
brew link [email protected] --force
curl -LO http://ergast.com/downloads/f1db.sql.gz
gunzip -k f1db.sql.gz
msyql -uroot
> create database f1db;
> source f1db.sql
createdb f1db
pgloader mysql://root@localhost/f1db pgsql:///f1db
psql -d f1db
f1db# COPY (select distinct driverid, driverref, drivers.number, code, forename, surname, dob, nationality, drivers.url from drivers join results using(driverid) join races using(raceid) where raceid in (1008, 1007)) to '/Users/nackjicholson/Downloads/drivers.csv' csv header;
tail -n +2 drivers.csv > drivers_data.csv
sqlite3
sqlite> create table drivers (driverid integer not null primary key, driverref text not null, number integer not null, code text not null, forename text not null, surname text not null, dob date not null, nationality text not null, url text not null);
sqlite> .mode csv
sqlite> .import /Users/nackjicholson/Downloads/drivers_data.csv drivers
sqlite> select * from drivers;
