--- title: Doltgres 1.0 | daily.dev description: Doltgres, the Postgres-compatible version of Dolt (the version-controlled SQL database), has reached its 1.0 release. The 1.0 milestone guarantees four things:... canonical: https://daily.dev/posts/doltgres-1-0-dnjnqean4 twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: Doltgres 1.0 | daily.dev og:description: Doltgres, the Postgres-compatible version of Dolt (the version-controlled SQL database), has reached its 1.0 release. The 1.0 milestone guarantees four things:... og:url: https://daily.dev/posts/doltgres-1-0-dnjnqean4 og:image: https://api.daily.dev/og/posts/DnJnQEAn4.png og:image:alt: Doltgres 1.0 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. # Doltgres 1.0 **[DoltHub Blog](https://daily.dev/sources/dolthub-blog)** · 5 min read · 13 upvotes · 2 comments ## Summary Doltgres, the Postgres-compatible version of Dolt (the version-controlled SQL database), has reached its 1.0 release. The 1.0 milestone guarantees four things: forward storage compatibility (no breaking storage changes in any 1.x release), production-level query performance (about 2.7x slower than Postgres but fast enough for OLTP workloads), 99% Postgres compatibility verified against 5.6 million SQL queries and 20+ client libraries, and a stable version control interface via system tables and functions. Upcoming roadmap items include PostGIS support, vector indexes, row-level security, collation support, and better DDL support. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Questions this post answers ### How fast is Doltgres 1.0 compared to native Postgres? Doltgres 1.0 is roughly 2.7 times slower than native Postgres in query latency, since it uses Dolt's underlying storage engine and Dolt is about 2-3 times slower than MySQL, which itself is 2-3 times slower than Postgres. In absolute terms this is a difference of about 0.2ms versus 0.5ms per query, which is typically dominated by network latency in real applications rather than the database engine itself. _daily.dev helps engineers weighing performance trade-offs stay current on database benchmarks like this._ ### How compatible is Doltgres 1.0 with real Postgres applications and client libraries? Doltgres 1.0 scores over 99% on a test suite of 5.6 million SQL queries verified against real Postgres, adapted from the sqllogictest project originally built for SQLite3. It also has integration tests covering more than 20 officially supported client libraries across different languages, with imports of hundreds of real-world Postgres dumps used to validate schema and query compatibility. _Teams evaluating a Postgres-compatible database can track compatibility claims like these on daily.dev._ ### Will Doltgres 1.x releases include breaking storage or version control interface changes? No, Doltgres commits to forward storage compatibility, meaning all future 1.x releases will remain backwards compatible with the 1.0 storage format, unlike Dolt's earlier history which included a backwards-incompatible storage change requiring customer data migration. The system tables and functions implementing version control are also frozen for 1.x, so applications built against them today will keep working in every future 1.x release. _daily.dev keeps developers planning long-term database migrations informed on compatibility guarantees like these._ ## Community discussion Top comments from developers on daily.dev. **@trevorsuna** · 2 upvotes > The 99% compatibility figure is encouraging, but the forward storage guarantee may be the bigger 1.0 signal for production teams. A 2.7x query gap can be benchmarked and planned around; uncertain upgrade compatibility is much harder to accept. PostGIS and row-level security will unlock a lot more real workloads. **@arminajdehnia** · 1 upvotes > Intresting! ## Similar posts on daily.dev - [Doltgres 1.0 Coming August 6th](https://daily.dev/posts/doltgres-1-0-coming-august-6th-wyku1t2ei) · DoltHub Blog · 43 upvotes · 4 comments - [Doltgres is as Fast as MySQL is Slow](https://daily.dev/posts/doltgres-is-as-fast-as-mysql-is-slow-svryjrerb) · DoltHub Blog · 45 upvotes · 4 comments - [Version Controlled SQL Database Dolt Releases 2.0 with Automatic Storage Cleanup and Compression](https://daily.dev/posts/version-controlled-sql-database-dolt-releases-2-0-with-automatic-storage-cleanup-and-compression-wfaha9aol) · InfoQ · 1 upvotes · 0 comments - [One Week Out: Doltgres 1.0 Update](https://daily.dev/posts/one-week-out-doltgres-1-0-update-bm5g269fo) · DoltHub Blog · 10 upvotes · 2 comments - [Doltgres Reaches 99% Compliance on SQL Logic Tests](https://daily.dev/posts/doltgres-reaches-99-compliance-on-sql-logic-tests-hhnymgooh) · DoltHub Blog · 0 upvotes · 0 comments --- Tags: [#backend](https://daily.dev/tags/backend), [#postgresql](https://daily.dev/tags/postgresql), [#version-control](https://daily.dev/tags/version-control) [View this post on daily.dev](https://daily.dev/posts/doltgres-1-0-dnjnqean4) ```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":"Doltgres 1.0","url":"https://daily.dev/posts/doltgres-1-0-dnjnqean4","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/doltgres-1-0-dnjnqean4"},"datePublished":"2026-08-06T23:53:33.498Z","dateModified":"2026-09-14T06:29:50.939Z","description":"Doltgres, the Postgres-compatible version of Dolt (the version-controlled SQL database), has reached its 1.0 release. The 1.0 milestone guarantees four things:...","image":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/59caa741efb5420653de45ff45ed0aed?_a=AQAEuop","thumbnailUrl":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/59caa741efb5420653de45ff45ed0aed?_a=AQAEuop","isAccessibleForFree":true,"articleSection":"DoltHub Blog","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":"DoltHub Blog","logo":"https://media.daily.dev/image/upload/s--LXDlvjS4--/f_auto,q_auto/v1780213587/logos/dolthub-blog?_a=BAMAMiWQ0","url":"https://daily.dev/sources/dolthub-blog"},"commentCount":2,"discussionUrl":"https://daily.dev/posts/doltgres-1-0-dnjnqean4","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":13},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":2}],"keywords":"backend,postgresql,version-control","timeRequired":"PT5M"} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"DoltHub Blog","item":"https://daily.dev/sources/dolthub-blog"},{"@type":"ListItem","position":3,"name":"Doltgres 1.0"}]} {"@context":"https://schema.org","@type":"WebPage","@id":"https://daily.dev/posts/doltgres-1-0-dnjnqean4","comment":[{"@type":"Comment","text":"The 99% compatibility figure is encouraging, but the forward storage guarantee may be the bigger 1.0 signal for production teams. A 2.7x query gap can be benchmarked and planned around; uncertain upgrade compatibility is much harder to accept. PostGIS and row-level security will unlock a lot more real workloads.","datePublished":"2026-08-09T04:25:20.065Z","url":"https://daily.dev/posts/DnJnQEAn4#c-0qPkfdtq9","author":{"@type":"Person","name":"Trevor Suna","url":"https://daily.dev/trevorsuna","image":"https://media.daily.dev/image/upload/s--dZ7gXxpp--/f_auto/v1784081551/avatars/avatar_EMoP47rpuw8DNjhp6R1b6?_a=BAMAMicg0"},"interactionStatistic":{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":2}},{"@type":"Comment","text":"Intresting!","datePublished":"2026-08-07T11:54:50.724Z","url":"https://daily.dev/posts/DnJnQEAn4#c-aRnQrXbmt","author":{"@type":"Person","name":"armin ajdehnia","url":"https://daily.dev/arminajdehnia","image":"https://lh3.googleusercontent.com/a/ACg8ocIPxWuXovS0USsoqfZqkgj9hR8I-KQ0dPvjB_AifsPMGAUd6NBB=s96-c"},"interactionStatistic":{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":1}}]} {"@context":"https://schema.org","@type":"FAQPage","@id":"https://daily.dev/posts/doltgres-1-0-dnjnqean4#faq","mainEntity":[{"@type":"Question","name":"How fast is Doltgres 1.0 compared to native Postgres?","acceptedAnswer":{"@type":"Answer","text":"Doltgres 1.0 is roughly 2.7 times slower than native Postgres in query latency, since it uses Dolt's underlying storage engine and Dolt is about 2-3 times slower than MySQL, which itself is 2-3 times slower than Postgres. In absolute terms this is a difference of about 0.2ms versus 0.5ms per query, which is typically dominated by network latency in real applications rather than the database engine itself. daily.dev helps engineers weighing performance trade-offs stay current on database benchmarks like this."}},{"@type":"Question","name":"How compatible is Doltgres 1.0 with real Postgres applications and client libraries?","acceptedAnswer":{"@type":"Answer","text":"Doltgres 1.0 scores over 99% on a test suite of 5.6 million SQL queries verified against real Postgres, adapted from the sqllogictest project originally built for SQLite3. It also has integration tests covering more than 20 officially supported client libraries across different languages, with imports of hundreds of real-world Postgres dumps used to validate schema and query compatibility. Teams evaluating a Postgres-compatible database can track compatibility claims like these on daily.dev."}},{"@type":"Question","name":"Will Doltgres 1.x releases include breaking storage or version control interface changes?","acceptedAnswer":{"@type":"Answer","text":"No, Doltgres commits to forward storage compatibility, meaning all future 1.x releases will remain backwards compatible with the 1.0 storage format, unlike Dolt's earlier history which included a backwards-incompatible storage change requiring customer data migration. The system tables and functions implementing version control are also frozen for 1.x, so applications built against them today will keep working in every future 1.x release. daily.dev keeps developers planning long-term database migrations informed on compatibility guarantees like these."}}]} ```