roadrunner_ex

joined 3 years ago
[–] roadrunner_ex@lemmy.ca 11 points 3 weeks ago (3 children)

I wonder if it would still hold up to me, but I really liked True Crime: Streets of LA on the Gamecube. I'm led to believe it was not well received, and is derided as a bad GTA clone

[–] roadrunner_ex@lemmy.ca 2 points 10 months ago

I am almost done with Legend of Zelda: Echoes of Wisdom. It's weird, but I'm enjoying it.

[–] roadrunner_ex@lemmy.ca 2 points 10 months ago

I had a blast with this one last year. Fun card battler with light social elements.

[–] roadrunner_ex@lemmy.ca 2 points 10 months ago* (last edited 10 months ago)

Aye, looking at the replies, I'm becoming aware that I left out a couple key assumptions I've made. Assuming:

a) id is a PRIMARY KEY (or otherwise UNIQUE)

b) I mean equivalent insofar as "the rows returned will contain equivalent data same (though maybe ordered differently)"

[–] roadrunner_ex@lemmy.ca 2 points 10 months ago* (last edited 10 months ago)

Aye, looking at the replies, I'm becoming aware that I left out a couple key assumptions I've made. Assuming:

a) id is a PRIMARY KEY (or otherwise UNIQUE)

b) I mean equivalent insofar as "the rows returned will contain equivalent data same (though maybe ordered differently)"

9
submitted 10 months ago* (last edited 10 months ago) by roadrunner_ex@lemmy.ca to c/sql@programming.dev
 

Putting aside any opinions on performance, I've been trying to test a notion about whether a couple queries would output the same data (ordering doesn't matter).

SELECT *
FROM articles
WHERE (
  last_updated >= %s
  OR id IN (1, 2, 3)
  )
  AND created_at IS NOT NULL
SELECT *
FROM articles
WHERE last_updated >= %s
  AND created_at IS NOT NULL
UNION
SELECT *
FROM articles
WHERE id IN (1, 2, 3)
  AND created_at IS NOT NULL

I think they're equivalent, but I can't prove it to myself.

Edit: Aye, looking at the replies, I'm becoming aware that I left out a couple key assumptions I've made. Assuming:

a) id is a PRIMARY KEY (or otherwise UNIQUE)

b) I mean equivalent insofar as "the rows returned will contain equivalent data same (though maybe ordered differently)"

[–] roadrunner_ex@lemmy.ca 3 points 10 months ago* (last edited 10 months ago)

I'm a big fan of tig for visualizing the graph and looking over history (then I don't need to leave the terminal, and it's snappier, in my experience, than most full-GUI programs like Sourcetree), but for actual Git commands, I like the CLI

[–] roadrunner_ex@lemmy.ca 6 points 1 year ago (2 children)

I'm glad it is now. I remember a decade or so ago, I wrote an APNG decoder, so I was deep in the world of APNG.

And I remember reading various things that made me think MNG was the 'more official' flavour of "animated PNG", and it was absurd to me, because APNG seemed like a much more approachable spec. I'm glad the winds have turned...

[–] roadrunner_ex@lemmy.ca 67 points 1 year ago (10 children)

One thing you should do is grab your data for easy moving, you haven't already.


Assuming you're using the default Lemmy web UI (not Voyager, or Photon, or a mobile app, or whatever), click on your username in the top right, and select "Settings".

On the settings page, there's a section called "Import/Export Settings". Click the "Export" button and let your browser download the file.

Then, when you switch instances, you can go into the same Settings page on the new instance, select the file you downloaded, and hit "Import" and you will automatically be resubscribed to the communities you subscribed to.

[–] roadrunner_ex@lemmy.ca 3 points 1 year ago

If you aren't married to Hugo as your solution, I will recommend giving Eleventy.js a look.

It's a static-site generator, but a good amount of flexibility is afforded by virtue of using pure JS to generate view data (which means that you can do any conversions needed, manually or with NPM packages if needed for more proprietary data formats), and it supports a bunch of templating engines too.

[–] roadrunner_ex@lemmy.ca 0 points 1 year ago (2 children)

I was about to reply with a "oh, really? Whoops, I maybe should I have looked a little deeper" and edited for the post title, but I'm not so sure, looking into the first link you posted.

RE: phabricator...I don't know what that service is or is for, so I can't comment if there's any proof therein.

But the "how to submit a patch" page linked has a section that seems to at least suggest that their Github repo is now first-class, per the first line of the section.

 

cross-posted from: https://lemmy.ca/post/41563491

AFAICT, this is a reprint of the same article originally from Rolling Stone https://www.rollingstone.com/music/music-features/heavy-metal-changed-my-life-1235305372/

 

AFAICT, this is a reprint of the same article originally from Rolling Stone https://www.rollingstone.com/music/music-features/heavy-metal-changed-my-life-1235305372/

[–] roadrunner_ex@lemmy.ca 2 points 1 year ago (1 children)

Oh, neat. I’ll be taking a look-see when I get to my bigger screen. Thanks for sharing!

 

I was just taking a peek at the various frontends supported by lemmy.ca, and I was wondering if the admins here have any insight into their respective use?

I'm going to bet the default (lemmy-ui) is most popular, but do any of the other frontends get far-and-away more use than the other alternatives? Has there been any trends up or down? Just thought I'd ask.

As an aside, if any of the frontend developers happen across this post, well done to all of you! I can immediately see the appeal of each, so each niche is being filled darn well!

Edit: to be clear, I'm talking about the frontends listed on the lemmy.ca main sidebar.

[–] roadrunner_ex@lemmy.ca 13 points 1 year ago (3 children)

So, there are a lot of words in the post that I'm not familiar with (LoRA, Oobabooga, CivitAI). However, I think those are details about the actual library or package you're looking at, so I will not touch any of that.

I can strict answer the question "what is Yarn?"

Long story short, it's a direct "competitor" to NPM (Node Package Manager). In the earlier days of Node and NPM, Yarn was an attempt to improve certain weaknesses perceived in NPM (including speed and security). Yarn is still used in many codebases, but it's become less popular over the years as NPM has resolved many of the things that Yarn sought to fix. Also, Yarn version 2 made a major design change which some have viewed as too radical (though I'm unclear on the details as I've only dabbled in v2).

https://en.wikipedia.org/wiki/Yarn_(package_manager)

 

Version: 1.0.187 (187)

Hardware: Google Pixel 7

Expected behavior: When swiping "back" on the main/posts page, expect to see "Are you sure you want to exit? Y/N"-type notification. "No" will return you to the app, whereas "Yes" will "close" the app (as in, reopening the app is a fresh open, not 'pick up where you left off'/minimize)

Observed behavior: Swiping "back" on the main/posts page just minimizes the app

view more: next ›