Postgres for everything
Postgres has been my go-to database for many years now.
I've always been aware that it can provide other functionality (some of which I've used), such as:
- Queue (SKIP LOCKED>
- Pub Sub (NOTIFY)
- JSON data store (jsonb/gin indexes)
- Full text search
- Geo-spatial functionality
But a post on Hacker News opened my eyes to some more things that I wasn't aware of, including returning JSON directly from the database - SELECT row_to_json(row) FROM (SELECT * FROM table) AS row
A nice list of the various things can be found at Postgres for everything
It's truly an amazing piece of software.