Feature Request: distributed supporting

[a876691666]

cr-sqlite

This idea might be a bit fanciful.

Can we use cr-sqlite to support Trailbase and achieve distributed operation of Trailbase

[ignatz]

Various flavors of "distributed" keep cropping up as a discussion. I've also chatted with a few chaps:

• from graft
• hiqlite
• Matt from https://www.reddit.com/r/pocketbase/comments/1pl1h07/my_hack_attempt_at_horizontal_scaling_curious_if/

Another related PB effort: https://github.com/litesql/pocketbase-ha.

There's certainly things that can be done independent of whether cr-sqlite is the best fit. It depends a bit on what folks are trying to achieve. There is a cost to synchronization that could be felt strongly given how fast sqlite is. For me personally the highest priority would be disaster recovery and failover. Edge replication for lower latency reads ads a lot of complexity in terms of traffic routing. There are other challenges around stickiness with realtime connections etc.

I'm also interested in graft because it might unlock PITR.

For disaster recovery, you can get pretty far today with litestream.

Is there anything in particular that you're looking for?

[ignatz]

Update: with the integration of PG and all the changes for it, we may be in a good spot to try out something like hiqlite. I may give it a shot at some point but if anybody else would like to jump in this could be a fun project :hide: 😄