I got a Slack message from colleagues at a major partner. They’d updated their dev environment to support WebSockets, so that Neon’s serverless driver could be used there, but then they’d run into a weird issue.  The nub of it was this: This hangs: This works Reproducibly, the query without an ORDER BY ran fine […]

Materialize

Bobby Iliev

DevOps

Community Picks is a section on daily.dev where our community members share the most interesting and valuable content they've discovered online. From insightful articles to handy tools, every post is a gem curated by our dedicated coomunity. To contribute to Community Picks, you need to have at least 250 reputation points, ensuring that only active and trusted members can share their finds.

Community Picks

A debugging story details an issue with a PostgreSQL query that hangs when using LIMIT 10 but works with LIMIT 9. The problem is linked to WebSocket payload lengths and an underlying bug in the undici package's handling of WebSocket frames in Node.js. The story highlights the nuances of WebSocket framing, the importance of precise buffer management, and how a small code fix resolved the problem.

When LIMIT 9 works but LIMIT 10 hangs