News for hackers. Stuff that matters.
Re:SQLite Release 3.25.0 adds support for window functions by cryptonector on Wednesday August 15, 2018 @11:06AM (#17766560)
The "lite" refers to things like:

   - it only has b*-tree indexes
   - it only has one index per-table source
Re:SQLite Release 3.25.0 adds support for window functions by SQLite on Wednesday August 15, 2018 @12:05PM (#17767098)
> it only has one index per-table source

I don't know for sure what this means, but it sounds like it is incorrect.

Re:SQLite Release 3.25.0 adds support for window functions by cryptonector on Wednesday August 15, 2018 @05:25PM (#17769906)
I could swear I've seen you say this. Maybe I'm mis-remembering? ISTR it was that for each table source in a query SQLite3 uses just one index (or the table itself) for indexing or scanning to find relevant rows in that table source.
Re:SQLite Release 3.25.0 adds support for window functions by SQLite on Wednesday August 15, 2018 @05:49PM (#17770087)
SQLite can use multiple indexes if there are OR terms in the WHERE clause.

SQLite tries to only uses indexes in situations where they help the query run faster. SQLite is not limited in its use of indexes. It is just that the use of multiple indexes for a single FROM-clause term is rarely helpful.

Re:SQLite Release 3.25.0 adds support for window functions by cryptonector on Wednesday August 15, 2018 @06:15PM (#17770215)
Ah, OK, thanks!