Why? Costs, operational complexity, data consistency

1. Caching with UNLOGGED table (that I've also found in other posts)
2. Pub/Sub with LISTEN/NOTIFY
3. Job Queues with SKIP LOCKED
4. Rate Limiting is also possible
5. Sessions with JSONB

PostgresSQL ist nearly 2 times slower compared to Redis, but is it worth it?

When to keep Redis?

1. extreme performance needed
2. using redis-specific data structures

Migration strategy:

1. Side by side
2. Read from Postgres
3. Write to Postgres only
4. Remove Redis

and Prisma provide for example typedSQL to have a smooth integration with Typescript.

Redis is faster, but they have the same order of magnitude. Maybe +1 order for Postgres in same examples.

The comparison of a lot of data does not made though.

A basic reimplementation of Redis. I like to use SQLite for it.

A description of a modern website architecture. It uses a bunch of modern technologies, and the author explains why they are useful in its case.

Antirez bequeaths the Yossi and Oran