I'm surprised they didn't spend more time talking about HCTree branch.<p><a href="https://sqlite.org/hctree/doc/hctree/doc/hctree/index.html" rel="nofollow">https://sqlite.org/hctree/doc/hctree/doc/hctree/index.html</a>
For production setups, you usually want high-availability. So unless you use it on a network file system like EFS (which the SQLite author recommends against), SQLite is not an option.
Related: Turbo [1] helps dealing with SQLite replication in a different way.<p>[1] <a href="https://turso.tech/" rel="nofollow">https://turso.tech/</a>