skysight-inc/HackerNews huggingface dataset:
Don't forget the venerable SQLZoo - I have referred a zillion people to it over the years. https://www.sqlzoo.net/wiki/SQL_Tutorial

Edit: also an inaccuracy that's minor but can bite you if you're not careful - they mention temporary tables are in memory not on disk - that's not true in almost all sql databases, they are just connection specific eg they don't persist after you disconnect.

Some databases are optimized for a temp table to be a throwaway, but that can be a good or bad thing depending on the use case.
I seem to sleep as well as I always have.

I go to bed when I am tired. Usually 11pm-1am. I fall asleep in a few minutes. Then I wake up about 7am, feeling OK. Closer to 6 hours is more normal for me.

I’ve been like that since I was a teenager and I didn't drink coffee then.
It's because journalists will ask Putin questions that he doesn't wish to answer. Tucker Carlson will not.

Russia arrests, imprisons, and poisons journalists doing actual journalism:

https://www.theguardian.com/world/2023/mar/30/russia-arrests...

https://www.reuters.com/world/europe/dozens-detained-moscow-...

https://www.reuters.com/world/europe/russia-investigates-jou...

https://www.bbc.com/news/world-europe-60749279

https://www.cbsnews.com/news/russia-ukraine-war-critic-vladi...

https://www.theguardian.com/world/2023/feb/23/russian-journa...
HTC couldn't even if they wanted to. it's a long time from their windows mobile and android innovative days.

as a standalone it's best in class minus 6dof gaming. people are excited for the future of this and other products
Yes. I don't mind the occasional JSON[B] column when it makes sense, but it should not be used as an excuse to not design a good schema. In general, if you find yourself trying to fit a non-scalar value into RDBMS, you should reconsider the data model.
Value of technology is not why people aggregate towards Bitcoin.

Otherwise it would've been long superseded by other chains.

Bitcoiners still arguing about the solidity of the network guaranteed by so much mining, yet virtually all the mining is in the hands of few specialized operations all knowing each other (so it's not really decentralized) and despite Ethereum proving new protocol to be a valid and safe alternative.

None of Bitcoin cultists at the end of the day understood that it wasn't about algorithms nor computers, but consensus among people.

And that consensus voted to have Bitcoin, the oldest and least technologically developed chain to be the "store of value" of cryptocurrencies.
Humanity's most distant space probe jeopardized by computer glitch
A better title would be Tesla issues "OTA Update" Recall on Almost Every Vehicle...

That would be a good headline if PCMAG was interested in informing their readers.

Clearly they're not interested in doing that. They're interested in getting clicks.
On one hand I agree with you.

On the other hand, if someone recored my whole work day every day I would not be happy. I don't think you would stay at your job of that was a condition of it.

There has to be a better solution to this issue.. extended recordings in an emergency, triggers based on conditions, private keys for pilots... IDFK, cause I try not to get involved in engineering that might KILL someone.
What do you dropper mix in? Other shakes?
Interestingly, France and Germany are getting serious on this. Looking forward to see more of these.

https://www-adac-de.translate.goog/verkehr/recht/verkehrsvor...
The guy can do whatever he wants of course. Let's just not call him a "journalist", please.
Chain migration is great imo.

Immigrants arrive with a built-in support system that get them off the ground when they arrive, a safety net and most importantly, someone that they can trust. All in ideal circumstances anyway.

Corporate migration puts immigrants at huge risk of abuse and failure if things don’t go as expected.

A lot of immigration happens somewhere in the middle.

Canada’s points system isn’t that robust, but I guess less problematic than a straight up lottery.
Because it's still theory 7 years after announcement it has been proven again and again to not be a real alternative.
My experience with Kubernetes has been mostly bad. I always see an explosion of complexity and there is something that needs fixing all the time. The knowledge required comes on top of the existing stack.

Maybe I'm biased and just have the wrong kind of projects, but so far everything I encountered could be built with a simple tech stack on virtual or native hardware. A reverse proxy/webserver, some frontend library/framework, a backend, database, maybe some queues/logs/caching solutions on any server Linux distribution. Maintenance is minimal, dirt cheap, no vendor lock-in and easy to teach. Is everyone building the next Amazon/Netflix/Goole and needs to scale to infinity? I feel there is such a huge amount of software and companies that will never require or benefit from Kubernetes.
The surest way to fail is to blame your parents.
IMO the biggest problem with Mastodon is that for a while decentralization was the biggest selling point. It led to the place being full of a lot of pedantic dorks. The situation did improve as Twitter exploded and various communities migrated in herds though.
Obviously 90% of readers just view the headline and don't read the article.

Misleading people through omitting important details in the headline is journalism 101 nowadays.
The Ethereum Name Service (ENS) provides this functionality in a standard protocol. You can associate Microsoft.com with an ETH, BTC, SOL, etc address. GoDaddy yesterday actually integrated this in a no-gas free manner [https://aboutus.godaddy.net/newsroom/company-news/news-detai...]. Other DNS providers will likely follow suite over the next few years.

Bonus, most web3 tooling already supports ENS so no jumping through hoops most of the time.
Yes, this is my main motivator when I cut back.

If I have to drive a long drive, as an example, I’ll skip coffee that day. I’d rather save stops.
It's not the EKS upgrade part that's a pain, it's the deprecated K8S resources that you mention. Layers of terraform, fluxcd, helm charts getting sifted through and upgraded before the EKS upgrade. You get all your clusters safely upgraded, and in the blink of an eye you have to do it all over again.
You can do it Vancouver. Seattle and Vancouver’s homelessness problem are remarkably similar, only differing in how Canada handles it better than the Americans do.
How much data can a toothbrush collect? Surely just a few hundred bytes per brushing session. The ESP32 has 160 kB of usable RAM out of the 520 kB total capacity. Surely enough for weeks of data even if the data structures are badly designed.
Facebook lawyers
Well Amazon CEO himself said, there is no shortcut to experience. I am sure gaining experience in developing infrastructure solution will give you respectable return in long term. Of course Cloud vendors will be happy to sell turnkey solutions to you though.
Clicking on the names at the top of the readme, it appears as though it is a collaboration of researchers both inside and outside of Apple.
I don't disagree about what the problem is. I just think this particular solution will cause more new problems then the old ones it will theoretically solve.
Rumor has it the controls are there, but subvert-able.

Apparently, there are two ticketing systems (one for "history of plane," Boeing internal, and one for "day-to-day onsite work," visible by contractors and Boeing management). The work to fix the rivets was logged in the day-to-day, but management and the onsite staff managed to convince themselves that merely opening the plug to fix the vacuum-seal trim did not constitute "removing" the plug, and since there was only an entry in the history-of-plane log for removing, not opening, they didn't log it there (when the intent was "there's no entry for 'just opening' because there's no such thing as 'just opening', breaching the pressure vessel at all constitutes 'removal of plug'").

The final inspection that should have caught the error would have been triggered by the update in the history-of-plane ticketing queue.

(And as for 'how many non-conformances,' the same source claims that Spirit is one of the few subcontractors with on-site staff at the factory because their parent company delivers such consistently shoddy out-of-compliance product that they are continuously doing final warrenty-work onsite. So maybe "fire that vendor" should be on the docket too).
I agree with the parent post in that it's mostly marketing. There was nothing preventing you from calling back and forth from cloud services on your mainframe before the recent marketing shift to "hybrid cloud". Hybrid cloud is a meaningless term on a technical level, but I guess for buisness people it means you can buy a new mainframe and that won't stop you from delivering "cloud" or whatever other initiative the suits have budgeted for.

So yes, its laughable to hear that kind of marketing if you are technical. But for the kinds of large organizations that would potentially be buying a new mainframe, its what you need to get this sort of thing budgeted.

Certainly the IBM systems group didn't come up it. They know just as well as the people trying to upgrade their mainframes that it's an on-premises strategy primarily intended for line of business applications with reasonably well understood resource utilization.
Why is that even a real need?

All crypto cultists I know don't give a damn to give all of their info to any provider, out there, be tracked everywhere "they already know everything" and yet there is a problem for a 1$ donation on some random website when they using their real dollars online for literally everything.

Also, there's literally 0 ways other than bartering to get bitcoins really anonymously, and the number of people able to transact while staying anonymous is below 0. You need to take your credit card and pay for it on an exchange, so it's not anonymous.

And the anonymous chains are borderline ignored, because being anonymous is really not what drags people into Bitcoin, but the hope of finding a fool paying more than they did.
The main problem with GPU architectures is that the manufacturers hide their details from us. Hell, they don't even document the instruction sets! At least NVIDIA doesn't. And they often don't tell us what the hardware actually _does_, and rather offer a mental model of how we can think about it.

Specifically, those structural diagrams of functional-units within SM's you see in the blog post? That comes from NVIDIA. And they explicitly state that they do _not_ guarantee that this is what the hardware is actually like. The hardware works "as-if" it were made up of this kind of units. And even more specifically - it's not clear whether there even is such a thing as a "tensor core", or whether it's just some hack for doing lower-precision FP math somewhat faster.

-----

Anyway, if the architectures weren't mostly _hidden_, we would make them far less mysterious within a rather short period of time.
Disney, Fox and Warner Bros. Join Forces for Sports Streaming Service
If most infra I worked on was a single region one, sure. :) DR is so much easier in the cloud. You can have ECS scale to 0 in the DR site and when us-east-1 goes down just move the traffic there. We did that with amazon.com before AWS even existed. With AWS it became easier. There are still some challenges, like having a replica of the main SQL db if you run a traditional stack for example.
Where did you read that SEPA is free? Thats not true.
You know, I've only ever had one bad experience with cannabis, and it was only bad for like 30 minutes or so (though it felt much, much longer). I made edibles, and I'd never made them before but I followed online instructions very precisely and ended up, by accident, creating extra-potent brownies.

Now, I knew before taking them how potent they were, I was licked the mixing spoon the night before, just a tiny bit here and there, and even that little bit was enough to make me relatively high. But when my friends saw how tiny the doses were, they thought I was being crazy and we all ended up getting each other to take waaaay to many, especially me, the host, which was an especially bad idea because within an hour I'd gone into my room, gotten into bed, and put on some youtube video to calm me down. Well, not very long after getting into bed I had this feeling of immense warmth and comfort, and I got super blissed out and my friends would come in to check up on me and I just gave them a thumbs up with a massive grin on my face. At some point one of my friends joined me in my room, and then sometime later I rejoined the party, which was getting along fine without me, and then we dispersed after we started to sober up.

So, all in all, it was a good experience. But I got super fucking high and I was literally starting to lose touch with reality before I sequestered myself, and my heart was beating out of my chest so hard I thought I was actually going to have a heart attack and die. I think it was easier for me to handle since I've had experience with fairly high doses of psychedelics in the past. I suppose alls well that ends well.
This is simply not true. AOT requires code that is free of uses of JIT-specific features like runtime reflection-emit or assembly loading, which is not possible without build instrumentation for AOT implementations on other platforms either[0], because it by definition needs a JIT compiler. Reflection itself not only works but is sometimes faster because closed world guarantee by AOT allows for a more streamlined implementation.

With that said, trimming, also known as tree-shaking, which is required to not have massive binary size, has to know at compile-time which types, members and metadata tokens are reachable. This means that certain patterns of unbound reflection are by definition not statically analyzable and require the user to annotate (with [RequiresUnreferencedCode(params)]) the corresponding types with details of what they need the trimmer/linker to preserve (the entire assembly can also be rooted but, well, that's bad for size).

Other features like compiled expressions have received proper interpreter fallback which makes them just work(tm) without developer intervention.

You can also see that GraalVM Native Image is subject to very similar restrictions[1].

[0] Like pre-generating generic types/method bodies for Unity with special tooling. NativeAOT currently has (planned to be deprecated) rd.xml to manually instantiate certain generic methods and root specific types, replace their bodies, etc., it will probably be fully superseded by further expansion of attributes-style annotations API or obsoleted by improving compile-time analysis in the future.

[1] https://www.graalvm.org/22.1/reference-manual/native-image/L...

p.s.: quick search shows that Java Swing is plagued by similar issues with Native Image (not mentioning having to generate metadata annotations) to making .NET's GUI frameworks work with NativeAOT save for certain blessed templates/workloads introduced in .NET 8. Java AWT appears to be faring somewhat better on hello world examples but I suspect it experience the same fate as the templates for WinForms that the community has come up with so far (let me know if that's not the case).
Per the article, "Habitual coffee intake was self-reported as cups per day, as part of the touchscreen questionnaire at base line with the question ‘How many cups of coffee do you drink a day?’ "

Sounds like it's based on the colloquial definition, which means... who knows! Self-reported values are very non-specific, since my definition of a 'cup' could mean a 24oz with an added triple shot... or it could mean a weakly brewed cup of instant coffee.
> Because it hurts EU customers by not applying the rules worldwide.

It’s an entirely expected outcome for wanting to enact one-of-a-kind laws that force a foreign company into doing something they’ve obviously wanted to avoid.
It's also slang for ejaculation, so there's that.

As Lil Jon might say,

To the window, to the wall!
Til the sweat drop down my balls
Til all these bitches crawl
Til all skeet skeet motherfuckers, all skeet skeet god damn!
Til all skeet skeet motherfuckers, all skeet skeet god damn!
> But you will usually read little in them about all the things that provided the basis for the success stories but which had nothing to do with the protagonists personally, like being born to wealthy parents in a socially and economically stable country with myriad educational and commercial opportunities. The message from this literary cottage industry is that where there’s a will, there’s a way. ‘Leaders’ are ‘winners’. They built themselves up and achieved greatness through their extraordinary qualities. They made their own history.

That's because it is largely true. There are a ton of people who are born into opportunity but never really leave their mark on history other than their position. For example, how many Pharaohs can you name?

Yet, there are people who have an impact far beyond their circumstances. An example is Temujin, whose father was killed when he was young, and he had a very hard early life but later became Genghis Khan one of the greatest rulers in history.

Octavian was born into wealth, and his uncle Julius did adopt him, but the odds were heavily stacked against him, but he became the founder of the Roman Empire, kicked off the Pax Romana, and became known in history as Caesar Augustus.

When Philip II came to the throne, the Macedonians had just recently suffered horrible defeat at the hands of the Illyrians and he was just a regent. He ended up becoming king, built the phallanx, and conquered Greece which was far wealthier than Macedon.

His son, Alexander, sure he was king, but Greece and Macedonia were just a backwater compared to the Achaemenid Persian Empire which probably ruled over a greater percentage of humanity than any empire before or since. He ended up conquering that Empire.

Sure, there are trends in history. Sure, many "Great Men" (and women) were born into privilege. But they end up doing something far greater than people in similar circumstances and make an inflection point in history!
Yeah, the new problem is arm count.
> I've mourned otherwise pristine machines with ugly gouges in their cases that neatly fit where the power cord had been. This is due to the plasticizers in the cord which will also plasticize the hard plastic shell of the computer itself — and you don't want that plasticized.

Whoa, I never knew this was a thing. I always unplug connectors when storing things because you never know if they're going to get banged around and weaken the connection, but for non-removable cords I would usually wrap them up since there's normally a strain reliever on there.
I'm not an accident investigator and don't know what exactly would turn out to be useful, but I think changing your intuition for why we study the CVR away from "because there might have been a large pilot error" to "so that we can learn more about how pilots react to emergencies with a goal of seeing if we can come up with process improvements" may help. If there was some aspect of the response that was not perfect, we could develop training on it for other pilots, right?
I find it a genuine quality-of-life improvement to adjust the color of light. The temperature matters more, but being able to do strong hues is really nice. Not everyone is into mood lighting, but I like it.

And I don't care as much about whether or not the bulb uses IP to reach my phone, but why should my outside connection going down ever matter? As long as the router has power, the internal network should continue to function. It's a shame is what it is. I figure I could put in the sweat to make it "work on my machine" but that doesn't solve Joe Normal's problem, and it doesn't sound like a fun hobby to me either.
https://archive.ph/XCRpa

http://web.archive.org/web/20240205170646/https://www.semafo...
As I noted "Buying lots of things in order to resell them is more complicated than buying just one or two things for yourself". Both of the links you provided to cheaper sellers are not set up for bulk sales. The one on Amazon has a link for buying in bulk, but that only goes up to 999, and if you put 999 in for the quantity in their bulk page, it won't let you because they only have less than 100 pcs available. And the aliexpress link has a hard limit of 1 per customer. These are not reliable wholesalers, and when you're sourcing for retail, you need reliable wholesalers. When you're sourcing wholesalers for retail, you need someone that you can buy from in bulk repeatedly. Often you also want a wholesaler who'll let you set up payment terms (net-60 is pretty common) so you don't have to pay for the inventory up front. I'm fairly confident that if you looked and found a bulk wholesaler for this item that offers terms, the per unit cost is going to be closer to the Adafruit price than to the Aliexpress price you quoted. And then Adafruit marks it up, not to "prey on well meaning but clueless electronics hobbyists" but to cover the costs of doing business, like any retailer. These costs include shipping-from-wholesaler, warehousing, preparing when the item purchased is not in the final sellable state, adding photos and copy to website, adding educational resources, etc etc. Some of the costs are one-time costs and some are ongoing costs or recurring costs. Running a retail business isn't cheap, especially in the US. Note that LOAMLIN and Xnbada (the two "companies" behind the links you provided) have zero web presence beyond storefronts on Amazon and/or Aliexpress. I can't even tell you where they're shipping from (though it's highly likely it's China or somewhere else where labor is very cheap), let alone who owns/runs them. There's no accountability whatsoever besides the comments on their listings, which doesn't mean much these days. There's no product support besides _maybe_ being able to return (to China?) for a refund. If you're OK with all of that, then yes, buying from them makes more sense for you. But that still doesn't mean that Adafruit is price gouging.
You're conflating the right to do something with whether it is advisable to do something.

Sure, you are ~allowed~ to begin an immediate descent in an emergency, but it is not a good idea considering from the pilot's perspective, the bang is most likely an engine going out and altitude is always your friend in this condition.
The issue with police body cam audio is that they are regularly recording non-police who do have a right to privacy. That's not an issue for pilot cockpit recordings. (If it is, you've got an incident that should be recorded.)

The muting you observe of police footage isn't of the first part of the audio, it's the prior 30 seconds from before the record button is pressed. They have a constant buffer going, as things can happen... unexpectedly.

This caught a cop in Baltimore; he wasn't aware of or had forgotten the feature. The 30 second buffer caught him planting drugs, then faking the finding. https://www.npr.org/sections/thetwo-way/2017/07/20/538279258...

Side note: It took years to charge him (https://www.baltimoresun.com/2020/03/09/caught-fabricating-e...) and he served no jail time for trying to send an innocent person to jail (https://www.wbaltv.com/article/officer-testifies-in-own-defe...).
Yes. As I said. The existing system can remain in place, with all of its existing high-temperature-tolerant components.

In addition to not giving up that requirement, we could also add a longer, not-heat-tolerant storage. If it gets destroyed in a fire, see the above paragraph. If there is an incident where the data is of interest and the aircraft is not destroyed in a fire, then this will maintain the data long after the above system has deleted it.

No one has advocated giving up the high temperate storage.