DoltgreSQL

Data

version-controlled database

SHOW HN2023

162points
63comments
#375of 3,109 in 2023
Top 13%of 2023 by points

How HN took it

MixedNo clear lean

6 positive, 16 neutral or asking, 4 mixed, 9 critical, out of 35 comments about the project. Thread score -0.05.

Idea: 1 for, 3 againstExecution: 0 for, 3 againstPerformance: 1 for, 1 againstPricing: 0 for, 1 againstDocs: 1 for, 0 against

The thread, comment by comment

Each row is a top-level comment and its replies, in HN's order. Select a cell to open that comment on HN.

positive neutral or mixed critical about another commenter or something else the maker

What HN said

What people liked

  • Interest in versioned database with Postgres support.

    From 2 comments
    • I've been waiting eagerly for this. Do you have a clear position on which PostgreSQL features not to support? I suppose there are more than just some things that won't make the…
      leononame on HN
    • Great work. I will use this for the pet project I'm working on. Postgres rules. Thanks.
      coddx on HN

Objections

  • Pre-alpha; not ready for production use.

    From 1 comment
    • Just want to point out that we're announcing development on the project. It's absolutely not ready for mainstream use yet! We have Dolt (https://github.com/dolthub/dolt) which is…
      Hydrocharged on HN
  • Emulated behavior may differ from real PostgreSQL.

    From 1 comment
    • I've been waiting eagerly for this. Do you have a clear position on which PostgreSQL features not to support? I suppose there are more than just some things that won't make the…
      leononame on HN
  • Performance trails MySQL and uses more disk and memory.

    From 2 comments
    • Hmmm... I've been trying to extend a website I have with essentially wiki functionality. But Dolt is 1.7x slower than MySQL, as is written in that Readme. I'm looking for ways to…
      huhuli on HN
    • The sqllogictests are better used as a judgement of how accurate our results are to MySQL's results given a very large range of statements (around 6 million tests). They are not,…
      Hydrocharged on HN

Requests

  • Support for PostgreSQL extensions.

    From 1 comment
    • Knowing that extensions are very important to you is great feedback for us. As we hear more about what users' requirements are, it helps us better plan for the future. Regarding…
      Hydrocharged on HN
  • Replication and scale-out.

    From 1 comment
    • How is the replication / master-master / scale-out for this database? We really would love a solution like this but it would need to scale for our use case.
      anonzzzies on HN
  • Shared storage with Dolt.

    From 1 comment
    • Is there any compatibility between the underlying storage systems of Dolt and DoltgreSQL? Yes, the interface is slightly different, but is the storage (partially) compatible? Why…
      dotancohen on HN

Questions

  • Why fork rather than add a front-end?

    From 1 comment
    • Why a fork? Couldn't you just add a separate front-end? Will the underlying storage format stay the same so one can flip over or do you want to get closer to PG semantics?
      whizzter on HN
  • How it differs from migration tools like Flyway and alembic.

    From 3 comments
    • Can people who use Dolt explain their use case? Dolt competes with Flyway and Bytebase, but it requires you to run their forked database? Schema migration is unpleasant and not…
      esafak on HN
    • Question: what is the difference with database migration tools like alembic ?
      bapetel on HN
    • How is this better than existing migration solutions? More specifically, what does this give me that I'm not getting using the migration provided by an ORM? Current migration…
      itslennysfault on HN
  • Local-first and offline syncing support.

    From 1 comment
    • Really exciting, I was interested in Dolt but I prefer postgres. I'm curious if you have any plans for local first development. I love the idea of a version controlled database,…
      hahn-kev on HN

Alternatives named

  • Neon and Xata (branching).

    From 1 comment
    • I just learned of Neon a few weeks ago. From the looks of it, Neon supports branching, but it doesn't support merging. Xata supports both branching and merging, however it only…
      Hydrocharged on HN
  • Flyway and Bytebase (schema migrations).

    From 1 comment
    • Can people who use Dolt explain their use case? Dolt competes with Flyway and Bytebase, but it requires you to run their forked database? Schema migration is unpleasant and not…
      esafak on HN
  • Alembic and ORM migrations.

    From 2 comments
    • Question: what is the difference with database migration tools like alembic ?
      bapetel on HN
    • How is this better than existing migration solutions? More specifically, what does this give me that I'm not getting using the migration provided by an ORM? Current migration…
      itslennysfault on HN
  • VMDS by GE.

    From 1 comment
    • Do you know VMDS by GE (part of Smallworld)? It has data versioning too, using a concept called ‘alternatives’. Do you know where DoltgreSQL and VMDS differ/overlap,…
      gijsnijholt1980 on HN

Category, keywords, summaries and labels on this page were made by AI (Thread Reader v2) and not checked by hand. Each point links to the comments it came from.

Add a badge to your READMEShown on HackerShow
[![Shown on HackerShow](https://hackershow.org/badge.svg)](https://hackershow.org/show/38108044)