#dev 2026-04-14
2026-04-14 UTC
ax562, Pixi, grufwub, benji, [Trevor_Morris], srazkvt, barnaby, claudinec, mossymaker2, boramalper, thegreekgeek_, bitauger, kishy, redshuffle, blacklight, gRegor, cotsuka and Xe joined the channel; NegateThis left the channel
# 
[capjamesg] Does anyone have any intuition for why a Sqlite database might take 10x longer to do a SELECT query but only every so often?
# [capjamesg] I have indexes set up and the query response time can be as low as 0.1s.
# [capjamesg] But some times it takes multiple seconds.
# [capjamesg] I am using Flask as my web server so I may need to figure out if a connection limit is being hit or something.
# [capjamesg] I haven’t run into this before though so I thought I’d ask!
# 
exxxxkc let do little trolling
[snarfed] and [aciccarello] joined the channel
# 
[aciccarello] [capjamesg] I'm not a DB expert but that sounds like some slow process is blocking. What you are describing reminds me of the effect garbage collection or a thread blocking process might have in application performance.
# [aciccarello] I wonder if there's something re-indexing or some other kind of periodic process
extremelymeow and lain` joined the channel
# [Kupietz] Hey [snarfed], sorry to bug you, but I'm curious... today at 2:54 PST I published https://michaelkupietz.com/?p=33354 with a webmention to bridgy fed. It did turn up on my bluesky at https://bsky.app/profile/michaelkupietz.com.web.brid.gy/post/3mjie4e6l54z2 but doesn't appear on my BF profile at https://fed.brid.gy/web/michaelkupietz.com. Meanwhile, moments after that, I made some edits to a three-week old page at
# [Kupietz] https://michaelkupietz.com/?p=29170, and seems like every time I update it (which is frequent, it's my "latest news" page), it moves back to the top of my BF profile list, although the log correctly says "seen this before" and it doesn't get pushed out to Bsky. Curious why the former doesn't show in the profile and the latter does... only if you have the time and inclination to have a look. Thanks.
ax562 joined the channel
[Sophia_wood] joined the channel
# [Kupietz] [snarfed] No trouble at all on this end, just thought it might be worth looking into.
# [Kupietz] Heh. I may have said this before, but a lot of the services I'm involved with know me as the annoying client who always manages to find the edge cases.
blacklight joined the channel