skysight-inc/HackerNews huggingface dataset:
That SQL has * as the only abstraction for column names is quite frustrating.

I can think of so many other ways of dereferencing column names, from using a map/or lookup table to using types.

For example, selecting the unique id of a table regardless of what its name is.
I recommend Assassins Creed Odyssey for anyone who likes Greek architecture. There is a touring mode that allows you to explore ancient Greece without conflict.
It's pretty common actually. The world exists in many shades of gray. Not everyone is a high priest like (I suppose) you.
Sounds like a winner to me! The Windows share path isn't a URL per the spec and this would be, afaik.
Indeed, you could have a type-erased allocator on top of that for preserving dynamic functionality.
My advice is to just go for it. I’m 2 years into a part time JD program that lasts 4 years, and I’ll tell you what my father told me as I considered whether to enroll: years ago he said to his therapist, “I’m really not sure about starting a PhD this late; I’ll be almost 40 when I graduate” and his therapist said “You’re going to be 40 anyway.”
> defer: Declarative control flow that obviates the need for RAII.

I feel like RAII is a term that has expanded to mean more than it means on its face. Maybe someone more familiar with the larger meaning of the term could help me understand? How does a defer capability have anything to do with initializing a resource upon allocation?
Most of the military kids i knew that grew up moving around every couple of years fucking hated it. Just when you were getting ready to really know some friends really well it was time to go. I would hate that. I have a few true, friends who are like family that I've known since grade school. I would hate to deny my kid those long term friendships. I'm sure it depends on the kid though.
Incidentally, the paper was a good read and I'm always looking for details of precisely how rendering works on 90s and earlier games.
Gabapentin and Tramadol work for me. I do 1 week use 1 week tolerance break to keep addiction away.
Yes, but no, but yes.

AutoEq (https://github.com/jaakkopasanen/AutoEq/) does something like this so... yes?

But targets various HRTF curves which aren't neutral or flat, and they usually aim for a Harman target of sorts, so no...

But there are some neutral-sounding curves that seek to just emulate pinna gain, so they have a ~3KHz peak which is required to 'emulate' the natural resonance of your ear, which you don't get naturally when you jam a driver all the way into it.

There's no AutoEq preset for the AS06s. Here's a representative sample targeting the 2019 Harman in-ear target for the KZ AS10s for funsies though: https://github.com/jaakkopasanen/AutoEq/tree/master/results/...
Redeeming Our Asymmetric Culture War – The European Conservative
https://news.ycombinator.com/item?id=32571890

Also, if you want to tell mods something, email it because @dang doesn't automatically summon a dang.
I was thinking the same thing myself, if this was similar.
One way to look at pedantry is that it's when someone emphasizes technical correctness, even when another person's actual intent is understood.

If it's the middle of July, and someone in California sets up a meeting with someone in New York, but tells them "9am PST", it would be understood to actually mean "PT" or "PDT". I suspect only certain kinds of neurodivergent people would show up for the meeting an hour off. And hopefully someone who genuinely thought PST was the intention would ask for clarification. Most people, though, who would bring it up do so just for reasons of pedantry, not because they're actually confused.
I think it depends on the district. Sure a rich neighborhood or private school would probably make their lives a living hell, but poor->lower middle class probably wouldn't get bullied any more than any other kid.
Do we have reason to think that is constant over time? What if we stratify by specific users? Etc.
frontend

- react or svelte

- preact or raw html/css/js if it's simple

backend

- go or python (go std lib is faster but harder to write complex queries in since the extant query builders/orms aren't as mature, django is easy and scales across a team)

- maybe node or deno if you prefer js syntax
Ask HN: How can I become a better designer?
I'm a software developer and I really struggle with design. I don't seem to be very good at web design or graphic design, or even interior design and fashion sense.

I've recently been doing a terrible job at furnishing a house and it doesn't look very good. I also did a bad job with some previous apartments, so I don't think I'm getting much better by trial and error.

I think I can identify good design when I see it on Pinterest or interior design subreddits, but it never turns out quite right when I try to copy something. I recently created a floorplan in Sweet Home 3D so I can experiment with some ideas. So at least now I can try things out before I buy anything else.

Can anyone recommend some resources that might help me to improve my general sense of design and learn some basic principles?
I learned that I put my faith and trust in some people who were never sincere and were simply using me.

Sometimes you flock to someone because you see them being kind, considerate, and overall a strong leader.

It turns out that some people know how to fake these qualities. They’ll use you, and while you look up to them, they see you as a pawn in a chess game.

Assuming that people make mistakes and everyone actually just means “well” or has good intentions, it’s extremely naive. People will sell you that shit and take advantage of you.

I got gaslighted enough times and finally saw what was happening.
> cease teaching it to every student

> Just telling on yourself, "I can't write software without training wheels"

I think both of these reactions go too far, in opposite directions. Of course the fact that C is difficult doesn't mean that we should stop teaching it. It could just as well mean the opposite, that we need to teach it better, certainly as long as it stays in widespread use. But at the same time, we should acknowledge that C is difficult even for experienced professionals, and that "not knowing how pointers work" isn't the main reason every large C and C++ codebase on earth has memory corruption vulnerabilities.

(I'm sure that's not literally true. Someone somewhere must've written a lot of perfect C code. But I think the usual posterchild for well-tested C is sqlite, and even sqlite has had memory corruption issues in the wild.)
> Is it possible that, then [1981], programmers were not familiar with dozens of other languages?

In those days people knew more programming languages than is common today. In addition most of the people on the CL committee were academics or from academic instititutions — “industry” back then was more nerd oriented than business oriented as it more commonly is today.
US Army Recommends Food Stamps for Soldiers Struggling with Inflation
For a home lab/home prod, time to install is not necessarily the worst thing to optimise for. For example, I’m not going to spend several hours each on 8-10 different alternative applications, just to install them so I can get a feel for which one I want to keep.

Docker is an amazing timesaver, and probably the only reason why I run anything more ambitious than classic LAMP + NFS on my home lab.
I do think the hate is overblown and a little immature. Maybe it felt a little silly if you were already a computer expert in 1995, or just hated Microsoft in general as was en vogue at the time, but the character served an important purpose. The Microsoft Office suite was huge, could be overwhelming, and still came with 20 pounds of printed manuals. Was the average user ever likely to discover the Letter Wizard or the Party Invitation Template? Clippy did do some analysis of the document you were typing and make some helpful suggestions to guide a new user around the program. And you could turn it off.

Personally I will go to bat for Clippy and don’t think he deserves the derision.
drawabox.com is incredible - started it a while back, really should get back into it.
In Hasidic Enclaves, Failing Private Schools Flush with Public Money
Heavier cars are safer for their drivers, but far deadlier for everyone else
I'm taking some CS courses to study Operating System and Compiler Design for malware reversing so it's a bit different from what you ask.

I'll probably take some Physics and Math courses to reach a solid understanding of General Relativity after this one.

I'm more interested in learning things I'm interested in instead of pursuing a degree. Degrees IMHO mean very little (I already got a Master's anyway) while knowledge is more important. To obtain a degree one have to take many courses that are deviant from the objective, which is a huge waste of time and money, neither is abundant.
Just draw more. I recommend you go to Youtube, there are a ton of talented digital artists there, you can learn everything nowadays!
Cold Case Hammarskjöld (2019)
> I am not sure "good vibes" is a healthy super-ordinate goal among adults.

Ok, elaborate why not
It's had those extra connotations from the start- the whole reason to tie allocation to initialization is so that you can also tie deallocation to destruction, making it automatic and thus less error-prone. "RAII" is mostly just a confusing name for "destructors."
He did, but he was strapped to the side of the plane (digitally removed to appear he was simply holding onto the plane.)
Check out some of the old Before & After videos by John McWade. He is good at expressing the principles of design in a straightforward way.

https://www.youtube.com/user/bamagazine/videos

There are books & magazines available as well. I think the BA magazine domain / website is down so you may have to check with other booksellers.
If it reduces property values then it effects others
Similarly, we’re on

https://news.ycombinator.com./

(Weird new line to get the whole url displayed)
As a huge music fan, I found "Country Music" by Ken Burns to be extremely enlightening and entertaining. After watching, you'll realize country music is the foundation of modern western (rock, pop, electronic, etc.) music.

https://www.pbs.org/kenburns/country-music/
You can't use the error handling part of the spec without invoking an error. Good minifiers will do the same, fwiw.
I might start calling this a Megalith, since it kinda fits if you squint at the definition.
Agreed! I worked at a job where most of the company worked on a monolith, with the frontend in its own repo, then another 25 microservices hanging off the monolith. Everything was different in every repo, including how to deploy and run tests etc.
The project I was working on was everything in one repo with a nice deploy.sh and test.sh and no chasing people to find out how to deploy that one microservice that was last touched months ago.
Grocery bag comparisons of environmental impact
If I remember correctly these are the PDP-10 Boolean operator codes.
Evolution of Access Control Explained Using Python
Capturing the Friedmans is brilliantly constructed. Jarecki peels the onion one layer at a time, saving key details for when they'll have maximum impact.
the paperclip's name was "Clippit" though.

yes, it was.
It would be nice to have a more composable solution though. Macros etc. don't have to be permanent. On the other hand, CTEs are pretty strictly tied to the structure for the current query.
Oh, CA actually did pass it? I thought it was still pending, and WA and OR were waiting on us. Did a quick search, and I don't see anything more recent than this past April, when it was not yet fully passed.

There's also the federal-level Sunshine Protection Act[0], which the Senate has passed, but annoyingly the House put it on hold back in March right after receiving it, and hasn't acted on it. Lame.

[0] https://www.congress.gov/bill/117th-congress/senate-bill/623...
This makes the cache locality excellent and is great for game performance.
New to Computer Programming? First, start with these basic Mathematics
Hackceler8 – Google game hacking speedrun competition
That makes sense, I guess I got a watered down version. The amount of deviation out there is wild. At least with math you can have clear and translatable standards. For home ec, I've met people whose classes basically ran the school's lunch and breakfast programs. I don't think the kids where I'm from could've handled that responsibility.
By the way, this type of reactor is technically a hybrid fusion-fission reactor. Because when the neutron hits a Lithium-6, what happens is a fission reaction. Lithium-6 absorbs the neutron, and then splits (in Tritium and Helium) and releases energy. We are taught that fission happens only for heavy nuclei, and this is mostly true, but Lithium-6 is an exception. The energy released in the fission of Lithium-6 is quite comparable to the energy releases in the fission of Uranium or Plutonium (4.8 MeV for the fission of one Li-6 nucleus vs about 200 MeV for Uranium-235 or Plutonium-239; that energy is nearly perfectly proportional to the atomic mass).
Yet 1-2% of population is using Linux as of today and 0% is using fusion energy as of today. Witty but false.
> data-driven healthcare

It frightens me to imagine what Google does with medical information.
Nothing you said changes the fact that that the medium income is $35,000.

Why do you think houses look so much affordable there?
Yup. MAME still has an "electron beam" since that's how all PC video works, just the software buffers a full frame before letting it scan out to the monitor. Even if emulators didn't buffer, they would have to somewhat exactly match the speed of the instruction execution of whatever they're emulating (do emulators do this? I have no idea), or else for example the amount of girder rendered in each frame would be different than the real system, i.e, they will be longer in that first frame if the ROM runs faster than the real system (I think... assuming the code is just filling the tiles at its own pace and not tightly scheduled by something else).
In C you have a system of memory allocation tied to scoping. A statement like "int x[10];" allocates memory such that when x goes out of scope, the memory is deallocated. RAII generalizes the concept so that when the variable comes in scope, some initializer function is called, and when it goes out of scope some destructor is called. This allows us to use it for dynamic arrays (unlike VLAs in C), hash tables, etc. We can replicate the system by simply calling the initializer when the var comes in scope, and the destructor when it goes out of scope. However, this creates the problem that the two statements are far apart from one another, and thus there is a chance that they might grow out of sync as the code changes. Defer allows us to cause some action to occur when the variable goes out of scope, but declare this at the site where we perform initialization, thus grouping the two together and making it easier to modify them in tandem.
Sure. So basically, it's very dependent on your goals and your target audience (or community). The way I see it, digital communication is a subset of physical communication. Audio = phone conversation, video = "in-person" communication, and text is a subset of both.

Video: Batch make videos, schedule clips for release over the week (YouTube)

Audio: I haven't used it, but I've heard good things about anchor.fm

Text: For socials, Buffer (https://buffer.com/). For newsletters, Substack and Revue both have scheduled publishing functionality.

Keep in mind, the end goal of this strategy is to work with how the internet communicates: repeated signal over time in a mountain of noise. Scheduling allows for this.
I always that the JFS code in Linux came from AIX but it does seem to have come from OS/2

https://en.wikipedia.org/wiki/JFS_(file_system)
> There’s another way in which the giant firecracker idea misleads us, because even scientists often talk about the “universe springing into existence.” Well, it didn’t, as far as we can tell. The opposite is true. There is no first moment of time, just as there is no smallest positive number. In physics we have equations and laws of nature that describe how one situation changes into another, but we have no equations that show how true nothingness turns into somethingness. So, since the universe did not spring into existence, it has always existed, though perhaps not in its current form.

Or the equations are only approximations that hold under certain conditions?
> ‘In all, I have been looking after bees 30-plus years. It started because of my wife’s love of honey.

> ‘So I bought her a book called Keeping Bees In The Back Garden. She read the book and said, “Well, it’s over to you now”. So I got the job of keeping bees in my home and it has just developed from that.

I think it's neat that a self-taught hobbyist beekeeper who learned the craft by reading a book could go on to become the royal beekeeper.
Mr Vince Cate belongs on the front page of HN.
"The G3000 also monitors pilot activity/inactivity and cabin pressure and can automatically engage Autoland or Emergency Descent Mode if no activity is detected." - Arstechnica article. https://arstechnica.com/cars/2019/11/this-system-from-garmin...
Yeah, I tend to agree.

I've watched a couple and they ask pretty good questions if the answers he gives require some additional research/critical thinking/knowledge of history.

The last documentary I watched, Hypernormalization, seemed to give platform to and justify the need for _more_ individualism via Trump-esque critique on Leftist ideologue. That is totally fine, but I can see how people can watch his documentaries accept many of the leaps in logic.
https://www.nber.org/papers/w17170 (11 year old paper)

PDF ->
https://www.nber.org/system/files/working_papers/w17170/w171...
My assumption is that it'll eventually get revived in the House sometime next year, but they will -- correctly -- decide that November 2023 will be too soon after it becomes law, will change the text to specify some date in 2024, but then it'll have to go back to the Senate, where it will get held up for dumb procedural (or political) reasons, and then we'll just repeat the same thing over and over.
The upper limbs of a fig tree seem to grow whichever way to reach the light, and the root system will also grow like that. A fig tree might be trimmed and still have an extensive root system.

Hardwoods will try to maintain some kind of symmetry. One root that branches supports a branch above ground. If that root is cut, the above-soil branch it supports dies out. Likewise, cut the branch, and if it does not grow back, the root will die back.

This is why for hardwoods and most trees, when you transplant them bareroot, it’s best to spread the roots out.
Wonder what their coverage is in this - or if they even still use it. There are many occurrences of "how does this ship" bugs in League where damage numbers don't add up or status's have no actual effect, etc - sometimes hanging around for many patches. Not that I don't understand how hard it is to test the big ball of mud that (10+ years old!) game engines end up being.
Fog of War is incredible. I haven't really seen anything else like it in the sense that powerful people very rarely publicly examine themselves and their lives the way McNamara does. The follow-up with Rumsfeld is so different because he doesn't.
I bet he has a great big house, but guess what he doesn't have? Anything to do! Boring! That's what I'm paying the extra 1.5k a month for! Fun shit!

California forever and goodbye!!!
Interesting stuff, can someone recommend a good book that deals more into this subject?

Preferably a book that’s entertaining to read rather than engrossed in mathematics
Yep, zachbeane's near-simultaneous comment to mine has a link with details on that.
Any recommendations on gage blocks for micrometers and calipers?

Veritas Set-Up Block (made in Canada) accuracy is rated at 0.002" (aluminum) and 0.0002" (steel), https://www.leevalley.com/en-us/shop/tools/hand-tools/markin... & https://www.leevalley.com/en-us/shop/tools/hand-tools/markin...
Also kinda the same reason why buses don't need seatbelts.
That's a reasonable choice and I do agree it has nice properties, for example (a << b) << c is equal to a << (b + c) (unless that latter addition overflows), but it also does put you pretty firmly in the category of "not squeezing out every last cycle like you can in C." Usually that's one of the the things people expect in a tradeoff involving safety.

Regarding "never," I am an adventurous programmer[1], so am fully willing to accept that I am the exception that proves the rule.

On the more general point of UB for arithmetic overflow, I think we're on the same side: this is a pretty broken story in the way C has ended up, and one of the clear motivations for a cleaned up better-than-C language. I'm more interested in your thoughts on data races, where I suspect we have a substantive difference in perspective.

[1]: https://github.com/linebender/kurbo/blob/de52170e084cf658a2a...
Clippy was just ahead of his time. Interruptions are the norm now.
Does this apply to hitting trees/poles? That's a lot of extra force you need to stop.
It's really beyond the DoD itself to solve these problems on their own. Pay increases require approval beyond those institutions further up the executive branch, and I believe in congress in some cases. Pay raises happen at the beginning of every year, so hopefully the further up's will take action - but it takes a while for it to get to the payees. Mid year raises don't happen. If congress was smart they would just do a COLA adjustment for all the enlisted folks below say E-7 to make up for inflation.
You’ve hit on three of the four of Jane Jacobs’s conditions for a healthy, high-density neighborhood in her book “The Death and Life of Great American Cities”!

- Variety of building age/quality, to have rent levels that allow diversity of activities (low rent hole-in-the-wall for an art club; high rent, new construction, ground floor retail for luxury shopping)

- Variety of building use schedules to ensure eyes on the street at all hours and full utilization of infrastructure (including restaurants). A pure residential area or pure office park will fail this and turn into a ghost town at some hours. Hudson Yards might hit 2 schedules but not 3, which is the ideal.

- “a dozen dozen places in a five minute walk” allows niche businesses to survive, since the large effective service radius includes enough people to find some customers. Rockefeller Center’s arcade is actually quite important and covered in the book, since it cuts some too-long blocks into short enough blocks.

I don’t remember the fourth condition, so read the book to find out.
You seem to have a lot of good ideas. I'm quite short, do you have any suggestions that could help me?
Which is saying something given the level of training, testing, safety culture, licensing, and ATC coverage.
Play Station emulation in the iMac was promoted by Steve Jobs itself.
Diffusion Bee: Stable Diffusion GUI App for M1 Mac
Diffusion Bee is the easiest way to run Stable Diffusion locally on your M1 Mac. Comes with a one-click installer. No dependencies or technical knowledge needed.

Features:
- Full data privacy - nothing is sent to the cloud
- Clean and easy to use UI
- One click installer
- No dependencies needed
- Multiple image sizes
- Optimized for M1/M2 Chips
- Runs locally on your computer
I hate that I will likely buy a larger car than my current Corolla just so I can feel slightly safer. I don't need it, I don't really want it, but given the adversarial nature of other drivers, I feel I would be putting myself unnecessarily at risk if I don't.