Support of open sourced Microsoft DocumentDB

[akarray]

With PayloadCMS’s commitment to open-source flexibility and developer-centric design, I propose exploring official support for Microsoft DocumentDB-a fully open-source document database built on PostgreSQL. This aligns perfectly with Payload’s ethos while addressing critical licensing and scalability concerns in modern CMS deployments.

Why DocumentDB Fits PayloadCMS

1. Philosophical Alignment :

• MIT/Apache License: Truly open-source, avoiding MongoDB’s SSPL restrictions.
• PostgreSQL Foundation: Leverages Payload’s existing PostgreSQL compatibility while adding MongoDB API support.
• Community-Driven: Extensible via 280+ PostgreSQL extensions (e.g., pgvector, PostGIS).

2. Technical Advantages

• BSON + SQL Hybrid Engine sql
• Store CMS content as BSON, query via SQL/MongoAPI
• Hybrid search (vector + full-text)
• Production-Grade Scalability 1M+ ops/sec on Citus clusters.
• Automatic failover <2s vs MongoDB : https://opensource.microsoft.com/blog/2025/01/23/documentdb-open-source-announcement/.
• AI/ML Readiness : Vector search via pgvector (HNSW indexes) and Hybrid BM25 + vector ranking for RAG workflows.

3. Cost Efficiency

• Avoid MongoDB Atlas/AWS DocumentDB vendor lock-in.
• Self-host or deploy on any cloud provider

This proposal leverages DocumentDB’s PostgreSQL backbone and MIT licensing to align with Payload’s open-source philosophy while addressing real-world scalability/AI needs. Community feedback will shape next steps!