skysight-inc/HackerNews huggingface dataset:
How do you pick out someone as being homeless? I'm in the UK and (accepting in the US it may be different?) there is a common misconception that people who sit in shop doorways begging for money are 'homeless' people when, in fact, they are usually just people who have a drug habit they need to continually finance.

The real homeless people are doing their best to blend into the background and not to look homeless.

[I used to be such a person]
You can ingest data using OpenTelemetry Protocol (OTLP), Vector Logs, and Zipkin API. You can also use OpenTelemetry Collector to collect Prometheus metrics or receive data from Jaeger, X Ray, Apache, PostgreSQL, MySQL and many more.

The latest Uptrace release introduces support for OpenTelemetry Metrics which includes:

- User interface to build table-based and grid-based dashboards.

- Pre-built dashboard templates for Golang, Redis, PostgreSQL, MySQL, and host metrics.

- Metrics monitoring aka alerting rules inspired by Prometheus.

- Notifications via email/Slack/PagerDuty using AlertManager integration.

There are 2 quick ways to try Uptrace:

- Using the Docker container - https://github.com/uptrace/uptrace/tree/master/example/docke...

- Using the public demo - https://app.uptrace.dev/play

I will be happy to answer your questions in the comments.
Fear of RDBMSes is quite common. I used to suffer from it too. It’s just so annoying to have to switch your brain to a different programming paradigm every time you need to do something with the database that you start to make up all sorts of excuses as to why it’s really just better to “do it in the code”. Your coworkers argument about FKs making data migrations difficult is one of them.

Another classic is the “joins are slow” argument, which I believe goes back to a period in the late 1990s when in one, not highly regarded at the time, database, namely MySQL, they were indeed slow. But the reason “everyone” knew about this was precisely the oddness of this situation: in fact RDBMSes are highly optimized pieces of software that are especially good at combining sets of data. Much better than ORMs, anyway, or, god forbid, whatever you cobble together on your own.

There is, in my mind, only one valid reason to not use foreign keys in a database schema. If your database is mostly write only, the additional overhead of generating the indexes for the foreign keys may slow you down a little (for reading, these very same foreign keys in fact speed things up quite considerably). Even in such a case, however, I’d argue you’re doing it wrong and there should be a cache of some sort before things are written out in bulk to a properly setup RDBMS.
What about the mixed drinks? I think it was only White Russian and Kamikaze.
I'd expect that even if he'd been totally blind, given the normal process of mixing paints on the palette before painting with them and that this is imprecise.

(Obviously I don't think he was totally blind, I'm only saying subtitles of colour aren't evidence of anything).
How to build a ‘citizen developer’ workforce
And bonus downvotes if that standard isn't yet another UNIX clone.
It's not a problem in Copenhagen. Most bike paths are wide enough to allow overtaking, and even the fastest cyclists are respectful enough of small children to slow down as they pass. (Many fast cyclists will be parents, after all.)
What is GoT's second-hand agenda?
Or a sky hook that rotated at the rate of the earths rotation.

On the moon it's just about doable with current technology and realistic levels of mass.
Swift is a systems language, has great c interop and solves Apples problem successfully. By all means it’s successful for Apple.
We definitely don't "live with" polio and measles, not in the sense the usual *** in the comments use this phrase.

We are also well on our way to stop living with HPV - but of course antivaxxers there are also sabotaging.
It's almost funny how both sides of the political spectrum think their voices are being suppressed
Extreme Integers – Doom from Below
Ah yes, fair point. I think it’s Gandalf that says the Hobbits are stouter than even the Wise know or something to that effect but, like you say, they aren’t impervious to the charm of the ring. Except perhaps Sam, with his abundance of hobbit-sense and love for Frodo.
Related: does the OEM (Apple, Samsung) or baseband radio vendor (Qualcomm) make that decision?
Based on what metric? I play with new cars that come out, every year, for fairly low speed technical driving competitions. I get to try a lot of models. The CVTs always overheat. Always. I bring a spray bottle of water to cool the radiator down between runs (the CVT cooling is piped into the rad).

The current Hyundai's and Kias using traditional six speed autos never overheat. The Spark is one of my favorite cars to drive on these courses, and unfortunately even the 98hp 1.4L will overheat the CVT after a minute of hard driving.
Not only has covid knocked ~2 years off the life expectancy in the US, it is likely to permanently knock a lot more of the healthy life expectancy. The long tail of sequlae is a reality and no level of denying and "I just want to live my life not worrying about it" will change that.
Fluoxetine: From Benadryl to Prozac (2006)
Oh comeon, Ghostbusters 2016 was genuinely bad. It had an incoherent plot that went nowhere.
The first episode of ROP was OK, amazing production value, a laying out of foundation, some nice fight scene. Nothing especially bad nor especially good.
The vitroil against this show is so obviously manufactured.
Being Shanghaied is still a thing.

I wish this was TIL, unfortunately I already did.

The world is a much more brutal place than many in the developed world realize.
No need for that.

Basically, you add noise to the picture that can only be picked up by non-colour-blind people.
Just because I feel the need to say it, I didn't get that vibe from your comment at all. Some people just want to have an argument.

But I do wonder the same thing, COVID has obviously been studied enormously around the world. It also seems to impact relatively healthy people in vastly different ways unlike a cold. However, I do wonder if you took a group of people who have been hit with the flu, if you would observe similar long term impacts, albeit perhaps not to the same degree.
Any time you make an error like that you should immediately change your password anyhow. But I guess some people like to live dangerously.
it's ok we already have your phone number
the thing here is the website is not collecting anything. Literally anything. That's a standard widget and from what I remember it's GDPR compliant. That's the last thing I would worry about to be honest but thanks for the comment.
Sorry about the confusion. Btw, we've met in person once in Mountain View some years back. Nice to see you here :)
I don't know; the article is hardly self-aggrandizing (which is the primary attribute I see on /r/LinkedInLunatics), and certainly some of us could appreciate the reminder, myself included. Do we really have to be all intellectual, all the time on HN?
The cloud provider might handle OS and platform upgrades for you, but don't forget about updating your images! :)

Then again, dealing with that is also something Kubernetes can help with.
Perhaps irrelevant question but:

Why does it have the feeling of something being designed by Google?
I make good use of those captions, given that most of Billy Butcher's dialog is: "Roight, now we gonnagyabrngs frbitszlan in th righnylnggnsya!"
This:

"You can always rewrite software. Rewriting bad data is not only difficult but often impossible."
I actually work for an automotive company and specifically deal with vehicle acoustics. Yes EVs at low speeds are imperceptible and a danger to even a person with baseline hearing let alone a partially deaf or blind person. These regulations are there for a reason. It’s not imagination. We measure quantifiable data using reference microphones.
Though I agree that some gas cars are extremely quiet and difficult to perceive, that doesn’t mean we should shackle ourselves and prevent meaningful change for next generation vehicles.
anyone can suggest a great openwrt compatible router in sub 50$ category?
But, besides index hints, the developers don't need to worry about those things if they use the database to perform joins. The database management system chooses for them and does it pretty well (counterproductive index hints are not unheard of).

If they do it in application code, then they probably ought to learn about fancy sorting and joining algorithms.

But they should really just do it in the database (using read only replicas if the load gets high).
I'll add my anecdotal experience, got covid in 2020, got the vaccine a year later and felt butterflies in my chest immediately after. Went away after a few seconds but after a month discomfort started during intense exercise. Another month later and I went to the ER with mild pericarditis. Its been a long ~year of recovery where I had to keep my HR under 100 and take tons of anti-inflammatories. Got lucky that I had it mild and finally back to normal (minus getting out of fitness), lets hope it stays that way.

What I learned (perhaps too late lol):
* Medical Science is largely empirical (requires statistical nous), unfortunately doctors do not understand statistics, take argmaxes and treat things deterministically in the guise of evidence based medicine.
* Said doctors advise Insurance companies so any doctors that do understand statistics will be bounded within the confines of what the insurance company considers evidence based medicine. This creates wasted work and even frustration as the doctor has to jump through hoops to get things done.
* getting a rare disease or disease with uncertainty requires becoming an expert on it to "correctly" navigate the health system (US here). I have a newfound appreciation for not only those who have to deal with insurance but simply navigating the uncertainty.
Holy heck, the diving into Silmarillion (sp?) intentions. Amazon has a series. It’s not true to subject matter. It’s been entertaining (not at the level Amazon paid). Just like the movies, liberties aren’t taken.
Correct, this setup wouldn't survive chaos monkey.
VW Seeks to Defy Market Gloom Going Ahead with Porsche IPO
I'm curious to know what was lost to the Lisp users in the change on Apple's Newton device going from the early Ralph implementation in Lisp to cplusplus.

On r/lisp there was a rant that included a reflection that things would be done in a third the time. There was an ask for $60M to apply Lisp to know a different world. Apple can easily afford a $180M experiment to see Ralph/Dylan implementation of iOS/macOS. If proved successful would the software platform leap how the hardware has done across multiple architectures? The ARM M series devices are a there and back again move given Apple Newton was on ARM and Apple invested which kept the idea alive.
This is really interesting. Do you have any examples?
> Why is this on top of HN? "Mind blown, I just learned about the concept of treating people nicely regardless of their job"?

I don't see anything wrong with the post. Treating nicely can surely be extended to its author as well.
Do you mean the 2Number app by BPMobile?
> or "10/10 lol"

Oh don't worry. They are only removing the negative reviews.
In the lack of any actual agreement on what the product/market/online-world should look like, we instead play this stupid game where we fine companies random amounts at random times like a mix of taxation and roulette...
There is live streaming built on top of Bittorrent. Sure you have to tweak it but it is very possible.
What is the reasoning of people accusing a player of the OTB cheating? That he somehow (with the help of a computer?) got up to +3 at some point against said #4 player, but then decided to stop cheating?

If he is that 'bad' to draw a +3 position, how did he achieve this position in the first place?
Just curious - what do you feel is a more accurate number and how are you coming to that conclusion?
Gervais has writing credit for literally one episode of the American Office https://www.imdb.com/filmosearch?role=nm0315041&job_type=wri...

And it has been said multiple times by people working on the American version that besides the inital setup, Gervais and Merchant had very little if any input and everything was done by the American wtiters/show runners.
Finnish Log-House Maker Stops Daytime Production to Cut Power Bill
sure, there is no problem with having 95+ % or more handled by professional industrial companies

the problem is that they literally don't even allow others at the table, only way is to force yourself a seat by having enough traffic
I would be shocked if it ever becomes illegal to sell used.
The people who write these believe that the old hero myths stories are based on the wrong values, and they are on a mission to correct it.

Responsibility, sacrifice, being torn between good and bad, these are not what modern stories should be made of.

But for some masochistic reason these same people can’t write their own stories, they actually want to destroy existing stories, kill off the previous characters and storylines, and insert their own philosophy into the old worlds.

It’s ridiculous, and narcissistic, and I sincerely hope something that makes these companies go bust. I sincerely hope in the long run there isn’t a market for this behaviour. Star Wars certainly seems to have collapsed.
Looks like the OpenWrt `/etc/banner` no longer includes a bartender recipe (which I think they had since before alliteration, including for White Russian).

I once included one of the OpenWrt login banners in a "screenshot" for the Racket community, and neglected to explain why alcohol was involved: https://www.neilvandyke.org/racket-openwrt/
You should certainly be nice to the janitor: They are not part of office politics and so can afford to just interact naturally and decently.

Conversely, people are careful to stay on guard to threats and opportunities in interpersonal power-games, and so when they see the janitor, the fact that politics does not apply makes them relax and behave naturally: This is either rudely or nicely, depending on the individual's character.
Biases: Understanding Human Mental Shorcuts
That's the smell I got from glimpses of a trailer. Bland, middle-of-the-road, bleh. I'm guessing the behind-the-scenes social events were given much more attention than the actual show.
I like the show so far. I don't mind that some people don't. Let's see what happens next.
Yes. Legolas is shown in The Lord of the Rings to be capable of stalking his foes day and night, and he only has to stop because Gimli and Aragorn can't keep up.

In general, the elves, especially the older ones like Galadriel, are shown to possess super-human characteristics in all physical feats, including agility, stamina and strength (though the Men of the First Age apparently were stronger though less agile).
I did this for roughly the first 25 years of my life. I no longer think it is a good idea. People invariably end up asking for money.
Modern Alternatives to BEM (CSS)
That sounds awfully like something OpenWISP should already be capable of.
Pretty sure the court was able to point out which laws they've broken.
Well in that case...it sounds like Amazon is abusing their position in the market and ought to be broken up into several smaller companies :)
Dickens' great expectations. Dreams of a small boy, like every one of using childhood, dreams shattered, how he faced manfully, the cherishing of Estella's girlish grace and charm, even at advanced age--Alltouched my boyish heart.
Ask HN: How do you prioritize the update of vulnerable 3rd party packages?
More specifically:
1. How do you know if the vulnerable package is called in a way that it can be exploited? For example, if the package has a critical vulnerability in a method "myFunc" but it is never called by your code, it won't be exploitable.

2. How do you know if it is safe to upgrade a package and it won't break changes? For example, if version 1.2.3 has "myFunc(p1,p2)" and it is called by your code, but the vulnerability was fixed in version 1.2.4, which has "myFunc(p1,p2,p3)".

3. What do you do if the vulnerable package is a sub-package of another package used by your code?
> PoS / staking is a grey zone right now... there is a lot of discussion over the legalities.

There's really not.
Well, one could argue that Tolkien didn't plan on his books to be translated in that many languages. I'm not sure why this matters at all, though.
https://archive.ph/jrk0S
I think that this would make a good HN poll, for example: https://news.ycombinator.com/item?id=21231804

Though the answers would probably vary and there's most likely lots of nuance per individual case (which might matter more than just yes/no), personally I can think of the following as examples:

- yes, we use foreign keys
- yes, but we use them in testing environments and turn them off in prod
- no, we don't use them because our database doesn't support them (e.g. distributed like TiDB)
- no, we don't use them and check integrity and orphaned data ourselves
- no, because our system design doesn't allow us to use them meaningfully (e.g. OTLT and EAV)
(also, talking about whether to cascade or not might be useful, e.g. whether you want to manually clean up related data, or not)

Someone else mentioned varying schools of thought, which rings true. Personally, my opinions about database design in general are along the lines of:

- avoid EAV and OTLT outside of very specific cases, have multiple tables over few (e.g. employees, employee_contact_information, employee_vacations, employee_notes instead of employee_fields and/or employee_field_values)
- have foreign key constraints across your tables, so that you might not end up with orphaned data, *consider* cascading the constraints (depends on requirements)
- use views liberally, especially for complex requirements in regards to selecting data, so that your app (or ORM in it) can map against it in a simple manner
- outside of batch operations, prefer to modify data through the app, instead of procedural SQL, since that's easier to debug; I'm yet to see someone use breakpoints/watches for stored procedures successfully

Though my ideal database design probably looks way different and scales slightly differently (which hasn't mattered as much yet) than someone else's.

There are people who want to build their entire database around a "classifier" system, about which I wrote previously here: https://news.ycombinator.com/item?id=32416093 (this also makes the DB hard to visualize as ER diagram because of meaningless links, and sometimes makes the DB hard to use without the app, e.g. type_enum_value vs table_name).

There are people who want to do everything in procedural SQL (I've seen application views call stored procedures to fetch all data and validate forms), there are those who don't want to touch it with a 10 foot pole.

It really varies a lot, though in my experience it's invaluable to be able to feed a database into something like DbVisualizer and get an overview about how the different tables are related to one another, basically like documentation: https://www.dbvis.com/
You still wouldn't get around the energy requirements to propel you, no matter what technology you use for the propulsion.
> But it’s simplistic with characters who are so dumb and childish that there’s no Star Trek in Lower Decks either.

Well... i wouldn't completely disagree, but it's a cartoon comedy so it seems fitting, the characters might be dumb and simplistic but they make fun of themselves; unlike Discovery where the characters are also dumb and simplistic yet pretentious and serious with terrible acting making it unbearable.
Oracle Faces Class-Action Lawsuit for Profiling the Data of 5B Users
"It used to be that all forums had pervasive doxxing and swatting..."

What kind of hell-forums were you using in the late 90s?! I never saw anything like that going on in the forums I was using back in my early days of internetting, though to be fair, I was mostly on classical music, historical fiction, and parrot-keeping forums, which tend to attract people outside the bored young male demographic, but I was also a regular Slashdot reader, where things sometimes got nasty, but I don't remember a swatting incident, or much in the way of doxxing.
It’s mostly hysteria. I’m enjoying it a lot more than the clunky GoT prequel series, for instance. I can’t possibly see how it could move someone to join in a one star review-bombing campaign unless they had a political agenda they weren’t being honest about.

I’m not saying you can’t have an opinion, of course. The recent Star Wars trilogy isn’t exactly an unparalleled artistic achievement. But unfortunately when the internet’s overflowing with misogynists and racists desperate to hold their crumbling cultural Maginot line, any legitimate criticism isn’t going to be heard.
Because it's a new chat app.
I guess this should be on the FAQ
I don't use foreign key constraints on the database.

I create all fields as NOT NULL and use empty string in place of NULL.

Last time I tried foreign key constraints can't work in an environment like this.
This is a rather poor example. If there are multiple checkmates, humans are usually much more likely to see ones that require the least number of moves. Anyway if there are multiple checkmates, the game is irrecoverably lost by another player and it is easy to see on the board.
The components are made with MUI, which is a component library based on Material design, originally created by Google.
When I’ve driven a Nissan Leaf, I almost keep it entirely in B mode. Keeping the battery level up feels almost gamified.
In the American version, Gingrich wanted just the poor kids to work as janitors in schools.
They should take a cue from the Expanse. Like the wire, they just made the characters epic, male or female (having amazing actresses helped)
Aquaculture is dependent on ocean fishing
Why are the mosquitoes reintroduced? Wouldn't there always be the risk of parasite reinfecting the stock?
Has any content producer/review platform blocked reviews on freshly released flagship product before or is it a new thing invented by Amazon?
> Careful about that one. I believe `uint8_t` isn't required to be a character type, which has implications for type based aliasing.

The fact that every single compiler typedefs "uint8_t" and "unsigned char" and yet that isn't guaranteed by the standard is the kind of thing that just makes you want to cry.

I'm actually genuinely curious about this: people talk about the possibility of existence, but I haven't seen anybody point to an actual compiler that implements uint8_t as an extended numeric type rather than being an equivalent typedef to "unsigned char". Is there a compiler that really does this?
This is the real point. Amazon seems to only care about review quality when it hurts their short-term bottom line. They don't much care when even a third party website like Fakespot can detect fake reviews better than their own systems.
In fairness to younger generations, I can never figure out how to use file choosers in modern operating systems or in crap like google drive.

It takes me a minimum of 60 seconds to naviate to ~ using the GUI on my work laptop.

(Partially because the dialog box sucks, and partially because I only do that once every 6 months or so.)

It's like some UI designer didn't understand folders, then somehow forced their brain damaged mental model of them on the rest of the population. After that, for some reason I will never understand, the rest of the industry copied the design.

(I've worked on filesystem implementations, tested for POSIX compliance, debugged insane customer issues, etc, etc. I know how directories work...)
And you'd expend the same amount of energy climbing it as you would propelling yourself upward with fire.
Standardising Observability and Incident Management at Miro