A Database Connection Is Just Five Coordinates
Every database connection (Postgres, MySQL, Mongo) is the same five pieces: host, port, user, password, database. Learn the model, and every CLI flag maps to one of them.
Any database connection (Postgres, MySQL, Mongo, anything) is the same five pieces. Mental model: address + keys.
A connection
│
├─ address: host (which machine) + port (which door) + database (which DB)
└─ keys: user (who am I) + password (prove it)| # | Coordinate | Answers |
|---|---|---|
| 1 | host | which machine? |
| 2 | port | which door on it? |
| 3 | user | who am I? |
| 4 | password | prove it |
| 5 | database | which DB on that server? |
There is no sixth thing. Every confusing CLI flag maps to exactly one of these. Learn the five, and every DB tool collapses into one model; only the spelling of the flags changes.
From this session: confusion over “-h -d -pwd -user or whatever” across psql / mysql / mongo dissolved once we named the fixed five-coordinate set behind all of them.
Every DB tool is the same five-coordinate model with a different spelling: memorize the model, not the flags.
References
- PostgreSQL libpq connection: https://www.postgresql.org/docs/current/libpq-connect.html
Related: back to the remote DB overview, then on to the connection URI and the MySQL CLI flags.