News for hackers. Stuff that matters.
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!