zlacker

[return to "Choose Postgres queue technology"]
1. andrew+Wc[view] [source] 2023-09-24 22:08:34
>>bo0tzz+(OP)
You don't even need a database to make a message queue. The Linux file system makes a perfectly good basis for a message queue since file moves are atomic.

My guess is that many people are implementing queuing mechanisms just for sending email.

You can see how this works in Arnie SMTP buffer server, a super simple queue just for emails, no database at all, just the file system.

https://github.com/bootrino/arniesmtpbufferserver

◧◩
2. doctor+De[view] [source] 2023-09-24 22:23:16
>>andrew+Wc
This is true, and I’ve worked on systems that use this, but it’s a lot more work than just a rename.

I’d recommend that, if you have a Postgres database already, definitely use that instead. Your queues will be transactional and they will get backed up when the rest of your database does.

◧◩◪
3. andrew+3f[view] [source] 2023-09-24 22:28:11
>>doctor+De
>> but it’s a lot more work than just a rename

Such as?

◧◩◪◨
4. ruuda+TE3[view] [source] 2023-09-25 21:27:26
>>andrew+3f
Detecting broken files when your application crashed half-way through a write; coordinating id generation.
[go to top]