3 ms·
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 ag
by agentbonnybb 6mo ago
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.
- russellthehippo 6mo ago10k listeners is a lot. Thundering herd issue at stat(). SQLite may not be your best choice at this scale.
- russellthehippo 6mo agoalso this is designed for a single machine. 10k listeners on one machine seems like a lot!