I'm looking for a little help working through some database scaling issues with #WriteFreely.
On our Write.as instance, we're up to 4.25 million rows in our `posts` table, and it's causing problems for some individual blogs with 9,000+ posts.
I have an idea of what some bottleneck queries are. But wondering if there are easy db optimizations we might make (indexes, etc.), and if anyone can help identify what they might be.
Boosts appreciated!
Hi, fediverse Web and mobile client developer.
What if you added a speed bump in the reply flow to slow down users for just a moment?
"Do you really want to reply to X? Will they appreciate your reply?"
Maybe just the first time they reply to someone; maybe easily turned off in settings.
If it makes people think for just a moment, it might help with making the fediverse a more welcoming place for women.
UPDATE: deleted and redrafted per multiple requests.
Is it “open source”? The question doesn’t really matter. – Matt Asay When we as an industry talk about whether the term open source matters, we need to talk about that question on more than one level. There’s the obvious question of the licensing for a given project. Often ignored, however, are the wider industry
@Gary_Host so, here are *some* things that are Reply Guy behaviour:
- Replying to the same person *a lot*
- Giving advice to someone who knows as much or more than you do
- Giving unsolicited advice
- Centering yourself
- Changing the topic
- Replying a lot on the same thread
- Assuming familiarity with someone you follow
Each may seem innocuous to you, but for someone looking at their mentions with 50 near-identical replies, all a little irritating, it feels exhausting.
Wikifunctions is starting up!
https://diff.wikimedia.org/2023/08/07/wikifunctions-is-starting-up/