In case someone wants possibly the longest thread on the fediverse for testing purposes, here you go: https://mastodon.social/@brownpau/112322747861701800With the way I store replies in #Smithereen, this will soon exceed my limit of 256 levels ¯\_(ツ)_/¯
-
In case someone wants possibly the longest thread on the fediverse for testing purposes, here you go: https://mastodon.social/@brownpau/112322747861701800
With the way I store replies in #Smithereen, this will soon exceed my limit of 256 levels ¯\_(ツ)_/¯ -
Gregoryreplied to Gregory on last edited by [email protected]
What will happen when this limit is exceeded? The "reply key" field will get truncated. It's 1024 bytes and stores the IDs of all parent posts as 32-bit integers, always starting from the top-level one. So essentially, all further replies will be erroneously considered replying to the 256th reply in the thread.
Now I don't think this is a problem in any real-world use cases, but yikes
-
I was sent another, longer thread, and yay it broke
-
Александр :straightally:replied to Gregory on last edited by
> 1024 bytes and stores the IDs of all parent posts as 32-bit integers, always starting from the top-level one.
THAT'S yikes.Is there any reason to store first post after 256/8/2 replies?
-
Gregoryreplied to Александр :straightally: on last edited by
@saiv46 yes, because I need to be able to select reply subtrees from any level