Merth nerdsniped me (didn't take very long, fortunately) with this question earlier:
That seemed like a moderately interesting query to construct against our database (see the end of this post for the query), so here are Cemetech's top 10 necroposts:
I'm actually a little surprised by how on-topic these responses are overall, and it's cool to see that people are able to derive value from (and continue to contribute to!) discussions that happened more than 10 years ago on our site.
The SQL query I ran against our database to find these posts:
Code:
This is the sort of thing that I think many people (especially those who aren't so familiar with useful SQL constructs) would write in their programming language of choice by iterating over all post rows, whereas it's an excellent application for window functions (LAG() with partition/ordering) to let the database do all of the work.
Quote:
I wonder if we could query for the biggest necro post.
And by if we could, I actually mean, I wonder if Tari would do that for me 😄
And by if we could, I actually mean, I wonder if Tari would do that for me 😄
That seemed like a moderately interesting query to construct against our database (see the end of this post for the query), so here are Cemetech's top 10 necroposts:
- At number 10, Merth updated his binsprite.html sprite editing tool in late 2024, after the last comments in 2013.
- Domino 464 made the first reply to a review of a Gamecube game in 2016, 11 years after the topic was created.
- Rank 8 goes to Kerm, for a 12-years-later update on the MobileTunes 3 converter tool, reporting on some work I did on it.
- Potatoman1234 commented on an cryptic error code from TI-connect about 11 years after the fact, in what looks like some useful answers to a question that never got a definitive answer.
- Rank 6 goes to darkwater4213 asking for some advice on backing up computers, in a thread that continues to lack any more modern advice (there are others with better advice to today's readers).
- De2290 made a joke about vaporware in relation to a math utillity program from 2006 to claim rank 5.
- Benryves' Nostromo engine has been without any commentary since 2011, but rat_yt took the opportunity in 2023 to ask if it could be made to work on a CE calculator.
- CDI gave us a blast from the past in 2023, showing some work on updating an old TI-BASIC game concept they first posted about in 2010, but this time thinking about targeting it to the Game Boy instead.
- Mcdonalds_lover_32 basically reponded "lol" to a jokes thread in February, breaking 14 years of restful repose.
- The number one most-necro of posts is one of mine! "Pronouncing 'Cemetech'" sat fallow from late 2007 all the way until I reported on my work to improve the pronunciation guide on our site frontpage in early 2024.
I'm actually a little surprised by how on-topic these responses are overall, and it's cool to see that people are able to derive value from (and continue to contribute to!) discussions that happened more than 10 years ago on our site.
The SQL query I ran against our database to find these posts:
Code:
WITH most_necro AS (
SELECT
post_time - LAG(post_time) OVER (PARTITION BY topic_id ORDER BY post_time) AS delta,
post_id
FROM forum_posts
ORDER BY delta DESC
)
SELECT post_id FROM most_necro LIMIT 10;
