Multi-Database Support

[charmitro]

Overview

Currently, the CNC project offers robust database replication capabilities for PostgreSQL. To broaden the tool's applicability and utility, introducing support for additional database systems would be highly beneficial.

Suggested Databases

• MySQL: Widely used open-source relational database management system.
• SQLite
• NoSQL Databases:
  • MongoDB: A leading NoSQL database, known for its scalability and flexibility with document-oriented storage.
  • Cassandra: A highly scalable NoSQL database designed for managing large amounts of data across many commodity servers.
  • Redis: An in-memory data structure store, used as a database, cache, and message broker, known for its performance.
  • Couchbase (NOT SURE): A distributed NoSQL cloud database with a flexible data model for building interactive web and mobile applications.

Goals

1. Versatility: By supporting multiple database systems, CNC can be used in a wider array of environments and for more diverse applications.
2. Adaptability: Ensure that the tool can easily adapt to different database architectures and data models.
3. User Convenience: Users can leverage a single tool for replication across different database systems, simplifying the data management process.

[charmitro]

@panosfol can we pick this up again? The rust migration is complete.