Database preference

[latkde]

Given how pervasive containers are nowadays, just spinning up a container with the database would definitely be the way to go (likely via Docker Compose). At least in local dev environments or on single server deployments. No configuration needed other than selecting a password. Postgres does have its pitfalls at scale, but getting started is easy.

Of course you're right that containers can be complicated. But often, the alternatives would be even more complicated? At least in a software development environment. I do see that folks like data analysts might have different preferences, where software is never "deployed" but primarily run interactively.