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.
Now, where SQLite starts to fall down in analytics workloads is that it’s row-oriented rather than column oriented. Performance could be better. Still, even for analytic workloads SQLite can be good enough for medium-sized data!