logoalt Hacker News

CharlesWyesterday at 6:38 PM5 repliesview on HN

> IMHO breaking free of SQLite's proprietary test suite is a bigger driver than C vs Rust.

I don't understand this claim, given the breadth and depth of SQLite's public domain TCL Tests. Can someone explain to me how this isn't pure FUD?

"There are 51445 distinct test cases, but many of the test cases are parameterized and run multiple times (with different parameters) so that on a full test run millions of separate tests are performed." - https://sqlite.org/testing.html


Replies

adamzwassermantoday at 4:14 PM

SQLite's test suite is infamously gigantic. It has two parts: the public TCL tests you're referencing, and a much larger proprietary test suite that's 100x bigger and covers all the edge cases that actually matter in production. The public tests are tiny compared to what SQLite actually runs internally.

show 1 reply
lmmtoday at 12:49 AM

The test suite that the actual SQLite developers use to develop SQLite is not open-source. 51445 open-source test cases is a big number but doesn't really mean much, particularly given that evidently the SQLite developers themselves don't consider it enough to provide adequate coverage.

einsteinx2yesterday at 6:57 PM

The irony is if they only had the public domain tests, no one would complain even though it would mean the exact same number of open source tests.

show 1 reply
digitalPhonixyesterday at 7:35 PM

The next bullet point:

> 2. The TH3 test harness is a set of proprietary tests…

show 1 reply
Ar-Curunirtoday at 3:01 AM

There are also non-public tests.