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/
This can't end well. I've already sent emails to our exec and data security departments about this.
Zoom terms of service now allow training AI on user content with no opt out
https://explore.zoom.us/en/terms/
§10.4(ii): 10.4 Customer License Grant. You agree to grant and hereby grant Zoom a perpetual, worldwide, non-exclusive, royalty-free, sublicensable, and transferable license and all other rights required or necessary to redistribute, publish, import, access, use, store, transmit, review, disclose, preserve, extract, modify, reproduce, share, use, display, copy, distribute, translate, transcribe, create derivative works, and process Customer Content and to perform all acts with respect to the Customer Content:(ii) for the purpose of product and service development, marketing, analytics, quality assurance, machine learning, artificial intelligence, training, testing, improvement of the Services, Software, or Zoom’s other products, services, and software, or any combination thereof
I think younger software developers don't appreciate how big of a deal #PHP was back in the day — and how important it was for the early mainstream Web.
The early mainstream Web — late 1990s and 2000s — was largely built on PHP — well —
PHP + MySQL + Apache + Linux
What eventually got called "L.A.M.P.".
("L.A.M.P." = Linux + Apache + MySQL + PHP.)
A lot of the explosion of creativity & culture & invention that happened during the early mainstream Web owes thanks to PHP.