I absolutely agree, but timestampz as a column type is of little help here, because no actual timezone info is being persisted, ever.
> I think best practice is to have PostgreSQL run in UTC and always store a time zone, that way you're always aware of time zone info and aren't restricted in the future.
I'm baffled by the insistence that "users" (backend services, really) should avoid timestamp in favor of timestampz.
I literally DO NOT understand, how is this good advice.
My backend service exists in some abstraction of a Linux environment, with a fixed timezone, most commonly UTC.
It maintains a pool of connections to Postgres, all sharing the same Postgres user, and the same timezone.
Why on earth would I prefer a timestampz to timestamp? Why would I even involve the server timezone into this equation?
I want to store timestamps in a uniform way, I store them in UTC as timestamps. If I stored them in a timestampz column, if the server timezone were to adjust, I'd get literally different values.
If I want to store timezone values per user (of my service), or per operation (that my users perform), then again, surely I have to handle that users move and change their timezones. Again, how does timestampz with its reliance on the connection timezone serve me?
It's me, I'm the person who's been waiting for this watch.
I want a nice-looking, curved-screen watch that feels snappy and fluid and has a non-terrible UI (so not Samsung or FitBit), has decent Wear OS update policy (so not Huawei or Xiaomi), and is compatible with an Android phone (not Apple, which otherwise would be ideal).
I guess they made the watch for me personally. I will buy it while fully realizing they will drop it before the third year comes — at least I'll have a nice Android watch for these two years.
That's hardly a point of view and more of a knee-jerk reaction. From whataboutism to half-hearted attempts to cast the article as antisemitic to the cynical "so what?" as if the conduct described by the NYT is not so clearly illegal.
Seems incredibly like an intentionally style-less, script-less version of HTML: a tree structure of blocks, tables, lists etc with simple actions like "show", "hide" and "submit form".
>You have a lot of USB-A QC chargers, and you just take a usb A -> C cable
Why would you assume it would work? Just because the connectors fit together?
Both my computer monitor and my TV have two HDMI input ports. Should I fault the HDMI protocol (and any connector standard where server and client sides are physically identical) that I can't daisy-chain them?
My grandma has a microUSB Android tablet and a microUSB feature phone. I set up for her a dual USB-A charger and two identical microUSB cables that are always plugged in, so she can use either one or both.
I don't quite see the problem with the USB-C setup either: get several high-powered chargers for her so that she can use whichever one.
But I get it. The times really did have changed; one piece of information - the wattage of the charger - that was hidden from the consumer is now reified: all chargers fit, but only some of them are powerful enough.
Fortunately, it's mostly a question of comparing integer numbers: my phone's 25W, and the charger is 30W - it fits! My laptop is 45W though, bummer. I should get a >=45W charger for it.
But for that nuisance we traded away the obnoxious burden of distinguishing between Pump Express and QuickCharge and Adaptive Fast Charge and Adaptive Super Fast Charge, between Lenovo thick or thin barrel plugs or yellow rectangle plug, between multiple generations of Apple laptop plugs, of insane proprietary connectors like Nikon's UC-E6, of having to power hubs externally (thank god for 15W minimum), of the anticonsumer pricing of the vendors' proprietary tech, and (fingers crossed) of the ridiculous mix and match approach Apple has to its iPhone and iPad lines.
It seems to be a good deal.
By the way, I fondly remember a Sony Ericsson K510i I had in high school :) That toothy connector was finicky as hell (something I'm reminded of by lower quality USB-C hubs).
True! I literally own two identical-looking (to the most minute details of the plug itself) barrel plug chargers (one for the vacuum, the other for the elliptical trainer). One is 18V, the other is 9V, both 500mA
At least I'm not afraid that the 65W USB PD charger will fry my phone lol
There's a lot of doom and gloom here; let's see if it really got that bad.
>You need a PD charger and not a QC charger...
Impossible, all USB-C QC chargers are also USB PD chargers.
>into the correct usb port to charge the laptop
The port is either marked (everything but MacBooks) or doesn't matter (MacBooks, pretty sweet).
>buy an original charger for your laptop
Good! Now you have a USB PD charger that covers your laptop and also every device you own that's lighter in wattage. Less chargers to pack when travelling :)
>you're back at where we were 20 years ago
No, not at all. 20 to 10 years ago all charging ports (including on cameras, phones, everything) were barrel plugs of slightly different diameter; everybody's cranking out their own boxy black chargers putting out maddening variations on the same ~20V for laptops and 3-5V for smaller devices, you can't share chargers between devices, can't always find the replacement, especially if the device is on the older side. Buying a device with a different connector - bam, old charger goes to e-waste (or e-bay).
>but it won't charge. You need a fast charger...
EU makes it mandatory to say on the packaging what wattage the device needs, and what wattage the chager can provide. Granted, the laptops are not covered by the EU proposition in question yet, but have patience, we don't now have those 240W chargers for nothing :)
*apparently active Thunderbolt 3 cables are an exception and won't work.
But it's better not to rely on Thunderbolt 3 cables to be valid USB 3 cables.
Of course, it's better now with Thunderbolt 4 where every Thunderbolt 4 cable is also an honest to god USB4 cable, and it's not as confusing for the consumer.
They already had USB4 cable logos denoting either 20Gbps or 40Gbps (still on the USB-IF website). This is in fact a rebranding, and the first USB logos since the very beginning of the standard that don't feature the trident.
Or are you concerned that the app is not compatible with the Android 9-based custom ROM you are rocking?