4 ms·

Postgres isn’t the only way to have fun. Other things just as good at being a queue: SQLite SQL server MySQL Plain old files on the file system

bhaney 3y ago
std::queue and a big swap file
cha42 3y ago
you can certainly encode queue in many ways. mkfifo just work. But integrating the queue in the DB isn't a bad idea if you want to have both the queue and the db in a shared state. I am happy that my queue inherit ACID properties. SQLite simply doesn't allow concurrent write so it is a no go for a queue. I don't know much about SQL Server and MySQL but I wouldn't favor a lockin closed source software or anything remotely connected to Oracle. At the end, only Postgresql remains I guess. Also, Postgresql is super solid and the closest to SQL standard.
- andrewstuart 3y ago
  You’re wrong that I’m wrong.
- tarruda 3y ago
  > mkfifo just work Are you certain about that?
- otoburb 3y ago
  >>I don't know much about SQL Server and MySQL but I wouldn't favor a lockin closed source software or anything remotely connected to Oracle. If that's a concern, then MariaDB is another alternative. Postgres isn't the only option in town. EDIT: I'm correcting myself here because as far as I can tell, LISTEN NOTIFY equivalent capabilities are only available in MariaDB's SkyQL fully managed services offering, and not in the base MariaDB Community Server.
tussa 3y ago
Don't forget the plain old postit notes.
- geon 3y ago
  I thought those were write-only?
  - dkersten 3y ago
    Use a pencil so you can erase (or an erasable pen like the frixion erasable pens)
  - tussa 3y ago
    I believe the right terminology is immutable.
crizzlenizzle 3y ago
> Plain old files on the file system …and accessed over SFTP. I worked for a company in the health industry and one of the labs we integrated refused to call a HTTPS endpoint whenever a result was ready, so we had to poll every _n_ mins to fetch results. That worked well until covid happened and there were so many test results causing all sorts of issues like reading empty files (because they were about to be written to disk) and things of that nature.

bhaney 3y ago

std::queue and a big swap file

cha42 3y ago

you can certainly encode queue in many ways. mkfifo just work. But integrating the queue in the DB isn't a bad idea if you want to have both the queue and the db in a shared state. I am happy that my queue inherit ACID properties. SQLite simply doesn't allow concurrent write so it is a no go for a queue. I don't know much about SQL Server and MySQL but I wouldn't favor a lockin closed source software or anything remotely connected to Oracle. At the end, only Postgresql remains I guess. Also, Postgresql is super solid and the closest to SQL standard.

andrewstuart 3y ago
You’re wrong that I’m wrong.
tarruda 3y ago
> mkfifo just work Are you certain about that?
otoburb 3y ago
>>I don't know much about SQL Server and MySQL but I wouldn't favor a lockin closed source software or anything remotely connected to Oracle. If that's a concern, then MariaDB is another alternative. Postgres isn't the only option in town. EDIT: I'm correcting myself here because as far as I can tell, LISTEN NOTIFY equivalent capabilities are only available in MariaDB's SkyQL fully managed services offering, and not in the base MariaDB Community Server.

tussa 3y ago

Don't forget the plain old postit notes.

geon 3y ago
I thought those were write-only?
- dkersten 3y ago
  Use a pencil so you can erase (or an erasable pen like the frixion erasable pens)
- tussa 3y ago
  I believe the right terminology is immutable.

crizzlenizzle 3y ago

> Plain old files on the file system …and accessed over SFTP. I worked for a company in the health industry and one of the labs we integrated refused to call a HTTPS endpoint whenever a result was ready, so we had to poll every _n_ mins to fetch results. That worked well until covid happened and there were so many test results causing all sorts of issues like reading empty files (because they were about to be written to disk) and things of that nature.