Hacker News Reader

Comment by olmo23 | Hacker News Reader

IIRC the official test-suite is not open-source, so I'm not sure how possible this is.

You do not recall correctly. There is more than 500K SLOC of test code in the public source tree. If you "make releasetest" from the public source tarball on Linux, it runs more than 15 million test cases.

It is true that the half-million lines of test code found in the public source tree are not the entirety of the SQLite test suite. There are other parts that are not open-source. But the part that is public is a big chunk of the total.

Out of curiosity, why aren't all tests open source?

One set of proprietary tests is used in their specialist testing service that is a paid for service.

What is that service used for besides SQLite?

One could assume also for Fossil.

It's still SQLite, they just need to make money: https://sqlite.org/prosupport.html

Edit: also this:

> TH3 Testing Support. The TH3 test harness is an aviation-grade test suite for SQLite. SQLite developers can run TH3 on specialized hardware and/or using specialized compile-time options, according to customer specification, either remotely or on customer premises. Pricing for this services is on a case-by-case basis depending on requirements.

That's interesting. Here is more information https://sqlite.org/th3.html

The roots of SQLite are in defence industry projects of US Navy and General Dynamics. Seems like TH3 might be of interest for these sort of users.

Reply on news.ycombinator.com