I've been using Postgres for everything I could for a long time already and I'm very happy about it.

Lately I've been trying SQLite for small projects which use small databases, and I'm also enjoying it a lot. The fact that the whole database system is just a file (no separate server and client) makes it convenient for such small projects, IMO.