Skip to content

You Got Job Queues in My SQLite!

Published: at 04:33 PM

Picture this: one person is walking down the street eating a chocolate bar, while another person is walking toward them eating peanut butter out of a jar, ya know, as you do. They collide. The person with the chocolate bar exclaims, “You got peanut butter on my chocolate!” The other replies, “You got chocolate in my peanut butter!” Then a narrator says, “Two great tastes that go great together…”

This and others like this were a series of commercials that ran in the 1970s and 1980s for Reese’s Peanut Butter Cups. What does this have to do with anything? First, the image of someone walking down the street with an open jar of peanut, eating from with nothing but than their fingers is hilarious. Second, when I read about Honker, a SQLite extension that gives it the ability to handle task queues, event streams, and pub/sub that vintage, classic commercial came to mind. “You got X in my SQLite!”

The Github repo’s README for this project does a great job of giving examples in multiple languages but I wanted to take it for a spin myself so I created a little demo using Docker and Python. Since everything runs in Docker you can build it, run the producer and workers and check out how it works!

SQLite-native worker queue demo using honker


Next Post
C2PA Ruby Library Release