docker-compose up
- cargo install sqlx-cli
- sqlx migrate run
- Download dataset here
- Install shp2pgsql
- Run
shp2pgsql -s 4326 TM_WORLD_BORDERS_SIMPL-0.3.shp | psql -h localhost -d postgres -U postgres -p 5431
- Connect to db and run
ALTER TABLE "tm_world_borders_simpl-0.3" RENAME TO countries;