skysight-inc/HackerNews huggingface dataset:
> SQLite plans are unfortunately not the most enlightening

> sqlite> explain select

About 5 years ago, sqlite introduced EXPLAIN QUERY PLAN to get something more like what other databases give with just EXPLAIN.

https://www.sqlite.org/eqp.html
I loved that game. Played it on my 8086 with CGA graphics in the early 1990s.

Check this out:

> Chopper Commando, a DOS game written by Mark Currie using Turbo Pascal in 1990

https://blog.loadzero.com/blog/chopper258/
That’s a misattribution. Not bringing your phone means you are choosing not to do something perfectly legal due to abuse of power — and doing so is likely to encourage further abuse because the culprits know they are less likely to be recorded.
LAX_FREE_AIRPORT_WIFI
This is very nice. It's a good tool for academics wanting to engage with the work of other academics.

I think, however, the biggest issue with scholarly communication right now has to do with how inaccessible the language and techniques tend to be for the average person. Of course, a highly technical paper needs all those details. But I believe we should be looking at requiring authors to maybe make an "extended abstract" sort of deal when submitting articles.

More in line to what you see from news sites who would be reporting on your article, but in a way that will obviously be more accurate; as journalists might overlook important details. The language we use matters so much.
Crates.io doesn't need to die necessarily. It needs some competition as a wake-up call.

Once a better alternative is out there, crates.io will either wither and die or improve. If it matches its competition in terms of quality and reliability, everyone is better off. If not, the alternative solution will take over.

I'm eager for this crates.io alternative to land, assuming they don't break too many projects in their improvements.
Nice! It looks like they were vendoring their own copy of it, and don't have to anymore. Now they're using `swift-certificates` and `swift-asn1`, which both got open-sourced in May.

That's why I try to push back when people say Apple "doesn't care" about server-side Swift – they're regularly releasing these packages that they wouldn't bother open-sourcing and maintaining if they "didn't care." Things like NIO-based implementations of IMAP and SSH, an OpenAPI generator & runtime, HTTP type abstractions, a Cassandra client, etc. Most of those are from the last year, in addition to those certificate packages. They're paying teams of full-time employee salaries to work on this stuff, including open-sourcing it.
Home help for eight days after giving birth – Dutch maternity care
To close the loop, Rust doesn't include a `null` type and you wouldn't encounter something comparable in idiomatic Rust (because you'd be using eg Option::map to handle None cases gracefully), so this is a class of test that would be common in Java and C that is close to irrelevant in Rust.
I wrote userscripts to speed up annoying MS and okta logins, like the ones where you have to click to send a 2FA text or click a stupid checkbox to stay logged in. I also wrote one to show what I call "spending cash available" (cash minus credit card balances) on personalcapital. Plus I found one that turns youtube shorts into normal videos. Fun stuff.
This is a nitpick, but I think this is a bad mental model of most lisps:

> Since the compilation unit of most Lisps is a form instead of a file like on most other languages, the core of the ClojureScript compiler can be seen as a program that will take a string representing a Clojure form as input, read it, recursively parse it into a tree of expressions also known as an AST (abstract syntax tree), and then walks down the tree emitting strings containing JavaScript code.

There might be a string representation of the code, but one thing that’s unique about a lot of lisps is that the input to compile/eval is not text: there is usually a function called something like “read” that turns the textual format into normal lisp objects and then eval can take any lisp object and evaluate it. Typical lisp objects are “self-quoting”, but what characterizes a lisp is that the domain and codomain of eval are the same type.
Here's a better explanation by somebody smarter than me about why Rust chooses what it does, what else you could choose and what the price is: https://without.boats/blog/why-async-rust/

tl;dr: You can have different (nicer to program) abstractions, but you can't have them in the same language you use to write firmware for a $10 electronic device, or Linux drivers, and we already have languages like Go and Javascript whereas we did not have a safer alternative to C++.
> It's not a spectrum where people eventually just dismiss extremely concerning things because someone made something cool.

That's the matter of the question. Elon Musk has some significant achievements which shouldn't be dismissed just because he behaves less than perfect somewhere else.
Would like to know the research.
Correct.

This analysis misses a LOT of economic factors.

As well as corporate control factors.
Apple support seems to come and go in waves depending on when the last time someone looked at the expenses were. In my time working there, we'd have months where everything was by the book and the book was the Apple Care service contract written up by the lawyers, or where every customer got the hard sell on all the metrics (they didn't have many but those they had we needed to push).

We also had months where one could get assigned to spending 3 whole days helping a customer port all of their emails and photos out of a corrupted windows outlook installation over to their new mac for no other reason than they'd asked for help getting it done.

Or where you would be celebrated for spending 5 hours with a 65 year old grandmother buying her first computer carefully going over all her needs and specs and down selling her from what the competitors had convinced her she needed (seriously, no 65 year old grandmother getting her first computer needs the hardware or associated software to cut together professional film in order digitize her collection of VHS home movies) and finish up with a sale of maybe $1300 and directions to competitor down the street because they have better photo printers than the few we carry in stock all on the (IMO correct) theory that a customer who can trust you to exactly what they need and nothing more and send them to a competitor for a better product is one who will come back again and again on the basis of that trust.

I don't know how expensive those two interactions were in the short term, but I do at least know that 65 year old grandmother became a regular customer and could not stop telling all the other customers how much she loved us. For as many problems as I did have with how Apple hamstrung their people, I do wish more companies were even half as good as that.
It’ll show up in Find My even if it can’t connect to the internet. BLE and UWB both work offline.
> people will NOT understand a roundabout with more than one lane

We have tons of 2-lane ones and everyone understands them…
The author had the incredibly genius idea of making a website that doesn't work on the most popular browser. Ridiculous.
How is this a good decision? You have to alias packages when names collide
dang-mode for days?
Re: async, rust is a down to the metal language. IE library yes, runtime no. Async implementations are all either runtimes (Javascript), or libraries that implement a runtime (Python). Under the circumstances I think it's fair that rust has less than ideal async.

I still like threads, but the I'm old and uncool.
Missing a timed transfer and having to wait 15 minutes is awful. Why did I miss my last timed transfer? Police activity on BART (again).
Because it installs like 100,000 python scripts of mystery origin that run with full privileges. Even if the maintainers are unlikely to be malicious on purpose, it only takes one person accidentally putting a typo in a dependencies file in one of the hundreds of packages it imports... many of which not commonly used ones.
The mouse cursor moves at like 10fps, even on the main menu before you've loaded anything. It's really comical.
Segfaults are not actually even the worst outcome, corrupting the program state yet still trucking along can lead to far worse consequences.
In my opinion, until you have spent a lot of time debugging C/C++/assembly issues (memory corruption, null pointer crashes, segfaults, build system problems, exception inception, etc), Rust would probably seem like a total waste of time.
When one of the space vehicles was doing a swing past Earth, for speed, Carl Sagan asked NASA to turn their equipment to the Earth and see what they could detect.

The surprising outcome was that the tools aboard that particular probe was unable to determine life on Earth, even when swinging in orbit around it.

Mind you, that wasn't it's original mission plan anyway. But it shows that you have to look for very specific things, and as of yet we have not detected life on Earth from Space (other than our satellites, but that's a given).
It's not just "free" customer products. See: Pixel Pass being canceled right before it was supposed to pay off with a phone upgrade. Those people paid significant amounts of money.

I don't think GCP is going to shut down as a whole, but that doesn't mean I'd trust Google to keep any specific service I might depend on up and running.
My only requirement for a car is that it works with Openpilot. Everything else? Don’t care, don’t need it. I’d prefer that my car didn’t have any additional displays or any connectivity options at all.
Golang's problems aren't due to using namespaces, they're due to delaying too many decisions until too late.

Go has namespacing mostly because for a long time it didn't have a package manager at all, so people just used a bunch of ad hoc URL-based solutions mostly revolving around GitHub, which happens to have namespaces and also happened to lend itself to aliasing (because a whole GitHub URL is too long).

If you want to look at an actual example of namespacing done well, Maven/Java is the place to look. There is no aliasing—the same imports always work across projects.
>Most of the current ones can carry about a ton and a half, but larger ones would be able to carry a lot more: the Hindenburg could carry 232 t, for instance.

The Hindenburg could carry 232 metric tons aside from its own weight and the weight of its gas, or this was its total maximum tonnage?
Around 10 Percent of the Internet Is Encrypted via Lava Lamps
Creating EM waves to activate the rods and cones in people's retina already works very well for VR.
How secret is it now that you've posted on HN about it?
I recovered a lost device (satellite messenger in my case) via Bluetooth as well! It had just fallen into some ferns a meter or so off the trail, but without Bluetooth I'm sure I'd have never found it again.
At least 50% of such APs I ran across didn’t work right. I chalk it up to broken implementation on the ISP side, but a decent number may be issues like this.
This really is an inappropriate comparison. Can we be serious for a bit? A professional-grade tool providing professional-grade feedback is not remotely like an abusive or even turbulent relationship.
Shutting down Twitter would be doing the world a huge favour. He's halfway there.
'Meaning' doesn't pay the rent or preserve your job if you appear in the wrong part of someone's spreadsheet. It's dangerous to internalize concepts like this because you will get shafted by people who don't share them.
You can go through vimtutor in like 30 minutes.

If it doesn't all stick, you can just go through it again once per Sunday until you internalize everything you need for everyday development, though this is unlikely to be necessary.
Debora Rios, et al of Rio de Janero University, has published this 9 question flowchart [0] of determining the authenticity of a meteorite vs slag. Basically, look for a crust, smooth dimpling (but not voids), and magnetism.

[0] https://sites.wustl.edu/meteoritesite/items/self-test-check-... linked because the washington site includes a gallery and more links
https://archive.ph/DKBzB
What does vim lack that one might need to complete a basic programming assignment?
A while ago, I came up with a way to use bookmarklets to make bookmarks that open to different pages depending on the order in which you click them.

https://jstrieb.github.io/projects/hidden-bookmarks/

Every clicked bookmarklet concatenates a character to a passphrase used for AES decryption. The encrypted text and current passphrase are stored as intermediate state in the URL hash. When it decrypts, it redirects. If it doesn't decrypt, it goes to a fallback page as if it was a regular bookmark.

It was mostly a fun proof-of-concept, but I am hopeful that the technique has actually been useful to someone.
Mine is 5, but I have already planned for this. I plan to get something like stroller or a wagon, and I will just cart him around the neighborhood, on trails, etc. so he can at least still sightsee.

We are best friends, and I can't do our activities without him.
The worst part about this article for me is that there is a reason for some people to buy new microwaves. Inverter microwaves (yes, these have been around a while) have become far more broadly available. This is a worthwhile upgrade for many users.
Oh, wow, I didn't realize "Find my" worked even when both devices are offline! But it makes sense – all that's really needed is GPS and Bluetooth.

Were you able to access it right there without signal, or did you need to move to an area with coverage for it to sync?
Nope. Please go and learn about the basics of interpreted and compiled languages.

You can blog once you’ve learnt the basics. It can wait.
As one of the main people working on Rust compiler diagnostics, I find this comparison beyond distasteful. The tooling is not capricious in its restrictions and we go out of our way to make it communicate to people with as much empathy and support as possible.
Once upon a time I distributed some software free for anyone to use or redistribute, except for Elliotte Harold. Frankly I don't think it had the requisite originality to even qualify for copyright protection, but that didn't stop a couple of panicked publishers from reaching out for waivers and being less than 100% satisfied when I sent them signed, snail mail letters attesting to my belief that it lacked requisite originality. (The Zen InterSLIP dialing script.)
Why each article about project completion in Rust is read as ex-husband words about his ex-wife:

- I loved here. I am still is. But we needed a divorce.
These days you don't edit things on servers. The most you might do is edit a file and change a single option. You can do that in vi, vim or nano. Certainly you don't get to install you favorite editor (and version) and the .config folder an every server.

Most of the time you'll be editing config locally on your laptop and it'll get pushed to the servers via config management or whatever.

Your laptop is the place for your tricked-out IDE with 27 plugins
This is a readily citable nationally televised recent singular event with many elected officials on stage, ~3 years before mRNA was rolled out for a major event

Decades and smaller advocacy groups are less distinct.
How do you pronounce "Mebd"? Can you work out how to pronounce that name from how it's spelled? Or "Siobhan"?

Your statement isn't even remotely true.
If you're on MacOS, you can simply not use Safari. If you're on iOS, you have to use lockdown mode, which is the only safe way to use an iPhone. Any benchmarks done without lockdown mode should be considered as useful as CPU benchmarks run with mitigations=off.
I totally take responsibility for my initial ban; I created a meme from an image that I didn't own. I understand that that isn't OK, but I naively thought for memes it was somehow OK.
I watched a team deliver a Next.JS app slower than it would have taken using Django a decade and a half ago. It doesn’t use less memory on the server, has multi-second second page load times, and nobody was sure how to get the client-side JavaScript below 3MB for very, very modest functionality.

On the plus side, it has many constantly-changing dependencies to support.
My understanding is they do it to get more coffee out of the grounds so they use less coffee grounds to maximize profits which also increases the risk of cause esophageal cancer.

My personal preference to accomplish maximizing coffee extraction is to use extra filters and less coffee grounds but that takes longer which may not be a viable option for that type of business.
I wouldn't say we do so little looking for life in space. Our preoccupation with looking for the things that brought what we needed for life to Earth before life came about here is akin to looking for life in space.

We are always looking for what we believe are the indicators that would make life possible. We say that it is to understand our own origin, but the side effect of that is that if we find enough of it in space, we'll study it for its potential for life, just as we are doing on Mars right now.
Damn, he wrote PopCorn? I wasted too much time on that.
As a chronic comparison shopper, this is a first-world problem that's near and dear to my heart. I think the reason microwaves (and appliances in general) suck is because comparison shopping is so hard.

I wish I could get a list of all microwaves and filter by criteria such as:

- Does the +30 seconds button start cooking immediately, or do you have to also press "start" afterwards?

- Does it beep every 30 seconds after it finishes, and if so can I turn that off?

- Better yet, can I turn the beeping off completely without taking the damn thing apart and desoldering the beeper, and of course in the process risking my life near the high-voltage electronics?

But it's basically impossible to know these things without buying it and opening the box, so there's no competitive pressure pushing manufacturers to make their appliances less annoying, so we all have to live with these little papercuts throughout our daily lives for perpetuity.
I'd like to see a Zojirushi microwave. I feel like they could make one that seems a little magical and worth the upgrade.
There's a clear distinction between someone who writes the code and everyone else in the world who works with the outputs of your code.

Doesn't feel that way to me.
Putting Censorship Circumvention to the Test: Security Audit Findings
The last impressive development for the 2D Mario games to me was Mario Maker.

It was genuinely exciting and offered so much for people to just go insane with. I particularly loved those levels where you would just run in one direction and crazy things would happen.

But, personally, I don't mind the game being "more of the same". I think there's something that maybe journalists and game critics and maybe gamers in general don't quite understand but I know it's something Nintendo probably thinks about quite a lot: new generations. My cousins who is 10 years younger than me, his first Mario 2D game wasn't one of the original ones, it was a Nintendo DS one. He didn't care for "novel mechanics" for him everything was novel.

Of course, there is always a push and pull between experienced and new gamers. But I think Nintendo has done very well over the years keeping the franchise fresh enough to entice older gamers and classic enough for new players to understand what Mario is about.

I would like to see, however, a truly challenging Mario game at some point. Though I think this could be a separate game. When it comes to 3D Mario, the one on the Switch was really fun... but it was so easy! Until you got to the "dark/darker side of the Moon" that offered such a challenge utilizing every power and so on. It was really difficult and insanely fun, at least for me and my friends. I spent weeks, if not a few months with my best friend just trying to beat that final level; we'd get drunk and play Mario for hours.
> What's the point of installing 100gb to the hard drive if you're just going to keep reading the disc anyways?

It's proof that you own the disc and didn't loan it to all your friends to install so they didn't have to buy it.

This way, you can sell the game when you're done and recoup some of the cost. Not that there's as big of a second hand market anymore. Ownership used to be primarily physical, until Steam came along and normalized digital "ownership" where your privacy and resale rights are lost.
100% this: part of this crew.

I have, over the course of my career, found that the teams that tend to do this are pure-SQL teams ie in DB developers who spend all their time writing - and more importantly - reading SQL. Doing this actually removes a lot of debugging and code-fixing friction
I've thought a lot about this myself, it's one thing to have an "AI" system tell you something, it's a very different thing to trust it without doing the (often arduous) task of verification.
In the period between working on Bing and his new venture, he spent 5 years as the CTO at the Russian search engine "Yandex," stepping in for the late co-founder Ilya Segalovich who passed away because of cancer. There are many anecdotes circulating about Parakhin at Yandex. One of them goes like this: on his first day of work, he was asked to choose a handle for his corporate email. He was surprised that such a choice was available, as he was used to Microsoft, where addresses were assigned based on names and surnames. He asked if he could seriously pick any handle. Upon receiving a positive response, he didn't believe it and asked if he could use the address imperator@yandex-team.ru, which means "emperor" in transliterated Russian. There's actually proof of this: https://github.com/yandex/fastops/blob/master/AUTHORS
Got a Breville recently, seemed like the only units that weren't the same as every others out there...
Not sure it's more durable, but at least it's super quiet, I can mute beep sounds, I can change time and power while food is cooking, and it's got a stainless interior so there's no cheap paint that'll start falling off after a few months.
That doesn't really work. All unsafe lets you do is dereference pointers or call unsafe functions. That's not gonna speed your development up during prototyping.

You can instead wrap everything in Arc<Mutex<T>> and .clone() liberally, though.
OSI Deprogrammer Re-conceptualizing cyberspace
The disc acts as a licence key. The game itself doesn't get read from the disc after installation--that would be far too slow.

The disc versions of the consoles are popular for people who like to buy games second hand and/or trade in after they've finished playing; it's frequently much, much cheaper than digital purchases, even when the digital versions are on sale. There are disc rental services like GameFly, too.

Of course, the manufacturers would prefer to kill this secondary market, so sooner or later I expect the disc drives to go away completely. That was Xbox's plan around a year ago, per some recent leaks, and if one does it the other certainly will as well.
I simply toggled off JS and kept reading
Yeah it's interesting devops is a lock-in on the cloud when (if you squint, a lot) it should be the opposite: there are devops tools that .... almost ... should make you more independent.

IMO it should be a sneaky powerful declaration by major corps that your app should be built to be deployed nearly at will on at least two clouds. I mean terraform is so tantalizingly close to it, until it isn't. This is like Bezos sending out the "thou shalt service everything".

AWS knows this and they are all about lock-in. They want you on the more complicated products, because those are really hard to move off of. Oh yes, don't use cassandra, use dynamo. Man you'll never move off that.

So if you let the devs have "you can develop on AWS" but then they have to deploy on Hetzner ... that will force the devs to be far more cloud-independent. I guess if I was a CIO (never let me become one) I'd try to institute that.