Microsoft quietly final month unveiled DocumentDB, an open supply NoSQL database that’s designed to be appropriate with MongoDB. The challenge makes public the PostgreSQL-based know-how behind the vCore-based Azure Cosmos DB for MongoDB . Microsoft says it hopes DocumentDB will assist make PostgreSQL an ANSI normal for NoSQL databases.
DocumentDB is a document-oriented database that permits customers to retailer information in Binary Object Notation (BSON), a JSON-like information construction additionally utilized by MongoDB. Microsoft’s DocumentDB database challenge–to not be confused with AWS’s MongoDB-compatible database providing, Amazon DocumentDB–is constructed atop PostgreSQL and makes use of two PostgreSQL extensions developed by Microsoft to allow its BSON performance.
The primary PostgreSQL extension is pg_documentdb_core, which Microsoft describe as “a customized PostgreSQL extension optimizing for BSON.” The library provides customers the power to parse and manipulate BSON paperwork within the PostgreSQL layer of the database engine; index fields within the BSON doc; carry out vector search queries; and implement a full authentication mechanism.
The second PostgreSQL extension is pg_documentdb_api, which Microsoft describes as a knowledge aircraft implementing create, learn, replace and delete (CRUD) operations, question performance, and index administration. The CRUD operations are mentioned to be MongoDB appropriate.
DocumentDB is obtainable on Microsoft’s GitHub code repository right here. The database is distributed underneath the permissive MIT License, which permits for reuse with proprietary software program.
The aim of DocumentDB is to offer a typical for interoperability, the corporate says in a January weblog put up by Abinav Rameesh, the challenge administration lead on Azure Cosmos DB.
“The mission for DocumentDB is to offer the developer group with a NoSQL datastore, applied utilizing PostgreSQL with full visibility into the structure and implementation of the engine,” Rameesh wrote. “All of the core elements of the database engine from CRUD…operations to indexing and vector search performance are public.”
Microsoft selected to make use of the permissive MIT license to foster extensive adoption and to get the group transferring towards a typical, he wrote.
“DocumentDB is the primary implementation of the challenge’s extra bold mission to create a typical for open-source doc databases, very like the ANSI (American Nationwide Requirements Institute) SQL normal for relational databases,” Rameesh wrote. “The creation of a NoSQL normal will heighten the compatibility and interoperability of NoSQL engines sooner or later.”
Azure Cosmos DB is a non-relational database service from Microsoft that helps a wide range of NoSQL information sorts and workloads, together with a doc retailer, a large column retailer, a key-value retailer, and a graph retailer. Whereas the API utilized in Azure Cosmos DB for MongoDB is MongoDB appropriate, the underlying know-how used within the “vCore” model of Azure Cosmos DB for MongoDB leverages a distributed database engine primarily based on PostgreSQL, which provides it the scalability and efficiency of a standard PostgreSQL setup.
Azure Cosmos DB for MongoDB was about 32% appropriate with the MongoDB API as of October 2023, in keeping with MongoDB. “Azure Cosmos DB for MongoDB implements MongoDB’s Wire Protocol to permit MongoDB drivers to attach and work together with Cosmos DB as if it have been a MongoDB host,” MongoDB wrote. “Nonetheless, this implementation has limitations…”
Associated Gadgets:
MongoDB 8.0 Launch Raises the Bar for Database Efficiency
FerretDB Supplies Various to MongoDB
There’s a NoSQL Database for That
