1:59
Hi, everyone, and welcome back to Azure 4 Show Season 2
2:10
As always, I'm your host, Simon, and we are back once again. And I am really, really excited for this episode of Azure 4 Show
2:17
as I'm hosting someone for the very, very first time. I've been doing these live shows and virtual conferences
2:22
over the past two and a half years, but it's surprising that I have not hosted our amazing guest for today
2:28
She's someone who's going to talk about the Azure Cosmos DB today
2:32
And for some of you who watch our shows at C Sharp Corner, you know, we stream the Azure
2:37
Cosmos DB conference. We have some great friends at the Azure Cosmos DB team. And the moment we saw the Azure Cosmos DB sessions, like, yeah, we're going to have more
2:47
Cosmos DB sessions at C Sharp Corner. So for the folks who are joining us for this time, there's a comment section
2:52
You can always go ahead and drop your questions, anything that you have. and uh without any further ado let's go invite sarah who is a microsoft mvp she's a published
3:01
technical author of a powershell book she does podcasts live coding games she speaks at conferences
3:06
she's heck of an organized she's a speaker she's a community active uh advocate and uh yeah she's
3:12
one of the very active speaker and awarded by such nice she is a rock star so hi sarah welcome to the
3:20
Azure Parshia Live show. Hello. Thank you for bringing me here. Thanks for accepting the patience, Sarah
3:26
I'm really excited to have you today. I see you're going to talk about Azure Cosmos DBN
3:30
We're really excited for it, right? So quick question. By the way, where are you joining us today from
3:35
I am joining from Northeast Ohio in the USA. Well, USA, what time is it
3:41
It is 1 o'clock in the afternoon. Oh, it's 11.30 p.m. at my place
3:45
Oh, late night. Late night, yeah. All right, Sarah. I know this live show, it's straight for just 14, 15, 30 minutes to deliver the content, right
3:55
So I'm not going to take any more of your time. I see you have shared your screen. I'm going to drop it to the stream now
4:00
Oh, wow. That's me. That's you. That looks good. Oh, wow. I'm not going to take much of your time
4:08
The show is all yours. Awesome. Thank you. Well, hello and welcome
4:13
For those of you who aren't familiar with who I am. So I am Sarah Dukavich
4:17
I go by Suduki in the community. I'm a Microsoft MVP in developer technologies, have been since 2009
4:23
I have my own consulting firm right now. I have a bachelor's degree in computer science and engineering technology, so I went to school
4:29
to make sure I could prove, hey, I know this stuff, but as you can see, 20 plus years in
4:35
the field, I kind of know what I'm talking about nowadays. I organize conferences like Codemash and SturTrack
4:41
I'm a speaker at many community events. I blog at suduki.com and dataadventure.com
4:46
I am married to a geek, my husband's a tech director, and I have two kiddos as well
4:52
But enough about me. We have about 25 minutes, and we are here to talk about Azure Cosmos DB
4:57
I love talking about Azure Cosmos DB because it's one of those that people are like, well
5:01
what is it? Well, if you notice in the title, I said data for all
5:05
And you're probably like, but for all? For everyone? Yeah, yeah, for all, I promise you
5:10
So what we're taking a look at with this is, first off, they have a bunch of different APIs, and they serve different services
5:20
So the document data, so there's two different APIs that we'll talk about for that
5:25
That's the Azure Cosmos DB for NoSQL and Azure Cosmos DB for MongoDB
5:31
There's columnar data, which is Azure Cosmos DB for Apache Cassandra. There's Apache, Azure Cosmos DB for Apache Gremlin, which is graph data
5:44
There's key value data, which is Azure Cosmos DB for table. And then the most recent one, as of October, there's now relational data at any scale available
5:55
in Azure Cosmos DB for PostgreSQL. Now you'll probably see me keep going, all right, how many words did I get out
6:02
Make sure I get the whole name. But the APIs, just remember them. They're Azure Cosmos DB 4
6:07
And then whatever they're for. Now, for those of you who are like, well, what's Azure Cosmos DB
6:14
I call it the flagship NoSQL offering in Azure. Like when I think NoSQL and I think Azure
6:19
Azure Cosmos DB is the thing that comes to mind. It's got turnkey global distribution
6:23
It's got really fast reads and writes, single digit millisecond reads and writes
6:27
It allows you to scale your storage and throughput. it. You have both manual and automatic failover capabilities. It's got five well-defined consistency
6:37
models. It is ytics ready, which means that you can take your data over. There is a link
6:42
between Azure Cosmos DB and Azure Synapse. There's an Azure Synapse link that you can use for that
6:47
There's security. There's encryption. Did I mention that it supports relational databases as well
6:53
and most of all you're going to hear this a lot which is it can be tried for free as in
6:59
no credit card required as in all you need is a Microsoft account and a GitHub account
7:07
Now they have comprehensive SLAs so again less than 10 milliseconds and then you're going to
7:12
see five nines for your high availability guaranteed throughput guaranteed consistency. You might be wondering who's using Cosmos DB
7:21
Who's using Azure Cosmos DB? You going to see all these different companies You seeing some big names here too So you seeing things like Ford and Coca and Domino Pizza Can you tell it around lunchtime here when I start going down to the pizzas and the beverages
7:36
But you can see these are big names that are using Azure Cosmos DB
7:40
And it's not just the big names, but small names too. I can tell you I was working for a smaller company
7:44
when I first saw Azure Cosmos DB. But we used it in our e-commerce platform
7:50
Okay, so Azure Cosmos DB, One of the things that can support is document data
7:56
So when it comes to document data, the first API that we want to talk about is the Azure Cosmos DB for NoSQL
8:02
This also used to be known as the SQL API or the core API
8:07
This is your base for Azure Cosmos DB. So what you need to know about it, so think of it as storing JSON documents
8:15
You have a hierarchy here. So you have the hierarchy for it starts with the account level
8:21
This is the highest. So this is where you set your API. So when you create your Azure Cosmos DB account, you have to choose your API
8:28
That's tied to the account. Within that account, you can have multiple databases
8:34
Within the databases, you can have multiple containers. And with the containers, the containers have multiple items
8:40
Now, with us only having 30 minutes total to talk through all this
8:44
I'm not going to be getting into a lot of the deep dives on this, but I do have a lot of slides and links to help with that
8:50
All right, so we talked about the hierarchy, how it's account databases, containers, and items
8:56
The names, containers, and items may change depending on the API, but for the NoSQL API
9:00
that's what they're called. The JSON does automatic indexing for you regardless of your data model
9:06
Again you've got the benefits of ingesting and serving your data in milliseconds
9:11
JSON, JSON under the covers. You will use it, SQL syntax, it is not like your SQL server relational database SQL syntax
9:22
but it looks similar enough. Azure Cosmos DB has this feature called a change feed
9:29
I call it the hidden gem of Azure Cosmos DB because it allows you to take a look at all
9:33
the changes that are coming in, and then you can do what you need with those changes
9:36
So if you want to do event sourcing, if you want to move your data from one container to another to create materialized views, things like that, you can do that with the Azure Cosmos
9:44
DB change feed, which works also with the Azure Cosmos DB for NoSQL API
9:50
You'll see on some of my slides I mentioned the free tier. The free tier is something that you can select on one Azure Cosmos DB account for your account
9:59
It has some limitations for each of the APIs. But just so you're aware, if you see free tier, most of the APIs, the free tier is on them
10:08
The only one that doesn't, we'll talk about that when we get there. Okay, so NoSQL, that's the core, that's the heart of Azure Cosmos DB
10:19
Who's the other document data endpoint, the API for MongoDB? So if you're familiar with MongoDB, if you're using things in the C-sharp world, we have MongoDB.driver
10:28
You can use that to talk to Azure Cosmos DB for MongoDB
10:32
It has the five nines availability and a lot of the other things being built on top of Azure Cosmos DB
10:38
but some things to note is that it is got three different ways to be provisioned or three different
10:45
ways to work with MongoDB. Azure Cosmos DB for MongoDB. It's provision, autoscale with zero
10:52
warmup, and serverless. There is free tier available on this. There are some features
10:57
that aren't supported. I'm going to put a link in chat that I know Simon will share with you all
11:02
And that will take you to what I also have the QR code for, which is where some of the
11:08
features aren't supported. You can see the chart of yes supported or no supported
11:13
The Azure Cosmos DB team has done a great job of documenting everything in the system
11:19
and pointing out things like, okay, this doesn't work and here's why. Okay
11:25
All right, columnar data. So this is your column stores. This API is known as Azure Cosmos DB for Apache Cassandra. So with this particular one, think of it as its fully managed serverless Apache Cassandra
11:47
If you're used to Apache Cassandra and using Node tools to manage your Apache Cassandra, you don't need that here
11:53
Azure Cosmos DB is fully managed, so that is handled for you
11:58
For those coming in from the Cosmos mind, not straight away into Cassandra
12:03
Azure Cosmos DB for Apache Cassandra uses a query language called Cassandra Query Language
12:08
It looks similar to SQL, but it has its own quirks, just like going from language to language
12:14
So think of Azure Cosmos DB for Apache Cassandra as it's got the benefits of being built on top of Azure Cosmos DB while still being able to use your Apache Cassandra tools
12:24
Now from a C Sharp standpoint, I want to make sure that you're aware I have a GitHub repository that I'll share a link for at the end with a bunch of C Sharp demos for all APIs except this one
12:37
The demo that I could find for this relies on .NET Framework 4 something and .NET Core
12:46
It had no support in there for .NET 6. I checked the DataStax website
12:50
DataStax does a C-sharp driver. I'm not finding anything good for .NET 6
12:54
I did leave my code in there so you could see what we attempted, but it doesn't work well with that
13:00
Something to note with Azure Cosmos DB for Apache Cassandra is that it supports durable commits
13:06
whereas Apache Cassandra by itself does not. All right, we'll post that link in the chat as well
13:13
These slides will also be available after the show in the GitHub repository
13:18
Again, links there. So if you're just like, oh, I don't have these links, or I can't scan the QR fast enough, rest assured, we've got you covered
13:28
All right, graph data. So graph data, I have a quick story on that
13:33
and that's talking about what we see here, which is the graph. graph data, think about it as you're not looking at like table relationships
13:41
you're looking at the relationships within the data. So the story I like to tell is how I heard
13:46
about C-sharp corner. So I'm Saduki and Simon here is our co-host and we have a friend in common
13:53
named Joe Godagno. And I'm sure if you've seen some of the stuff here in the community, you've
13:58
probably heard of Joe. And so for me to learn more about C-sharp corner, I've been keeping an eye on
14:03
what he does. Well, I know Joe, and Joe knows Simon. So I know Simon through Joe. This is a graph
14:14
This is, these are things, these are vertexes, or V, and these arrows are relationships, also known
14:21
as edges, or E. And so we can look at the relationships between things and how they go
14:29
from there. Now I've done many user group talks on the Gremlin API stuff so if you have questions
14:38
about that afterwards feel free to hit me up and I'll answer what I can. The demos that included
14:44
in the repo for this are based off of the demos of the quick starts but I also have a few other
14:49
demos for Gremlin With Apache Gremlin so it is Azure Cosmos DB for Apache Gremlin is the API name the gremlin comes from the Apache TinkerPop project TinkerPop is where the Gremlin server the Gremlin client live the Gremlin console
15:09
I just have a link also in chat for this one. So this operates, again, on the concept of vertices and edges, or like I call them, things and relationships
15:19
You use the Gremlin syntax. So you're using their g.v, g.e, and navigating with ins and outs and both
15:26
and being able to loop and navigate until you hit a certain point. All of that is done in Gremlin syntax
15:32
Now, in the demo, we'll use gremlin.net, but notice they support other languages too
15:38
So Java, Python, Node, PHP, Go, and a console. Same goes for all these other tools that I'm showing you
15:45
If we have time for the demos, just so you can see what the code looks like
15:49
you'll be able to see I'm using the tools for that particular product
15:55
I'm not using Azure Cosmos DB's SDK to access these other different APIs
16:00
only for NoSQL's API. The rest have their own SDKs and tools
16:12
Okay. So the next API is key value data
16:22
A key value data, you may be thinking, hmm, I think we have something in Azure already
16:29
What about Azure Table Storage? Is that related to this? Well, let's look at Azure Cosmos DB for Table
16:37
So Azure Cosmos DB for Table is going to use that same table model as Azure Table Storage
16:42
So it's a managed service. It has the benefits of Azure Cosmos DB plus the familiarity of
16:49
Azure Table Storage. In fact, in the demo, we use the Azure Table SDK rather than using the
16:56
Azure Cosmos DB SDK. Why is that? Because the Table API, when you're working with Table Storage
17:02
Azure Table's code is what you're going to be using in C-sharp. But the difference between
17:08
Azure Cosmos DB for table and Azure table storage, you're getting better SLAs. So you're getting your
17:14
five nines. You're getting support for consumption and provision capacity. You've got your consistency
17:21
levels. So in the Azure table storage, you have strong primary consistency and eventual secondary
17:27
consistency set up. But in Azure Cosmos DB, there are five different consistency levels
17:34
There's more indexing support with Azure Cosmos DB for Table. There's no upper limit on the throughput
17:40
There's more operations per second per table supported. So Azure Cosmos DB for Table, if you're working with Table at a large scale
17:47
you should consider Azure Cosmos DB for Table. It uses the same prod operations as well
17:52
Grab the links for assignment as well. And that is this one
17:56
all right and the newest of them is azure cosmos d for postgresql they announced it at
18:08
ignite in october of 2022 and it is relational data at any scale and this is something that
18:16
people are like but cosmos big data lots and lots of data really relational data in any scale even
18:24
Even at the smaller scale? Yeah, even at the smaller scale. What's nice about Azure Cosmos DB for PostgreSQL is that it is PostgreSQL under the covers
18:33
It is PostgreSQL on its nodes. They are standalone servers, but they are powered by this extension called Citus
18:40
Now if you're in the PostgreSQL world and you're like, but Azure Cosmos DB for PostgreSQL
18:45
didn't we already have an offering for this in Azure? You did
18:50
It used to be known as Azure Database for PostgreSQL Hyperscale. Now it is Azure Cosmos DB for PostgreSQL
18:56
And the documents do redirect. So if you're just like, let me check those docs, you'll see that they redirect here
19:03
Relational data at any scale, because it's PostgreSQL under the covers. So you have that PostgreSQL support
19:10
You have your relational database. The difference is once you get Citus involved, now you can scale your data horizontally
19:16
And then you can make it so it's optimized for your queries by partitioning and sharding your data in a way that makes sense
19:27
Now, with Azure Cosmos DB for PostgreSQL, so it can be started with either a single node or a multi-node setup
19:34
If you start with a multi-node setup, then you can scale it out to multiple worker nodes
19:42
They have coordinator nodes and worker nodes. The worker nodes are the ones that store the shards
19:49
The coordinator node knows which of the workers have which shards. The coordinator node knows which workers to engage based on queries
19:57
You can set it up with a single node as well if you're just starting out
20:01
If you're working with a small amount of data and you don't really need to take advantage of the horizontal scaling, don't panic
20:08
You can still use this here. because each, like I said, each node is a standalone Postgres server
20:13
There's a lot to get into with the architecture of it and stories for that
20:18
I do have a link that I want to share with you all. It is on Microsoft Learn
20:24
So there's a learning path for Azure Cosmos DB for PostgresQL. That'll give you a good introduction of what Azure Cosmos DB is capable of with this API
20:34
and also what you need to consider when you're dealing with scaling and horizontal scaling, the sharding
20:49
How are we on time? All right, I have a few minutes that I can actually show you the code
20:58
So I'm going to bring my code over. All right, so this is my Visual Studio code
21:08
I have a folder for demos and each of the APIs will be within their folders
21:16
You can see with Gremlin, for example. Let's pull up the CS project Y so you can see that the reference there, the only things
21:24
I'm pulling in are gremlin.net and then newtonsoft.json. That's just so that I can map some fields
21:31
But other than that, I'm not dealing with the Azure Cosmos DB SDK here
21:35
I'm using the Gremlin driver to talk to the Azure Cosmos DB for Apache Gremlin API
21:41
And if I wanted to run these, these are all .NET console apps
21:48
So I can go into my demos folder and I can go into my Gremlin folder and I can do a .NET run
21:57
And you'll have access to the GitHub repo at the end of here
22:01
You'll see orange. Oh, hold on. I have to set up my environment variable
22:07
So all these demos work on environment variables. And the environment variables depend on the demo
22:14
Sometimes it's a connection string. Sometimes it's a hostname, username, password. you'll see the get environment calls in there
22:28
So what you seeing here when I do a run this is calling out to Azure Cosmos DB and executing some queries And then this is the response that is coming out What awesome with
22:39
this demo is that it shows things like, all right, what's the query that you're running? What's the result coming back? And then how long does it take to come back plus the charge for
22:48
running it? So you can see what I'm working with here in the Gremlin API. Notice that the response
22:54
you're seeing here, we're working with JSON. So if you remember when I talked about Azure Cosmos DB for NoSQL
23:03
how it's JSON under the covers, it is JSON under the covers for all of the APIs
23:11
Sometimes I do another demo where I use, so Sauron Web has a Cosmos DB extension
23:17
that you can run in Visual Studio Code where you can query your APIs. And I've done queries where I've shown
23:23
that you can query the Gremlin API and get the JSON back using SQL
23:28
But don't do that because it's one of those that they're optimized to work
23:33
for these queries that are coming in. But you can see, like, okay, I want to know all the first names
23:40
for example, of all my vertices. So you can see the results that way
23:44
The one I like to talk about with the navigation. So I have it set up so that I know Joe
23:52
Joe knows Simon. how do I know Simon? So the query is, you can see here that Joe knows a person knows a person is a
24:04
query. This is the query that I want to show here, the g.v.suduki. So starting at the circle that is
24:12
labeled Suduki, keep going, following those arrows until I hit Simon. How do we get there
24:19
So this is what it looks like in Gremlin. So you have that g.v. Let me see if I can zoom it up a little bit more so you guys can see it
24:27
There we go. So thank you. So this g.v. Suduki, repeat, out, which means keep going out until it says, okay, when do we want to hit a stop
24:40
So when you need to go from point A to point B and you don't know what's in between
24:44
this is where you do a loop of repeat and where to stop at so we can see that this now there's
24:51
json reading json can be kind of gross but as developers we're kind of used to these kind of
24:57
things for debugging purposes so you can see it goes from me to joe then from joe to simon
25:04
so this is what it looks like again with gremlin with mongo if i look at my program cs you can see
25:11
all I have is MongoDB driver. So I'm doing nothing special here
25:17
I'm just using the MongoDB driver to talk to Azure Cosmos DB for MongoDB
25:23
In my program, that's CS files for each of these APIs, I try to get most of the CRUD apps represented
25:29
so that you can see what's going on. And so you can get started with it today
25:35
Now, these are just my demos. There's also a ton of quick starts in the Azure Cosmos DB docs
25:40
that will also help you get moving today. Okay. So just so you can see, no tricks up my sleeve
25:48
things under the covers. This one does use the Microsoft Azure Cosmos DB SDK
25:52
but that's because this is NoSQL. This is its actual, the base of it all
25:57
It is its main thing. Okay. And then Postgres uses the NPGSQL
26:10
And then finally, table uses Azure.data.tables. Now, all of my demos in this repo I've done for .NET 6 because that is the long-term support
26:24
The exception, like I said, is Cassandra. Cassandra, I tried to move it to .NET 6, but its driver isn't supporting it
26:31
So be aware of that. All right, so no tricks up my sleeve, but I know we're also only so much time
26:41
So I can deep dive in most of these APIs. If you have more questions, feel free to ping me on LinkedIn or Twitter
26:48
I've got links to share on how you can find me on those. I will gladly answer as many questions as I can
26:53
And what I don't know, I'll be able to show you where it is in the community as well, all we can talk with
26:58
All right, so you want to try Azure Cosmos DB for free? Check this out
27:04
So Azure Cosmos DB for free. Let me post the link so that I'm going to post that
27:11
So Azure Cosmos DB for free. This is a screenshot. The next couple slides are just screenshots of what happens when you sign up for free
27:18
Again, to show you no tricks up my sleeve, to show you no credit card
27:22
So what I did is I went to that URL that I posted and it takes you to try Azure Cosmos DB for free
27:31
Now I highlighted the recommended APIs and others because you might want to try an API that is not on the recommended
27:38
Rest assured if you check under others, you'll see that there. This requires a Microsoft account or a GitHub account
27:45
Then when we go to tell it to create, the next thing you'll see is consent
27:52
For me, I tried to do a Postgres trial, and so that's what you're seeing here
27:59
So am I going to allow them to access my Microsoft account
28:04
Yeah, that's fine, but no credit card is needed for that. Just so you're aware, if you already have a Microsoft account, an Azure account
28:14
and you want to do the trial, you can still do that trial. Just be aware that this is going to be what's known as a sandbox trial
28:22
So if you're in an Azure account and you aren't sure where your trial went for Cosmos
28:29
you'll probably have to go in the upper right corner where your account is until it switched directory and switch it to whatever the directory name is
28:37
In my case, I looked for my subscription. I didn't see it under my general subscriptions
28:43
and so that's how I found it to do switch directory. But the sandbox trial, it tells you how long you have
28:51
This here, to get started, you have to change your password here. This change your password is changing your password on the database
28:57
So for me, I have a Postgres API spun up. I need to set my administrator password, which I already did
29:04
But just so you're aware when you see this, I got to change my password. It's for the server itself
29:09
It has nothing to do with your account. Something else to note with these trials is that they are limited resources
29:18
so you can do only so much. For the Azure Cosmos DB for Postgres, for example
29:25
it spun up a single node configuration. I cannot scale that out to multiple nodes
29:30
I cannot do multiple worker nodes, no high availability. So you are limited in the trial to what you can do
29:37
but it is enough for you to get started and to work with it and to see. The demos that I have in my repo
29:43
the demos for the quick starts are fine for this trial. So be aware of that
29:53
Make sure there are any questions. Not yet, okay. Now suppose you wanna learn more, again
29:59
Short period of time, not a lot to cover, but there's a lot of other resources out there
30:04
There's the Azure Cosmos DB Global User Group. They are located on Meetup
30:08
It is a virtual user group, and they have a meeting next week on Valentine's Day where I will be talking about Azure Cosmos DB for Postgres
30:17
but they also have talks on all sorts of other things from indexing to data modeling to the various APIs
30:25
to the conferences going on about Cosmos and everything else under the sun
30:31
It is a great community. It is a welcoming community. So I would highly recommend that you check them out
30:39
If you want to learn more about Azure Cosmos DB and the various APIs
30:43
but you're not sure where to get started and you're like a quick start might not necessarily
30:48
be what I need. There are also the learning paths and modules on Microsoft Learn
30:56
And this goes for anything again from the various API specific things to configuring storage and
31:03
prepping for the Azure Cosmos DB certification. All sorts of different options to explore for
31:09
learning more about Azure Cosmos DB. If you're just getting started with Azure Cosmos DB
31:20
there's a series called Azure Cosmos DB Essentials. It's on YouTube. There are three seasons
31:24
where you get to join Mark and Mustafa and learn more about how does Azure Cosmos DB work
31:32
What are the things you need to be aware of under the covers? How can you tune things
31:38
So that is on YouTube. Share that link as well. There's the Azure Cosmos DB developer site, so developer.azurecosmosdb.com
31:56
So that where we have any developer resource that you need for Azure Cosmos DB more guidance on it They have great links for that
32:13
There's a GitHub repo as well. So I put these slides plus all of these links plus the demos
32:20
as you saw in my Visual Studio Code, are all available on GitHub. It is a public repo
32:28
so feel free to check it out. I will be adding more documentation within the code after this presentation
32:35
but just so you're aware that the code is available right now, these slides are available right now
32:40
and you can try Azure Cosmos DB for free right now. If you have any other questions about Azure Cosmos DB
32:48
feel free to reach out to me. Like I said, the community is great. I can help you navigate it
32:53
You can find me on Twitter as Suduki or on LinkedIn as Suduki as well
32:58
Any questions? That was great
33:15
That was a rocket speech. I want you to catch some breath because I don't think you even stopped for even like 10 seconds, right
33:22
and you have cursed me throughout the show for giving only 25 minutes
33:28
I was gonna say I'm just like okay I can't go deep diving through any of these because I know
33:33
we're on a time limit here but I do have a ton of links for you all to explore so as I'm sure
33:39
you're seeing I'm like oh no she's got more links and more links I've never dropped so many links
33:44
ever I'll be honest yes that's what happened yeah but I think you covered a lot in just about last
33:51
25 minutes. I can recall in the beginning you started with like there are so many APIs
33:55
right? Maybe you can come from any background, right? Cosmos DB has gotten a lot of APIs
34:00
for you and you showed so many big companies and also small companies using Cosmos DB And I think if you just a developer you just starting up as you share towards the end uh the free tier that cosmos db has i think it was released on only a year or
34:15
maybe a year and a half back i remember uh earlier then they didn't have it but great and thanks for
34:21
putting my and joe name in the examples thing i really understood that that is that is the time
34:25
when i really started giving attention to your session that's one of those where i try to whenever
34:30
I'm writing my demos. I try to make sure that it's relevant to the audience. So you're going to see in the GitHub repo that I mentioned Azure for sure
34:37
that I mentioned some of the books that are on the website, and I mentioned today's event. And I mentioned Joe because Joe is my connection to your community
34:44
And so, yeah, I try to make my examples relevant so that you can relate to them as you're working with them and going
34:51
oh, yeah, that's exactly how this works. Yeah, I really loved it. And also, you know, the examples that you had in the end
34:57
the demos are in fact, right? from across the board maybe from MongoDB or Postgres or whatever right and even also towards
35:05
NoSQL so that's pretty helpful and having those those resources on the on the GitHub it's pretty
35:10
easy right and and because I use Postgres but not for the Azure Cosmos DB but for the other open
35:16
source backend as a service and I love Postgres so just I just want I just want to know Sarah
35:21
someone who comes from a Postgres background like that's for me or for anyone for any background
35:26
right what is going to be the very first step okay now that I've decided I want to go and start
35:31
learning Cosmos DB maybe explore it right what is the first thing that maybe should what should
35:36
the steps one should follow or to to get started I understood the entire ecosystem of Cosmos DB
35:42
right but how what is the step one should I take I would say if you're not familiar with Azure
35:47
Cosmos DB at all start with the Azure Cosmos DB essentials videos on YouTube oh yeah you share
35:52
Understand the principles. Now, I guess I should qualify that. For all the APIs except Postgres, I would say use Azure Cosmos DB, the essentials, to get an understanding for the foundations
36:04
Postgres is a different beast. So for that one I would say check out the learning path on Microsoft Learn for Azure Cosmos DB for PostgresQL There four modules there And it tell you all the little gotchas of okay I have my regular PostgreSQL database that maybe you running a PostgreSQL database at home because you playing with it
36:22
and you really enjoy it. But now you want to take a look at it and go, okay, can I scale it
36:27
You know, how does it work in Azure? So Azure Cosmos DB for PostgreSQL would be able to show
36:31
you that. Yeah. And I see, you know, they have quite a good extension and also some of the
36:36
content of and you are speaking on a valentine's day come on i know i get to talk about post-press
36:41
on the day of love yeah if you don't if you don't have hearts in in your sessions you don't have
36:47
hearts in your slides i'm not i'm not joining your session i will make sure that there are hearts in
36:52
there for the post-press session and you know sir i missed i just missed to put it in the summary
36:57
but i really like on how you were just breaking down of the entire you know uh the the path of
37:02
the, I should not say path, but the way you broke down, it's like you have an account
37:08
in Cosmos DB, you have a database, then you have a container, and
37:12
then you have an item. If someone just looks at these four steps, it
37:16
gives you an idea on how Cosmos DB works, right? You have to do an
37:20
account, create a database, then a container item, boom, bang, now you know
37:24
how to work with it. Exactly. That's how cool this session was
37:28
That was absolutely great, Sarah. Any final thing you want to plug in before we wrap up the show today
37:32
So I would say if you want to learn more about Azure Cosmos DB for Postgres
37:37
come to the Global Meetup user group or check me on Twitter at Tuduki and tweet me
37:43
and I will send links your way as well. Yeah. All right
37:47
So Sarah, that was really exciting. Thank you so much once again, accepting the invitation
37:51
We hope to see you here in India along with Joe. That would be fun. We'll see if we can make that happen
37:56
Yeah. All right, Sarah. Thank you so much once again. And thank you everyone for joining us today and watching us maybe later on
38:01
We'll see you next Thursday, same time, only then take good review yourself and bye-bye
38:05
Bye, take care. Bye, Sarah. See you