News for hackers. Stuff that matters.
Re:SQLite Release 3.25.0 adds support for window functions by electroly on Wednesday August 15, 2018 @06:41PM (#17770380)
I'm sorry, you've misunderstood. I'm fully aware that you can query it more efficiently, and in fact that's the point. If you're writing a virtual table provider, SQLite does not provide enough information about the actual user's query for you to know that you can do it more efficiently. There's no way to know that the user wants a count at all; the count function is not pushed down into the virtual table provider interface. SQLite only tells you that it needs you to retrieve every field in every row. You can't know that, in actuality, SQLite only wants to count the rows.
Re:SQLite Release 3.25.0 adds support for window functions by bobwaycott on Wednesday August 15, 2018 @07:24PM (#17770608)
Ah. My apologies. I did misunderstand what you were calling attention to.