mackuba

mackuba, 10 days ago (edited 10 days ago) to random

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, 15 days ago to bluesky

#Bluesky traffic tonight:

mackuba, 17 days ago to random

Just out of curiosity, can anyone recommend a nice terminal-based editor (ideally with multi-file support) which is not any variant of Vi(m) or Emacs? 😄 I normally use Nano when editing files on a server, but I was wondering if there's maybe something better.

mackuba, 18 days ago to random

Pretty good summary of the drawbacks of having a single-user Mastodon instance that result from ActivityPub's architecture (and partially from Mastodon's implementation): https://mull.net/mastodon

It's nice to be in control of your account, but you need to know what you're getting yourself into.

mackuba, 19 days ago to random

#MacDev #AppKit question: if I have a main storyboard set in Info.plist, and an initial (entry point) window controller in that storyboard (with "single presentation"), so like in the Mac app Xcode template, the storyboard automatically creates the window controller and its window and displays it; can I get a reference to that controller from AppDelegate somehow? (Calling instantiateInitialController creates a second window controller for some reason…) 🤨

mackuba, 19 days ago to random

Oh wow… someone on StackOverflow recommended to use this for an animation; available in iOS since 3.1, on macOS added only in Sonoma 😳 #MacDev

mackuba, 22 days ago to OutOfTheLoop

I'm getting the impression that there's apparently some kind of drama about the iTerm terminal app?… #OutOfTheLoop

mackuba, 23 days ago to bluesky

#Bluesky launched DMs! 👀 (not federated or encrypted yet, just a v1) https://bsky.app/profile/bsky.app/post/3kt3y33tk4w2m

Took them like a month to build it all from start to finish :0

mackuba, 29 days ago to bluesky

I sometimes wonder how things would've looked on #Bluesky if the first beta had been ready just 6 months earlier, if all those people who left Twitter for Mastodon could have gone there…

I've just checked the hashtag feed for #swiftlang and apparently there were 19 posts in total… (and 9 of those from me) 😕

mackuba, 29 days ago to random

😬😬 https://bsky.app/profile/did:plc:cak4klqoj3bqgk5rj6b4f5do/post/3ksnbjtnvlx2z

mackuba, 1 month ago to random

Current status: beta-testing DMs on Bluesky by making API calls to sendMessage and getMessages in the Ruby irb console, because I didn't feel like messing with npm and React Native, and I figured I'd rather dig into the code and do it manually 😆

mackuba, 1 month ago to random

That feeling when Mastodon people would rather side with Jack Dorsey than with the #Bluesky developers 🙃

mackuba, 1 month ago to bluesky

Jay, #Bluesky's CEO, now has a bridged account here via Bridgy Fed 🙂 @jay.bsky.team@bsky.brid.gy 🦋

mackuba, 1 month ago to bluesky

#Bluesky has posted an updated #ATProto protocol roadmap for the coming months: https://docs.bsky.app/blog/2024-protocol-roadmap

mackuba, 1 month ago to random

I don't need an iPad, I don't need an iPad, I don't need an iPad… #AppleEvent

mackuba, 1 month ago to bluesky

#Bluesky tip: if you're running some kind of company/org account that's posting to Twitter/Mastodon etc. and you could consider posting to Bluesky too, but you need to integrate it into some existing system, there is a command line tool someone wrote here: https://github.com/mattn/bsky - it should be possible to integrate it with anything that lets you run a shell command. Handles images, link facets etc.

mackuba, 1 month ago to rust

New word learned: "monomorphization" 🤨 https://doc.rust-lang.org/book/ch10-01-syntax.html

(Please tell me there are no monads here 😛) #rustlang #🦀

mackuba, 1 month ago to bluesky

Mastodon when #Bluesky launches: "it's Jack's social network"

Mastodon when told that Jack is not the CEO and doesn't own or control it: "but he's still on the board"

Mastodon when Jack leaves the board: "well Bluesky is dead now since Jack left"

mackuba, 1 month ago to random

Oh nice, looks like it's official 👀 https://docs.bsky.app/blog/self-host-federation

(I don't know what's the status of the "10 users" limit, at least the Bridgy PDS got it lifted, but even if it's not announced yet I think it's also going away / or will be relaxed soon)

#bluesky #atproto

mackuba, 1 month ago to ruby

Current status: I opened about 100 links to articles and threads from Google results comparing #ruby, #golang and #rustlang and I'm planning to read them 🫠

(no, I'm not really considering Go, mostly just trying to convince myself that I'm not making a mistake starting to learn Rust and not Go 🦀😛)

mackuba, 1 month ago to golang

It's insane that I can have a conversation with this thing and in a few moments and a few back and forths build a working program in a language I know nothing about (I don't know Go)… don't tell me this isn't huge 😳 #golang #chatgpt

You: One modification - this current code counts all matches of all regexps against the text. So if one line of text matches two or more regexps, it will be counted as 2 or more. I want a given line of text to only be counted once if it matches
You: What's the command to compile this to a binary? ChatGPT: To compile a Go program to a binary, you can use the go build command followed by the name of the Go file you want to compile. If you want to specify the output binary name, you can use the -o flag followed by the desired name. Assuming your Go file is named main.go, you can compile it to a binary named my_program like this: You: Looks like
You: Great, that works 👍 Is there some way to compile this program in "release mode", with a more optimized version or something? ChatGPT: Yes, you can compile your Go program in release mode with optimizations using the go build command with the -ldflags flag set to -s -w, and the -trimpath flag set to remove the build path from the resulting binary. Here's the command to compile your program in release mode: You: I mean, not optimizations for binary size, but optimizations to make it faster? ChatGPT: Ah, I see! In Go, optimization for speed primarily comes from the compiler's default optimizations, and there isn't a direct flag to enable additional optimizations beyond what the compiler already does. However, there are some general principles you can follow to improve the performance of your Go program: Profiling: Use Go's profiling tools (go test -cpuprofile, go tool pprof, etc.) to identify bottlenecks in your code and optimize them. Profiling helps you understand (…)

mackuba, 1 month ago to bluesky

Good read - interesting comparison of how moderation is handled on the Fediverse and #Bluesky, with Fedi being more like a "network of clubs" and Bluesky putting more emphasis on personal preference vs. closed communities, and what this means in practice: https://www.aendra.com/some-thoughts-on-running-a-moderation-service-that-blocks-screenshots/

mackuba, 1 month ago to bluesky

The #BlueskyBridge by Snarfed was soft-launched this week - still very alpha and a lot of things don't work, but posts are starting to come through both ways 🙂

Right now you need to follow the bridge to get bridged (the DM-request mechanism isn't finished yet). I'm tracking the bridged accounts (M->B) here: https://blue.mackuba.eu/directory/fedi

#bluesky

mackuba, 1 month ago to bluesky

So apparently we've hit that 30% chance after all and #Bluesky didn't die before they allowed a bridge to run, who'd have guessed? 🤔

Somebody plz ping Evan about this - I'm not on Threads, I don't like commercial social media platforms 😈

mackuba, 1 month ago to random

Test 1