rqlite[1] author here. It's very interesting see this. Not sure whether it can bring more functionality to rqlite, but it's definitely cool to see the SQLite database evolve with more client-server applications in mind.
I will say that one misconception people often have about rqlite is that it's a drop-in replacement for SQLite. You see that a bit even in the comments section here. That was never its goal. Its goal is a lightweight and super-simple to use distributed relational database. Using SQLite as the database engine was the perfect way to meet that requirement.
I will say the promise of "improved concurrency" is very interesting to me. If nothing else, I would definitely pull that into rqlite (probably as an option). That said, working with Raft log has always been the real bottleneck, not SQLite.
I will say that one misconception people often have about rqlite is that it's a drop-in replacement for SQLite. You see that a bit even in the comments section here. That was never its goal. Its goal is a lightweight and super-simple to use distributed relational database. Using SQLite as the database engine was the perfect way to meet that requirement.
[1] https://www.rqlite.io