SShortSingh.
Back to feed

Developer builds background job queue using PostgreSQL SKIP LOCKED

0
·1 views

A developer building a service for scheduling HTTP jobs explored using PostgreSQL as a job queue instead of adding Redis and BullMQ. They created a jobs table in PostgreSQL to store pending tasks with execution times and statuses. The implementation uses SKIP LOCKED to allow multiple workers to safely claim jobs from the database concurrently. To handle worker crashes, the system uses timed leases on claimed jobs and a recovery process for expired leases. This approach allowed the developer to avoid introducing an additional infrastructure dependency.

Read the full story at DEV Community

This is an AI-generated summary. ShortSingh links to the original source for the complete article.

Discussion (0)

Log in to join the discussion and vote.

Log in

Related stories

0
ProgrammingDEV Community ·

Developer analyzes $320 million ransom negotiation details from terminal

A developer named Davi de Jesus detailed an analysis of a $320 million ransom negotiation. The analysis was performed from a computer terminal and posted on September 8. It involved examining data related to a significant digital ransom demand. The technical exploration, shared on DEV Community, touched on topics including Bitcoin, Python, security, and open-source software.

0
ProgrammingDEV Community ·

Independent review finds SupaVoxel outperforms Tripo AI in 3D model generation test

An independent reviewer tested two AI 3D modeling services, Tripo AI and SupaVoxel, using the same source image of a skull ornament. The reviewer generated models using each service's default settings and analyzed the resulting files for printability. Tripo's model was significantly larger and more expensive in credits but introduced unwanted wood-grain texture into the geometry. SupaVoxel's model was smaller, cheaper, and produced a cleaner mesh, though it required some repair for shell structure. The reviewer concluded SupaVoxel's output was preferable for 3D printing the specific test object.

0
ProgrammingDEV Community ·

Tutorial: Building a Competitive Intelligence Agent for Public Companies

A developer tutorial proposes building a competitive intelligence agent for public companies. The agent is designed to gather and synthesize data from sources like SEC filings, news, and market data. It aims to extract strategic signals and produce a cited brief for human review. The workflow is implemented in TypeScript and uses the Valyu API for data retrieval. The tool is intended for research purposes and explicitly avoids providing investment advice.

0
ProgrammingDEV Community ·

Developer creates EchoVault app to archive family recipes and stories from voice notes

A developer built an app called EchoVault for older family members to preserve oral memories. The tool allows users to easily record or forward voice notes, like those sent over WhatsApp. An open-source AI pipeline then processes the audio to separate cooking instructions from personal anecdotes. The system archives these elements into an interactive digital book accessible to the whole family.