Proposal: Dotmim.Sync Provider Support for "Local-First" Architectures

[YBazanPro]

Following up on the "Graph/AI" capabilities, another massive enabler for .NET enterprise apps (like SaaS with offline support) would be Synchronization.

Instead of reinventing the wheel, have you considered implementing a Dotmim.Sync Provider for SharpCoreDB?

Use Case: Local-First AI Agents
Imagine a "Hybrid AI" architecture:

1. Server (PostgreSQL/SQL Server): Holds multi-tenant global knowledge.
2. Client (SharpCoreDB): Syncs only a specific project/tenant subset locally using Dotmim.Sync filters.
3. Local Inference: The local agent runs Vector Search + Graph queries on this high-performance local subset, with zero latency and full privacy.

Technical Viability
Since v1.2 supports Triggers and Change Tracking primitives, building a CoreProvider for Dotmim.Sync seems feasible. The main challenge would be efficient change enumeration.

Security Question
Given SharpCoreDB's strong encryption-at-rest features, how would this play with sync? Presumably, the provider reads decrypted data → syncs over HTTPS → Server stores it. Do you see any roadblocks for a "Zero-Knowledge" sync scenario where the server stores encrypted blobs that only the local DB can index/search?

[MPCoreDeveloper]

Hello ,

For this i have to do some learning and reading up first , when SharpCoreDB reads the data and provides it , it is already decrypted ...
but that might actually be a nice 'option' 🤔

First I work on the GraphRAG Architecture then i come back after I made a thorough investigation and plan proposal

[MPCoreDeveloper]

Done in the current version of SharpCoreDB 1.4.1