Skip to Content
Migrating Applications to the Cloud with Azure
book

Migrating Applications to the Cloud with Azure

by Sjoukje Zaal, Amit Malik, Sander Rossel, Jason Marston, Mohamed Waly, Stefano Demiliani
December 2019
Intermediate to advanced content levelIntermediate to advanced
494 pages
11h 41m
English
Packt Publishing
Content preview from Migrating Applications to the Cloud with Azure

The SQL API

Cosmos DB provides a SQL layer over a document database. The data is stored in collections as JSON, just like they are with MongoDB. However, retrieving that data can be done using SQL queries instead of MongoDB JavaScript objects. That being said, SQL is not entirely what you're used to. While most of it looks the same, some operators, such as LIKE, are not supported. Because we're still dealing with a schemaless JSON database, other functions have been introduced. For example, STARTSWITH, ENDSWITH, and CONTAINS make up for the lack of the LIKE operator, while IS_DEFINED checks whether a property has been defined on a document:

All your documents can be queried through an HTTP-based RESTful API. For example, to get a document, ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Migrating Applications to the Cloud

Migrating Applications to the Cloud

Steve Swoyer
Microsoft Azure: Planning, Deploying, and Managing the Cloud

Microsoft Azure: Planning, Deploying, and Managing the Cloud

Julian Soh, Marshall Copeland, Anthony Puca, Micheleen Harris

Publisher Resources

ISBN: 9781839217470Supplemental Content