CountVon

Side note, does the page say there’s 17 comments on this post for you?

No, for me it says there are 7 comments but that's still incorrect. When I manually count them I see 5 comments, not including the one I'm writing. I suspect edits might be getting counted as "new posts" by some instances. I gooned up the SQL pretty bad on the first attempt and edited it several times. There maybe something funky going on under the hood with federation as well that would explain why we're getting different incorrect counts.

It's been edited a few times, try the latest again.

Probably something like this (syntax may be incorrect for MySQL, I work mainly with Oracle):

select p.name, sum(pc.count * c.price)
from products p, product_components pc, components c
where p.id = pc.product_id and pc.component_id = c.id
group by p.name;

Edit: Here's the equivalent ANSI SQL syntax... I think:

select products.name, sum(product_components.count * components.price)
from products
join product_components on products.id = product_components.product_id
join components on product_components.component_id = components.id
group by products.name;

Cosmetics, probably? If an instance had been customized for particular formatting on mobile, I don't think any of that would change the way that an app displays the site. I believe an app would read the raw data using an API and then format that data in whatever way made the most sense to the app dev. I'm not sure how much incentive there would be for an instance owner to spend a lot of effort formatting for mobile anyway. Personally I think it makes sense to let apps worry about formatting on mobile and let instances worry about formatting in desktop browsers. Although even then, I'm already overriding the desktop CSS to give my view of Lemmy a format closer to old.reddit: https://sh.itjust.works/post/53395

As for functionality, I think the answer would be "no" in the ideal case where everything is working correctly, but site-specific, app-specific, or site-app-interaction bugs might cause functionality issues. Those would hopefully be transient problems though, and not the regular state of affairs.

This isn't really a good recommendation for OP, since it has fairly hefty modern graphics card requirements, but I'd like to give a shout out to the System Shock remake. It finally launched two weeks ago (I kickstarted way back in 2016 lol) and I've been enjoying it. It's mostly a graphical and controls update that doesn't otherwise stray far from the original game's design. Largely the same maze-like space station layout, old-school tile-based inventory management, etc.

System Shock 2 is one of my all-time faves, and I'd love to see Night Dive give it the same treatment.

Every spec-compliant USB-C charger should be able to charge every spec-compliant USB-C device. Some combinations of charger, cable and device will be able to charge faster than others. There's a sort of handshake happening between the charger and device when you plug them in, plus some resistors inside the USB-C cable itself. All together they let the device and charger determine how much juice can be sent down the wire.

The problem with the Switch is that it has some proprietary additions that aren't part of the USB-C standard. It has a USB-C charging port but isn't actually a fully USB-C compliant device itself. Some (typically cheap) USB-C chargers had problems after a Switch firmware update. Note that this was a Nintendo problem, really. After what was essentially a software update on the Switch side, chargers that previously worked were suddenly bricking Switch consoles.

This site has a bunch of recommendations for 3rd party chargers that have been found to work well with the Switch. You'll note that none of them are exactly dirt cheap, the lowest being $20 while the official Nintendo brick is the $30. The cost is not unwarranted as USB-C chargers have a fair amount of electronic complexity to handle power negotiation, and high quality components are important when charging at up to 100W. The original USB spec only handled 5W of power, for comparison.

Bottom line, if in doubt I'd stick with the original brick for the Switch. If you need a smaller form factor for travel (that original brick is a chunker!) then make sure you get one that advertises Switch compatibility, and don't cheap out too much.

I'm using Jerboa on Android right now and it's working fine. The equivalent iOS app would be Mlem. All taken from this page: https://join-lemmy.org/apps/

Also, https://sh.itjust.works/ does work pretty well in a mobile browser. App optional!