Feature Request: Add Support for Additional Database Sources #19
Description
Description
While DStream currently focuses on monitoring changes from Microsoft SQL Server, it would greatly benefit from extending support to other popular relational databases such as PostgreSQL and MySQL. This added flexibility would increase the usability of DStream across various projects and user bases.
Benefits
- Wider Adoption: By supporting additional databases, DStream can appeal to a larger audience beyond SQL Server users.
- Enhanced Flexibility: Users can leverage DStream for change data capture in diverse environments.
- Broader Use Cases: Many organizations use multiple database systems, and this feature would simplify their data streaming architecture.
Suggested Implementation
- Investigate how change data capture can be effectively implemented with PostgreSQL and MySQL, possibly utilizing their native CDC features.
- Develop a modular architecture that allows users to easily add support for new databases in the future.
- Provide configuration options in the existing setup to specify the database type.
Additional Considerations
- Documentation should be updated to reflect new features and provide usage examples for these databases.
- Ensure that performance and reliability characteristics, which are core strengths of DStream, are preserved across these new integrations.