db staging - Githubissues

CalCOFI / server

calcofi.io server setup for R Shiny apps, RStudio IDE, R Plumber API, temporary PostGIS database, pg_tileserv

MIT License

0 stars 0 forks source link

db staging #9

Open bbest opened 8 months ago

bbest commented 8 months ago

presently the database server looks like this:

Ideally we move towards :

databases:

dev (developmental) database
- work on creating new tables / columns / relationships
prod (production) database
- static and we can dump the database and have a commit ID and even a DOI
- copy of dev for a given timestamp

schemas:

raw\ raw data, before cleaning / processing or adding any derived columns
public\ final tables for use with APIs, etc; ideally all modifications and QA/QC are generated from reproducible scripts (in workflows)

bbest commented 8 months ago

Add above to:

Ch. 5 Database | CalCOFI Docs