--- title: Version Controlled SQL Database Dolt Releases 2.0 with... description: DoltHub has released Dolt 2.0, a major update to its open source MySQL-compatible SQL database with built-in Git-style version control. Key additions include... canonical: https://daily.dev/posts/version-controlled-sql-database-dolt-releases-2-0-with-automatic-storage-cleanup-and-compression-wfaha9aol twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: Version Controlled SQL Database Dolt Releases 2.0 with Automatic Storage Cleanup and Compression | daily.dev og:description: DoltHub has released Dolt 2.0, a major update to its open source MySQL-compatible SQL database with built-in Git-style version control. Key additions include... og:url: https://daily.dev/posts/version-controlled-sql-database-dolt-releases-2-0-with-automatic-storage-cleanup-and-compression-wfaha9aol og:image: https://api.daily.dev/og/posts/WfahA9AoL.png og:image:alt: Version Controlled SQL Database Dolt Releases 2.0 with Automatic Storage Cleanup and Compression og:image:width: 1200 og:image:height: 630 og:locale: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # Version Controlled SQL Database Dolt Releases 2.0 with Automatic Storage Cleanup and Compression **[InfoQ](https://daily.dev/sources/infoq)** · 3 min read · 1 upvotes · 0 comments ## Summary DoltHub has released Dolt 2.0, a major update to its open source MySQL-compatible SQL database with built-in Git-style version control. Key additions include automatic garbage collection and archive compression enabled by default (reducing storage footprint by 30-50%), adaptive storage, and beta support for version-controlled vector indexes using MariaDB's Vector type. Performance has improved significantly — the team claims Dolt is now 13% faster than MySQL on writes and 5% faster on reads, up from being 10-20x slower at launch. Dolt stores data in content-addressed Prolly Trees supporting branching, merging, cloning, and diffing. The release also notes DoltgreSQL, a Postgres-compatible variant sharing the same storage engine, remains in beta. Alternatives in the Git-for-data space include LakeFS and Nessie. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Questions this post answers ### What's new in Dolt 2.0? Dolt 2.0 adds automated garbage collection and archive compression enabled by default, adaptive storage, and beta support for version-controlled vector indexes. A new on-disk archive format uses dictionary compression to cut storage footprint by 30-50%. The release follows Dolt's first major version, released three years earlier, and the team reports the database is now faster than MySQL on sysbench benchmarks. _daily.dev surfaces release notes like this for teams tracking version-controlled database options._ ### How does Dolt's SQL query performance compare to MySQL? Dolt 2.0 is now 13% faster than MySQL on writes and 5% faster on reads in sysbench benchmarks, according to DoltHub founder Tim Sehn. This is a major improvement from earlier versions, which started at roughly 10x slower on reads and 20x slower on writes compared to MySQL, reflecting sustained performance work by the team. _developers comparing database performance benchmarks can follow updates like this on daily.dev._ ### Why does Dolt need garbage collection and what does it clean up? Dolt is copy-on-write, meaning every intermediate committed transaction state is preserved to disk even though it isn't part of a formal Dolt commit; that untracked intermediate state is disk garbage. Since Dolt already preserves all history in its commit graph, uncollected garbage can consume disk space very quickly, which is why Dolt 2.0 enables automatic garbage collection and compression by default. _daily.dev helps engineers managing storage growth in versioned databases stay on top of fixes like this._ ## Similar posts on daily.dev - [DoltLite Beta](https://daily.dev/posts/doltlite-beta-6gdortkc2) · DoltHub Blog · 14 upvotes · 1 comments - [What People Are Saying: LWN Edition](https://daily.dev/posts/what-people-are-saying-lwn-edition-rqozyipga) · DoltHub Blog · 0 upvotes · 0 comments - [Doltgres 1.0](https://daily.dev/posts/doltgres-1-0-dnjnqean4) · DoltHub Blog · 13 upvotes · 2 comments - [Doltgres 1.0 Coming August 6th](https://daily.dev/posts/doltgres-1-0-coming-august-6th-wyku1t2ei) · DoltHub Blog · 43 upvotes · 4 comments --- Tags: [#backend](https://daily.dev/tags/backend), [#mysql](https://daily.dev/tags/mysql), [#vector-search](https://daily.dev/tags/vector-search), [#version-control](https://daily.dev/tags/version-control) [View this post on daily.dev](https://daily.dev/posts/version-controlled-sql-database-dolt-releases-2-0-with-automatic-storage-cleanup-and-compression-wfaha9aol) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@type":"TechArticle","headline":"Version Controlled SQL Database Dolt Releases 2.0 with Automatic Storage Cleanup and Compression","url":"https://daily.dev/posts/version-controlled-sql-database-dolt-releases-2-0-with-automatic-storage-cleanup-and-compression-wfaha9aol","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/version-controlled-sql-database-dolt-releases-2-0-with-automatic-storage-cleanup-and-compression-wfaha9aol"},"datePublished":"2026-07-18T07:45:18.983Z","dateModified":"2026-09-14T08:40:57.990Z","description":"DoltHub has released Dolt 2.0, a major update to its open source MySQL-compatible SQL database with built-in Git-style version control. Key additions include...","image":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/12660f8c9635d2e27bdaca796d02e513?_a=AQAEuop","thumbnailUrl":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/12660f8c9635d2e27bdaca796d02e513?_a=AQAEuop","isAccessibleForFree":true,"articleSection":"InfoQ","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"InfoQ","logo":"https://media.daily.dev/image/upload/t_logo,f_auto/v1/logos/afc3bced3e1e4b188dd9127017a60e0c","url":"https://daily.dev/sources/infoq"},"commentCount":0,"discussionUrl":"https://daily.dev/posts/version-controlled-sql-database-dolt-releases-2-0-with-automatic-storage-cleanup-and-compression-wfaha9aol","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":1},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"keywords":"backend,mysql,vector-search,version-control","timeRequired":"PT3M"} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"InfoQ","item":"https://daily.dev/sources/infoq"},{"@type":"ListItem","position":3,"name":"Version Controlled SQL Database Dolt Releases 2.0 with Automatic Storage Cleanup and Compression"}]} {"@context":"https://schema.org","@type":"FAQPage","@id":"https://daily.dev/posts/version-controlled-sql-database-dolt-releases-2-0-with-automatic-storage-cleanup-and-compression-wfaha9aol#faq","mainEntity":[{"@type":"Question","name":"What's new in Dolt 2.0?","acceptedAnswer":{"@type":"Answer","text":"Dolt 2.0 adds automated garbage collection and archive compression enabled by default, adaptive storage, and beta support for version-controlled vector indexes. A new on-disk archive format uses dictionary compression to cut storage footprint by 30-50%. The release follows Dolt's first major version, released three years earlier, and the team reports the database is now faster than MySQL on sysbench benchmarks. daily.dev surfaces release notes like this for teams tracking version-controlled database options."}},{"@type":"Question","name":"How does Dolt's SQL query performance compare to MySQL?","acceptedAnswer":{"@type":"Answer","text":"Dolt 2.0 is now 13% faster than MySQL on writes and 5% faster on reads in sysbench benchmarks, according to DoltHub founder Tim Sehn. This is a major improvement from earlier versions, which started at roughly 10x slower on reads and 20x slower on writes compared to MySQL, reflecting sustained performance work by the team. developers comparing database performance benchmarks can follow updates like this on daily.dev."}},{"@type":"Question","name":"Why does Dolt need garbage collection and what does it clean up?","acceptedAnswer":{"@type":"Answer","text":"Dolt is copy-on-write, meaning every intermediate committed transaction state is preserved to disk even though it isn't part of a formal Dolt commit; that untracked intermediate state is disk garbage. Since Dolt already preserves all history in its commit graph, uncollected garbage can consume disk space very quickly, which is why Dolt 2.0 enables automatic garbage collection and compression by default. daily.dev helps engineers managing storage growth in versioned databases stay on top of fixes like this."}}]} ```