Skip to content

Implement PostgreSQL Support #7

@peter7775

Description

@peter7775

Description

Add PostgreSQL as a source database option alongside MySQL.

Why This Feature?

  • PostgreSQL is widely used in enterprise environments
  • Many users have requested this feature
  • Expands project's usability significantly

Technical Requirements

Database Driver

  • Add github.com/lib/pq dependency
  • Create PostgreSQL adapter in internal/infrastructure/persistence/

Configuration

  • Extend config schema to support PostgreSQL connection
  • Add database type selection (mysql/postgresql)

SQL Compatibility

  • Handle PostgreSQL-specific SQL syntax differences
  • Update query builders for PostgreSQL compatibility

Testing

  • Add PostgreSQL to docker-compose.test.yml
  • Create integration tests with PostgreSQL

Acceptance Criteria

  • PostgreSQL connection established
  • All existing transformation rules work with PostgreSQL
  • Configuration supports both MySQL and PostgreSQL
  • Integration tests pass with PostgreSQL
  • Documentation updated with PostgreSQL examples
  • Docker compose includes PostgreSQL option

Files to Modify

  • internal/infrastructure/persistence/ - Add PostgreSQL repository
  • config/ - Update configuration schema
  • docker-compose.test.yml - Add PostgreSQL service
  • README.md - Update documentation

Resources

Estimated Effort

2-3 days

Metadata

Metadata

Assignees

No one assigned

    Labels

    backendBackend/server related workdatabaseDatabase related changes - MySQL, Neo4j, queriesfeatureNew feature or functionalitymedium-difficultyMedium difficulty - requires some experience

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions