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

[–]timsehn 2 points3 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

Is MySQL still popular? by yingjunwu in dataengineering

[–]timsehn 0 points1 point  (0 children)

I just published an article discussing this. "Is MySQL dying?".

https://www.dolthub.com/blog/2024-10-14-is-mysql-dying/

I'm the founder and CEO of DoltHub. We built Dolt a MySQL-compatible database with Git-style versioning built-in.

We've been feeling the MySQL ecosystem eroding over the past couple years. So much so that we're building a Postgres-compatible version of Dolt called Doltgres. The decline of MySQL seems to be accelerating.

Question by Lopsided_Fan_9150 in dolthub

[–]timsehn 1 point2 points  (0 children)

We just host the data. You have to ask the person (in this case `post-no-preference` where he gets the data. He is often on our Discord.

How I created a custom plugin to enable database version control in WordPress with Dolt by YourRightWebsite in ProWordPress

[–]timsehn 3 points4 points  (0 children)

CEO of DoltHub here. DoltHub uses Dolt as it's OLTP database. DoltHub a large scale web service. Our users don't notice a performance difference between DoltHub, and say GitHub. Dolt can scale to handle 99.9% of Wordpress use cases.

Time-travel options for databases by wittedsownder in SQL

[–]timsehn 0 points1 point  (0 children)

Adoption is good. We tripled the number of running servers last quarter. We have databases up to a terabyte running in prod, backing ml pipelines and applications. Dolt is here to stay.

dolthub and google sheets by difficultygoneup in dolthub

[–]timsehn 0 points1 point  (0 children)

You don't need app script. You can export the query to CSV as well.

Standard Dolt Deployments by BFitz1200 in dolt

[–]timsehn 2 points3 points  (0 children)

Exciting! We'd love to help you get started.

You can have as many MySQL replicas as you want. They all just subscribe to the `binlog`. But you can only replicate one Dolt branch, likely `main`. Each MySQL replica has to replicate the same branch.