skysight-inc/HackerNews huggingface dataset:
Here is a scenario that I've encountered a number of times.

We needed to serve up some data for an API endpoint. Great! We'll write a SQL query for it. Just need a couple of joins and where-clause parameters -- it will be speedy, and easy to maintain.

Before long, we are asked to make our query more robust, including a couple of optional parameters. Some null-coalescing in our join expressions and where-clauses is introduced. Performance immediately suffers. (I've seen the same kind of impact when introducing unions or function calls within such expressions -- the query plan can get very messy when you try to scale in this manner.)

So what do we do? Restructuring our data (maybe with a materialized view or something) is one option.

A reasonable alternative is to break up the single query into a few more specialized queries, and then use application logic to inspect parameters and choose the best query to use for each request.

Plenty of trade-offs to consider in both cases.
A PKI is not a blockchain.
Agreed. One place, the team lead actually acted like an EM, then decided he'd rather code and stepped back. Then I got a garbage EM.
Some people do not internalize the idea that Palestine is a sovereign nation. At best, they consider it an occupied territory thus any conflict they have with Mother Israel is couched in terms like apartheid, segregation, and colonization.

For an examples, look at how many commenters on this thread are calling this an “internal dispute” even though they fully support Palestine.

Some Palestinian supporters don’t even recognize Hamas as the government of the Gaza Strip. How can a country exist without a government? People are just in support of the people.
Wall Street Journal bootstraps cumrag from their "Work & Life columnist", literally begins with a dubious founder origin story. Save yourself three minutes and read something else.
It’s not just violence. They’re also annoying in other ways like taking up the entire sidewalk and shitting on the street.
697 Clichés you should avoid to keep your writing fresh
Yeah, weird. In my neighborhood (admittedly very safe for walking, and in an ideal climate) the streets were full of people going for a daily walk (twice daily for some people) throughout 2020-2021. There was nowhere to go around the neighborhood; it was just to get out of their houses.

Edit: I guess this study really doesn't measure for that(?). A three-mile walk for exercise through the neighborhood counts as one "trip" whereas a few 250-meter walks across parking lots count as a few trips.
Modern language models refute Chomsky's approach to language
"Script" in the movie/tv world has a specific meaning, and is very different from what the subtitles are. Subtitles are just dialog, while the script contains so much more.

Calling the subtitles "basically a script" is like saying JavaScript is basically Java.
Volkswagen tracking firm sued for refusing to find stolen SUV with kidnapped boy
Only one: a lack of availability/scale and consequent cost.

It's a problem that can be solved.
Employees. They're pretty passive aggressive, but for the most part they just shut up and do their work. Makes my job easy. These days I mostly just take people to lunch, golf, smile & shake hands, occasionally do an inspirational TED-like talk, and just collect the cash.
A message from Ella – sharing Kid's data on social media [video]
A similar Intercept article was posted on HN a while back, and got limited discussion: https://news.ycombinator.com/item?id=31127965

As much as HN hates advertising, so many seem ignorant of how much of the ecosystem works. I guess lots of people simply work for companies involved in these schemes, so they simply turn a blind eye or feign ignorance.
The latest revision of Oberon has several implementations. Also, OBNC can be used on Windows, macOS, Linux and other POSIX compliant operating systems. Component Pascal has a single implementation which is Windows only. Oberon was created by a master of programming language design; the feature set is minimal but complete. Component Pascal adds a number of features which Niklaus Wirth intentionally left out in Oberon.
And they propagate the lie of the American Dream. If you're not filthy rich, it's all your own fault.
> They spent so much time on one company's green technology, that they could not cut it as electricians. They literally could not wire an electrical panel in a new home.

No, it sounds like them not being well trained on the basics is what made them unemployable. You add on the green tech stuff once you’ve mastered the basics, it shouldn’t be in place of the basics.
I have been able to partially print them[0]. The electrodes we used could have been inkjet printed* and there is some potential of printing the dielectric fluid too. In the process I developed, the HASELs had to be filled with dielectric fluid during postprocessing, but it has been shown that it is possible to print closed volumes of fluid with inkjet 3d printers[1]. Although there is some risk the dielectric fluid could interfere with the curing of the polymer.

*We also were able to develop a technique for printing electrodes without modifying the printer, but this hasn't been published yet

[0]https://www.researchgate.net/publication/343949671_Modeling_...

[1]https://www.csail.mit.edu/news/first-ever-3-d-printed-robots...
Very strange that Orlando ranks so highly in walking trips. I can only assume that the data is thrown off massively by the theme park visits. Probably the same with Las Vegas.
It may not guarantee quality, but to turn the argument around, everything good/brilliant/interesting made so far was made by humans (barring naturally-ocurring coolness).
This is obviously completely anecdotal but I've been noticing the same whenever I’m on holiday here in Europe or abroad.

My girlfriend and I like to guess where other tourists we see on the streets are from and one of the most obvious indicators for Americans is that as soon as they hit 40-50 there’s a high chance they're either limping or using a cane or similar.

My theory used to be that a lot of them played high-impact sports such as (American) football or basketball in their youths and consequently ruined their knees. But honestly not being used to walking might also contribute
What do other realtime OS kernels do when printing from various places? It almost seems like this should be done in hardware because it's such a difficult problem to not lose messages but also have them on a different OS thread in most cases.
This is what kills Horizon Worlds, which is Facebook's earnest answer to the problem of making VR authoring much easier than "making a video game"

I want to make a 3-d world based on photographs (even stereo) and visual art and to do that I need to import JPG or PNG images. No can do. They have a short list of textures they supply, but you cannot import media assets like images, audio, video, geometry, point clouds, whatever, ...

McDonald's would insist on putting a Coca-Cola logo on the cups and so would every other brand.
Perhaps the author of that comment was a millennial.

Constant, random shit-talking of our generation was the norm set by uncreative thinkpiece authors as we were growing up, so it can be easy sometimes to fall into that mindset. Blame whoever was writing popular media from like 1995-2015.
GNU Guix into Termux
I really wanted to like them. They kept falling out of my ear with all tips, and at almost $300, I didn’t want to have to buy aftermarket foam tips or ear hooks.

The sound is great and the Bluetooth pairing is excellent though.
Ideas?

There is no way to use it in the frontend securely. Communicating with OpenAI will have to happen on the backend and to prevent anyone from abusing your API, it will have to be protected by authentication.
I built a local developer-mode plugin that gives ChatGPT access to a local directory [0] -- it's pretty basic in terms of functionality (just simple bridge to access/read files) but I've found a surprising amount of value from it [1]!

[0] https://github.com/samrawal/chatgpt-localfiles

[1] https://samrawal.substack.com/p/example-driven-development
Windows Forms for .NET Framework 4 using Visual Studio was (is?) a simple Windows-only option.
It's kind of crazy that a feature necessitated 20 years of active development to be somewhat called complete.

I hope it will be ready soon. I'm working in a project that has strict serial communication requirements and it has caused us a lot of headaches.
True, but all of those strokes of luck put together don't make for success without virtues like wisdom, grit and hard work. And with those virtues many people have succeeded without those kinds of luck. So the virtues are more central to success than the luck.
Yeah, "autonomia" (autonomy) is used to describe a cars range in Portuguese where we would normally use "range".
> In 5 years it will be an 11+ year old CPU running on 7+ year old servers.

My desktop is 12 years old and works completely fine. The major difference being that it's x86_64 so it keeps getting current software.
It rings true. Maybe the best thing for me is sort of unorthodox relationship. But whatever, I'll manage.
I think this flag was added because a lot of these sex workers want to post pictures without flagging their sensitive media. Then they dog pile replies on all the trending tweets, and people find the adult content.

Any time that happens to me, I flag sensitive content. And then I block the user—so I don't need to deal with it.

I see this as punishing people who're not following the terms, not gatekeeping.
Show HN: AI-Powered Binary Analysis
direct link: https://planthardiness.ars.usda.gov/

I'd like to play with overlaying these maps on topographical data.

We're on a hilltop, couple hundred meters above the surrounding area; and its remarkable how we have a microclimate that feels more like the land a couple hundred miles north of us. Our nettles bloom later and longer than the lowland neighbors, we collect the migratory birds up for a week before they leave, etc.

Maybe a couple square miles affected by this, all told. Not big enough state level maps to be concerned about. Of interest locally, tho.
I don’t think amphetamines do that on their own, but rather over time the fatigue builds up and the drugs can’t mask it anymore.

The issue with smart drugs is that high tolerance leads to psychosis much easier than you’d think.
I was lucky to be born into a middle-class family in the USA with access to good schools.

I'm lucky to be a quick learner.

I'm lucky that all the challenges I've faced in life have been manageable.

I can't think of how I would have made that kind of luck for myself.
Anecdotes from recent-ish visits to the US, I’m curious how representative these might seem to Americans: when walking in a Southern California suburb, from my hotel to a supermarket about 3 km away and back, all along perfectly decent (but empty) sidewalks, I was stopped by a police officer who wanted to run my ID for warrants. When I asked why I had been stopped, he said "People don’t walk here. I thought it looked suspicious.”

In two separate visits to Alabama, whenever I walked a couple of kilometers from where I was staying to the closest shop, a driver passing by called out "f-ggot!". I had been warned beforehand that people don’t walk there, and my local contacts all agreed that that slur was due only to the fact that I was walking. My ultimate conclusion was that unless you live in a community where people do walk, walking anywhere in the US comes with social stigma, and people are reluctant to be seen as weirdos.
But but I read WSJ for the cumrags
Living/Sleeping Rough
Walking as transportation is decreasing, but walking and running as exercise remains very popular.

https://www.strava.com/heatmap#7.00/-120.90000/38.36000/hot/...
Are you sure? I remember one of Dreamweaver competitive advantages was that it produced much cleaner HTML than it's competitors. FrontPage was the big offender with awful code.
Why would this even be worth the dev resources to deal with?
I can understand the Itanium community feeling like they are trying to do The Open Source Thing by volunteering to keep it alive, only to be (what might feel like being) summarily dismissed by the rest of the community.

I’m afraid that the community has grown so enormously and is subject to such powerful economic forces that if there are more people who need/want better EFI support (or whatever it may be) than who can keep up Itanium support, the Itanium community is probably out of luck.

I daydreamed a bit about picking up some Itanium equipment used just so I could say I’ve experienced it. It looks like a lot of power hungry gear with a lot of unsupported components that was all originally bound to some black-box vendor support contract. It would’ve been a hoot to have a big 90s mainframe running IRC or something, but I decided to allocate my hobby time elsewhere.
Why do you leave the house less frequently post pandemic? WFH?
On the assumption that 'Anatomy' was a spellchecker distortion of Anatoly: everything in your reply was already obvious except 'Odessa'.
You're arguing that there aren't STL methods for doing inefficient things.

But the parent took that as a given. Their comment translates as, "why doesn't the STL allow efficient removal at the front of a vector" (which would be possible in principle, e.g. python bytearray is similar but supports it). Part of the answer is that it would need an extra internal data member.

BTW the pop on std::stack refers to the back so doesn't help with pop_front (and vector already supports pop_back).
I used VBA and Tk. They were good. I always assumed front end web people have similar tools?
Yes! If you have a previously generated shape selected, it incorporates the code from that file into the prompt for the next one. i.e. "here's what we had before, here are the notes that came back"
> yet another sign that America is a country of car lovers

Or is it Stockholm syndrome.
> Website and app design often begins with "what does a button look like,"

Yup. Been a long time since I've used an un-customised standard button outside my personal projects, no matter how much R&D has been spent by Apple on working out what it means for a UI to be good.
Why do you think it is a problem to make very precise things with effectively basic mechanical tools? Also, keep in mind, the ones that didn't pan out might have been discarded etc., so you are seeing the good ones.
Netmind Power has finally launched o Product Hunt! And we are providing free compute power during our beta. Join our journey towards democratising compute power!
> That capability is strictly less than the capability of most manual testers / QA staff, but it's a lot faster at it, and gets much closer to being exhaustive.

That's if you put the effort in to write good tests. When I look at the state of gaming in general, it's ... pretty obvious that this hasn't worked out. Or the GTA Online JSON debacle - I'm dead sure that this was known internally for a long time, but no one dared to modify it.

And even then: an automated test can't spot other issues unrelated to the test that a human would spot immediately. Say, a CSS bug causes the logo to be displayed in grayscale. The developer who has accidentally placed the filter on all img elements writes a testcase that checks if an img element in content is rendered in greyscale, the tests pass, the branch gets merged without further human review... and boom.
Reminds me of Linus Torvalds’ quote from 1992:

> Of course 5 years from now that will be different, but 5 years from now everyone will be running free GNU on their 200 MIPS, 64M SPARCstation-5.
It is a political and societal choice.

I could understand that a people decides that it should be governed with pure human processes, and therefore that its government and civil servant has to use only human brain power (and compassion) to govern and administrate.

I would be afraid to miss some good or even just rational decision making, but I think we can all agree that a 100% AI government or administration would be a bad idea, so how to ensure that there's always a reasonable and informed human to decide, even with the help of AI and computer models?

The wiseness of this decision should probably spread largely, for example, when considering the decision making that has been done and keep being done around things like climate change MODELS, and COVID spreading MODELS.
"Entirely new genres" of anything is unlikely from ML models trained on existing work. Someone using AI to implement an entirely new idea will be frustrated as the AI keeps gravitating toward convention.
I made it a point to walk 3 or more miles every day this year. Haven't missed a day this whole year so far (knock on wood). It's been a great decision, although it is hard to compare it to what I would have felt like if I didn't walk, though.
CompareIt! [1] - It's an ancient diff program last updated over a decade ago, but I've never found a diff program nearly as useful.

It is windows only, but it is fast, allows quickly setting manual anchor points (I miss this horribly when doing git diffs via vimdiff), and has converters for common file formats like doc and pdf (extracts the text and then does the diff).

I use it for both work and home. In addition to code diff, it's great for comparing things like PDFs of insurance renewals, to see what has changed.

It's the best $30 I've ever spent on software.

[1] https://www.grigsoft.com/wincmp3.htm
Using a rock as an example makes sense given the post I replied to. The argument that we lack a "mechanistic model of qualia" has nothing to do with behavior.

That aside, we should be close to certain that LLMs don't have internal lives. That computer programs can mimic human behavior in some contexts is a tremendous discovery but it's no reason to assume an internal life. Conversely, many animals can't mimic human behavior but clearly have internal lives.

The capacity for an internal life evolved over a billion odd years. It has something to do with our bodies and if we want to understand it, we should focus on biology and neuroscience. A machine with an internal life would need hardware designed or evolved for that purpose and modern computers lack that.
And you can use the enable_* sledgehammers as well.
Click the little Copy icon next to the output iframe.
That's not how VB6 or Delphi work.

Delphi's visual editor allows you to position, link together and configure visual and non-visual components in design time, automatically serializes all the components into text file and in runtime your program deserializes these components from the resource embedded in the program's binary file. It also allows you to create handlers for events like OnButtonClicked or OnDBConnectionOpened where the usual arbitrarily complex programming happens.

The first result from google showing what this looks like: https://www.youtube.com/watch?v=AyWm24ekSVM
I think we need to get started on organizing the resistance to our robot overlords.
Obesity prevalence in Americans is actually about 42%

https://www.cdc.gov/obesity/data/adult.html
ethanol fuel, by itself, doesn't increase engine power. Ethanol allows the use of higher compression-ratios/increased ignition-timing/higher air-density than typical petroleum tunes due to lessened chance of detonation.
What still miraculously works for me is s/twitter.com/nitter.net/
Synchronous logging strikes again! We ran into this some at work with GLOG (Google's logging library), which can, e.g., block on disk IO if stdout is a file or whatever. GLOG was like, 90-99% of culprits when our service stalled for over 100ms.
Don't know. I am renting my apartment in my 40s because a certain generation blocked all new housing construction using NIMBY regulatory capture.

Now seem to be even buying up all the scraps (with cash) that are left over with their enormous savings from the market bull run and housing boom. While enjoying high interest rates of their savings.

https://www.washingtonpost.com/business/2023/11/13/housing-m...
The seed binary to bootstrap a full Guix system is a 357-byte ELF paired with a 25MB Guile.

https://guix.gnu.org/en/blog/2023/the-full-source-bootstrap-...

Making an ARM seed cannot be far off
We do need people out there willing to take risks in research. Many of his claims may not be correct, however some findings may be made or may stimulate productive directions.

The problem with this work is with the messenger. His massive ego does not allow for doubt nor does he allocate credit to the science that has preceded him. His off-putting manner and unwillingness to collaborate in the usual way science is done means that even if there is significant merit, few will develop it out further.
> Unlucky people skip over opportunities right in front of them.

This idiot does not know what she is talking about. Unlucky people are those who don't get opportunities in the first place.
> do you think that people who want subtitles would pay for content if there were no subtitles available for it?

Pretty much. If you're Japanese and don't speak English, and a show you really want to watch is only available to pirate in English (no subtitles available) which means you can't understand it, but if you subscribe to Netflix you can watch it with Japanese subtitles that Netflix provides... I mean yeah?

I'm presenting both sides of the argument. The question is really, which side will a court find to be stronger? And there may very well be a distinction here between fan-made subtitle translations, versus official subtitles.
Debt is never "wiped away." It is paid off by somebody, in this case the US taxpayers.
A Size for Every Stream: The Expert's Guide to Sizing Kafka Streams
Postgres 15: Logical Decoding Row Filters with Debezium (2022)
I think they’re required in California too.

In any case, there are multiple companies that will compete to collect your kitchen grease out of that 55 gallon drum, for free. Maybe they’ll even pay if the kitchen makes enough grease — that mess is valuable!

I suspect that most kitchens pay for grease trap service, as it’s more labor and equipment intensive and the resulting extracted crud may be more of a mess than a valuable commodity.
No, "uses cookies or collects information" is too blanket a statement. The GDPR allows the collection and use of data on six lawful grounds. Five of those do not require consent or even notification. In fact, "consent" is the six justification.

Contractual obligations, legal obligations, vital interests, public tasks, and legitimate interests do not require consent. You ask for consent if you collect data you have no legitimate reason to collect in the first place. This should already tell you a lot about those pesky banners. The GDPR "homepage" [1] has a ton of information with regards to this topic. Don't be fooled by those who blame your shitty web browsing experience on the GDPR. It's on them, not the GDPR.

[1] https://gdpr.eu/
The Archive link was posted in the thread: https://news.ycombinator.com/item?id=38289869
Plastic Waste in the Fuel Tank?
This is clearly a partisan issue: blue states tend to walk more and red states prefer gas guzzlers.
And yet they are available, proving the studios will never learn.

Capitalists always say the market will work it out, but all I see are entrenched companies who think customers are beholden to them, not the other way around.

Piracy wouldn't be needed if it weren't for the studios shooting themselves in the foot.
> Boomers cannot walk. I know many that cannot walk a single block.

Boomers are between 59 and 78, so that there are a fair number that can’t walk a single block isn't surprising (Silents are even worse in that respect.)

> It's a huge reason American cities are so car centric, too

No, its not. Its true that when that trend began, most Boomers couldn't walk, too (for the opposite reason; many were too young, more weren't born at all), but that really wasn't the driving factor.

Racism was a pretty big factor, as well as corporate interests.