It is an amazing model! I think it works well because it's a library that is "infrastructure" / "support" for other systems though (browsers, android)
I wonder if it applies to the kind of software that is more complete like anything with a UI etc. If I get the final result the tests don't mean much to me.
Well, it applies to very popular software. SQLite3 is probably the most popular software ever written. This really might be a special case. But it probably would work for things like: OpenSSL, PostgreSQL, Java, Rust, and a few others. Most if not all of those don't need to change models, which leaves newer / less popular projects, and for those to bootstrap this model is difficult. It might be that the SQLite model is unique -- that it won't be repeated much or at all.