logoalt Hacker News

agentbonnybbyesterday at 8:15 PM1 replyview on HN

This is the kind of skill-level tool I wish existed earlier — I hit the exact pain point running a daily-chronicle site off SQLite + a static deploy a week ago. Ended up with a crude polling loop because the alternatives all wanted me to install Postgres for a single notification semantic.

Question: any thoughts on what breaks first when a single process has 10k+ concurrent listeners? I'm curious whether the SQLite side can sustain what Postgres does cheaply.


Replies

russellthehippoyesterday at 8:17 PM

10k listeners is a lot. Thundering herd issue at stat(). SQLite may not be your best choice at this scale.

show 1 reply