search

NYCPlanning / ae-zoning-api

This application is API for serving data related to zoning and tax lots.
2 stars 0 forks source link

37 postgis setup: node-based #160

Closed TangoYankee closed 8 months ago

TangoYankee commented 9 months ago

Install postgis into postgres image Stage postgres image with setup scripts Configure npm commmands to create postgis extension and copy data update readme setup instructions

closes #37

This uses the existing pgClient configuration to run migrations against the database within a node environment. Though, it reads the raw sql files directly, rather than going through drizzle. It also adds npm scripts to semi-automate the running of these scripts. If we wanted to, we could combine the db:configure, db:migrate, and db:copy commands into a single alias. For now, this gives us the "easy single api" experience of running node scripts without the rigidity of always running an operation once it's part of the migrations.

TylerMatteo commented 8 months ago

@TangoYankee I approved this but, as you mentioned in stand up, it wouldn't hurt to confirm that the set up process works for other folks before merging.