Show HN: Honker – Postgres NOTIFY/LISTEN Semantics for SQLite • Hacker News Board

Re: Show HN: Honker – Postgres NOTIFY/LISTEN Semantics for SQLite

#91

Post by valkdb » Tue, Apr 28, 2026, 7:59 AM UTC

[dead]

Re: Show HN: Honker – Postgres NOTIFY/LISTEN Semantics for SQLite

#92

Post by vogje01 » Tue, Apr 28, 2026, 8:21 AM UTC

Cool!

Could I use it as a CRUD message stream?

Just in case I need to inform some consumers.

Re: Show HN: Honker – Postgres NOTIFY/LISTEN Semantics for SQLite

#93

Post by nawi » Tue, Apr 28, 2026, 10:31 AM UTC

The 1 ms pragma data version polling is a nice way to bypass the lack of a server process. didyou measure the impact on cpu or battery life for applications running on lower power devices or laptops? i curious if the polling that prevents the CPU from entering deeper sleep states

Re: Show HN: Honker – Postgres NOTIFY/LISTEN Semantics for SQLite

#94

Post by robertlagrant » Wed, Apr 29, 2026, 10:18 AM UTC

russellthehippo wrote: post #87

robertlagrant wrote: post #30

If I'm using SQLAlchemy, can this integrate? It seems to want to make the db connection itself.

I've added examples for many ORMs and web frameworks to the docs. See here: https://honker.dev/guides/orm/#sqlalchemy--sqlmodel

Thank you.

Re: Show HN: Honker – Postgres NOTIFY/LISTEN Semantics for SQLite

#95

Post by aleken » Thu, Apr 30, 2026, 8:00 AM UTC

I have used update_hooks to achieve similar behaviour in my projects. But perhaps this is intended as a higher level layer? It looks like the implementation is not using hooks?

https://sqlite.org/c3ref/update_hook.html