René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"sqlite: expose prepared statement stats","articleBody":"### What is the problem this feature will solve?\n\nSqlite's prepared statements [collect various statistics about their behavior](https://sqlite.org/c3ref/stmt_status.html); see [the full list here](https://sqlite.org/c3ref/c_stmtstatus_counter.html). It would be nice to expose them.\n\nMost notably, as discussed [here](https://tenderlovemaking.com/2026/07/15/detecting-full-table-scans-with-sqlite/), you can check whether a statement has performed a full table scan. Asserting that a statement does not perform a full scan is a very useful check to prevent degenerate performance.\n\n### What is the feature you are proposing to solve the problem?\n\nAdd one or more methods or getters on [StatementSync](https://nodejs.org/api/sqlite.html#class-statementsync) exposing this information.\n\nThis could be:\n- a single method where you pass the name of the counter you're interested in and get a number back\n- a single method with no parameters which returns all the counters as an object\n- a method for each counter\n- a getter for each counter\n\nMy inclination would be getters, but I'm ok with any of these options.\n\nOptionally, we could also expose methods to reset the counters. That seems less important but it's a feature in the underlying API.\n\n### What alternatives have you considered?\n\nI don't think there is any way to do this currently. `sqlite3_stmt_status` isn't exposed to userland by any mechanism I can find.","author":{"url":"https://github.com/bakkot","@type":"Person","name":"bakkot"},"datePublished":"2026-07-16T17:45:04Z","url":"https://github.com/nodejs/node/issues/64540"}