Either do a left join and repeat all the post values for every tag or do two round-trip queries and manually join them in code.
JSON_ARRAYAGG. You’ll get the object all tidied up by database in one trip with no need to manipulate on the receiving client.
I recently tried MariaDB for a project and it was kinda neat, having only really messed with DynamoDB and 2012 era MsSQL. All the modern SQL languages support it, though MariaDB and MySQL don’t exactly follow the spec.
HIPAA doesn’t even require encryption. It’s considered “addressable”. They just require access be “closed”. You can be HIPAA compliant with just Windows login, event viewer, and notepad.
(Also HIPAA applies to healthcare providers. Adobe doesn’t need to follow HIPAA data protection, though they probably do because it’s so lax, just because you uploaded a PDF of a medical bill to their cloud.)
Burn-in is a misnomer.
OLEDs don’t burn their image into anything. CRTs used to burn in right onto the screen making it impossible to fix without physically changing the “glass” (really the phosphor screen).
What happens is the OLED burns out unevenly, causing some areas to be weaker than others. That clearly shows when you try to show all the colors (white) because some areas can no longer get as bright as their neighboring areas. It is reminiscent of CRT burn-in. LCDs just have one big backlight (or multiple if they have zones) so unevenness from burnout in LCDs is rarely seen, though still a thing.
So, OLED manufacturers do things to avoid areas from burning out from staying on for too long like pixel shifting, reducing refresh rate, or dimming areas that don’t change for a long time (like logos).
There is a secondary issue that looks like burn-in which is the panel’s ability to detect how long a pixel has been lit. If it can’t detect properly, then it will not give an even image. This is corrected every once in a while with “compensation cycles” but some panels are notorious for not doing them (Samsung), but once you do, it removes most commonly seen “burn-in”.
You’d have to really, really leave the same image on your screen for months for it to have any noticeable in real world usage, at least with modern OLED TVs. You would normally worry more about the panel dimming too much over a long period of time, but I don’t believe lifetime is any worse than standard LCD.
TL;DR: Watch RTings explain it
Recently, Mr. Lawrence said, customers have been snapping up used Teslas for a little over $20,000, after applying a $4,000 federal tax credit.
3rd sentence?
I’ll share the rest because the paywall:
Carmakers including Tesla, Ford, General Motors and Stellantis, the owner of Jeep, have announced plans for electric vehicles that would sell new for as little as $25,000.
More than half of the used electric vehicles on the market sell for less than $30,000, according to Recurrent, a research firm that focuses on the used E.V. market.
Wow, you think Teslas are “Chinese EVs”. You’re literally the first person I’ve encountered to think so. Also why lead into an article with a graphic of the least selling vehicle?
Doesn’t stop it from being misleading.
It’s called “burying the lede”.
In China. But the majority of Teslas are manufactured are in China, and no one really considers Teslas “Chinese cars” or “Chinese EVs”.
People can beat this game with their eyes closed.
Well, I feel misled. The graphic shows a Volvo as a Chinese manufactured vehicle.
Sales of Chinese made EVs in Australia
- Tesla - 46,116
- BYD - 12,438
- MG - 5,928
- Volvo - 3,949
They’re counting Tesla as a Chinese EV.
I didn’t really care about this thread until I read this comment.
VSCode will add a yellow box around the character and tell you it’s an uncommon glyph.
https://code.visualstudio.com/updates/v1_63#_unicode-highlighting
To note, this came about because it could be valid code and it’s a security risk from copy/pasting malicious code. See:
Ask her what she thinks about immigrants and minorities.
Judkins said that after the finger test, a lead cybertruck engineer at Tesla said he did the video wrong.
Steam has limited rollback support from the command line which we had to do plenty of times for Starfield when working on Luma. Sometimes updates are small. Sometimes the entire exe gets reshuffled so you have to find where to patch the exe all over again.
All the versions are apparently there. You just need to download the “depot” and it’ll dump into a folder. From there you copy that folder over your game directly.
It also works the other way around. I can download the depot for the latest version and stay on the version I’m at. It’s useful to pick apart and diff what was actually changed.
Why they can’t add that as an option I’m not sure. That seems more of a UX/UI issue rather than a technical one (like avoiding people using old versions on the web server).
I was about to mod the game for HDR and then found out news of FO4 getting updated.
Updates break mods. Just how it is. Though, after seeing the work needed for modding Starfield after each exe change, I’m doing shader replacement now. As long as they don’t change from DirectX, I should be good.
Edit: Nevermind. Somebody asked me for help and got roped in. Got HDR working. Let’s see if it actually lasts.
Your dad is right. On desktop, navigation is on the left. On tablet, you shrink it to a rail. On mobile it should be a dismissible nav drawer.
The top menus, especially the flyover(on mouse hover), are bad for accessibility because they convert a non-committal action (hover) to a context changing one (focus). It’s a uniquely web-only invention and thankfully falling out of usage. (Unless you mean menubar/toolbar. Those are fine but extremely rare on Web.)
I’m enjoying my Plex one and Nexus Mods. The latter one was in 2013 and cost me $40. Today the yearly subscription is $70.
The problem is it’s a script that logs onto Haier’s servers with the user’s email and password and starts polling for data. Considering that most designed usage is probably based around users every once in a while checking and adjusting their thermostat, just one user with an HACS install doing a poll every minute is 1440x more usage than the next who checks it once a day. If HACS uses were the majority of traffic for these devices I wouldn’t be surprised by that metric.
That’s what probably meant by the ToS because the users using it are probably violating it, and the addon can be considered as something that makes violating it easier (it doesn’t have a secondary purpose other than using a set of credentials that are only given after accepting the ToS).
I’ve had crappy “Smart” ACs and Samsung was the absolute worst. At random times their AWS instance in Europe would go down or their app wouldn’t respond. I gave up and coded my own script to directly interface with the device over the local WiFi. You cut Samsung completely out of the equation. You don’t have to worry about their servers not working anymore. That’s an ideal way for an add-on to work. Ideally most of the script can be retuned to work directly with the device.
The way his content is structured and edited is like junk food for your brain. There’s a formula that appeals to the
leastlowest common denominator and he (his team) excels at it.The topics he picks usually hit some nerve of vicariousness (game shows contestants) or suspense from wanting to know what happens next (challenges and clickbait).