dittodb uses the
nycflights13 dataset for testing and example purposes.
nycflights13 dataset contains airline on-time data for all flights departing NYC in 2013. It also includes useful ‘metadata’ on airlines, airports, weather, and planes.
Have a look to the database schema:
dittodb has a few functions that make loading
nycflights13 data into a database easier.
nycflights13_sql(con, schema = "nycflights") will write the
nycflights13 data to the database connect to with
con and write it to the schema
To quickly set up an SQLite version
nycflights13_sqlite() will create an in-memory SQLite database with the