litequeue
pgmq
| litequeue | pgmq | |
|---|---|---|
| 3 | 11 | |
| 138 | 897 | |
| 3.6% | 13.4% | |
| 7.4 | 8.9 | |
| about 2 months ago | 19 days ago | |
| Python | Rust | |
| MIT License | PostgreSQL License |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
litequeue
-
Choose Postgres Queue Technology
To make sure you that the message you are trying to retrieve hasn't been locked already by another worker.
[0]: https://github.com/litements/litequeue/
[1]: https://github.com/litements/litequeue/blob/3fece7aa9e9a31e4...
-
SQL Maxis: Why We Ditched RabbitMQ and Replaced It with a Postgres Queue
SQLite is missing some features like `SELECT FOR UPDATE`, but you can work around some issues with a few extra queries. I wrote litequeue[0] with this specific purpose. I haven't been able to use it a lot, so I don't have real-world numbers of how it scales, but the scaling limits depend on how fast you can insert into the database.
[0]: https://github.com/litements/litequeue
-
What's New in SQLite 3.35
The `RETURNING` is so awesome! I'm implementing a set of data structures on top of SQLite, one of them is a queue[0], and I had to do a transaction to lock a message and then return it, but this makes it easier.
There's one little issue I keep finding with SQLite, and it's that most virtual servers / VM images ship with version 3.22.0, and upgrading often means building from source.
In any case, SQLite is absolutely wonderful. My favorite way of building products is having a folder for all the DBs that I mount to docker-compose. This release makes it even better.
[0] https://github.com/litements/litequeue
pgmq
- Pgmq: Lightweight message queue extension for Postgres
- Replace SQS / RSMQ with pgmq: A lightweight message queue based on Postgres
-
Introducing pgzx: create PostgreSQL extensions using Zig
And lots of interesting extensions use it, like
https://github.com/tembo-io/pgmq
https://github.com/zombodb/zombodb
https://github.com/supabase/pg_jsonschema
-
Show HN: Hatchet – Open-source distributed task queue
Have you considered https://github.com/tembo-io/pgmq for the queue bit?
- Show HN: An SQS Alternative on Postgres
-
Postgres as Queue
some notes about pgmq, https://github.com/tembo-io/pgmq, that is on this list. It is built as an extension in Postgres, which makes it compatible with all languages that have a Postgres driver.
There's no 'magic' to it, it uses existing Postgres features so all the performance and consistency guarantees of Postgres are to be expected. Easily gets to 10k+ concurrent reads and writes even on smaller sized Postgres instances, which is more than most applications need.
- FLaNK Weekly 31 December 2023
-
What are the best job-scheduling tools, frameworks or libraries?
Newer project but there's no library needed. https://github.com/tembo-io/pgmq. They have a pretty simple SQL api similar to SQS. It's an extension though, so some cloud provider will not support it.
- FLaNK Stack Weekly for 20 Nov 2023
-
Choose Postgres Queue Technology
PGMQ does not require a client library, https://github.com/tembo-io/pgmq so long as your language of choice can run SQL. All the functions live in Postgres, and you just call them with SQL statement. Very similar feel and semantics to SQS.
What are some alternatives?
datasette-dateutil - dateutil functions for Datasette
pg-boss - Queueing jobs in Node.js using PostgreSQL like a boss
pgjobq - Atomic low latency job queues running on Postgres
kubeblocks - KubeBlocks is an open-source control plane that runs and manages databases, message queues and other data infrastructure on K8s.
Bedrock - Rock solid distributed database specializing in active/active automatic failover and WAN replication
FLaNK-EveryTransitSystem - Every transit system
sqlite_modern_cpp - The C++14 wrapper around sqlite library
torchgeo - TorchGeo: datasets, samplers, transforms, and pre-trained models for geospatial data
litestream - Streaming replication for SQLite.
CML_AMP_Intelligent-QA-Chatbot-with-NiFi-Pinecone-and-Llama2 - The prototype deploys an Application in CML using a Llama2 model from Hugging Face to answer questions augmented with knowledge extracted from the website. This prototype introduces Pinecone as a database for storing vectors for semantic search.
starqueue
screenshot-to-code - Drop in a screenshot and convert it to clean code (HTML/Tailwind/React/Vue)