On: Show HN: Goqite, a persistent message queue Go lib...

[polyrand]

I also built something similar for Python [0]. I decided to go with a separate DB file for the queue, I think it's better for performance but also to avoid mixing the data storage with the message queue (in my case, I assume the message queue is just an implementation detail and not really tied to the rest of the DB schema).

[0]: https://github.com/litements/litequeue

[markusw → polyrand]

Yeah, that’s a good idea! I was today old when I learned that SQLite can have transactions across separate db files.

[ncruces → markusw]

Only if you don't use WAL.

[markusw → ncruces]

Ooooooooh. TIL!