@mackuba@martianbase.net
@mackuba@martianbase.net avatar

mackuba

@mackuba@martianbase.net

Independent Mac/iOS & web developer. Building useless random stuff in Swift, Ruby or JavaScript and wasting time. Currently also learning Rust 🦀 I'm mostly hanging out on Bluesky these days and hacking things on the AT Protocol, so follow me there 😎 🐦 @kuba_suder 🦋 @mackuba.eu

This profile is from a federated server and may be incomplete. Browse more on the original instance.

mackuba, to random
@mackuba@martianbase.net avatar

Checks out

mackuba, to random
@mackuba@martianbase.net avatar

Not bad 👍 PiS is finally down to #2, and with a pretty big difference 😏 Though pretty bad for the center-right and left coalition partners 🫤 And the far-right Confederation did really good too…

And he said that apparently things aren't looking good in France and Germany? 🇵🇱🇪🇺

mackuba, to random
@mackuba@martianbase.net avatar

Small thread about the Threads bridging that I probably made more complicated than it should be: ⬇️ https://bsky.app/profile/did:plc:oio4hkxaop4ao4wz2pp3f4cr/post/3kuensrskkb2w

mackuba, to random
@mackuba@martianbase.net avatar

Thanks to the magic of federation, your throots can now turn into toots and then into skeets ✨ https://bsky.app/profile/did:plc:p2cp5gopk7mgjegy6wadk3ep/post/3kueek7qixk2u

mackuba, to random
@mackuba@martianbase.net avatar

I’m not a big fan of how much warmer the white balance is on this iPad’s screen vs. my MacBook (with True Tone off!)… It looks much more yellowish and I prefer more blueish whites. But I think that’s just how they set it everywhere now? I tested briefly an iPhone Mini and IIRC it was also like this.

mackuba, (edited ) to random
@mackuba@martianbase.net avatar

Oh man, I love this - in "tablet mode" (without keyboard), I can use the Pencil to show link URLs on hover (literally hovering, not touching the glass) (see bottom-left corner) 🤯

This was honestly the main reason why I didn't do more reading on the iPad - because there are often a lot of links in articles and I’m used to quickly hovering the cursor over them on the Mac to see if it's something worth opening in a new tab, but this was too inconvenient on iOS, with the preview loading etc…

mackuba, to random
@mackuba@martianbase.net avatar

Holy shit, iPad with a black keys on silver Magic Keyboard… want! (https://www.macstories.net/stories/apple-tv-go-ipados-workstation/)

mackuba, (edited ) to random
@mackuba@martianbase.net avatar

EU fixed plastic bottle caps:

mackuba, (edited ) to random
@mackuba@martianbase.net avatar

👀👀 https://blue.mackuba.eu/directory/fedi

(I wasn't checking it waiting for a round number, I swear!)

Btw, I'm planning to add some kind of bidirectional contact search there, so you can look up which of your Mastodon/Bluesky friends are available on the other side.

mackuba, to bluesky
@mackuba@martianbase.net avatar

🌉 PSA: if you're only posting on Mastodon/Fediverse, but you'd like your posts to be seen on too using the Bridgy bridge, all you need to do is follow the bridge account here: @bsky.brid.gy - and all your posts will be mirrored to Bluesky/ATProto, and people from there can interact with you if their accounts are bridged too. Let's build a connected meta-fediverse (lowercase m) 😄

My Bluesky account is visible here: @mackuba.eu@bsky.brid.gy

mackuba, to random
@mackuba@martianbase.net avatar

I got myself a little present for Children's Day 👦🏻😅

mackuba, (edited ) to random
@mackuba@martianbase.net avatar

Ok, #SQL wizards plz help 🥺

I have a table posts (#SQLite), with a string repo (user DID) and int thread_id. Thread_id references the thread root post, around 1/6 of posts have thread_id NULL, the rest are replies. There's an index on repo+time and one on thread_id.

I want to select recent posts from one or more users that have thread_id NULL. But this very smart query planner uses the thread_id index to find posts, even though that will make it check 1/6 of all posts…

mackuba,
@mackuba@martianbase.net avatar

I want it to use the index on repo to find recent posts from given user(s), and then just filter out those with non-null thread_id.

Am I doing something wrong? Or do I need to just force it to use a specific index manually (which the docs say is a last resort since the query planner is very smart)? I tried running analyze and pragma optimize, but no change.

mackuba,
@mackuba@martianbase.net avatar

@helge Ok, looks like it works if I force it to use the right index, and it's just not smart enough to figure out which index to use in this case (or rather, it uses the right one if I search for 1 repo, but not if I search for 2+).

Schema for table + indexes below.

Long discussion here 😉 https://blue.mackuba.eu/skythread/?author=mackuba.eu&post=3ku4ml2hhpp2f

mackuba, (edited )
@mackuba@martianbase.net avatar

@helge And the query + explain is:

Using the thread_id index, it goes through all recent posts with null thread_id (which could well be hundreds of thousands) to find those from these two users. While I want it to instead load a couple of pages of recent posts from two users, combine them and filter out those with a non-null thread_id.

mackuba, to random
@mackuba@martianbase.net avatar
mackuba, (edited ) to Signal
@mackuba@martianbase.net avatar

EU Commission wants to introduce mandatory filtering for E2EE messaging services. Signal says they would leave EU if this passes… 😐

@EU_Commission please rethink this, it would be a disaster if this proposal is passed…

https://mastodon.world/ #ChatControl #Signal

mackuba, (edited ) to random
@mackuba@martianbase.net avatar

Hey WWDC gang! If you're planning to follow the keynotes, talks, and scoop from the betas and docs next week, on which social sites will you be posting this time? [Note: multi-choice poll 📊]

mackuba, to random
@mackuba@martianbase.net avatar

while true do
water = @kettle.boil(Water.​new)
@cup << TeaBag.​new
@cup << water
go_to :room
wait(3600.0)
go_to :kitchen
assert @cup.temp < 30
@cup.empty!
say "kurwa..."
next
end
go_to(:room) && @cup.drink!

mackuba, to random
@mackuba@martianbase.net avatar

That's… a lot of phones 😳 @_Davidsmith https://mastodon.social/

mackuba, to random
@mackuba@martianbase.net avatar

Oops 🫣🫢

mackuba, to bluesky
@mackuba@martianbase.net avatar

I've updated my #Bluesky stats page with a 7-day moving average line on the daily activity charts, and a new weekly activity chart: https://blue.mackuba.eu/stats/

I've also looked at the language stats from the last week (not on the site yet):

  1. English = 45.9%
  2. Japanese = 31.9%
  3. German = 8.8%
  4. Portuguese = 3.1%
  5. French = 1.6%
  6. Spanish = 1.4%
  7. Turkish = 1.1%
  8. Dutch = 1.1%
  9. Korean = 0.9%
  10. Ukrainian = 0.6%
mackuba, to random
@mackuba@martianbase.net avatar

Thank you past Kuba who added a 2-paragraph long description in a commit that fixes something, in case I forgot what this was about again, because I happened to forget what this was about again 🙏

mackuba, to random
@mackuba@martianbase.net avatar

Interesting… so the iPad Pro 11" had a more widescreen aspect ratio than the 12.9", and the new one has slightly more widescreen one. It's 32 px wider, and it looks like it's diagonally larger about as much as the bigger one, which would make it a 11.1" really 🤔

Lazarou, to twitter
@Lazarou@mastodon.social avatar

I'm not exactly sure how it's happened, but it's pretty cool I can see Bluesky accounts talking on here.
It seems a shared interest in the misfortunes of the Nazi Bar has bridged the technical divide somewhere.

mackuba,
@mackuba@martianbase.net avatar

@Lazarou One very hardworking open source developer (not affiliated with Bluesky) made a "bridge" thing which let people post from one side to the other (basically it creates kind of "mirror" accounts on the other side which clone the posts, translating links, mentions etc.): https://snarfed.org/2024-05-04_52915

  • All
  • Subscribed
  • Moderated
  • Favorites
  • JUstTest
  • everett
  • rosin
  • thenastyranch
  • mdbf
  • osvaldo12
  • Youngstown
  • InstantRegret
  • slotface
  • DreamBathrooms
  • kavyap
  • ngwrru68w68
  • tester
  • normalnudes
  • megavids
  • magazineikmin
  • tacticalgear
  • khanakhh
  • GTA5RPClips
  • ethstaker
  • Durango
  • Leos
  • anitta
  • cubers
  • cisconetworking
  • modclub
  • provamag3
  • lostlight
  • All magazines