DocumentDB vs JayDB

DocumentDB is an MIT-licensed, open-source document database built on PostgreSQL for MongoDB compatibility. It stores native BSON documents, supports document CRUD and PostgreSQL SQL operations, and offers single-field, multi-key, compound, text and geospatial indexes, including nested fields. Pgvector powers vector search for embeddings and similarity search. MongoDB-compatible clients and tools include mongosh, PyMongo, the official MongoDB Node.js driver and a VS Code extension. The extension can create a local database, generate credentials and save a connection. DocumentDB runs locally in Docker or on a user’s infrastructure or cloud. Its gateway supports SCRAM-SHA-256 authentication, with TLS terminating at default port 10260. Hosted packages currently cover Ubuntu 24.04 and EL9 with PostgreSQL 17 or 18 for amd64 and arm64. A Kubernetes operator for failover, replication, backups and TLS is in preview and requires Kubernetes 1.35+ and cert-manager.

JayDB is a JSON document database with per-user sign-in, aimed at static apps that need user, session, or tenant data without an app-owned backend. Documents are JSON at slash-separated paths, and the first write creates the namespace. Its REST data plane supports GET, PUT, DELETE, and prefix listing. Browser apps can authenticate through OIDC with Authorization Code and PKCE without embedding a client secret. Listed identity providers include Google, GitHub, Microsoft, generic OIDC, and custom OAuth2. The official SDK supports authentication, token refresh, typed document access, and compare-and-swap operations. ETag-based compare-and-swap may reject a write with HTTP 412 if the document changed since it was read. JayDB is available as managed cloud software or as a self-hosted Go engine under the MIT license, using S3-compatible storage or local disk. The free plan is free and includes 1 GB stored, 100,000 reads per month, and 10,000 writes per month; usage hard-stops at those allowances. Metered rates are $0.05 per GB-month of storage, $0.20 per million reads, and $0.50 per million writes.