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 another post in the reply_to_post_number field. Whenever any topic (or section of posts from a topic) is retrieved from the server, it contains a sorted array of the post_id’s of every post in the topic. The front end provides access to specific post_numbers via the URL, but when such a URL is actually accessed the request made to the back end is in terms of post_ids (presumably accessed from the above mentioned array). This is all well and good, but it seems like everything post_number is used for could be accomplished with post_id instead: post_id’s are always increasing, so they can be used to determine the relative ordering of posts in a topic. Since they are globally unique they are certainly unique within each topic, and so could be used in a reply_to_post_id that serves the same purpose as reply_to_post_number. TLDR; What purpose does post_number serve that could not be easily accomplished with post_id? If there is none then removing it would streamline the data model, which would seem to be a good thing.

[图片] 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_Wildenradt is arguably much prettier than Why post_number? - #9 by sam or Bootstrap failed with exit code 128 which does not hint properly on the topic.

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 post would become the second post, but its post_number does not change accordingly and is now wrong. Post_id would behave the same way in this scenario, except that it would not wrongfully identify what is now the second post in the thread as the third. [图片] sam: Why post_number? - #3 by Kevin_Wildenradt is arguably much prettier than Why post_number? - #9 by sam Agreed that it is a prettier URL.

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_number 6 before the deletion, and it still is if you look at the JSON representation of this topic Why post_number? I have a running discourse instance without the 24 hour deletion delay, and in my testing there the post_number remains the same after deleting preceding posts.

[图片] 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 ever renumbered links would break which would be terrible. (post number, topic_id) is an alias for (post_id) which is used to keep urls looking just right.

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 identifier? You would have to check that a post with that post_id existed in the thread the reply was being posted in, but you already have to do that with post_number.

[图片] 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 Product Support	10	1133	2019 年7 月 20 日
Whispered replies leak in the post number Product Support whispers	29	2173	2021 年1 月 26 日
From post number to post id Development rest-api	2	1543	2021 年7 月 21 日
Show post numbers Feature	10	1512	2025 年1 月 23 日
Jump to post does not reflect post deletions UX	9	1091	2019 年5 月 29 日

Why post_number?

相关话题