3 ms·
Really exciting, I was interested in Dolt but I prefer postgres. I'm curious if you have any plans for local first development. I love the idea of a version co
by hahn-kev 3y ago
Really exciting, I was interested in Dolt but I prefer postgres.
I'm curious if you have any plans for local first development. I love the idea of a version controlled database, but I want to use it for local first and distributed data syncing for users who are frequently without internet. It's not clear how you would do this without running the database locally. Do you have thoughts on this? DoltLite?
- timsehn 3y agoSo you can do local first with the `dolt_clone()`, `dolt_remote()`,`dolt_fetch()`, `dolt_pull()`, and `dolt_push()` procedures: https://docs.dolthub.com/sql-reference/version-control/dolt-sql-procedures https://docs.dolthub.com/sql-reference/version-control/dolt-... as well as the `dolt_remotes` system table: https://docs.dolthub.com/sql-reference/version-control/dolt-system-tables#dolt_remotes https://docs.dolthub.com/sql-reference/version-control/dolt-... We have a ton of remote options: https://docs.dolthub.com/sql-reference/version-control/remotes https://docs.dolthub.com/sql-reference/version-control/remot... Right now, DoltHub (https://www.dolthub.com/ https://www.dolthub.com/) will still work as a remote but all the SQL there will be the MySQL version. Over time the Doltgres storage format may become more bespoke and we'll have to figure out how DoltHub will work.
- lifty 3y agoYou can already use Dolt in embedded mode. Check this blog post from them: https://www.dolthub.com/blog/2022-07-25-embedded/ https://www.dolthub.com/blog/2022-07-25-embedded/. I use it like that and it works great.