ElephantSQL is the fallback Db for students who have trouble installing Postgres - mainly Windows students and some ubuntu. ElephantSQL has a 20MB limitation on free accounts so we need to slim down the database.
Attached is a DB dump with about 1000 restaurants and grades. Plus some additional commands to DROP TABLE/TYPE IF EXISTS in case the student attempts to reload the data. This comes in around 15MB in ElephantSQL. Honestly, I'm not sure why it is that large, but that's what they list it as.
ElephantSQL is the fallback Db for students who have trouble installing Postgres - mainly Windows students and some ubuntu. ElephantSQL has a 20MB limitation on free accounts so we need to slim down the database.
Attached is a DB dump with about 1000 restaurants and grades. Plus some additional commands to DROP TABLE/TYPE IF EXISTS in case the student attempts to reload the data. This comes in around 15MB in ElephantSQL. Honestly, I'm not sure why it is that large, but that's what they list it as.
nyc-restaurants-data-backup.sql.zip