Skip to content

epic: Implement PostgreSQL compatibility layer in the new v1 architecture #391

Description

@wwoytenko

Since MySQL has been developed on top of the v1 framework, we need to port the PostgreSQL logic from v0.2 to v1 to ensure backward compatibility and wider adoption. The main requirement is to keep the PostgreSQL v1 implementation as backward compatible as possible. The goal is to support multiple DBMSs through a single Greenmask utility. In the MySQL version, most of the required abstractions have already been implemented, which makes PostgreSQL ready to be ported onto the new rails.

High-level tasks to implement:

  • Explore the current v0.2 implementation and define tasks required to port it to the new framework
  • Identify and document breaking changes for PostgreSQL
  • Port dump logic
  • Port restore logic
  • Port the PostgreSQL driver to the new rails
  • Implement metadata similar to MySQL, or revise it to make it common across most DBMSs
  • Port the PostgreSQL subset system
  • Revise existing documentation
  • Implement integration tests
  • Implement the list-dump command for PostgreSQL

Metadata

Metadata

Assignees

Labels

v1Planned for v1 version

Type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions