Deebster @ Deebster @programming.dev

New account since lemmyrs.org went down, other `@Deebster`s are available.

---

Read more

Posts

57

Comments

958

Joined

2 yr. ago

That won't show if results are equivalent, only if the query plans are matching, which they won't be (at least before the SQL engine's optimisations).

There aren't any joins in either query (and only one table involved), so that quoted bit of documentation isn't relevant.

Order aside, the two results would be identical In the same way that 2(4 + 3) = 2×4 + 2×3

Twenty years ago, I had an epiphany: Linux was ready for the desktop.

Please read articles before posting; this is literally the first sentence. The article is about the author's 20 years of Linux desktop usage.

I have fingerprint biometrics protecting my phone's lock screen and the vault itself - I feel this is the biggest weakness in my security, both from weaker legal protections (there are situations where you cannot be compelled to give your password but your fingerprints aren't protected) and the fact that my phone has my fingerprints all over it.

My desktop just has a numeric PIN on the lock screen since you also need to enter the Bitwarden master password (and you need to be in my house to get the chance to type it in).

We know this as the Caravan Game.

Anal Buccaneer
Anal Xplore
Anal Freedom
Anal Cavalier

I'm pretty sure you wouldn't be able to get a custom number plate of that star's name.

metux is Enrico Weigelt, the dev behind Xlibre, the new fork of X11. He's quite controversial, partly due to claiming to want to keep politics out of development by filling his posts with alt-right dog whistles, as well as being an antivaxer and having some... er... revisionist views of history.

Network effect, same as for most social things. Perhaps the EU will force interoperability, but they seem more focused on "save the children" style control and monitoring.

That mirrored mode is interesting and made sense to me even before I read the explanation. I'd assumed it only makes sense for using the left hand and that using just the right would need a different version of the keyboard, but there doesn't seem to be a flipped version.

Going into more detail would be helpful: Do you get an error? Do some settings restore or change? How old is your backup (i.e. from what version of Voyager)? Android or iPhone (before and after)? Are you selecting a file from your device, or trying to use from cloud storage (Google Drive, Nextcloud, etc)?

Mirror: https://archive.ph/FBVff

Two months after suffering her injury on the final season of Game of Thrones, Casey Michaels was one of 80 performers asked to contribute £300 towards a gift for Irlam for keeping the team safe. Although they were told the collection, which potentially raised £24,000, was voluntary and would “not impact any future employment,” Michaels believes the opposite is true. “Everybody knew there would be repercussions for not paying,” she says.

This Rowley Irlam comes across like a corrupt, arrogant arsehole.

I'm guessing by the recipes you mean Southern USA. I thought okra was from somewhere in Asia, but Wikipedia tells me it's from East Africa (Ethiopia, Eritrea and "East Sudan" - which is kinda funny as there's a Sudan and South Sudan).

Dickbutt? Getting /r/HighQualityGifs/ vibes

btw, you wanted cue not queue, as in cue cards, that's my cue, cue the music.

Nothing dates it more than the reference to Boing Boing.

Then the UK's equally dumb: it was 10:04 pm BST (GMT+1) cos daylight savings is a thing in most of Europe too. At least it's synchronised across Europe^{[The EU is planning on killing daylight savings but I have no idea if the UK will do the sensible thing and go along when/if this happens] so you just need to remember that most}[thanks for making it more confusing, Mexico] of North America changes a few weeks earlier.

Also, the UK says GMT/BST which is nice and clear - calling both EST and EDT "Eastern Time" makes even more of a mess!

And yes, I've just rediscovered you can use footnotes, why do you ask?

The duplicate content thing is kinda impossible to solve perfectly. Some people will tell you it's a feature, and it can be interesting to see the different instances' comment sections (especially after moderation), but yeah it can be annoying to have your feed dominated by a few stories.

The default web front-end will merge crossposts, but won't if they're multiple posts to the same URL. I think some of the apps do have that deduplication as a feature, but I couldn't tell you which.

I remember the same problem from my Reddit days, but there wasn't generally so many similar, overlapping communities.

From the Lemmy docs:

• Active (default): Calculates a rank based on the score and time of the latest comment, with decay over time
• Hot: Like active, but uses time when the post was published

My default is set to

• Scaled: Like hot, but gives a boost to less active communities

This is the newest sorting option, I think, and it helps me not miss posts from the smaller comms - particularly ones where people are asking a question and there's been no engagement. Ideally I'd like to have Mastodon-style lists so I could have "quiet comms" or something and check them all every so often.

I will switch to new or top 6h/24h if I've been on recently and just want to see what's fresh. Top all time or 1y if I'm looking at new-to-me comms so I can see what type of thing to expect from it.

There's no algorithm here, so use the different sorting options (for both posts and comments), as well as setting your favourite as default once you see what works for you.

the different sort options are of course algorithms, but I mean there's no automatic, manipulative system like YouTube's "The Algorithm", Facebook, TikTok, etc.

Voting doesn't tune your algorithm, so I'd say only use downvoting for things that are low quality, trolling, in the wrong sub, duplicate posts, etc. Your votes aren't private, by the way - although Lemmy itself doesn't display voters' names, that info is in every server's database, and some other software in the Fediverse does show them.

There are quite a few apps available, I like Voyager on Android and I stick to the default website on my computer.