[ivanr]

Try NATS @ https://nats.io

It's a single binary and can operate as a message bus, persistent queue, KV store, object store, provide services, and so on.

[Zambyte]

I really like NATS, but it's worth noting that it's only really "the SQLite of queues" in the context of their Go client, which can embed a NATS server into an application.

Otherwise I would really say it is more like the Postgres of queues (still great, but potentially not what OP is looking for)