News for hackers. Stuff that matters.
Re:SQLite Release 3.25.0 adds support for window functions by ddebernardy on Wednesday August 15, 2018 @03:42PM (#17769064)
I dunno... In my neck of the woods, datasets larger than anything a hard drive will store are commonplace, making SQLite a non-starter. I can imagine SQLite being useful for prototyping or for toy apps or for one-offs with small datasets, but not much else...

(Edit to clarify: I think it's awesome for embedded apps. But it never struck me as a good choice for data science.)

Re:SQLite Release 3.25.0 adds support for window functions by peatmoss on Wednesday August 15, 2018 @03:50PM (#17769130)
Cool, but in between data that fits in RAM and data that requires exotic storage and computing surely you can at least imagine data of this mid-sized variety.

For that, SQLite isn’t necessarily bad.