this post was submitted on 06 Jun 2023
5 points (100.0% liked)

Beehaw Support

41 readers
1 users here now

Support and meta community for Beehaw. Ask your questions about the community, technical issues, and other such things here.

A brief FAQ for lurkers and new users can be found here.

Our June 2023 financial update is here.

For a refresher on our philosophy, see also What is Beehaw?, The spirit of the rules, and Beehaw is a Community


This community's icon was made by Aaron Schneider, under the CC-BY-NC-SA 4.0 license.

founded 2 years ago
MODERATORS
 

Is there anyone out there with database expertise willing to help?

you are viewing a single comment's thread
view the rest of the comments
[–] [email protected] 0 points 1 year ago (2 children)

Question really is why is it developed that way? Why does it need to do a reindex every hour? I have not looked at Lemmy source code, but wondering if a trigger function could do the same thing.

[–] [email protected] 3 points 1 year ago (1 children)

(Apparently the UI allows you to edit your own deleted comment, but saving it doesn't un-delete it, you just lose what you wrote... Bummer!)

In the conversation on Github, it looks like they considered a trigger and some other options based on DB query analyses, and arrived at a solution. It requires code refactoring, though, so I wouldn't expect it to be out in the wild right away.

[–] [email protected] 3 points 1 year ago

There's a branch that likely fixes the issue with a pull request to main, but it failed some automated testing and needs to be tested in main before a new release. The timing of this is unfortunate. I suspect Monday and Tuesday to have many 50x codes on any instances that get attention.

[–] [email protected] 1 points 1 year ago* (last edited 1 year ago)

In the conversation on Github it looks like they considered a trigger and looked at a ton of database query analyses and found a promising direction to go in.

The change requires code refactoring, though, so I wouldn't expect it to land in a stable version of Lemmy for a little bit.