10
votes
Accepted
How can a User's CreationDate be after they have posted?
There are two viable explanations that I know of:
Long ago, we sometimes allowed merges of profiles going from an older profile into a newer profile. The merge process always keeps the CreationDate ...
- 190k
8
votes
Accepted
How does SO store revisions?
No, it does not store diffs. The complete source of each version is simply kept for each revision.
Although the exact implementation might differ we can peek at the database schema for SEDE and the ...
reneMod
- 92.1k
5
votes
Accepted
Does Stack Exchange use event sourcing?
That timeline is pretty much this:
Select stuff from Comments
Union
Select stuff from Posts
Union
Select stuff from PostHistory
Union
Select stuff from Votes
Union
Select stuff from ReviewTaskResults
...
- 454k
4
votes
How does a post end up in the review queue?
What kinds of posts get to the review table? (Ex. Questions, answers,..)
Yes, questions and answers. Tag wikis and tag wiki excerpts too. Depends on the queue.
What is the qualifying factor?
...
- 155k
3
votes
How does Stack Overflow find 'Linked' questions?
They are certainly stored in the database, and available in SEDE in the PostLinks table (for details, see the schema documentation).
When something happens to a question (like it's edited, or a ...
GlorfindelMod
- 256k
Only top scored, non community-wiki answers of a minimum length are eligible