Stack Overflow 的论坛已经衰落，但公司仍在运转

# Stack Overflow 论坛因 AI 而消亡，但公司仍在运转……同样归功于 AI – Sherwood News（以及 SEDE – Stack Exchange Data Explorer 上的几个链接） 来源：https://wiert.me/2026/05/26/stack-overflows-forum-is-dead-thanks-to-ai-but-the-companys-still-kicking-thanks-to-ai-sherwood-news/ 有趣的文章：[Wayback (https://web.archive.org/web/20260115160923/https://sherwood.news/tech/stack-overflow-forum-dead-thanks-ai-but-companys-still-kicking-ai/)/Archive (https://archive.is/2026.01.08-214223/https://sherwood.news/tech/stack-overflow-forum-dead-thanks-ai-but-companys-still-kicking-ai/)]Stack Overflow 论坛因 AI 而消亡，但公司仍在运转……同样归功于 AI – Sherwood News (https://sherwood.news/tech/stack-overflow-forum-dead-thanks-ai-but-companys-still-kicking-ai/)\. 其中有一段重要引文： > 复杂的问题仍然会在 Stack 上被提出，因为没有其他地方可去。如果 LLM 的质量取决于数据（通常是人类策划的），那么我们是这方面最好的地方之一，如果不是技术领域最好的话。 我想知道它现在衰退到了什么程度，并且认为以下也是衰退的原因： - 每个主题的许多基本问题已经被问过了 - 过去十年很少有新的编程语言流行起来（我认为 Go 语言是最后一个主要的） - GitHub 上的讨论（GitLab 上较少）已经分流了大量流量 - 主要是在 Stack overflow 和我在《对“什么是驱动硬件的软件解决方案问题的好替代 Stack Overflow 方案？ – Meta Stack Overflow”的毒性反应》中提到的元站点上的毒性行为 无论如何，那篇文章中的图表只是你在 SEDE (Stack Exchange Data Explorer) 上自行创建查询的炫酷版本。这就是为什么我把两者都放在下面。 >  图表：Stack Overflow 论坛的衰落在几年前就已开始，但 AI 彻底摧毁了这个平台；横轴：年份；纵轴：每月提问数量（包括已删除问题）；从 2008-24 年上升，在 2021/2022 年新冠疫情期间达到峰值，从 2024 年 ChatGPT 推出后开始下降 如果你也像我一样，你可能还想看其他指标，比如回答和评论：它们是否也在下降？如果是，下降速率是否相同？以及随着时间推移，回答与问题的比例、评论与问题和回答的比例如何变化？ ### 自行生成类似的图表 如果你想重新生成一个非常相似的图表，请查看查询 [Archive (https://archive.is/2026.01.15-175821/https://data.stackexchange.com/stackoverflow/revision/1932522/2374035/questions-per-month-including-deleted)]每月提问数量（包括已删除问题） – Stack Exchange Data Explorer (https://data.stackexchange.com/stackoverflow/revision/1932522/2374035/questions-per-month-including-deleted) > `` SELECT DATEFROMPARTS(YEAR(CreationDate), MONTH(CreationDate), 1) AS [Month], COUNT(*) AS [Questions] FROM PostsWithDeleted WHERE PostTypeId = 1 GROUP BY DATEFROMPARTS(YEAR(CreationDate), MONTH(CreationDate), 1) ORDER BY [Month] ASC `` 这是我经过快速搜索后的起点，也是下面所有查询的基础。 上述查询生成了这张图表：[Archive (https://archive.is/2026.01.15-165347/https://data.stackexchange.com/stackoverflow/revision/1932522/2374035/questions-per-month-including-deleted%23graph)]每月提问数量（包括已删除问题） – Stack Exchange Data Explorer (图表) (https://data.stackexchange.com/stackoverflow/revision/1932522/2374035/questions-per-month-including-deleted#graph) > [Wayback (https://web.archive.org/web/20260115180251/https://private-user-images.githubusercontent.com/2033367/536362203-4db75341-a0c7-4b64-a6ec-e67f80575005.png?jwt=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3Njg1MDA0NTMsIm5iZiI6MTc2ODUwMDE1MywicGF0aCI6Ii8yMDMzMzY3LzUzNjM2MjIwMy00ZGI3NTM0MS1hMGM3LTRiNjQtYTZlYy1lNjdmODA1NzUwMDUucG5nP1gtQW16LUFsZ29yaXRobT1BV1M0LUhNQUMtU0hBMjU2JlgtQW16LUNyZWRlbnRpYWw9QUtJQVZDT0RZTFNBNTNQUUs0WkElMkYyMDI2MDExNSUyRnVzLWVhc3QtMSUyRnMzJTJGYXdzNF9yZXF1ZXN0JlgtQW16LURhdGU9MjAyNjAxMTVUMTgwMjMzWiZYLUFtei1FeHBpcmVzPTMwMCZYLUFtei1TaWduYXR1cmU9YTFkMGYxZWVlMTk3OWIyZDE1Y2FhYmMwNmZlODJhM2ZhOTY5NDc0NzI1ZGRlZWE1MzNlMTQ2Y2JhNWQ4N2Y2YiZYLUFtei1TaWduZWRIZWFkZXJzPWhvc3QifQ.4bOZP0e_zWrUHxKt04gsvwC8kl7ktKDdRpJAdmyp90c)/Archive (https://archive.is/2026.01.15-180250/https://private-user-images.githubusercontent.com/2033367/536362203-4db75341-a0c7-4b64-a6ec-e67f80575005.png?jwt=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3Njg1MDA0NTMsIm5iZiI6MTc2ODUwMDE1MywicGF0aCI6Ii8yMDMzMzY3LzUzNjM2MjIwMy00ZGI3NTM0MS1hMGM3LTRiNjQtYTZlYy1lNjdmODA1NzUwMDUucG5nP1gtQW16LUFsZ29yaXRobT1BV1M0LUhNQUMtU0hBMjU2JlgtQW16LUNyZWRlbnRpYWw9QUtJQVZDT0RZTFNBNTNQUUs0WkElMkYyMDI2MDExNSUyRnVzLWVhc3QtMSUyRnMzJTJGYXdzNF9yZXF1ZXN0JlgtQW16LURhdGU9MjAyNjAxMTVUMTgwMjMzWiZYLUFtei1FeHBpcmVzPTMwMCZYLUFtei1TaWduYXR1cmU9YTFkMGYxZWVlMTk3OWIyZDE1Y2FhYmMwNmZlODJhM2ZhOTY5NDc0NzI1ZGRlZWE1MzNlMTQ2Y2JhNWQ4N2Y2YiZYLUFtei1TaWduZWRIZWFkZXJzPWhvc3QifQ.4bOZP0e_zWrUHxKt04gsvwC8kl7ktKDdRpJAdmyp90c)]536362203-4db75341-a0c7-4b64-a6ec-e67f80575005.png (1003×535) (https://private-user-images.githubusercontent.com/2033367/536362203-4db75341-a0c7-4b64-a6ec-e67f80575005.png?jwt=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3Njg1MDA0NTMsIm5iZiI6MTc2ODUwMDE1MywicGF0aCI6Ii8yMDMzMzY3LzUzNjM2MjIwMy00ZGI3NTM0MS1hMGM3LTRiNjQtYTZlYy1lNjdmODA1NzUwMDUucG5nP1gtQW16LUFsZ29yaXRobT1BV1M0LUhNQUMtU0hBMjU2JlgtQW16LUNyZWRlbnRpYWw9QUtJQVZDT0RZTFNBNTNQUUs0WkElMkYyMDI2MDExNSUyRnVzLWVhc3QtMSUyRnMzJTJGYXdzNF9yZXF1ZXN0JlgtQW16LURhdGU9MjAyNjAxMTVUMTgwMjMzWiZYLUFtei1FeHBpcmVzPTMwMCZYLUFtei1TaWduYXR1cmU9YTFkMGYxZWVlMTk3OWIyZDE1Y2FhYmMwNmZlODJhM2ZhOTY5NDc0NzI1ZGRlZWE1MzNlMTQ2Y2JhNWQ4N2Y2YiZYLUFtei1TaWduZWRIZWFkZXJzPWhvc3QifQ.4bOZP0e_zWrUHxKt04gsvwC8kl7ktKDdRpJAdmyp90c) ### 每月回答数量（包括已删除问题） 这是一张与上面类似的图表，但现在显示的是回答数量，而不是从上述问题查询中派生的问题数量：每月回答数量（包括已删除问题） – Stack Exchange Data Explorer (https://data.stackexchange.com/stackoverflow/query/1933385/answers-per-month-including-deleted)： > [Wayback (https://web.archive.org/web/20260118120041/https://private-user-images.githubusercontent.com/2033367/537280204-e8929110-74f7-4fd5-a327-aaf32d270914.png?jwt=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3Njg3Mzc5MjQsIm5iZiI6MTc2ODczNzYyNCwicGF0aCI6Ii8yMDMzMzY3LzUzNzI4MDIwNC1lODkyOTExMC03NGY3LTRmZDUtYTMyNy1hYWYzMmQyNzA5MTQucG5nP1gtQW16LUFsZ29yaXRobT1BV1M0LUhNQUMtU0hBMjU2JlgtQW16LUNyZWRlbnRpYWw9QUtJQVZDT0RZTFNBNTNQUUs0WkElMkYyMDI2MDExOCUyRnVzLWVhc3QtMSUyRnMzJTJGYXdzNF9yZXF1ZXN0JlgtQW16LURhdGU9MjAyNjAxMThUMTIwMDI0WiZYLUFtei1FeHBpcmVzPTMwMCZYLUFtei1TaWduYXR1cmU9YWM4ZTI0YTU1Yjk5ZjZlM2I4OGY3ZDdiNjRlODg3NTYxYWJjY2YzMmE4MDEwZGEwYzgyNWYzYTFkYmUwNjU4MCZYLUFtei1TaWduZWRIZWFkZXJzPWhvc3QifQ.D5x-xHmhCq96Qhbdec8b0hIySr-B7F1wf6FPIXv_qAk)/Archive (https://archive.is/2026.01.18-120042/https://private-user-images.githubusercontent.com/2033367/537280204-e8929110-74f7-4fd5-a327-aaf32d270914.png?jwt=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3Njg3Mzc5MjQsIm5iZiI6MTc2ODczNzYyNCwicGF0aCI6Ii8yMDMzMzY3LzUzNzI4MDIwNC1lODkyOTExMC03NGY3LTRmZDUtYTMyNy1hYWYzMmQyNzA5MTQucG5nP1gtQW16LUFsZ29yaXRobT1BV1M0LUhNQUMtU0hBMjU2JlgtQW16LUNyZWRlbnRpYWw9QUtJQVZDT0RZTFNBNTNQUUs0WkElMkYyMDI2MDExOCUyRnVzLWVhc3QtMSUyRnMzJTJGYXdzNF9yZXF1ZXN0JlgtQW16LURhdGU9MjAyNjAxMThUMTIwMDI0WiZYLUFtei1FeHBpcmVzPTMwMCZYLUFtei1TaWduYXR1cmU9YWM4ZTI0YTU1Yjk5ZjZlM2I4OGY3ZDdiNjRlODg3NTYxYWJjY2YzMmE4MDEwZGEwYzgyNWYzYTFkYmUwNjU4MCZYLUFtei1TaWduZWRIZWFkZXJzPWhvc3QifQ.D5x-xHmhCq96Qhbdec8b0hIySr-B7F1wf6FPIXv_qAk)]537280204-e8929110-74f7-4fd5-a327-aaf32d270914.png (983×566) (https://private-user-images.githubusercontent.com/2033367/537280204-e8929110-74f7-4fd5-a327-aaf32d270914.png?jwt=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3Njg3Mzc5MjQsIm5iZiI6MTc2ODczNzYyNCwicGF0aCI6Ii8yMDMzMzY3LzUzNzI4MDIwNC1lODkyOTExMC03NGY3LTRmZDUtYTMyNy1hYWYzMmQyNzA5MTQucG5nP1gtQW16LUFsZ29yaXRobT1BV1M0LUhNQUMtU0hBMjU2JlgtQW16LUNyZWRlbnRpYWw9QUtJQVZDT0RZTFNBNTNQUUs0WkElMkYyMDI2MDExOCUyRnVzLWVhc3QtMSUyRnMzJTJGYXdzNF9yZXF1ZXN0JlgtQW16LURhdGU9MjAyNjAxMThUMTIwMDI0WiZYLUFtei1FeHBpcmVzPTMwMCZYLUFtei1TaWduYXR1cmU9YWM4ZTI0YTU1Yjk5ZjZlM2I4OGY3ZDdiNjRlODg3NTYxYWJjY2YzMmE4MDEwZGEwYzgyNWYzYTFkYmUwNjU4MCZYLUFtei1TaWduZWRIZWFkZXJzPWhvc3QifQ.D5x-xHmhCq96Qhbdec8b0hIySr-B7F1wf6FPIXv_qAk) 查询只在两个地方有所不同：`count(*)` 别名和 `PostTypeId` 值。 > `` SELECT DATEFROMPARTS(YEAR(CreationDate), MONTH(CreationDate), 1) AS [Month], COUNT(*) AS [Answers] FROM PostsWithDeleted WHERE PostTypeId = 2 GROUP BY DATEFROMPARTS(YEAR(CreationDate), MONTH(CreationDate), 1) ORDER BY [Month] ASC `` 这让我开始追求得到这张图表： ### 组合所有帖子类型的综合图表 为此，我需要聚合各种帖子类型（问题、回答）并按月份分组。这比上面的 `Count(*) where PostTypeId=#` 查询稍微复杂一些。 所以我做了一些研究，但结果……并非来自 Stack Exchange 网络（： 我开始寻找交易类型和月份，因为我知道这是数据库中的常见场景。Google 搜索 (https://en.wikipedia.org/wiki/Google_Search) 返回了相关结果，但 Duck Duck Go (https://en.wikipedia.org/wiki/DuckDuckGo) 没有。 - [WaybackFailed (https://web.archive.org/web/20260118110841/https://www.google.com/search?q=sql+count+transaction+types+group+by+month)/ArchiveSave (https://archive.is/?run=1&url=https://www.google.com/search?q=sql+count+transaction+types+group+by+month)] (无法存档) sql count transaction types group by month – Google Search (https://www.google.com/search?q=sql+count+transaction+types+group+by+month) - [Wayback (https://web.archive.org/web/20260118110820/https://html.duckduckgo.com/html?q=sql+count+transaction+types+group+by+month)/Archive (https://archive.is/2026.01.18-110846/https://html.duckduckgo.com/html?q=sql+count+transaction+types+group+by+month)] sql count transaction types group by month at DuckDuckGo (https://html.duckduckgo.com/html?q=sql+count+transaction+types+group+by+month) 没有好的结果 - [Wayback (https://web.archive.org/web/20210228075240/https://p2p.wrox.com/sql-server-2000/49092-sql-query-generate-counts-month.html)/Archive (https://archive.is/2026.01.18-110010/https://p2p.wrox.com/sql-server-2000/49092-sql-query-generate-counts-month.html)] sql query to generate counts by month (https://p2p.wrox.com/sql-server-2000/49092-sql-query-generate-counts-month.html) (由于 #ThisIsWhyWeCantHaveNiceThings 和 JavaScript 及 URL 重写，Wayback Machine 没有更近期的存档) > 你可以使用 “GROUPING” （下面未包含）来做一些事情，使小计和总计更明显，但考虑到你没有发布模式或数据，以下内容应该能让你入门，只需根据需要对表和列名进行适当替换... `SELECT d.Company,` `d.[Year],` `SUM(CASE WHEN [Month] = 01 THEN Transactions ELSE 0 END) AS Jan,` `SUM(CASE WHEN [Month] = 02 THEN Transactions ELSE 0 END) AS Feb,` `SUM(CASE WHEN [Month] = 03 THEN Transactions ELSE 0 END) AS Mar,` `SUM(CASE WHEN [Month] = 04 THEN Transactions ELSE 0 END) AS Apr,` `SUM(CASE WHEN [Month] = 05 THEN Transactions ELSE 0 END) AS May,` `SUM(CASE WHEN [Month] = 06 THEN Transactions ELSE 0 END) AS Jun,` `SUM(CASE WHEN [Month] = 07 THEN Transactions ELSE 0 END) AS Jul,` `SUM(CASE WHEN [Month] = 08 THEN Transactions ELSE 0 END) AS Aug,` `SUM(CASE WHEN [Month] = 09 THEN Transactions ELSE 0 END) AS Sep,` `SUM(CASE WHEN [Month] = 10 THEN Transactions ELSE 0 END) AS Oct,` `SUM(CASE WHEN [Month] = 11 THEN Transactions ELSE 0 END) AS Nov,` `SUM(CASE WHEN [Month] = 12 THEN Transactions ELSE 0 END) AS [Dec],` `SUM(Transactions) AS Total,` `SUM(Transactions)/24 AS Average` `FROM (--派生表 "d" 查找年份和月份的计数` `SELECT Company,` `[Year] = DATEPART(yy,TransactionDate),` `[Month] = DATEPART(mm,TransactionDate)` `Transactions = COUNT(*)` `FROM yourtable` `GROUP BY Company,` `DATEPART(yy,TransactionDate),` `DATEPART(mm,TransactionDate)` `) d` `GROUP BY d.Company,` `d.[Year]` `WITH ROLLUP` `ORDER BY d.Company,` `d.[Year]` ...并且，在适当索引的环境中，可以在很短的时间内处理数百万行（例如，400 万行大约 5-7 秒）。 – Jeff Moden - [Wayback (https://web.archive.org/web/20260118105934/https://datasciencewallah.medium.com/how-to-summarize-monthly-transactions-by-country-in-sql-step-by-step-guide-977b0dcb77ff)/Archive (https://archive.is/2026.01.18-110803/https://datasciencewallah.medium.com/how-to-summarize-monthly-transactions-by-country-in-sql-step-by-step-guide-977b0dcb77ff)] 如何用 SQL 按国家汇总每月交易 | 分步指南 | 作者：Data Science Wallah | Medium (https://datasciencewallah.medium.com/how-to-summarize-monthly-transactions-by-country-in-sql-step-by-step-guide-977b0dcb77ff) > 在本教程中，我们将解决 LeetCode 的 SQL 问题 **“Monthly Transactions I”** 。这个问题将测试你按日期和国家分组数据，以及根据特定条件过滤和聚合交易数据的能力。这是一个练习 SQL 聚合函数如 `COUNT()`、`SUM()` 和 `GROUP BY` 的绝佳问题。... 以下是解决问题的完整 SQL 查询： `` SELECT DATE_FORMAT(trans_date, '%Y-%m') AS month, country, COUNT(*) AS trans_count, SUM(CASE WHEN state = 'approved' THEN 1 ELSE 0 END) AS approved_count, SUM(amount) AS trans_total_amount, SUM(CASE WHEN state = 'approved' THEN amount ELSE 0 END) AS approved_total_amount FROM Transactions GROUP BY DATE_FORMAT(trans_date, '%Y-%m'), country; `` 使用的技巧/所需知识： - 结合 `SUM` 和 `CASE WHEN` 来计数相关值，因为没有 `COUNT(WHEN ...)` - `GROUP BY` 不能使用 `SELECT` 部分的别名 为了获得各种 PostType 的计数，我们需要添加一列，对每个 PostType 值进行计数。 `PostTypes` 如下（感谢 [Wayback (https://web.archive.org/web/20250813192032/https://data.stackexchange.com/stackoverflow/query/36599/show-all-types)/Archive (https://archive.is/2025.08.13-192032/https://data.stackexchange.com/stackoverflow/query/36599/show-all-types)] 显示所有类型 – Stack Exchange Data Explorer (https://data.stackexchange.com/stackoverflow/query/36599/show-all-types)，更多信息见下文）： > `` Id PostType ---- ------------------- 1 Question 2 Answer 3 Wiki 4 TagWikiExcerpt 5 TagWiki 6 ModeratorNomination 7 WikiPlaceholder 8 PrivilegeWiki `` 由此产生了以下查询：每月问题、回答及其他帖子类型（包括已删除） – Stack Exchange Data Explorer (https://data.stackexchange.com/stackoverflow/revision/1933447/2375006/questions-answers-and-other-post-types-per-month-including-deleted) (3 秒) > `` SELECT DATEFROMPARTS(YEAR(CreationDa