数据结构国王挖宝藏_数据浏览器：IT专业人员的隐藏宝藏

数据结构国王挖宝藏

by Adam Arold

亚当·阿罗德(Adam Arold)

数据浏览器：IT专业人员的隐藏宝藏 (Data Explorer: A hidden treasure chest for IT professionals)

Do you ever wonder what technology professionals use in the IT industry? Which tools are trending?

您是否想知道IT专业人员使用什么技术？ 哪些工具正在流行？

There are many resources that you can read to answer these questions, like Google Trends or ITJobswatch.

您可以阅读许多资源来回答这些问题，例如Google Trends或ITJobswatch 。

But what if you want more insight?

但是，如果您想获得更多见识呢？

Enter the Stack Exchange Data Explorer (SEDE), where you can find fine-grained information about all Stack Exchange users.

输入Stack Exchange数据资源管理器 (SEDE)，您可以在其中找到有关所有 Stack Exchange用户的详细信息。

那么什么是Stack Exchange？ (So what is Stack Exchange?)

Launched in 2010, the Stack Exchange network consists of 133 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Stack Exchange网络于2010年启动，由133个问答社区组成，其中包括Stack Overflow，Stack Overflow是最大，最受信任的在线社区，供开发人员学习，共享知识并发展职业。

— from Stack Exchange

—来自Stack Exchange

The SEDE is a meta-site where you can write queries against all publicly available data in any of the Stack Exchange sites. In this article, we’ll be working with the data from Stack Overflow.

SEDE是一个元站点，您可以在其中对任何Stack Exchange站点中的所有公共可用数据编写查询。 在本文中，我们将使用Stack Overflow中的数据。

为什么这对我有用？ (Why is this useful to me?)

If you look at the queries posted on data.stackexchange.com, you can see many questions. Most are related to Stack Overflow, for example:

如果您查看data.stackexchange.com上发布的查询 ，则会看到很多问题。 大多数与堆栈溢出有关，例如：

“How many up-votes do I have for each tag?”

“每个标签我有多少票？”

“Jon Skeet comparison.”

“乔恩·斯基特的比较。”

These don’t seem to be useful out of the context of the site itself, but you can define your own queries by navigating to the compose query page.

从站点本身的上下文来看，这些似乎没有用，但是您可以通过导航到撰写查询页面来定义自己的查询。

一个实际的例子 (A practical example)

Let’s say that you just moved to city x , and you want to connect with people in that area who are using the same technology that you are. Stack Overflow group users who are enthusiastic about their craft, so let’s write a query that will help us find them.

假设您刚搬到城市x ，并且想与该地区的人们使用与您相同的技术进行交流。 热衷于手艺的Stack Overflow组用户，所以让我们编写一个查询来帮助我们找到他们。

Note that Data Explorer comes with a tutorial that you can check out if you are not familiar with the concepts detailed here.

请注意，Data Explorer附带了一个教程 ，如果您不熟悉这里详细介绍的概念，则可以签出 。

If you navigate to the compose query page, you’ll be presented with something like this:

如果导航到撰写查询页面，将显示以下内容：

Here you can write SQL queries against the Stack Overflow database. On the right side of the screen are the tables that you can query. On the left side of the screen, you can write the query.

在这里，您可以针对Stack Overflow数据库编写SQL查询。 屏幕右侧是您可以查询的表。 在屏幕的左侧，您可以编写查询。

So let’s write one:

因此，让我们写一个：

This will show us Stack Overflow users who live in Connecticut. The results will order the users by their reputation. If you don’t want to have to modify a query by hand every time you change the Location, you can add a parameter.

这将向我们显示居住在康涅狄格州的 Stack Overflow用户。 结果将按用户的声誉对其进行排序。 如果您不想在每次更改位置时都必须手动修改查询，则可以添加参数 。

As shown in this query, to refer to a parameter, surround its name with double pound signs:

如该查询所示，要引用参数，请在其名称前后加上双井号：

When you run this, SEDE will ask you to specify a Location. I suggest you use a city name, and only supply more information (for example Connecticut, USA) if there are multiple cities that you want to use.

运行此命令时，SEDE会要求您指定一个位置。 我建议您使用城市名称，并且如果要使用多个城市，请仅提供更多信息(例如美国康涅狄格州)。

Now SEDE comes with another useful feature: it can enter links into the results. To do so, use the syntax [* Link], like this:

现在，SEDE具有另一个有用的功能：它可以在结果中输入链接。 为此，请使用语法[* Link] ，如下所示：

If you do this, you will see that the Id s of the users are now links in their profile page.

如果执行此操作，您现在将在其个人资料页面中看到用户的Id链接。

So far so good.

到目前为止，一切都很好。

But you only want to see users who have provided contact information on their profile, right?

但是，您只想查看在个人资料上提供了联系信息的用户，对吗？

It is easy to add this to our existing query:

很容易将其添加到我们现有的查询中：

We can also apply filters so that we are searching for users who:

我们还可以应用过滤器，以便我们搜索以下用户：

• were active last month
  上个月很活跃
• have already contributed to Stack Overflow
  已经对堆栈溢出做出了贡献
• have their reputation above 1000.
  他们的声誉超过1000。

This is nice, but we have not yet filtered for technology.

很好，但我们尚未筛选技术。

Users on Stack Overflow have Posts, and Posts can have Tags. Let’s add a parameter that will filter for Tags:

Stack Overflow上的用户有帖子，而帖子可以有标签。 让我们添加一个可以过滤Tag的参数：

And that’s it!

就是这样！

Now you can search for:

现在您可以搜索：

• users who live in the city you specified
  您指定城市中的用户
• posts that have the tag you specified
  具有您指定标签的帖子

Here is an example:

这是一个例子：

如果我不想编写SQL怎么办？ (What if I don’t want to write SQL?)

If you are a recruiter, for example, and you don’t want to (or can’t) write SQL but just want quick answers, don’t fret. There is a solution to your problem.

例如，如果您是一名招聘人员，并且不想(或不能)编写SQL而只想快速获得答案，请不要担心。 有解决您的问题的方法。

SEDE comes with an useful search function that provides prepared queries for your searches.

SEDE带有有用的搜索功能，可以为您的搜索提供准备好的查询。

Let’s see what we find if we search for:

让我们看看如果搜索以下内容会发现什么：

• users who live in the city you specified
  您指定城市中的用户
• posts that have the tag you specified
  具有您指定标签的帖子

Most of these do not work outside of the box, so you will have to try them. But you’ll get there.

其中大多数不能在开箱即用的情况下使用，因此您必须尝试一下。 但是你会到达那里。

结论 (Conclusion)

In this article, we explored how SEDE works and how you can extract useful information from it. I encourage you to try it out for yourself.

在本文中，我们探讨了SEDE的工作原理以及如何从中提取有用的信息。 我鼓励您自己尝试一下。

I’m interested to know what you think about SEDE, so please share your insights in the comments section.

我很想知道您对SEDE的看法，因此请在评论部分分享您的见解。

Thanks for reading.

谢谢阅读。

You can read more of my articles on my blog.

您可以在我的博客上阅读更多我的文章。

翻译自: https://www.freecodecamp.org/news/data-explorer-a-hidden-treasure-chest-for-it-professionals-cd85bcf4795a/

数据结构国王挖宝藏