DocumentDB
Azure DocumentDB is the highly scalable NoSQL document database-as-a-service that offers rich query and transactional processing over schema-free data. It helps deliver configurable and reliable performance and enables rapid development. This is all through a self-managed platform and is backed by the power and reach of Azure. DocumentDB is the right solution for web and mobile applications when predictable throughput, low latency, and flexible query are key.
-
Add support for aggregate functions like Count, Sum, and Avg along with Grouping
It would be great to have some baseline aggregation functions support without having to return all the records and then perform aggregates on them in code.
2,404 votesWe have already started working on supporting aggregations and are targeting early CY2017 for this feature. We will update you once we have more information including availability within a private preview.
In the interim, please refer to the linked DocumentDB stored procedure example (https://github.com/Azure/azure-documentdb-js-server/blob/master/samples/stored-procedures/Count.js) which provides an example of how to do a count using Javascript stored procedures.
HTH!
Denny Lee
Azure DocumentDB -
[DocumentDB] Allow Paging (skip/take)
Allowing paging would be huge. Btw, Thank You for rolling out this feature at all! It looks wonderful! Can't wait to try it! However, I won't be able to use it for actual work projects until it supports paging and sorting.
1,513 votesHi,
Support for SKIP is under review; we will provide an update once we have a confirmed schedule. As previously announced, TOP is supported, and the LINQ provider supports TAKE.Han Wong
Program Manager
Azure DocumentDB -
Be able to do partial updates on document
Allow to push only values for some fields of a document and not need to read the whole document and save it to documentDB.
1,124 votesThis feature is currently under review and we will get back to you as soon as we have an update on this.
In the interim, a design approach to consider would be to break your JSON document down into smaller pieces, for example one document for the data that rarely changes and smaller document that is regularly updated. This in combination with upsert would allow you to quickly modify the attributes that needed modifying.
HTH!
Denny Lee
Azure DocumentDB -
Backup Solution for DocumentDB
It seems that there is no backup for DocumentDB. You should provide a backup solution for DocumentDB.
1,086 votesAs @Govind has noted in the comments, the procedure for DocumentDB Automatic online backup and restore with DocumentDB can be found at: https://azure.microsoft.com/en-us/documentation/articles/documentdb-online-backup-and-restore/.
Note, we are keeping this at the “started” stage and will file this as “completed” once we complete the tasks to provide you the ability to backup and restore within the Azure portal.
HTH!
Denny Lee
Azure DocumentDB -
DocumentDB Free Tier
DocumentDB offering should provide a free tier for dev/testing.
I'm maintaining the MongoDB provider for NEventStore (https://github.com/NEventStore/NEventStore.Persistence.MongoDB) and would try to build a DocumentDB Persistence Provider.Would be even better to have an "open source" subscription for oss projects on azure (dev/testing)!
965 votesWe’re excited to announce the public preview of the DocumentDB Emulator (azure.microsoft.com/blog/documentdb-emulato..), which provides a local development experience for the Azure DocumentDB service. Using the DocumentDB Emulator, you can develop and test your application locally without an internet connection, without creating an Azure subscription, and without incurring any costs.
We hope this addresses some of the scenarios for a Azure DocumentDB free tier.
Thank you,
Aravind Ramachandran
Azure DocumentDB -
Partitioned Collections with < 10k RU/s
Please allow partitioned collections with fewer than 10k RU reserved.
I really would like to use partitioned collection but according and the pricing model $6/month for each 100 RU seems fair. But the minimum RU/s for partitioned collections are > 10.000 RU/s which is min $600 a month.
709 votesHello,
Thanks Ethan for your feedback. We are currently in Private Preview of the lower throughput limit so feel free to contact us through [email protected] to get early access to the lower limit offer. Also, we are working on a smooth transition from single partition to partitioned collection.
Thanks,
Arnaud Comet
Azure DocumentDB team -
Have DocumentDB in Brazil datacenter
Enable DocumentDB in Brazil Datacenter
670 votesWe are planning to have DocumentDB in the Brazil Data Center early CY2017. We will update this once the data center is online.
HTH!
Denny Lee
Azure DocumentDB -
Allow me to set JsonSerializerSettings
Today I have to use JsonProperty or JsonConverter attributes to decorate my objects one property at a time.
This is painful when dealing with large objects and error prone.
It would be a much better idea to support the use of JsonSerializerSettings to set global behavior for JSON.NET ... just like WebApi and ASP.NET does today.667 votes -
Support OData Protocol
Since OData is a standard API supported by Microsoft and intrinsically supports JSON, and DocumentDB is JSON-based, it's a good fit. A standard protocol would also greatly increase interop potential, like SQL, which you are supporting.
584 votesAs there has been some more recent asks for support of OData protocol, this ask is currently review. We will update you when more information becomes available.
Thanks,
Denny Lee
Azure DocumentDB -
Set based operations (INSERT, UPDATE, DELETE)
It would be nice to be able to update parts of documents, delete documents, and insert documents using set based operations, similar to SQL.
e.g.
UPDATE Users SET IsActive = 0 WHERE LastLogin < '2010-01-01'
DELETE FROM Users WHERE LastLogin < '2009-01-01'
INSERT INTO table2 SELECT * FROM table1552 votesWhile this suggestion is still under review at this time. In the interim, we would suggest using stored procedures for write operations as this allows you to perform write operations that span multiple documents to get transaction semantics.
Thanks,
Denny Lee
Azure DocumentDB -
Provide support for DISTINCT
Need to provide support for SELECT DISTINCT xyz FROM c.
506 votesWe are planning to provide DISTINCT capabilities in a future release. Once we have released aggregates, we will be working on providing DISTINCT. Will update you once we have a firm timeline for this.
Thanks,
Denny Lee
Azure DocumentDB -
Support cross-document joins
I have a many-to-many scenario that requires something like document-to-document joins.
In my app, users can "like" posts. That's three "tables" or entity sets. One each for users, likes and posts. I can't put the likes inside of either the users or the posts entities as sub-documents because there could be thousands of them. Even with 256KB documents I'd run out of room pretty quickly. I need a way to quickly get the top 100 posts that a user liked (and continue to paginate from there). I also need to go the other way. I need to get all the…
486 votesIn the scenario described involving documents that have users, likes, and posts; you can place all three set of JSON documents into the same DocumentDB collection. DocumentDB stored procedures allow you to perform write operations that span multiple documents while having transaction semantics. This way you can perform your CRUD operations against the three different set of documents and avoid putting all of the entities in the same document. By any chance would this address your scenario?
Thanks,
Denny Lee
Azure DocumentDB -
Transparent Data Encryption (TDE)
DocumentDB should support Transparent Data Encryption.
484 votesWe are currently working for support for TDE/Encryption at Rest in Azure DocumentDB. We will update you as soon as we get closer to a preview.
Thank you,
Aravind Ramachandran
Azure DocumentDB -
On-Premise instance
Allow us to host our own on-premise DocumentDB instances
460 votesAs noted in the request “Standalone local instance” (https://feedback.azure.com/forums/263030-documentdb/suggestions/6328798-standalone-local-instance), we will have a local emulator version of DocumentDB ready soon for offline development and unit testing. Hopefully this will address some of your scenarios.
Thanks,
Denny Lee
Azure DocumentDB -
Batch Operation Support
Document DB should support batch operations in REST API and SDK level. It would be very useful to insert 1000 entities in one transaction.
444 votes -
Unique constraint on document properties
While document ID's are unique, I would like a unique constraint on a given property as well. Today, the only ways I see to accomplish this is either with a client-side query or a pre-trigger (also requiring a query).
I'd like a "unique" constraint to be applicable for given property names within a collection.
443 votes -
Implement Wildcards when searching
Add support for the LIKE '%%' SQL keyword and associated functionality.
432 votesThanks for the feedback. We are reviewing this feature request and will provide an update soon.
Thanks,
Aravind Ramachandran
Program Manager
Azure DocumentDB -
Support Unit of Work pattern in client SDKs
Unit of Work pattern is vital -
Start some unit of work (or "Transaction") do a bunch of stuff, then commit everything to the server at once in a atomic transaction.I don't like server side programming for a number of reasons
1) it's a different language so not great for skill reuse when all our devs know & use C#
2) they're impossible to debug
3) they're a pain to deploy to multiple collections
4) they're a pain to keep in sync between prod & dev
5) they're impossible to unit testand finally, and probably most importantly
6)…429 votes -
Powershell script for DocumentDB
Hi,
I don't find any Powershell script for DocumentDB, therefore please create Powershell Scripts for DocumentDB.429 votes -
I want atomic counter
I want a counter is a valid atomic in the collection. Such as use with automatic sequential number.
422 votes
- Don't see your idea?
