News for hackers. Stuff that matters.
Re:Show HN: DoltgreSQL – Version-Controlled DB, Like Git and... by hahn-kev on Thursday November 02, 2023 @11:56AM (#38115356)
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?

Re:Show HN: DoltgreSQL – Version-Controlled DB, Like Git and... by timsehn on Thursday November 02, 2023 @12:08PM (#38115600)
So 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-...

as well as the `dolt_remotes` system table:

https://docs.dolthub.com/sql-reference/version-control/dolt-...

We have a ton of remote options:

https://docs.dolthub.com/sql-reference/version-control/remot...

Right now, DoltHub (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.

Re:Show HN: DoltgreSQL – Version-Controlled DB, Like Git and... by lifty on Wednesday November 08, 2023 @09:07AM (#38190468)
You can already use Dolt in embedded mode. Check this blog post from them: https://www.dolthub.com/blog/2022-07-25-embedded/. I use it like that and it works great.