- Postgres – Install and Connect
Postgres 16 in a container in one command, then the same thing done properly: a docker-compose file with a named volume, a healthcheck that waits for the database rather than the process, and an init script. Why the published port is the one that enforces a password and the container socket is not, what happens to your data on `down -v`, and how to connect from psql, a URI and an app.
- Postgres – Introduction
What Postgres actually is under the marketing: one process per connection, a write-ahead log, and MVCC — which is why a reader never blocks a writer and why VACUUM has to exist. Which version to run, what the release cycle promises, and an honest table of where Postgres beats MySQL, where it does not, and the three questions worth asking before you pick either.
- Recursion in Coding Interviews
Most people can explain what recursion is and still freeze when a problem needs it under time pressure. The three questions that turn a blank page into a fill-in-the-blanks exercise, the leap of faith that stops you tracing calls in your head, when recursion is the wrong tool, and how to reason about the cost of a branching search.
- Testing
- Security