Read/write split on the same host

[solracsf]

My question is, using the read-replica, is there any benefit (thinking about locking here) hosting both write.db and read.db files (primary and ro-replica) on the same host and split connections using /path/to/read.db?mode=ro? Or is it too much pain for little (no?) benefits?

Goal here is not to achieve some HA setup but rather a "better" scaling single-node mode.

[benbjohnson]

@solracsf The read replica code has been removed from Litestream. It didn't quite fit Litestream very well so it's been moved to another project called LiteFS.

As for performance, I don't think you'll see much benefit as SQLite handles locks between readers & writers really well when using the WAL journaling mode.

[solracsf]

Noted, thanks!