Is there a reason why not model social network with SQL API?

Question

In one of our apps we need to introduce a feature of users being able to choose friends, see friends activity, etc. So far we use CosmosDb container with SQL API (for things app does beside this social network aspect).

I am wondering is there a reason not to model it with SQL API but to go strictly with Gremlin?

I’ve seen examples on Microsoft site about modeling basic social network done with ordinary SQL API but i am not sure if i am missing something that would bite me down the road in a case not going with Gremlin?

Answer 1

You should be safe in choosing either. From docs:

Each API operates independently, except the Gremlin and SQL API, which are interoperable.

The stored data is JSON in both cases.

More on choosing an API.