Nothing pressing in terms of questions or concerns, but I was just wondering how things are at Fedecan and with the instance(s)? It feels like it's been a hot minute since the last update (big or small), so I thought I'd show my interest in knowing how things are going.

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)"

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/

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.

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

So, I'm tentative to announce this project, as the server it's running on is a bit of a potato which will probably fall over pretty quick if it gains any traction, but...

Introducing RSS Temple!

If you're interested in a free RSS reader which attempts to mimic some of the more useful features of the big players (Feedly and Google Reader, in particular), including full-text search, hotkey navigation, small footprint interface, and sharing to both Lemmy and Mastodon (among others), I would love if you gave RSS Temple a try.

I've been working on this project for ~7 years now, and I alone cannot find any more bugs or usability issues, so I hope it's ready for the community to see. Any feedback is appreciated!

The code is open at:

https://github.com/murrple-1/rss_temple (server, Python)

https://github.com/murrple-1/rss_temple_ui (landing page and web app, Angular and EleventyJS)

https://github.com/murrple-1/ansible-collection-rss-temple (Ansible scripts to deploy one's own instance)