- Postgres – psql and the Tools You Actually Use
psql is the tool that ships with the database and the one every answer online assumes. The meta-commands worth memorising — \d, \d+, \di, \l, \dn, \x, \timing — the connection URI in full, running a file with ON_ERROR_STOP so a migration does not half-apply, and a .psqlrc that makes the shell bearable. Plus where a GUI still wins.
- Intellij Hot Keys
Reformat Code For Mac ⌥ ⌘ L command + option + l View Structure/Outline of Class command + 7
- 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.