News for hackers. Stuff that matters.
Re:SQLite's Automatic Indexes by yread on Wednesday December 28, 2022 @12:37PM (#34163468)
would be cool to get a diagnostic message when that happens
Re:SQLite's Automatic Indexes by chasil on Wednesday December 28, 2022 @12:42PM (#34163532)
For transient indexes, or permanent ones?

The transient indexes will be created in a separate, temporary file. They will be erased on a commit, rollback, or crash recovery. They will not persist.

Re:SQLite's Automatic Indexes by masklinn on Thursday December 29, 2022 @03:22AM (#34170640)
Per the linked mailing list post there’s no dust but there is a back channel through which you can be notified:

> SQLite comes with instrumentation (specifically the SQLITE_STMTSTATUS_AUTOINDEX verb for sqlite3_stmt_status() - http://www.sqlite.org/c3ref/stmt_status.html) that can be used to detect when automatic indices are used and alert the developer through a back channel to this fact so that she can fix the problem with an appropriate CREATE INDEX. In other words, SQLite provides you with the tools to help you detect and eliminate the use of automatic indices.