wordpress-playground icon indicating copy to clipboard operation
wordpress-playground copied to clipboard

Explore Dolt

Open adamziel opened this issue 11 months ago • 4 comments

https://github.com/dolthub/dolt is a SQL database that you can fork, clone, branch, merge, push and pull just like a Git repository.

MySQL->Dolt replication, push/pull mechanics, and the conflict resolution approach could give us a lot for free. PostgreSQL support is on their roadmap, too, and perhaps that’s how WP could get Postgres support. A few things that worry me are the ~103mb binary size, no plans to support WebAssembly (in 2019 at least), and no timeline for Dolt->MySQL replication.

cc @bgrgicak @brandonpayton

adamziel avatar Mar 11 '24 23:03 adamziel

That looks pretty cool. I haven't had a chance to play with it yet, but it got me thinking: Dolt may turn out to be directly useful for Playground and WP, but if it doesn't, there may still be a lot we can learn from how it approaches merge, push, and pull.

brandonpayton avatar Mar 12 '24 02:03 brandonpayton

I'm also curious what contributes to its 103mb binary size. Maybe the essential parts wouldn't take much space.

brandonpayton avatar Mar 12 '24 02:03 brandonpayton

I'm also curious what contributes to its 103mb binary size. Maybe the essential parts wouldn't take much space.

Hmm, it's written in Go which defaults to static linking.

brandonpayton avatar Mar 12 '24 02:03 brandonpayton

Dolt may turn out to be directly useful for Playground and WP, but if it doesn't, there may still be a lot we can learn from how it approaches merge, push, and pull.

+1 we will probably need to build something in the end. Dolt seems to have a lot more features than we actually need.

bgrgicak avatar Mar 12 '24 05:03 bgrgicak