Microsoft Announces General Availability of Data API Builder for Azure Cosmos DB – InfoQ

Original link (2024-07-06)

Microsoft recentlyData API Builder for Azure Cosmos DatabaseGeneral availability announced. This open source project provides REST and GraphQL endpoints for Azure databases and on-premises stores.

The new API Builder (DAB) aims to simplify the process of exposing GraphQL endpoints to Azure Cosmos DB clusters, enabling relational queries, filtering, and mutations, including patching. The DAB offers a cross-platform CLI, native OpenAPI support, Swagger for REST endpoints, and Banana Cake Pop for GraphQL endpoints.

I am a product manager for Azure Cosmos DB.Sagitharan SenathuraiIt describes several use cases.

Whether you want to create a data exchange, build a mobile app, or tune your own Azure database, Data API Builder has you covered. You can seamlessly integrate multiple backend stores, from NoSQL to relational databases, and manage multiple databases at once effortlessly.

Source: Microsoft Blog

Cross-platform and language-independent, DAB is designed as an alternative to custom APIs for CRUD operations on databases using a single configuration file. It provides retry policies, global logging, in-memory caching, column mapping, and result filtering. DAB is an ASP.NET project written in C# and includes GraphQL ChilliCream.hot chocolatethe cache in the memory hasFusion CashUses.

thisAbout Project Publishinga senior product manager at MicrosoftJerry NixonHe says:

Nearly three years ago, building a Data API started as just a dream. How could we reduce the friction for developers who wanted to access databases in client applications? We developed the Data API Builder to solve this problem, providing secure, feature-rich REST and GraphQL endpoints to your database without any code.

Azure says the container-based DAB allows developers to create GraphQL endpoints while maintaining flexible and granular security features, Senathurai adds.

DAB is a standard Docker-friendly container. Completely stateless and scalable. Can be your own environment or the cloud. Run one or more containers against a single or multiple databases.

While supporting custom on-premises deployments, DAB natively integrates with Azure Static Web Apps and works with Azure Container Apps, Azure Container Instances, Azure Kubernetes Service, and Azure Web Apps for Containers.

Cosmos DB support for MongoDBSome developers are asking to add a Microsoft Principal Product Manager.Arun VijayaraghavanMr.commentThey do.

What really stands out in DAB projects is bringing the database closer to the edge provider. For example, edge providers like Cloudflare, Vercel, and Netlify all rely on Javascript V8 or Deno and don’t have a full set of APIs to interact with databases. Therefore, the best solution is to use a REST API to access the database.

The Data API project is free, there is no premium tier, and under the MIT license.GithubAvailable in