Yeah it kinda feels like we're just going back to how things were before everyone decided 12-factor was the new hotness. SQLite has its uses for sure - just no

Yeah it kinda feels like we're just going back to how things were before everyone decided 12-factor was the new hotness. SQLite has its uses for sure - just not on a system that might need horizontal scaling, HA, or separate worker processes. Sure, sure, you can duct tape a few SQLites together but then you're dealing with this > LiteFS only allows a single node to be the primary at any given time. The primary node is the only one that can write data to the database. The other nodes are called replicas and they provide a read-only copy. Might as well have just set up a separate DB server, less faff. At the point where you need to scale MySQL/postgres beyond vertical scaling you can probably afford to pay someone to do it for you