News for hackers. Stuff that matters.
Re:SQLite Release 3.25.0 adds support for window functions by cosmie on Wednesday August 15, 2018 @05:22AM (#17764693)
Ditto! For anyone who isn't familiar with SQLite's testing procedures, read this[1] fascinating page.

The SQLite project has a mind boggling 711 times more test code than SQLite itself has. Put another way, only 0.1% of the project's code is SQLite itself. The other 99.9% consists of tests for that 0.1%.

[1] https://www.sqlite.org/testing.html

Re:SQLite Release 3.25.0 adds support for window functions by OskarS on Wednesday August 15, 2018 @05:39AM (#17764757)
In a similar vein, I rarely (if ever) seen a library that handles dynamic memory allocation more robustly than SQLite. This page is a glory to behold: https://www.sqlite.org/malloc.html
Re:SQLite Release 3.25.0 adds support for window functions by clappski on Wednesday August 15, 2018 @02:28PM (#17768479)
That page is inspiring, for a commodity, open source and old software project everything is very clearly defined and the language is very definitive which I hope is indicative of the actual library quality (I’ve never used SQLite).
Re:SQLite Release 3.25.0 adds support for window functions by cosmie on Wednesday August 15, 2018 @06:04AM (#17764842)
Oh that is a fun read! I hadn't seen that before.
Re:SQLite Release 3.25.0 adds support for window functions by mabbo on Wednesday August 15, 2018 @05:48AM (#17764789)
While in complete agreement with you on how amazing SQLite's engineering practices are, your math is off by an order of magnitude.

1/711 = 0.00140646976

0.00140646976 ~= 0.14%, not 0.01%.

I'll go put on my "pedant" hat now.

Re:SQLite Release 3.25.0 adds support for window functions by cosmie on Wednesday August 15, 2018 @06:03AM (#17764839)
Thanks for catching that!

Although it was more a typo than a math error (as the 99.9% figure was correct). I'll chalk it up to posting when I should be sleeping (4:30am local time).

Re:SQLite Release 3.25.0 adds support for window functions by sehugg on Wednesday August 15, 2018 @06:13AM (#17764872)
Good thing too, since it's in just about everything: https://www.sqlite.org/mostdeployed.html
Re:SQLite Release 3.25.0 adds support for window functions by m_fayer on Wednesday August 15, 2018 @06:48AM (#17765063)
I find it fun to look around whatever room/bus/park that I'm in and try to count the instances of Sqlite.
Re:SQLite Release 3.25.0 adds support for window functions by Cthulhu_ on Wednesday August 15, 2018 @06:56AM (#17765096)
Is it like curl in that regard?