#Doltgres
LightNews LightNews
dolthub.bsky.social
Doltgres now supports server-side cursors!
This allows you to fetch rows in batches, move through results, and keep a consistent snapshot even when you switch branches within your session.
Closer to full Postgres compatibility. Zach demos https://www.dolthub.com/blog/2026-11-04-doltgres-cursors/
Doltgres Now Supports Cursors
Doltgres now supports server-side cursors with DECLARE, FETCH, MOVE and CLOSE.
www.dolthub.com
November 5, 2026 at 9:15 PM
dolthub.bsky.social
Doltgres is now natively supported in DoltHub!
Bring Git-like collaboration, pull requests, and row-level diffs to your Postgres-flavored databases.
This blog shows you how🔗 www.dolthub.com/blog/2026-10-19-doltgres-on-dolthub/
Doltgres databases are now supported on DoltHub
You can now use DoltHub as your remote for Doltgres databases. Push, pull, and clone from your local Doltgres and then view and edit your data from the DoltHub UI.
www.dolthub.com
October 20, 2026 at 6:00 PM
dolthub.bsky.social
The Dolt and Doltgres Q4 roadmap is here, including row-level security, PostGIS, pgcrypto support, and more..
2026 is shaping up to be our biggest release year yet!
See what’s coming next: https://www.dolthub.com/blog/2026-10-07-roadmap-update/
Q4 Roadmap Update: What's Coming Next for Dolt and Doltgres
Learn what features we're working on next in Dolt and Doltgres
www.dolthub.com
October 8, 2026 at 4:20 PM
handle.invalid
If you enable RLS on Doltgres, make sure the predicate column is indexed; otherwise queries will scan full tables and degrade performance. Adding an index to the column used in your RLS policy fixes the gap immediately.
October 8, 2026 at 4:32 PM
dolthub.bsky.social
When are PostgreSQL 18 database clones enough? TLDR: Clones work when copies stay independent. If versions need to be compared or merged, Dolt's branches take the cake.

The highly anticipated Aaron blog breaks it down 🔗 https://www.dolthub.com/blog/2026-10-01-postgres-cheap-database-clones/
PostgreSQL Database Clones vs. Doltgres Branches: When Are Clones Enough?
PostgreSQL 18 made it cheap to create complete copies of a database on certain filesystems. How does the feature compare to Dolt's branches and what are some compelling use cases for it?
www.dolthub.com
October 2, 2026 at 5:03 PM
dolthub.bsky.social
In this Doltgres feature release, we add support for PostgreSQL multi-dimensional arrays. You can now store, access, update, concatenate, replace, and unnest arrays with any number of dimensions using Postgres behavior.
https://www.dolthub.com/blog/2026-09-24-postgres-multi-dimensional-arrays/
Doltgres now supports multi-dimensional arrays
Doltgres now supports multi-dimensional arrays, just like Postgres.
www.dolthub.com
September 25, 2026 at 5:49 PM
dolthub.bsky.social
Customers asked if we had a Supabase-like product. Dustin tried it, built a todo app, and shared what Dolt and Doltgres could learn. Take the tour 🔗 https://www.dolthub.com/blog/2026-09-21-a-tour-of-supabase/
A Tour of Supabase
A hands-on tour of Supabase, covering local development, Postgres, APIs, authentication, storage, and Edge Functions.
www.dolthub.com
September 22, 2026 at 8:30 PM
dolthub.bsky.social
Postgres and MySQL evaluate UPDATE expressions differently.
Doltgres inherited MySQL’s behavior from its shared SQL engine. A user caught the mismatch, so we added an override that preserves the correct behavior for both databases.
https://www.dolthub.com/blog/2026-09-11-postgres-update-statements/
Postgres follows the SQL standard for UPDATE statements, unlike MySQL
Learn how Dolt and Doltgres support different SQL behavior on a shared engine using a new engine extension point
www.dolthub.com
September 18, 2026 at 4:30 PM
dolthub.bsky.social
We changed Doltgres to emulate PostgreSQL extension APIs in Go. uuid-ossp and pgvector done; PostGIS next. Here's why this suits version-controlled databases better 🔗 https://www.dolthub.com/blog/2026-09-03-doltgres-extensions-update/
Doltgres Now Emulates Extensions
Doltgres now emulates extensions rather than loading their shared libraries directly. Read on to find out why.
www.dolthub.com
September 5, 2026 at 2:01 PM
devblogs.bsky.social
Post-mortem: early Beta releases of Doltgres could trigger data loss on upgrade to 1.0

https://dolthub.com/blog/2026-09-04-postgres-data-loss-post-mortem
September 4, 2026 at 12:30 AM
dolthub.bsky.social
Postgres can run multiple statements in a single transaction, even without an explicit BEGIN.
The boundary depends on the Simple Query or Extended Query protocol.
Read how implicit transactions and how Doltgres matches Postgres behavior.
https://ow.ly/Rtli50ZFVlT
Postgres's implicit transactions
Learn about when Postgres implicitly creates transactions of more than a single statement
ow.ly
August 26, 2026 at 10:39 PM
pgus.bsky.social
Your weekend watch is “Doltgres: Version Controlled Data and Database Based on Postgres” with Tim Sehn and Zach Musgrave:

www.youtube.com/watch?v=RF33...

#PostgreSQL #postgres
Doltgres: Version Controlled Data and Database Based on Postgres
Doltgres is a SQL database where you can branch, merge, diff, and commit data like you would with Git (and it is based on Postgres). Dolt will be at Postgres Meetup for All ready to talk about why…
www.youtube.com
March 27, 2026 at 1:36 PM
pgus.bsky.social
Your weekend watch is “Doltgres: Version Controlled Data and Database Based on Postgres” with Tim Sehn:

www.youtube.com/watch?v=RF33...

#PostgreSQL #postgres
Doltgres: Version Controlled Data and Database Based on Postgres
Doltgres is a SQL database where you can branch, merge, diff, and commit data like you would with Git (and it is based on Postgres). Dolt will be at Postgres Meetup for All ready to talk about why…
www.youtube.com
December 12, 2025 at 6:20 PM
dolthub.bsky.social
Our Postgres-compatible, version-controlled SQL database got 1.8x faster on sysbench, moving from 4.4x to 2.6x slower than Postgres.
That puts Doltgres roughly at MySQL-level performance on this benchmark suite.
🔗 https://www.dolthub.com/blog/2026-08-13-doltgres-as-fast-as-mysql-is-slow/
Doltgres is as Fast as MySQL is Slow
Overview of recent performance optimizations to Doltgres that brought it on par with MySQL
www.dolthub.com
August 14, 2026 at 10:45 PM
dolthub.bsky.social
DoltHub now supports DoltLite and Doltgres databases.
That means you can push, pull, and clone both on DoltHub. Doltgres just hit 1.0, and DoltLite is here for lightweight, SQLite-compatible version-controlled databases.
https://www.dolthub.com/blog/2026-08-07-dolthub-supports-doltlite-and-doltgres/
DoltHub Now Supports DoltLite and Doltgres Databases
DoltHub now supports DoltLite and Doltgres databases. You can now push, pull, and clone DoltLite and Doltgres databases on DoltHub.
www.dolthub.com
August 10, 2026 at 7:24 PM
dolthub.bsky.social
Doltgres 1.0 is here.

The Postgres version of Dolt is now production-ready, with Git-style version control for schema and data, 99% Postgres compatibility, and support for the tools engineers already use.

Read more: https://www.dolthub.com/blog/2026-08-06-doltgres-1-0/
Doltgres 1.0
Doltgres, the Postgres-flavored version of Dolt, is now 1.0 and ready for production.
dolthub.awsdev.ld-corp.com
August 7, 2026 at 3:15 PM
dolthub.bsky.social
No Index GroupBy Optimization
Sneak peek at one of the optimizations we’re applying to Dolt and Doltgres to make GroupBy faster without needing an index.
https://www.dolthub.com/blog/2026-08-03-no-index-groupby/
No Index GroupBy Optimization
Sneak peek at one of the optimizations applied to Dolt and Doltgres
www.dolthub.com
August 4, 2026 at 9:59 PM
dolthub.bsky.social
Doltgres 1.0 is one week away. We’ve shipped remotes, replication, and automatic garbage collection, hit 99% SQL Logic Test compliance, and kept pushing on correctness and performance. Dive in: https://www.dolthub.com/blog/2026-07-30-doltgres-1-0-one-week-out/
One Week Out: Doltgres 1.0 Update
Doltgres 1.0 launches August 6th. Here's what has landed in the codebase over the past few weeks: replication support, automatic garbage collection, data-correctness fixes, and more.
www.dolthub.com
July 31, 2026 at 5:01 PM
dolthub.bsky.social
Ito reviews your PR branch, runs real tests for Doltgres with real SQL and Postgres protocol. 43 PRs, 2:1 signal-to-noise, catching hidden bugs. www.dolthub.com/blog/2026-07-20-ito-ai-qa-for-doltgresql/
Running Ito, a Runtime Analysis Code Review Tool, on Doltgres
For the past six weeks, we've been running Ito, a runtime analysis code review tool that works off of GitHub PRs and builds and runs your application instead of just reading the diff. We've had success using this on our Doltgresql repo and in this blog post we'll show what it's caught, how it works, and where it's let us down.
www.dolthub.com
July 22, 2026 at 7:31 PM
dolthub.bsky.social
Heatwave forecast: 100% chance of Dolt sundae.
Dolt now comes in four flavors: Dolt, Doltgres, DoltLite, and Dumbo.
https://www.dolthub.com/blog/2026-07-16-dolt-in-4-flavors/
#VersionControl belongs in every database format, pick the flavor that fits your stack: https://github.com/dolthub
July 17, 2026 at 3:15 PM
dolthub.bsky.social
Doltgres hit 99% SQL Logic Test compliance on the way to 1.0! Millions of queries match PostgreSQL results and formats.
Write‑up: https://www.dolthub.com/blog/2026-07-10-doltgres-99-percent-sql-logic-tests/
Try it: https://github.com/dolthub/doltgresql
Doltgres Reaches 99% Compliance on SQL Logic Tests
Doltgres now passes 99% of our SQL Logic Test suite, hitting one of our key correctness targets for the Doltgres 1.0 launch on August 6th.
www.dolthub.com
July 10, 2026 at 6:00 PM
dolthub.bsky.social
We investigated BranchBench performance gaps in Doltgres and shipped fixes for index usage, join planning, and CPU hotspots.

RangeRead is now within ~5% of Postgres after a 653x speedup. Simulation is much faster.

https://www.dolthub.com/blog/2026-06-25-branch-bench-performance-update/
BranchBench Performance Update
Addressing some of the performance concerns in BranchBench
www.dolthub.com
June 30, 2026 at 2:01 PM
dolthub.bsky.social
Doltgres 1.0 ships August 6.

We’ve been hard at work making Doltgres, our Postgres-compatible version-controlled database, production-ready. Here’s what we’ve built, where things stand, and what we’re focused on before launch:

https://www.dolthub.com/blog/2026-06-26-doltgres-1-0-coming-this-fall/
Doltgres 1.0 Coming August 6th
Doltgres 1.0 is coming August 6th. Here's what we've been working on and what we're focused on to get there.
www.dolthub.com
June 29, 2026 at 7:00 PM
dolthub.bsky.social
🚀 Doltgres now supports functional indexes!
You can now index expressions and function results in our version-controlled Postgres database.
⚡️ Tested a 37x speedup on 300k rows from 150ms down to 4ms.
Try it safely on an isolated branch! https://ow.ly/l4QB50Z6P9S
June 2, 2026 at 6:27 PM
dolthub.bsky.social
Doltgres supports set-returning functions—RETURNS TABLE and SETOF. One function, unified logic, plus branches, diffs, and time-travel. https://www.dolthub.com/blog/2026-02-18-doltgres-returns-table-udf/ #Postgres #DatabaseEngineering #Doltgres
User-Defined Set-Returning Functions in Doltgres
Doltgres now supports PostgreSQL set-returning functions using RETURNS TABLE and RETURNS SETOF syntax, allowing SQL functions to return a set of records with multiple values, instead of just returning a single, scalar value. We continue to move closer to full support in Doltgres for all the features available through Postgres' user-defined functions.
www.dolthub.com
February 19, 2026 at 8:35 PM