Database Documentation⚑

Schema⚑

Connecting⚑

Running Locally in Docker Container⚑

• pgsync/pg_dump to retrieve SQL from remote hosted production database
• spin up docker container for postgres locally with correct credentials (password=p, port=5432, dbname = postgres, etc.)
• create copy of remote database's public schema in the newly created docker container
• connect to local container database instance from apps, API, etc.

Resources:⚑

Tools⚑

• Database Markup Language (DBML)
• dbdocs.io
• dbdiagram.io
• PostgreSQL
• psql
• pgcli

GUI's⚑

• pgAdmin4
• Valentina Studio
• DBeaver
• VSCode
• RStudio

R Packages⚑

• DBI
• RPostgres
• RPostgreSQL
• Pool
• dbplyr
• dbplyr
• dbx
• connections
• sqlpetr
• sqldf

and more...

---

Links: PostgreSQL | PostgreSQL Tools | System Design | Databases Source: https://techdocs.powwater.org