News for hackers. Stuff that matters.
Re:It’s About Time for Time Series Databases by da_chicken on Thursday January 25, 2018 @02:52PM (#16233990)
Yep. Parallel performance is the biggest issue I've seen with SQLite.

SpiceWorks is the biggest example of a product that doesn't scale because they've elected to use SQLite (and only SQLite). There's no hard limit on the number of devices, but most people say not to exceed about 1,000 devices. We tested it out against 800 devices. We started it on Friday. On Monday, it was still running.

The only other issue I've seen with it is with the data typing. Type inference is much weaker than strict typing, and sometimes it doesn't quite store things the way you'd expect. Granted, the last time I saw problems with that was years ago, but I've seen it.

Re:It’s About Time for Time Series Databases by baldfat on Thursday January 25, 2018 @03:54PM (#16234569)
There are plenty of problems that don't need parallel performance.
Re:It’s About Time for Time Series Databases by da_chicken on Thursday January 25, 2018 @04:45PM (#16234990)
And there are plenty that do. What's your point?
Re:It’s About Time for Time Series Databases by mixmastamyk on Thursday January 25, 2018 @05:08PM (#16235162)
Because some won’t consider sqlite even for those that don’t.