I’ve noticed that all posts bear both a post_id and a post_number. I understand that post_id is the unique identifier of the post in the entire forum, while post_number is the number of the post in its topic. Posts identify themselves as replies to other posts by referencing the post_number of anoth…

[图片] Kevin_Wildenradt: TLDR; What purpose does post_number serve that could not be easily accomplished with post_id? This allows Why post_number? - #3 by Kevin_Wildenradt to continue to work efficiently even if Why post_number? - #2 by sam is deleted. And Why post_number? - #3 by Kevin_Wilde…

Thanks for getting back to me so quickly Sam :smile: [图片] sam: This allows Why post_number? - #3 by Kevin_Wildenradt to continue to work efficiently even if Why post_number? - #2 by sam is deleted. How would post_id not work for this scenario? It would seem that if 2 is deleted, the third po…

And if post 2 is later undeleted after post 3 takes its place, does it then become post 1 1/2 ?

@Mittineague I do not believe that post_number is ever updated, even in the event of post deletions. If it were updated then deleting a post would result in every link to every post after that post being broken. I have just deleted the post immediately before this, post_number 5. This was post_numb…

[图片] Kevin_Wildenradt: How would post_id not work for this scenario? It would seem that if 2 is deleted, the third post would become the second post, but its post_number does not change accordingly and is now wrong. The post number is correct now, cause external links continue to work. If we …

That makes sense, but why is reply_to_post_number used to identify which post a post is a reply to? If post_number only exists to make URL’s look prettier, why is it the identifier that replies depend on? Wouldn’t it be more consistent to make replies depend on post_id, a much more fundamental ident…

[图片] Kevin_Wildenradt: why is it the identifier that replies depend on? Wouldn’t it be more consistent to make replies depend on post_id, a much more fundamental identifier? Yeah, this is a historic artefact we may get to cleaning it up at some point.

Why post_number?

Development

sam (Sam Saffron) 2016 年11 月 11 日 22:59 9

Yeah, this is a historic artefact we may get to cleaning it up at some point.

话题		回复	浏览量
Post number on slider disagrees with post Support	10	1075	2019 年7 月 20 日
Whispered replies leak in the post number Support whispers	29	2130	2021 年1 月 26 日
From post number to post id Development rest-api	2	1515	2021 年7 月 21 日
Show post numbers Feature	10	1500	2025 年1 月 23 日
Jump to post does not reflect post deletions UX	9	1074	2019 年5 月 29 日

Why post_number?

相关话题