Most Popular Cloud Platforms
We are well aware of how rapidly the cloud platforms are growing! With more service offerings being announced each day, companies in every industry are convinced to move to the cloud eventually. From personal experience I can say that migration to the cloud platform is hot right now!
There are numerous cloud platforms that provide both IaaS and SaaS. The three big names that make up for over 54% of the market are AWS, Microsoft and Google. I was curious to see how many people are using the different services offered by them.
I went ahead and analyzed Stack Overflow data over the last 10 years to find some interesting results. All the queries were executed on Stack Overflow’s open tool – Data Explorer which runs off the Stack Exchange data.
Comparing Tags for top cloud platforms
For starters, taking a look at the most commonly used tags will help understand how the questions are spread across the 3 platforms.
Heres taking a look at the top 10 tags across AWS, Azure and Google Cloud Platform.
SELECT TOP 10 t.tagname as [cloud tags], t.Count as [tag count] FROM Tags t INNER JOIN Posts p ON p.id=t.wikipostid AND (t.tagname LIKE 'azure%' OR t.tagname LIKE 'google-cloud%' OR t.tagname LIKE 'aws%' OR t.tagname LIKE 'amazon%') ORDER BY 2 DESC;
The number of posts with the tag Azure well exceeds the other tags. This is a very generic tag, does not really specify what service is most used. We will go in deeper with the next query.
But looking at the big picture, there are definitely more tags for posts based on AWS. AWS has about 56% more posts as compared to Azure and 80% more questions compared to Google Cloud. This is only adding to the statistics that AWS continues to be the leader.
To get a better understanding of the individual players, let’s take a look at the popular tags being used within each platform.
Top 10 Tags
Top 10 tags for AWS questions
SELECT TOP 10 t.tagname as [aws tag], t.count as [tag count] FROM Tags t WHERE (t.tagname like 'aws%' or t.tagname like 'amazon%') ORDER BY 2 DESC;
Given S3 being one of the first services offered by Amazon, it still is the most used service.
Dynamodb, Lambda and Redshift are definitely gaining popularity.
Top 10 tags for GCP questions
SELECT TOP 10 t.tagname as [google tag], t.count as [tag count] FROM Tags t WHERE (t.tagname like 'google-cloud%') ORDER BY 2 DESC;
Data storage solutions seems to be most used, irrespective of the cloud platform.
Top 10 tags for Azure questions
SELECT TOP 10 t.tagname as [azure tag], t.count as [tag count] FROM Tags t WHERE (t.tagname like 'azure%') ORDER BY 2 DESC;
Looking at all the tags and the number of times they are used, Storage solutions and database services are the most popular ones in all 3 of the platforms.
Looking at the databases SQL and NoSQL alike, both seem to have almost equal number of posts.
Most Viewed Questions
Taking a look at the questions that have the maximum number of views
SELECT TOP 10 id as [Post Link], viewcount, tags FROM Posts WHERE id in ( SELECT PostId FROM PostTags WHERE TagId in ( SELECT Id FROM Tags WHERE (tagname like 'azure%' or tagname like 'google-cloud%' or tagname like 'aws%' or tagname like 'amazon%') ) ) ORDER BY 2 DESC;
Looking at the list of questions and the number of views they have, questions about Azure seem to be on top.
The most popular questions seems to have around 900K views.
In the AWS section, most questions are related to EC2 instances and S3 buckets. Understanding that EC2 instances being the base for various other services like RDS, DynamoDB etc.
Considering SQL Server has been around for a while, the 55K Azure SQL Database posts is justified.
Stack Overflow is one of the top places to look for technical remedies, so querying their database gives a fairly good idea of cloud platform usage distribution.
The results we found from above are in line with popularity and number of services each of the top three cloud platforms provide. So, we see that AWS is still the number one player followed by Azure and Google respectfully.