Stackoverflow is dying in 5 years its ded

0

Please login or register to vote for this query.

(click on this box to dismiss)

Android Enthusiasts

Q&A for enthusiasts and power users of the Android operating system

/*
 Less and less people using SO each year since 2015. 
 Less engagement, less accepted answers. The only increase is questions, 
 which is probably a lagging indicator (ie it will drop in 2019). 
 
 2018 a particularly bad year, 
 it might be the tipping point that pushes this over the cliff.
 I'd blame the community ~ really the "moderators" who focussed on 
 rules > people, endless gaming to "show how smartz i haz" 
 and just a lack of usability. 
 
 It's not a friendly site. 
 
 If you think it is friendly - sure. But these are SO's own numbers, so 
 something's going wrong.
 
 If you're wondering why this is so bad - SO makes money from recruitment 
 spending. If there are less people actually engaging with the site, 
 that's less bodies to be sold to corporates. That means their recruitment
 division - their most profitable arena - will struggle going forward to
 hit targets.
 
 (I don't value their Q&A site much, that's something that the good folk
 at Atlassian could nab any day they felt the urge to do so.) 
 
 Their real value is the data they get from users, the same users that 
 they treat like so much cattle. 
 If this trend continues, watch for a "new improved moderator free" or 
 "Moderated by people who are actually friendly" shift.
 
*/

/* 2008 */
SELECT count(*)
FROM Posts
WHERE 
  PostTypeId = 1 AND
  creationdate between '2008-01-01' and '2008-12-31'
  AND AcceptedAnswerid is not NULL
  AND AnswerCount >= 1
  
SELECT count(*)
FROM Posts
WHERE 
  AnswerCount >= 1 AND
  PostTypeId = 1 AND
  DeletionDate IS NULL
  and creationdate between '2008-01-01' and '2008-12-31'

SELECT count(*)
FROM Posts
WHERE 
  PostTypeId = 1 AND
  DeletionDate IS NULL
  and creationdate between '2008-01-01' and '2008-12-31'

/* 2010 */
SELECT count(*)
FROM Posts
WHERE 
  PostTypeId = 1 AND
  creationdate between '2010-01-01' and '2010-12-31'
  AND AcceptedAnswerid is not NULL
  AND AnswerCount >= 1

SELECT count(*)
FROM Posts
WHERE 
  AnswerCount >= 1 AND
  PostTypeId = 1 AND
  DeletionDate IS NULL
  and creationdate between '2010-01-01' and '2010-12-31'

SELECT count(*)
FROM Posts
WHERE 
  PostTypeId = 1 AND
  DeletionDate IS NULL
  and creationdate between '2010-01-01' and '2010-12-31'

/* 2013 */
  
SELECT count(*)
FROM Posts
WHERE 
  PostTypeId = 1 AND
  creationdate between '2013-01-01' and '2013-12-31'
  AND AcceptedAnswerid is not NULL
  AND AnswerCount >= 1

SELECT count(*)
FROM Posts
WHERE 
  AnswerCount >= 1 AND
  PostTypeId = 1 AND
  DeletionDate IS NULL
  and creationdate between '2013-01-01' and '2013-12-31'
  
SELECT count(*)
FROM Posts
WHERE 
  PostTypeId = 1 AND
  DeletionDate IS NULL
  and creationdate between '2013-01-01' and '2013-12-31'

/* 2015 */
SELECT count(*)
FROM Posts
WHERE 
  PostTypeId = 1 AND
  creationdate between '2015-01-01' and '2015-12-31'
  AND AcceptedAnswerid is not NULL
  AND AnswerCount >= 1

SELECT count(*)
FROM Posts
WHERE 
  AnswerCount >= 1 AND
  PostTypeId = 1 AND
  DeletionDate IS NULL
  and creationdate between '2015-01-01' and '2015-12-31'
  
SELECT count(*)
FROM Posts
WHERE 
  PostTypeId = 1 AND
  DeletionDate IS NULL
  and creationdate between '2015-01-01' and '2015-12-31'  

/* 2016 */
SELECT count(*)
FROM Posts
WHERE 
  PostTypeId = 1 AND
  creationdate between '2016-01-01' and '2016-12-31'
  AND AcceptedAnswerid is not NULL
  AND AnswerCount >= 1

SELECT count(*)
FROM Posts
WHERE 
  AnswerCount >= 1 AND
  PostTypeId = 1 AND
  DeletionDate IS NULL
  and creationdate between '2016-01-01' and '2016-12-31'
  
SELECT count(*)
FROM Posts
WHERE 
  PostTypeId = 1 AND
  DeletionDate IS NULL
  and creationdate between '2016-01-01' and '2016-12-31'  


/* 2017 */  
SELECT count(*)
FROM Posts
WHERE 
  PostTypeId = 1 AND
  creationdate between '2017-01-01' and '2017-12-31'
  AND AcceptedAnswerid is not NULL
  AND AnswerCount >= 1

SELECT count(*)
FROM Posts
WHERE 
  AnswerCount >= 1 AND
  PostTypeId = 1 AND
  DeletionDate IS NULL
  and creationdate between '2017-01-01' and '2017-12-31'
  
SELECT count(*)
FROM Posts
WHERE 
  PostTypeId = 1 AND
  DeletionDate IS NULL
  and creationdate between '2017-01-01' and '2017-12-31'
  
/* 2018 */  
SELECT count(*)
FROM Posts
WHERE 
  PostTypeId = 1 AND
  creationdate between '2018-01-01' and '2018-12-31'
  AND AcceptedAnswerid is not NULL
  AND AnswerCount >= 1

SELECT count(*)
FROM Posts
WHERE 
  AnswerCount >= 1 AND
  PostTypeId = 1 AND
  DeletionDate IS NULL
  and creationdate between '2018-01-01' and '2018-12-31'
  

SELECT count(*)
FROM Posts
WHERE 
  PostTypeId = 1 AND
  DeletionDate IS NULL
  and creationdate between '2018-01-01' and '2018-12-31'

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results