-12

I've noticed something peculiar in the Stack Overflow public data lately. The vibrant community that once generated tens of thousands of questions and views per month has apparently decided to collectively take a vacation.

According to my AI-generated query, the number of questions and views has dropped to nearly zero. I ran this query:

SELECT
  DATEADD(month, DATEDIFF(month, 0, CreationDate), 0) AS MonthStart,
  CONVERT(varchar(7), CreationDate, 120)            AS YearMonth, -- YYYY-MM
  SUM(CAST(ViewCount AS bigint))                    AS TotalNumberOfViews,
  COUNT(*)                                          AS QuestionCount
FROM Posts
WHERE PostTypeId = 1 -- questions
GROUP BY DATEADD(month, DATEDIFF(month, 0, CreationDate), 0), CONVERT(varchar(7), CreationDate, 120)
ORDER BY MonthStart;

Did all programmers simultaneously retire? Is there a new programming language that doesn't require asking questions?

Perhaps everyone finally learned how to code without errors? That seems unlikely, but the data doesn't lie.

I'm wondering if anyone else has noticed this phenomenon or if there's some explanation for why Stack Overflow has apparently become the digital equivalent of a deserted island.

Query Result

New contributor
zs2020 is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct.
2
  • 17
    Your AI made a bad job. The view count is aggregated over the whole lifetime of a question. Your query makes it seem as if the views for a question happen all at the creation date, which is wrong. The true picture is different and the first graph is not useful. Didn't the AI tell you this? Regarding the second graph: it's widely known and discussed and heavily cited. It probably doesn't give the complete picture but it's a hint. Just read some of these discussions to get possible interpretations. Commented Jan 26 at 12:01
  • 1
    Me, I blame the commies. Commented Jan 26 at 18:57

0

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.