Ask HN: What Is the SQLite of Queues?

24 points by dinobones a month ago

I love how simple and lightweight sqlite is.

I'm looking for an open source queue solution with similar qualities. All I really want are topics/messages/publishers/subscribers. That's it.

I do not want to run ZooKeeper.

deterministic a month ago

SQLite is the SQLite of queues. Simply use a table per queue. And use your choice of SQL to implement the types of queues you want.

withinboredom a month ago

beanstalkd might be what you are looking for. It's ancient but solid af. I know of systems still running today that use it. For something more modern, check out Nats—and if you are using Go, you can embed the server in your executable.

ivanr a month ago

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 a month ago

    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)

toast0 a month ago

/var/queue/

brudgers a month ago

Serious engineering question:

Will SQLite work for your application?

I’m sure there are better solutions on paper and for performance under common workloads. But if SQLite is good enough for your use case, it’s good enough for your use case.

It probably isnt. Good luck.

  • turtle_heck a month ago

    Was wondering this for OP as well, I've used a database as a queue for small projects in the past and it was fine.

bbkj a month ago

[dead]