RoundSparrow

joined 2 years ago
MODERATOR OF
[–] RoundSparrow@lemmy.ml 3 points 2 years ago* (last edited 2 years ago)

I've been studying the underlying PostgreSQL content of path and how child_count gets done the last few days...

First off, is this consistent - as there are some questions about deleted comments, removed comments, personal blocking of users who create comments, banned from community person who created comments, etc. Your API with curl doesn't have an auth on it, so personal blocking shouldn't be a factor (not logged in).

max_depth=999 limit=999

I'm not sure how lemmy_server behaves when ranges are out of bounds here. limit on comments is 300 hard-coded in the Rust code AFAIK, and max_depth like around 15.

I think child_count is intended to mean all generations of children, not "direct replies to this comment" count. In your example:

  "path": "0.2157873.2158260",
  "id": 2158260,
  "content": "You just post questions as top-level replies to the stickied thread that day, and we'll be online to answer them.",
  "child_count": 6

The child_count looks correct, hand-counting I get 6 that are all originating off of 2158260.

  "path": "0.2157873.2158260.2229041.2231423",
  "id": 2231423,
  "content": "As the post mentions, it will be stickied to the top of lemmy.ml ",
  "child_count": 2

Also looks correct, I see a child and a grandchild, totaling 2 comments in the way I understand they intend to count.

  "path": "0.2157873",
  "id": 2157873,
  "content": "Really cool! I'm excited to learn more about you and the project!\n\nWhat's the format? Should we submit questions beforehand, or will you process questions that arrive at the start time? I've never participated in an AMA  😅 ",
  "child_count": 9

I would expect 7 given what you show. Are 2 reply comments deleted, removed?

I do KNOW that in version 0.18.4 - the SQL that updates comment_aggregates child_count does NOT look at deleted or removed. It suspect it always counts them as children, even if you as a non-moderator, non-administrator can not fetch them. The fetch policy has changed in 0.18.x releases, it used to be you could indeed load deleted comments and even see their content.

As I said first off, is this consistent? Can we find a 9-count comment tree that has all 9 where there are no delete or remove at play.

[–] RoundSparrow@lemmy.ml 9 points 2 years ago (6 children)

Is your intention to have local copies of content from popular servers and read it locally? Major communities like news., memes, etc?

Many people seem to think this is offloading the major servers like lemmy.world - but I think the opposite is true in my measures of how lemmy_server performs. There is a lot of overhead to each additional instance in Lemmy 0.18.3 backend. Lemmy code does a lot of work to keep each of these subscribing servers updated with every post, comment, vote, person - attempted in real-time.

[–] RoundSparrow@lemmy.ml 6 points 2 years ago* (last edited 2 years ago)

Keep in mind with 0.18.3 there is a new "dead server" check that cuts off communication that won't show up on the block list. There have been reports in !fediverse@lemmy.ml recently that this has caused some issues. notable posting: https://lemmy.ca/post/2626714

[–] RoundSparrow@lemmy.ml 2 points 2 years ago

Storage was still pretty expensive, and there we transitions in computing from originally paper terminals to screen and people didn't have a sense of long-term retention of personal messages (I guess many people probably felt that way about SMS messages on mobile). There also wasn't really a way to look at a user's "profile" like you have on Lemmy - to see everything you post in any topic - which a search-engine provided a way to search for your name across a time period.

[–] RoundSparrow@lemmy.ml 7 points 2 years ago (3 children)

BE: 0.18.0

that isn't that long ago, as in July 1 Reddit API app deadline

[–] RoundSparrow@lemmy.ml 8 points 2 years ago (2 children)

sdfasdf

Wait... Did they CASH IN? Sell out?: Odorono?

[–] RoundSparrow@lemmy.ml 4 points 2 years ago (3 children)
[–] RoundSparrow@lemmy.ml 14 points 2 years ago* (last edited 2 years ago) (4 children)

!sdfasdf isn’t a community?

EDIT: we did it Lemmy!!! !sdfasdf@lemm.ee

Me and my brother were talking to each other
About what makes a man a man
Was it brain or brawn, or the month you were born?
We just couldn't understand

[–] RoundSparrow@lemmy.ml 2 points 2 years ago* (last edited 2 years ago)

Really, are you going to ignore what it says? The opening?

It implies a flat /c/a /c/b /r/a /r/b system "until now"? Or am I wrong?

Perhaps you aren't faniliar with how under-utilizes naming dots matter in domain names?

smtp.chemistry.science.oranic.org has been in the Internet (Usenet) conventions for a VERY long time! Forgotten, burred in $$$$$$ wealth. "Windows"... Everywhere. Owning the words. TradeMarks.

[–] RoundSparrow@lemmy.ml 1 points 2 years ago

!sdfasdf isn't a community?

 

The webapp is somehow using data from another posting or something? You can see in the screenshot that the posting was only 1 minute old.

 

Anyone able to confirm this problem before I open an issue on GitHub?

 

Yesterday people were saying it wasn't covered by "mainstream media", but that seems to have changed this morning. Newsweek qualifies as a "mainstream media", posted their version of the story 2 hours ago. Fox News website also posted the story 2 hours ago.

view more: ‹ prev next ›