Sometimes sqlite really is shit
I have a lot of repos in my private gitea server because I mirror repos I care about accessing locally
well, it's come to the point where loading my dashboard after login takes somewhere between 4-8 seconds to render the page... the template it says renders in a dozen or so milliseconds, but the page portion is really high
so I enabled all the redis caching options.
It got better. 1.5 - 2 seconds now.
I just migrated the gitea database to my postgresql server
Now it loads in 25ms
Like holy shit batman, that's a world of difference
Looks like I picked the wrong week to start using Friendica.
Crashes across all interfaces, takes forever to load. Maybe, if you collapsed all comments by default, just maybe it wouldn't be crunching so hard. Bluesky integration fails completely. Oh well, seemed perfect for me, in the abstract. I learned quite a lot about the potential. Think I just need to make Mastodon my one stop-shop instead.
It has been addressed in github.com/friendica/friendica/pull/14974
The patch is not yet live on friendica.world though.
Query tuning: NOT IN
Bug Description There are queries using 'NOT IN' which are performing badly when the tables have millions of rows. Steps to Reproduce explain SELECT `uri-id` FROM `post` WHERE (NOT `uri-id` IN (SEL...ruudschilders (GitHub)
RT: furry.engineer/users/soatok/st…
Soatok Dreamseeker (@soatok@furry.engineer)
And the reason I will not be kind is simple: The people doing this are actively peddling Security Theater when they tell people to use something less-cryptographically-secure than Signal.Furry.Engineer - Duct tape, hotfixes, and poor soldering!
itslinuxfoss.com/install-dpkg-…
this is the worst article i have ever seen
Though the dpkg manager comes pre-installed on Ubuntu, it is ready to use, but if it is not installed, it can be installed from the default repository of Ubuntu.
no not really I mean, apt relies on dpkg to install packages if you don't have dpkg installed there is nothing that is going to be able to install dpkg. I mean dpkg literally ships as a .deb usually these systems are bootstrapped by debootstrap wiki.debian.org/Debootstrap you can't just install dpkg without dpkg (unless you have another package manager but ubuntu is famous for using well apt and dpkg)
How to Install dpkg on Ubuntu 22.04
To install the dpkg on Ubuntu 22.04, run the command “sudo apt install dpkg”. You can use the “-i”/“-r” options to install/remove packages using dpkg.Saryia (Its Linux FOSS)
Just listening to the speech of the @EUCommission's DG Connect Director Thibaut Kleiner, who celebrates #FOSS and the global ecosystem of #opensource developers as well as the #NGI programme but somehow his convictions seem to not be enough for the Commission to massively scale up investments in the #digitalcommons. What am I missing? 🤔
So cool to now also see @matrix's @Amandine at #NGIForum25 to speak about sovereign and secure messaging #infrastructure (and strongly warn against the nationalist version of the digital #sovereignty narrative 💪):
"Does self-sufficiency even make sense in a globalised and digitised world?"
EU tech Brussels really has come a long way :) 🎉
RE: bsky.app/profile/did:plc:gpnca…
“The ban is causing very significant harm to trans children and young people and, consequently, there can be no justification for it.”
I mean, any honest person who's even vaguely paid attention to such things could've told you that.
thepinknews.com/2025/06/19/pub…
Puberty blockers ban causing ‘extensive’ harm to trans youth, study shows
Trans youth are reportedly feeling more suicidal since the UK banned puberty blockers indefinitely, a study suggests.Amelia Hansford (PinkNews | Latest lesbian, gay, bi and trans news | LGBTQ+ news)
"On Saturday, June 14th, Arturo Gamboa was attending the "No Kings" protest in downtown Salt Lake City. He was there armed, within his legal rights, and peacefully protesting. During the event, the "peacekeepers" hired by Utah 50501 to control the crowds at the event opened fire on the crowd, shooting both Arturo and Arthur "Afa" Folasa Ah Loo who was tragically killed by the stray bullet.
Due to the tragic loss of life, Arturo was unjustly arrested and is currently being held by Salt Lake County sheriffs department. They are holding him regardless of the fact that his weapon was never fired, his gun barrel was never pointed anywhere but the ground, and the bullet that tragically caused the death of Ah Loo was fired from the gun held by hired "peacekeeper."
In a serious gain in efficiency, a Space X Starship prototype has exploded without actually being launched.
They're next plan is to see if they can produce an explosion during the assembly process.
youtube.com/watch?v=71AwkBt3_t…
#news #science #space #NASA #spacex
SpaceX Starship 36 Explodes During Flight 10 Testing at Starbase
While preparing for a 6-engine static fire test as part of its pre-flight test campaign, SpaceX's Ship 36 experienced an anomaly, resulting in destruction of...YouTube
reshared this
This sounds like a joke, but I kid you not:
While the US military is rushing to The Middle East, Trump suddenly wants to wait two weeks before deciding what he wants to do in Iran.
US tax dollars are burning in the engines of the carrier strike groups, but as always Trump has no plan.
I think we have heard that “in two weeks” excuse 3 times with regards to Ukraine.
The US lost its leadership on January 20.
Trump to allow 2 more weeks for diplomacy before deciding on US strike in Iran
President Donald Trump will decide whether to launch a US strike on Iran within the next two weeks, he said in a statement delivered by his press secretary d...YouTube
SpaceX Starship 36 Explodes During Flight 10 Testing at Starbase
While preparing for a 6-engine static fire test as part of its pre-flight test campaign, SpaceX's Ship 36 experienced an anomaly, resulting in destruction of...YouTube
𝐿𝒶𝓃𝒶 "not yet begun to fight" (@Lana@beige.party)
Oh are you leaving MAGA? That's great 👍🏼 I still don't fucking trust you go fuck yourself.beige.party
In another universe:
I'm so sorry I used to be a capitalist, I didn't understand the consequences. Please let me join your socialist movement I want to help now
no, go fuck yourself
Well that's one way to ensure the socialist labor movement is on the road to success 
Enshittification comes for open source:
Slack is kicking two large open source groups, Cloud Native Computing Foundation and Kubernetes, off of their donated enterprise tier, giving them one week notice to migrate multiple years of data to a new platform before it's all deleted: cncf.io/blog/2025/06/16/cncf-s…
Instead of learning from this experience and not trusting the good will of profit-motivated closed source companies, it looks like both projects will be moving to ... Discord. Because "people know it." Will we never learn?
(Dropped Cory because he's probably getting tons of spam from this. Sorry!)
CNCF Slack Workspace Changes Coming on Friday, June 20 | CNCF
The CNCF Slack workspace will be converted from an enterprise plan to a free plan on Friday, June 20, 2025. This will have implications for how Slack works for…Katie Greenly (CNCF)
what strikes me about this is that all these guys are like, well he seemed normal to us
yes that's the problem
the normalization of extremism is exactly the problem
Childhood friend says Minnesota suspect had 'darkness inside of him' | AP News
apnews.com/article/minnesota-s…
32 years ago today, #FreeBSD was announced for the first time. I haven't tried this OS yet but I can assure you that I will because I want Quark, my OpenSource reverse proxy, to be supported on other Unix systems than Linux.
For this special occasion, I drew this little picture on #Krita 🙂
#FreeBSDday #Unix #Server
Several abbreviations in those voices are implemented in such a way that they match on inflected forms of the abbreviations. For example, CH, the abbreviation for Chapter, also matches on CHY, which is said as "chaptery," or CHFUL, which is said as "chapterful." In fact, the voices allow word suffixes to be chained together in any order, seemingly forever. Typing something like NEFULERYING will result in them saying "northeastfullerying." This creates endless possibilities for silly sentences. Here's one I made.
buttondown.com/access-ability/…
#a11y #productmgmt #webdev #webdesign
Dangerous Accessibility Assumptions That Put Everyone at Risk
Three strips of intersecting yellow and black “warning” tape. Accessibility isn’t an extra feature or a nice-to-have add-on. It’s a foundational requirement...Access * Ability
reshared this
#AudioMo day 19:
Because the thing I wanted to post today didn't work out, I'll throw this here instead.
In late July of 2016, I was visiting my parents. They were getting ready for a move, and thus, were about to toss a bunch of stuff, including a bunch of old hard drives. The newest of these was probably 10 or 20GB, and the oldest was 80MB. Most of them didn't calibrate.
So, just because I could, I recorded exactly 30 seconds of each hard drive being powered on, regardless if it calibrated or not, then stacked them all. Result is this clicky clacky thing I called "a Bad Day in the Server Room."
I can't find the original multi-track project, so I am not sure how many hard drives are featured in this recording. I'm pretty sure it is at least 15. Have fun trying to count them all.
This was recorded with a Zoom H6 and it's X/Y microphones.
Announcing Withdrawal of NSF Pathways to Enable Open-Source Ecosystems Proposal
In September 2024, The Carpentries submitted a proposal to the U.S. National Science Foundation (NSF) Pathways to Enable Open-Source Ecosystems (POSE) Program.The Carpentries
Wir haben Euch in unserem Newsletter und hier im #Fediverse gefragt, wo man überall das #Deutschlandticket ohne App-Zwang / Digitalzwang bekommen kann. Daraus ist eine Tabelle mit ca. 180 Einträgen geworden (die sich auch mobil betrachten lässt.) Weitersagen! ReTrööten, bitte!
digitalcourage.de/blog/2025/ue…
Deutschlandticket ohne App-Zwang | Digitalcourage
Wer das Deutschlandticket kaufen möchte, wird von der Deutschen Bahn schnell auf ihren „DB Schnüffel-Navigator“ geleitet. Viele Verkehrsunternehmen bieten dasdigitalcourage.de
Trump Administration Abandons Deal With Northwest Tribes to Restore Salmon
—
The Trump administration canceled a deal, signed under President Joe Biden, that would have enabled the removal of four hydroelectric dams along the Columbia River that are considered harmful to salmon.
propublica.org/article/trump-s…
#News #Trump #Native #Indigenous #Oregon #Environment #Sustainability #PNW
Trump Cancels Deal With Tribes to Restore Columbia River Salmon
The Trump administration canceled a deal that would have enabled the removal of four hydroelectric dams along the Columbia River that are considered harmful to salmon.ProPublica
#FreeBSD provides the Ports Collection, a convenient way to install applications. Some ports allow users to configure options before building and installing. By default, this configuration is done through an interactive menu in the terminal.
To improve readability and #Accessibility especially for users with low vision or color blindness, it's important to offer simple and customizable color options. These features have recently been implemented and documented in the preview version of the FreeBSD Accessibility Handbook:
freebsd-accessibility-9d667f.g…
The next step is to extend these features to all terminal-based graphical components.
I'd love to hear from you:
Do you use any accessibility features in the terminal?
Which color-related assistive technologies make the biggest difference in your daily workflow?
Together, we can make FreeBSD more accessible for everyone. #ThePowerForEveryone #FreeBSD #Accessibility #OpenSource #LowVision #ColorBlindness #AssistiveTechnology #AccessibilityMatters
Chapter 3. Colors | FreeBSD Documentation Portal
Features to set up colorsfreebsd-accessibility-9d667f.gitlab.io
Not hacked in. Not community-patched. Built-in. From Valve.
There's an accessibility tab. There's a screen reader. There's high-contrast mode, UI scaling, color filters, reduced motion, and more.
I can’t believe I’m saying this but: I need a Steam Deck now.
Accessibility isn’t just coming to gaming — it’s here, and it’s official.
Let’s make some noise so they keep going.
🔗 theverge.com/games/689922/stea…
#Accessibility #Gaming #SteamDeck #ScreenReader #Linux #valve
Steam is adding screen reader support and other accessibility tools
Valve’s latest Steam beta adds new accessibility features to Big Picture mode and SteamOS.Adi Robertson (The Verge)
reshared this
Glad to hear this. More options for blind gamers.
Steam is adding screen reader support and other accessibility tools theverge.com/games/689922/stea…
Steam is adding screen reader support and other accessibility tools
Valve’s latest Steam beta adds new accessibility features to Big Picture mode and SteamOS.Adi Robertson (The Verge)
Na (re)kole Prahou
Po městě jezdím na kole běžně. Do práce to je pro mě nejlepší způsob dopravy. S autem často nezaparkuju a MHD trvá déle. Co když ale nemá člověk kolo zrovna u sebe nebo je v cizím městě? Poprvé jsem vyzkoušel sdílená kola a byl příjemně překvapený.
#bike #Cyclers #cycling #kolo #NextBike #Rekola
blog.eischmann.cz/2025/06/19/n…
(reakce na tento příspěvek se může zobrazit jako komentář pod článkem)
reshared this
🧵 So to recap something that happened yesterday, as I see it:
Yesterday Mastodon gGmbH sent out an email to mastodon.social and .online users announcing a new TOS. The TOS would take effect July 1, and would ship in the next version of the Mastodon server software as a suggested "template" TOS instances could adopt.
This TOS had multiple problems, and several people said so loudly. This morning, Mastodon announced they're backing off and taking additional legal advice:
mastodon.social/@Mastodon/1147…
Mastodon (@Mastodon@mastodon.social)
We've heard your feedback on the Terms of Service updates for mastodon.social and mastodon.online, and we're pausing the implementation date (previously announced to users via email as 1st July 2025) so we can take further advice and make improvemen…Mastodon
Steam is adding screen reader support and other accessibility tools
Valve’s latest Steam beta adds new accessibility features to Big Picture mode and SteamOS.Adi Robertson (The Verge)
reshared this
variety.com/2025/tv/global/doc…
#Global #News #BBC #Disney #DoctorWho #RussellTDavies
Doctor Who Showrunner on Series Future: 'Don't Know What's Happening'
"Doctor Who" showrunner Russell T Davies is addressing the show's uncertain future after its Season 2 finale.Ellise Shafer (Variety)
nvaccess.org/post/nvda-2025-1-…
𝖏𝖆𝖊[Ø]™
in reply to feld • • •feld
in reply to 𝖏𝖆𝖊[Ø]™ • • •feld
in reply to feld • • •𝖏𝖆𝖊[Ø]™
in reply to feld • • •feld
in reply to 𝖏𝖆𝖊[Ø]™ • • •@jae yeah I prefer valkey. The benchmarks aren't a lie, traditional Redis is single threaded which is obviously problematic if you care about it ever being able to use more than 1 CPU core
However, pinning the work to one core means you have a better chance of the kernel / NUMA implementation allocating memory on the local memory controller which will keep the memory accesses as low latency as possible
With Valkey it's possible it needs to read from memory attached to another CPU and that could be significant under heavy load
Well, guess that just means if you're trying to use all your hardware for a busy Redis workload you need to be smart about the hardware you pick
Trade offs... but normal multi core CPUs on a single socket motherboard? Should smoke Redis
☢️🌲🌜
in reply to feld • • •feld
in reply to ☢️🌲🌜 • • •@scathach @jae I have no clue what the cause was for my specific performance issue, but the changes they made in the next release that I installed after I solved my problem were described in the changelog as:
Add cache for common package queries (#22491)
Move issue pin to an standalone table for querying performance (#33452)
Improve commits list performance to reduce unnecessary database queries (#33528)
Optimize total count of feed when loading activities in user dashboard. (#33841)
Optimize heatmap query (#33853)
Other people had also been complaining about long page load times, sometimes up to almost 15 seconds. Allegedly these changes made it fast for them again.
Well, for me on Postgres this release made it slightly slower but it's still so fast now I shouldn't complain ...
𝖏𝖆𝖊[Ø]™
in reply to feld • • •feld
in reply to 𝖏𝖆𝖊[Ø]™ • • •𝖏𝖆𝖊[Ø]™
in reply to feld • • •feld
in reply to 𝖏𝖆𝖊[Ø]™ • • •feld
in reply to feld • • •lol Gitea 1.24.0 "performance improvements, fixed slow queries"
buddy you made it slower for me
feld
in reply to feld • • •Blurry Moon
in reply to feld • • •feld
in reply to Blurry Moon • • •@sun bookmark this it has the important bits. You should just do it, it can probably be done in 5 mins
calumcrawford.com/posts/gitea-…
Gitea database migration
Calum CrawfordEmi Yusa
in reply to feld • • •>I have a lot of repos in my private gitea server because I mirror repos I care about accessing locally
That's the problem right there
feld
in reply to Emi Yusa • • •Emi Yusa
in reply to feld • • •feld
in reply to Emi Yusa • • •Emi Yusa
in reply to feld • • •feld
in reply to Emi Yusa • • •@GNUxeava this is a limitation you've made up in your head, SQlite's max db size is currently ~ 281TB. It was raised from 140TB a few years ago.
It's not the size of the data that matters, and in my case the db was barely 1GB. It's schema design and queries that matter