PostgreSQL support? about vitess HOT 11 CLOSED

Interest in Postgres has been rising. It's possible we may add this to the roadmap depending on how much eng bandwidth we build and other priorities.

from vitess.

There's currently code in various places that deal with Statement Based Replication of mysql, which will be a hindrance. I plan to delete that code as my next project.

Once that is done, vitess will be more db agnostic. After that, the work will mostly be related to vttablets. Impact on other parts will be relatively less.

Rough estimate is likely to be 1-2 person-years of work.

from vitess.

+1

from vitess.

Any plans to support PostgreSQL?

Thank You.

from vitess.

A similar product but support postgreSQL. https://github.com/citusdata/citus

from vitess.

Curious if any work has gone on this route?

Not so far. See #7084

from vitess.

Hi kidoman,
For now, Postgres is not on our roadmap. We may revisit this based on how the industry evolves. But we're currently focused on MySQL and their upcoming versions.

from vitess.

Any updates on this?

from vitess.

@lobosan Still no work is being done on Postgres compatibility, though it is technically possible. I wouldn't hold your breath. :)

from vitess.

@sougou Since you mentioned the possibility of doing this, Lets say If anyone were to think about contributing on this, do you think Vitess can architecturally add postgres as a "backend". Is VTablet and VtGate and other components coupled with mysql implementation?

from vitess.

Curious if any work has gone on this route?

from vitess.