alt Hacker NewsLibSQL doesn't look anywhere close to active enough to consider it for production IMO.
Just compare the most recent commits from LibSQL: https://github.com/tursodatabase/libsql/commits/main/
To those of SQLite: https://sqlite.org/src/timeline
One of these looks like a healthy and actively maintained project. The other isn't quite dead, but it's limping along.
Your activity comparison isn't wrong, but it's because they are focused on doing a complete rewrite instead of focusing on the libSQL fork.
https://turso.tech/blog/we-will-rewrite-sqlite-and-we-are-go...