It is definitely neat, but I think it's more than an exercise. I believe he runs it through the extensive SQLite test suite (I've seen that before, though I can't see where that's stated now).
My understanding was that the sqlite test suite is closed source, and kept under pretty tight grip as it represents their competitive advantage to anyone trying to fork sqlite.
Pretty sure the lead dev said something along those lines when he did an episode of Corecursive?
The bits in https://gitlab.com/cznic/sqlite/-/blob/master/tcl_test.go run the full suite of SQLite TCL tests as part of a Go test. That's in turn run as part a CI setup with results at https://modern-c.appspot.com/-/builder/?importpath=modernc.o....
Those are not all the tests for SQLite: https://sqlite.org/testing.html#harnesses
Only the TCL and SQL Logic Test are publicly available; it's one of the ways that the SQLite developers get paid.
You are correct, I should have clarified that it's just the publicly-available tests. Still, those are pretty expansive.
Re:Go port of SQLite without CGo
by preseinger on Saturday April 08, 2023 @12:03PM
(#35494596)
i use it in production, at high volume and scale
it's got quirks but it's powerful and performs well
I look at it like a neat exercise but not really something to use in production. (I actually use it in tests though.)