Doltgres is a SQL database with Git-style versioning, a Postgres version of Dolt. We've been working to make Doltgres compatible with PostgreSQL by supporting database workbenches such as TablePlus and DBeaver. Today, we share our progress of where we are at today and what we are currently missing. The first workbench we started working on is Tableplus.

Doltgres can connect to TablePlus now

Before we started on this workbench compatibility project, we could not even connect to TablePlus, so it displayed nothing. The pg_catalog schema data was the most important part that was missing along with some of Postgres built-in types and functions. We added support for those and now, we can connect TablePlus to Doltgres server!

Basic functionality

As of today with Doltgres v0.11.1, we can perform basic operations using TablePlus. We see table and view data and their metadata in different schemas. For instance, on public schema:

Then, we switch to myschema:

We can create and drop tables and views. Let's create a view on mytbl named mytbl_view.

We can also insert, update and delete row data in the mytbl table. Before committing the changes:

After committing the changes, we can see the data we changed in mytbl_view:

As you can see, most basic functionality works with Doltgres in TablePlus without any user interface glitches. Our pg_catalog, function, and types work really paid off.

We use our version control feature committing the changes we made so far using DOLT_COMMIT() procedure.

Then, we can check the commit log using dolt_log system table.

What's missing?

• We don't support ALTER TABLE statements yet.
• Some fields of table and index metadata are missing.
• Small gaps on using types when creating tables.

We are currently working to get these and other incompatibilities fixed. If there is any missing support you need, let us know. We are on our Discord channel or file an issue on GitHub. We will be happy to get it working for you as soon as possible.