How can we improve Azure Cosmos DB?

Gremlin queries from stored procedures

It would be nice to have the ability to execute Gremlin queries against the Graph API from a stored procedure. Ideally, this would also enable transactions.

111 votes
Vote
Sign in
(thinking…)
Sign in with: oidc
Signed in as (Sign out)
You have left! (?) (thinking…)
Jeff shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

4 comments

Sign in
(thinking…)
Sign in with: oidc
Signed in as (Sign out)
Submitting...
  • Charan commented  ·   ·  Flag as inappropriate

    It would be great if we can use cosmos db stored procedures to traverse the graph db

  • Eva commented  ·   ·  Flag as inappropriate

    Switch from Janus Graph to COSMOSDB relief me from maintaining a deployment, which is really great. However, Janus natively supports transaction and many existing business logic heavily relies on that: query to uncommitted vertex/edge, rollback entire transaction once any faulty state.
    Also, if each query will go to COSMOSDB server, the latency from an entire business flow is really unacceptable. So I'm thinking if CosmosDB could provide a more sophistic client to handle transaction and cache?
    (we're trying to achieve this by ourselves, but for complex query we found it really complicated. But I think CosmosDB already have much knowledge on graph compute, so it would be great this capability can be provided by CosmosDB team)

Feedback and Knowledge Base