Apple Thread - The most overrated technology brand?

[⠠⠠⠅⠑⠋⠋⠁⠇⠎ ⠠⠠⠊⠎ ⠠⠠⠁ ⠠⠠⠋⠁⠛]

I'm no PHP dev but that seems like a join with extra steps.

It's two separate queries.

My assumption is that this is the kind of thing a retard would do to minimize the time individual SELECTs locked tables- potentially blocking inserts/updates/deletes- rather than just realizing that it was perfectly fine if the display of what users a user was following was retrieved at READ UNCOMMITED level.

 

[Least Concern]

@3119967d0c

Arment expands a bit on his thinking here.

On database joins – Marco.org

archived 7 Sep 2021 05:00:22 UTC

archive.md

Pardon the further web dev sperging, but… No, I don't buy it. Joins might be expensive, but you know what's even more expensive? Making two, three, four, God knows how many queries to the database when you could have just made one. Talking to the database requires IPC which is being done via a local Unix socket if you're lucky and over a freakin' TCP/IP connection if you're not, so the process of making that connection and then waiting for results is slow and expensive itself. And web development must by necessity use async queries since you can't really render a web page you haven't loaded the contents for from the database yet, so every time a query is made, the program screeches to a halt and twiddles its thumbs until the data comes back from the database server - it's very much a goal in web dev to minimize that as much as possible by reducing the number of queries made. Arment's basic justifications here are the same sort of easily debunkable justification for shit coding practices that Mahan makes.

Benjamin also did Hypercritical with Sircusa and Talk Show with John Gruber. Once Gruber threw Benjamin under the bus and went solo the whole Apple crowd followed.

Gruber. Talk about a guy who can't keep his political sperging out of his otherwise decent tech content. I remember getting annoyed when his blog Daring Fireball would get polluted with BDS sperging during the early '00s. (That's Bush Derangement Syndrome to you zoomers - TDS was a spin on the phrase.)

It's two separate queries.

My assumption is that this is the kind of thing a retard would do to minimize the time individual SELECTs locked tables- potentially blocking inserts/updates/deletes- rather than just realizing that it was perfectly fine if the display of what users a user was following was retrieved at READ UNCOMMITED level.

I don't think any commonly-used DBMS locks tables for SELECTs. But even if so, my argument still stands - you're locking a table twice (or three times, or however many - I've written many queries that will join over half a dozen tables) when you could lock it just once.

 

[⠠⠠⠅⠑⠋⠋⠁⠇⠎ ⠠⠠⠊⠎ ⠠⠠⠁ ⠠⠠⠋⠁⠛]

I don't think any commonly-used DBMS locks tables for SELECTs. But even if so, my argument still stands - you're locking a table twice (or three times, or however many - I've written many queries that will join over half a dozen tables) when you could lock it just once.

Yes, SELECTs on their own should be fine. But some default MSSQL configs and, if I remember right, older MYSQL engines, will absolutely let a SELECT lock out insert/update/delete operations, and vice versa.

I can see how.. if you saw that behavior.. it might indeed 'optimize' things to make more, slightly faster, queries (possibly, as he suggests, even having the actual DB connections go to different servers).

Of course, the queries to show the titty pics of Tumblr users you're following should be done at isolation level 0 anyway, so there shouldn't be any locking issues at all. But, that would assume Arment had actually done some research into how DBs work rather than just hacking away at PHP.

 

[Ita Mori]

Biggest thing I got out of the Sept 14 iPhone/iPad/watch reveal is apple loves niggers.
No subtlety.

 

[Dan Abrams]

Biggest thing I got out of the Sept 14 iPhone/iPad/watch reveal is apple loves niggers.
No subtlety.

I came here to ask this. I skipped today's keynote for the first time ever. I guess I assumed correctly that they continued last year's tradition of cramming as many niggers, mutts, and fags into the product presentations as possible and minimizing the amount of time evil straight white men like Craig Federighi get to speak.

Meanwhile Chinese child slaves are working on getting the phones ready for next week.

 

[Least Concern]

No Macs. Lame.

Well, there's rumors of there being education-themed product announcements next month. Maybe we'll finally see some M1X/M2 action there.

I did think it was interesting they announced the new iPads would have an A-series chip instead of the M1 like the current iPad Pro has. I think it makes sense to continue to have a separate chip line for the iOS stuff. But whatever.

 

[awoo]

The cynic in me wants to overlay the obnoxious "California Soul" music on top of footage of homeless people in San Francisco and LA. It has nothing (directly) to do with Apple but the emphasis on California has always been kinda stupid too.

 

[DoubleD]

I did think it was interesting they announced the new iPads would have an A-series chip instead of the M1 like the current iPad Pro has. I think it makes sense to continue to have a separate chip line for the iOS stuff. But whatever.

The only functional difference between the A-series and M-series chips is the way that they are marketed. M1 is basically a tweaked A14.

When the Apple Silicon Macs were getting hyyyype, it made sense to say "You know that awesome new chip we put in our computers? It's now in our iPads too" when in reality the situation was the reverse – Macs are now using iPad chips, but hey, "Your fancy new laptop is now using a chip made for a toy computer" would have been a much harder sell for Mac users.

I do find it interesting, now that the iPad Mini has the 2018 Pro design with the Pencil and USB-C port, how they also gave a spec bump to the the iPad-without-a-name while changing nothing else about its design. Since they only went one generation forward (A12 to A13, in contrast to the Mini, which got A15), I'm assuming this was discussed internally as the minimum viable upgrade to avoid having to discontinue the product entirely.

This also makes it the only remaining iPad with a headphone jack (RIP) and a Lightning port (good riddance). But since Apple don't keep their old products around for legacy ports, I assume its only purpose in the lineup is to be cheap (or at least cheaper than the Air and Mini).

They really made a point to sell us on the capability of iPads (such as by giving them USB-C ports), while also emphasising their portability (dreaming up all sorts of scenarios in which surgeons and pilots might need to use them) - but in spite of this, I've noticed it's a lot like certain other device that Apple sells.

And I suspect the only reason they haven't stuck a USB-C port on the iPhone (and probably the reason it's probably never going to get one) is because it would make people realise their phone does almost anything an iPad can do, and there would no longer be a reason to buy both.

Apple is promoting the fuck out of their iPad (allowing it to cannibalise Mac, but not allowing iPhone to cannibalise iPad) because it's the one market where they are still the dominant player. And so, the bigger the tablet market becomes, the bigger their advantage overall. If they could just manage to usher in a little more of the promised post-PC utopia where everyone uses an tablet with a locked down OS instead of a far more practical laptop, they might just be able to expand their profits for at least another year or two.

Because when a company becomes this big, their main problem is that they aren't able to keep growing. And Apple is running out of markets it hasn't already reached saturation in. iPads are the one they're bettng on. It's either that or fitness videos, and I know which one I'd choose.

 

[awoo]

I feel like Samsung is trying harder to innovate, even if the "108 MP" camera takes comparable photos due to worse software. From what I can tell, Samsung's Fold phones are getting closer to being real phones and not just expensive first-gen tech. Apple finally did add 120 Hz to their Pro models and I think their Pro video cameras are still objectively the best phone video shooters, but the standard models hardly looked like an upgrade.

And yes, there were many folx of color represented.

 

[Least Concern]

Safari 15 is out and seems to have this awful new feature where it sets a custom background color on the toolbar which seems to be algorithmically based on the colors of the web page in some way or other. The result can be ghastly.



Fortunately it can be turned off by going to the "Tabs" section of the Preferences and unchecking "Show color in tab bar." I suggest you all do so after upgrading.

Experimenting with the new tab groups feature. Not quite as in-depth as I was hoping it'd be (something akin to a tree-based tab structure in a vertical sidebar) but might prove useful for doing stuff like separating tabs into personal stuff and work-related stuff. One thing I don't like is that if you have media like a YouTube video playing in a tab but you then switch to a new tab group, the media stops playing (even if it's in the pop-out player) and the page gets unloaded from memory to the extent that it doesn't even save your current spot in the video. Hmm.

 

[malt ipecac]

Safari 15 is out and seems to have this awful new feature where it sets a custom background color on the toolbar which seems to be algorithmically based on the colors of the web page in some way or other. The result can be ghastly.

Fortunately it can be turned off by going to the "Tabs" section of the Preferences and unchecking "Show color in tab bar." I suggest you all do so after upgrading.

I thought the color-changing was kind of cool until I changed tabs. I gave it a shot for about an hour, but it's just too jarring to have your entire window change colors when moving between tabs.

I do very much like the new 'extra'-compact mode. Feels like a deserved "fuck you" to Mozilla after they removed/hid compact mode from Firefox.

The compact mode is odd in that to the tabs change sizes as you cycle through them. It's maybe a bit harder to navigate tabs using a trackpad/mouse, but I've found that when I navigate with ctrl-tab/ctrl-shift-tab, it's actually easier to keep track of which tab I'm in. I can rely on my peripheral vision and know where I am without even looking up.

 

[Least Concern]

Argh, in Safari 15, it's no longer possible to drag a link into a tab to open it in that tab. I'm quite used to doing this particularly when clicking links that I know the site is going to try to open in a new tab or do something other than open in the current tab; for example, the notification bell icon here on KF (you have to click twice in order to see the notifications on a separate page, but the first time you click it, it will mark those notifications as "read" and no longer highlight them when you get to the separate page). Kinda annoyed by that. Hope that functionality gets restored in a minor update soon.

On the other hand, the tab groups synch up between computers. I'm loving that for storing articles or videos or such that I want to save from my work computer to watch on my home computer and vice versa. It was possible to open up tabs on "other" computers/iPhones before but doing it that way is much nicer IMO.

 

[Gar For Archer]

And I suspect the only reason they haven't stuck a USB-C port on the iPhone (and probably the reason it's probably never going to get one) is because it would make people realise their phone does almost anything an iPad can do, and there would no longer be a reason to buy both.

Apple is promoting the fuck out of their iPad (allowing it to cannibalise Mac, but not allowing iPhone to cannibalise iPad) because it's the one market where they are still the dominant player. And so, the bigger the tablet market becomes, the bigger their advantage overall. If they could just manage to usher in a little more of the promised post-PC utopia where everyone uses an tablet with a locked down OS instead of a far more practical laptop, they might just be able to expand their profits for at least another year or two.

Bizarre take, IMO. A USB-C port isn’t the selling point of an iPad, if that were true the device would’ve never gotten off the ground in the first place. Especially considering the first-Gen iPad literally WAS just an upscaled iPod Touch with only the bare minimum software optimization for the larger screen.

Sure an iPhone is technically capable of running most of the same software as an iPad, and if it got a USB-C port it would have access to the various accessories afforded to the iPad, but what the fuck are you gonna do, organize photos and edit video on a 6 inch screen? Possible, yes, but not something you’d do if you had any other option. The iPhone will never be an iPad competitor because ultimately, the main selling point of the iPad is the large size.

If it were still 2012, we could entertain a debate about whether or not anyone even wants a device that’s not as portable as a smartphone and not as powerful as a full-on computer. But the iPad’s been around for nearly a decade now, and despite the mockery and skepticism it faced during its early years, it’s proven that it’s a product people do want, filling a niche that fundamentally cannot be satisfied by either smartphones or computers.

 

[Staffy]

Safari 15 is out and seems to have this awful new feature where it sets a custom background color on the toolbar which seems to be algorithmically based on the colors of the web page in some way or other. The result can be ghastly.

View attachment 2555827

Fortunately it can be turned off by going to the "Tabs" section of the Preferences and unchecking "Show color in tab bar." I suggest you all do so after upgrading.

Experimenting with the new tab groups feature. Not quite as in-depth as I was hoping it'd be (something akin to a tree-based tab structure in a vertical sidebar) but might prove useful for doing stuff like separating tabs into personal stuff and work-related stuff. One thing I don't like is that if you have media like a YouTube video playing in a tab but you then switch to a new tab group, the media stops playing (even if it's in the pop-out player) and the page gets unloaded from memory to the extent that it doesn't even save your current spot in the video. Hmm.

Jeez that looks ugly. Chrome for android pulls this off well. This just doesn't seem to work with that kind of look.

 

[♦️ King of Diamonds ♦️]

I refuse to ever buy another MacBook or iOS device because of the transition they made in 2015 to USB-C. USB work perfectly fine, I don't want to have to shell out extra money for your egregious grift of selling adapters to work with USB-C.

 

[Least Concern]

I refuse to ever buy another MacBook or iOS device because of the transition they made in 2015 to USB-C. USB work perfectly fine, I don't want to have to shell out extra money for your egregious grift of selling adapters to work with USB-C.

It's annoying, but of course, you don't have to buy Apple's adapters; none of mine are. And the desktops still have USB-A ports. And there are persistent rumors that Apple's next batch of laptops will have a fuller compliment of ports again, so hopefully the "thinner by any means" design policy of Apple's laptops over the last decade or so is on its way out.

At any rate, people scoffed at the original iMac because it didn't have any ADB ports or floppy drives. And then they got over it and the thing sold like hotcakes.

 

[Full Race Replay]

Did anybody else update to iOS 15, and their iPhone is not automatically connecting to known wifi networks anymore? I can’t find anything about this online.

 

[Gar For Archer]

It's annoying, but of course, you don't have to buy Apple's adapters; none of mine are. And the desktops still have USB-A ports. And there are persistent rumors that Apple's next batch of laptops will have a fuller compliment of ports again, so hopefully the "thinner by any means" design policy of Apple's laptops over the last decade or so is on its way out.

At any rate, people scoffed at the original iMac because it didn't have any ADB ports or floppy drives. And then they got over it and the thing sold like hotcakes.

And again when they removed the CD drive from iMacs and MBP's.

That being said, I don't think normal USB (what is it, A? B?) is dead in the water yet, and while it's fine for the entry level Macbook to forgo it, there's no excuse to leave it off a supposed "Pro" device.

 

[HumanHive]

Anyone who thinks USB-A is dead is out of their mind.

 

[AnOminous]

Did anybody else update to iOS 15, and their iPhone is not automatically connecting to known wifi networks anymore? I can’t find anything about this online.

No but thanks for the note, I'd forgotten to turn off automatic updates so I just went and did that. They always fuck up the major version number changes.