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
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