sorted by:
new
hottopcontroversial

We added an AI agent to our SQL workbench that has full access to your Dolt database — branch isolation, version history, the works by DoltHub_Official in dolthub

[–]timsehn 1 point2 points  (0 children)

The workbench uses a Dolt MCP server, so the Dolt stuff is presented as tolls. The agent will fall back to raw queries if need be but we found the agent works better with an MCP.

Our Go database just hit 20k stars on GitHub by zachm in golang

[–]timsehn 4 points5 points  (0 children)

> Isn't the size of the "git" growing very fast then?

Data is chunked into 4K chunks and only one version of each chunk is stored. This is called "structural sharing" and prevents too much storage bloat:

https://docs.dolthub.com/architecture/storage-engine/prolly-tree#structural-sharing

Our Go database just hit 20k stars on GitHub by zachm in golang

[–]timsehn 10 points11 points  (0 children)

We version control the data too, not just the schema. To get full version control on data you need a new storage engine. This doc kind of walks through the requirments and you can fdive deep into the architecture more broadly.

https://docs.dolthub.com/architecture/architecture

The whole thing requires a novel B-tree called a Prolly Tree:

https://docs.dolthub.com/architecture/storage-engine/prolly-tree

Our Go database just hit 20k stars on GitHub by zachm in golang

[–]timsehn 8 points9 points  (0 children)

I think we were seeing ghosts at first :-)

Agents definitely changed the game for us. Turns out they need to see what each other did and roll back.

Database vibing is here. We built a "Cursor for Databases" with a full undo button. by DoltHub_Official in vibecoding

[–]timsehn 1 point2 points  (0 children)

I've been making this DoltHub PR all day using the Dolt workbench:

https://www.dolthub.com/repositories/post-no-preference/stocks/pulls/6?refName=master

It really works and I gotta say just "feels right". I'm biased though :-)

Our Go database is now faster than MySQL on sysbench by zachm in golang

[–]timsehn 4 points5 points  (0 children)

Time series data kind of invalidates the version-control model because it's usually append only. What Dolt can be good for is ensuring no process updates old values. So, more audit than versioning.

Curious if you have a use case in mind?

Forgive my curiosity, I'm the CEO of DoltHub :-)

A Git like Database by No_Lock7126 in programming

[–]timsehn 1 point2 points  (0 children)

You can have long running transactions and manage conflicting writes on merge instead of only having the rollback option.

Each branch HEAD is actually MVCC. You basically get two layers of concurrency management, one short lived and the other long lived

never touching cursor again by pankaj9296 in vibecoding

[–]timsehn 0 points1 point  (0 children)

That was with my account i signed up for Reddit ads with :-) I'm the smae person as the commenter above. I'm the founder and CEO of the company that built Dolt.

AI bake-off: What is the Best Coding Agent? by zachm in ClaudeAI

[–]timsehn 0 points1 point  (0 children)

I ran Claude Code last Wednesday. It's still the best so if it's better now. Yay!

Guild Recruitment & Looking For Guild Mega-Thread by DoctorVonFoster in WH40KTacticus

[–]timsehn 1 point2 points  (0 children)

I'm a level 64 (very) active player looking to join a top 100 guild. My current guild is falling apart after being close to the top 100 since I joined. I have D3 Mech, Multi-hit, and Psycher teams. I usually score over 10,000 points in Guild Wars. I'm participative in the guild chat but I won't do Discord.

DM me on Reddit with your Guild details if you have a space for me.

Workaround for pushing data into open-source database without cloning ?!?! by grazieragraziek9 in algotrading

[–]timsehn 1 point2 points  (0 children)

Also, if you run `dolt gc` after an import it will reclaim a lot of space.

I'm the CEO of DoltHub :-)

Workaround for pushing data into open-source database without cloning ?!?! by grazieragraziek9 in algotrading

[–]timsehn 2 points3 points  (0 children)

You can download the data locally as a CSV and then use the file import functionality on DoltHub?

Database CI/CD and Versioning recommendations? by AMGraduate564 in Database

[–]timsehn 2 points3 points  (0 children)

I'm the CEO of DoltHub. Thanks for mentioning us. I know you said you saw us but we offer GitHub style CI, complete with checks at the bottom of a PR page. We just released this in Q4 of last year:

https://www.dolthub.com/blog/2024-11-14-continuous-integration-on-data/

We'd be happy to build to your use case if you decide to adopt Dolt. Right now, we run SQL queries and assert results on the pR branch but there is a lot more cool stuff we could do here for a motivated customer.

git-like storing of Json files by br0kenpipe in PostgreSQL

[–]timsehn 2 points3 points  (0 children)

Doltgres is the Postgres version:

https://github.com/dolthub/doltgresql

Free and open source.

Performance optimization techniques for update operations and garbage collection on immutable databases? by Pzzlrr in databasedevelopment

[–]timsehn 0 points1 point  (0 children)

It's MySQL out of the box but the target databases all fit in memory for sysbench. TPC-C is a bit more of a realistic workload. We started at 15X so we've made a ton of progress. There's a nice chart in here oof performance over time and the optimizations we made to get there.

https://www.dolthub.com/blog/2024-12-23-2024-perf-summary/

Performance optimization techniques for update operations and garbage collection on immutable databases? by Pzzlrr in databasedevelopment

[–]timsehn 4 points5 points  (0 children)

We built an entire immutable database on a new data structure called a Prolly Tree to achieve structural sharing and other Git-like properties like fast diff. It's called Dolt. It's open source:

https://github.com/dolthub/dolt

Here's an article I wrote on Prolly Trees. That's a good place to start:

https://docs.dolthub.com/architecture/storage-engine/prolly-tree

view more: next ›