skysight-inc/HackerNews huggingface dataset:
> large financial differences

I'm wondering, are you against dating outside one's social class, too? should millionaires date waitresses? or billionaires date millionaires? Doctors dating house cleaners?

>Brain development

How about dating outside one's education, so to say. Is it ok for a college graduate to date a highschool dropout? How about a well-educated, cultured, person dating a trailer park educated person? How much of an IQ difference is ok? 120 IQ dating a 90 IQ?
Attività
> This is not so common today...

It's happening in india today. It's very sad.
> I have a raspberry pi set up with an infrared LED to control my old NAD amplifier.

Interesting - could you share a little about how you have done this?

I have a Raspberry Pi that I use as a jukebox, connected to a NAD C320BEE amplifier, and I would like the jukebox to turn the amplifier and (active) loudspeakers on, using a usb-controlled relay, when I unpause mpd and off when I pause it, but unfortunately when the amplifier is powered on, it is humming until a source is physically selected!
Maybe I'm way off base from what you're asking, but would a Raspberry Pi with an amplifier hat solve this?

I _think_ Rpi supports HDMI-CEC, but then again I've never seen CEC working properly outside of the fantasy realm
Now that you mention it the same is what I saw: equipment had the cross on green while staff and vehicles used the white cross on a red circular bottom. I thought the choice was esthetic/camouflage but it’s the Geneva convention at work.
Ask HN: How would I make 3 millions euros in two weeks
Let's get imaginative over here
There's an earlier album that also sampled the archive I'm fond of[1], dipping in and out of a rather atmospheric and mellow tone. Golden Time being a favorite track.

[1] https://sadsic.bandcamp.com/album/blue-light-special
Yes this law came in 2015 and it indeed made a big difference. I saw zero downsides thus far.
The good ole days when web pages were web pages!
Merriam-Webster disagrees: https://www.merriam-webster.com/dictionary/lingua%20franca
>FDA is now narrowing the recommended window of patients to only those with milder forms of the memory-robbing disease. ..

So not really walking back. What a joke! Just a hand full of bullshit "research" showing "good effectiveness", away from expanding the recommended window to what it was earlier.

Can someone tell me why people still believe institutions such as these?

The most mind boggling thing for me is that they went ahead with approval even after the whole controversy was in news!
Most of the weirdness with SELECT could be fixed by switching the syntax to FROM ... WHERE ... [ GROUP BY ... HAVING ] ... SELECT ... ORDER BY.
There is in fact significant doubt among climatologists as to the veracity of this record.

While the 1913 hot spell was certainly significant, all recorded weather information at the time from surrounding locations, in combination with the dynamics of local microclimates, imply that the 134 degree reading was "essentially not possible from a meteorological perspective." [1]

Observer error stands to be the most plausible explanation, implying that the the recent 130 degree reading in Death Valley may actually become the location's, and the world's, hottest verified temperature.[2]

[1] https://www.wunderground.com/blog/weatherhistorian/an-invest...
[2] https://www.washingtonpost.com/weather/2021/07/09/death-vall...
I’m curious to know: which language is that a literal translation from? (Given the V-final word order, postpositions and use of ‘exist’, I’d guess either Korean or Japanese.)
My point was that it's easy for capitalist society to justify it. I am not arguing that a non-capitalist society can't.
Not a monospace font, but I made this:

https://imgur.com/a/G5hDiP6
I think the problem of this essay is that it's overly technical: only those versed well enough in SQL will really care to read the whole thing, and if they are already at that level, either they accepted that "SQL will get the job done in the end", or they learned to live along it and now even kinda embrace it, and are happy to write about how the examples are very poor and dismiss the critique based on that, when the essay kinda explains it main point pretty well:

>> The core message [...] is that there is potentially a huge amount of value to be unlocked by replacing SQL

To me, a lot of people defends SQL saying that "perfect is the enemy of good" and that SQL simply works. Not the favourite of anyone, but everyone kinda accepts it.

And yeah, it's true. People use SQL because it's good enough, and trying to reinvent the wheel would take more work (individually speaking) than just dealing with SQL as it is right now. For large organizations where the effort could be justified, all your engineers already know SQL anyway, so it's not so great either.

But for something so relevant as relational databases, perfect is not the enemy of good. We do deserve better. We generally agree that SQL has many pitfalls, it's not great for any kind of user (for non-technical users, a visual programming language would work well here, more like what Airtable does, closing the bridge between spreadsheet and hardcore database, and for technical users, it does feel unwieldy and quirky). We should be more open to at least consider critiques and proposals for better. We might find out that people, from time to time, are making some good points.
The author explicitly said "the only solution" and that's plain wrong.
I'd have to look it up to see which was first, but the ports of Pitfall! are a rough contemporary of Spelunker, which also has an infamous NES port. Both are Western-originated games about descending into caverns and collecting treasures. Spelunker in arcade is actually really interesting in how forgiving it is relative to most platformers of the time, while the NES game is its merciless counterpart.
Are you also talking about switching from a relational model to something graph-based, or is there some way one could use GraphQL with a relational database?
"History is for the meaningful, not the things that wouldn't even make the minor footnotes. "

History is the sum of everything that happened. Not just the few "glory" moments of some dudes, historians liked. (And it seems they mainly liked those with the highest kill count.)

"Almost no-one in the world has any significance"

Everything and everyone has significance to their own time and place. The world would not be complete and working like it is, if one thing is missing.

Now and as to why Elfdalian is specifically important? It is the closest alive language to old norse. Many people are trying to reconnect with their culture roots, after centuries of monocultural imperialism trying to cut them.

So yes, the world would move one without Elfdalian, but personally I like a colorful, vibrant culture. Where not every place looks and sounds the same - only then I would consider it all insignificant, as all is the same shit anyway. But it is not and I support efforts to fight against that and for rich local cultures.
German landlords can't set the rent as high as they want, for starters. At least not in Berlin with the Mietpreisbremse capping how high rent can be relative to the past, and to the neighbourhood.
There is pretty overwhelming evidence that using modifier keys is an advantage in this sort of thing. Pretty much every other language - possibly all of them - in common use make heavy use of modifier keys in describing what a computer should be doing. SQL is pretty much the dying breath of the attempts to do without them because the syntax is so bad in practice. Even configuration files typically make use of modifier keys.

Losing the explicit link between a function and its arguments is a big deal. Note that even the relational algebra model behind SQL doesn't try to make that sort of silly trade off.
three M's? I would just type one M every 5 days.
> They won't be able to decide if they are going to vaccinate or not either.

That's already how it works. The overwhelming majority of children in first-world countries are given a slate of vaccinations as a matter of course. Or did you think that polio went away on its own?
Does GNU Taler provide the "tomatoes not diamonds" feature that this document asks for?
I.e. the ability to have transactions below a threshold not be tracked/traced while those above a certain threshold are.

It seems nice allowing one to buy sex toys and such with pseudo-cash while preventing weapon-smuggling to do the same but I wonder if it's even possible in theory.
I have never heard of such a thing, but before 2015 Makler fees were ubiquitous. I live in Berlin.
There's an AP Herbert book called "Uncommon Law", in which one of the (fictional) cases involves a crossword-setter (Mr. Haddock) who is sued for setting puzzles with defamatory clues.

For example, "Bibulous bishop". That could be any bishop, except that the space for the solution, and the other intersecting answers, narrow the field considerably, to the point that the solver is forced to conclude that Bishop XYZ is the solution.

If you follow the Assange case, then you might see a strong similarity with the idea of "jigsaw identification".
Hi everyone, quite unexpected to see this on the frontpage of Hacker News!

I made this so many years ago but I'm not using it myself anymore and I haven't been maintaining it.

I was (and am) also very inexperienced making fonts so the result was "good enough for my own limited use case" but too broken for general use, so it's good to see other people taking it and running with it, fixing my oversights and improving things.

Questions or suggestions are more than welcome.
I think we should be wary of anyone that tries to manipulate emotions against an "other" group.

It's popular because it triggers existing prejudices about your so called "semi-neckbeardy creepy men". Even that phrase links appearance to bad behaviour.

(I mean in general terms here and not specifically anything about your post, I should point out).

However it's pure fantasy. The original story takes two people's perfectly ordinary relationship and twists it into a series of misandrist and ageist stereotypes.

This is pretty normalised in current modern media.

Attacking the currently unpopular out-group always sells well because the audience actively wants to believe the worst about people they already don't like. Truth be damned.

Really though, we should see this for what it is. The original author of Cat Person was at one time romantically involved with this man. She wrote an unpleasant fictionalised story about him which is now clearly shown to be untrue.

Many authors, male and female, do this all the time. e.g. Ian Flemming did it all the time in his Bond books.

Her story is just a passive aggressive form of revenge for some imagined slight.
I suspect it's oversimplified to think of homogenization as being a topdown process driven by the quest for power. A lot of it can be bottom-up - as the article describes, parents deliberately chose to teach their children Swedish. The advantages of speaking the "bigger" language are obvious: it'll open a wider set of opportunities. That's why people all over Europe teach their children English. If anything, their states probably have an incentive to push French, German etc., but English opens doors.
Usually that's only necessary at home because the movie's mixed for a huge surround sound system, though.

("Usually" because there are some exceptions like, say, the way that Christopher Nolan films have repeatedly had garbage sound mixes even in theaters.)
This article promotes other relational alternatives and query languages.
At home an offsite backup is going to be best - the initial backup though, especially on a cable internet connection is going to take weeks.
Oh yes I completely agree with being able to work with the hardware and software without getting sued. I was thinking of it purely from the hardware design for repairability and adaptability point of view. My point was that the original all in one mac was competing with all kinds of weird and clunky computers when it came out and it was successful because it streamlined the complexity of using a computer and, despite the bad period in the late 90’s, apple have shown that people want this streamlined experience. I want this streamlined experience most of the time but I would like to be able to unlock an advanced mode on my iphone so I can hack on it. E.g Years ago I wanted to write some software for my phone to communicate with my laser measure over Bluetooth and I couldn’t because there was no way to communicate with a Bluetooth device that was not approved, without signing up for some special hardware developer program, which I would never get access to. I was pissed off by this arbitrary limitation.
Not compatible w my old galaxy s3 :(
Show HN: Online Catalog of Slack Integrations
We're currently moving into a different direction, removing Spark Code to move most of the stuff into BigQuery SQL (which can use structs, one of the points of the article), because it's easier for Data (Engineers|Analysts|Scientists) to write SQL than e.g. Scala.
GraphQL isn't a graphdb querying language. The "graph" in its name is highly misleading, and should basically be ignored.

It's an API querying language.
The worst case scenario would have been China trying to use its hash power majority to to attack the Bitcoin network. Kicking miners out of the dictatorship actually made the network safer in my point of view.
Prince is fucking insane. Glad to see he was cocky enough to entangle himself in the shitshow of Trump Inc., may eventually lead to things going sour for him.

Can only imagine he managed to ingest a bit too much of the lead plaguing the MidWest when he was growing up.

> (The head of Lancaster 6, a longtime Prince associate named Christiaan Durrant, told TIME he was not aware of any such documents and asked for a copy; after being sent one, he stopped responding.)

Lol.

>>On Prince:

"Speaking of his internship, Prince said, "I saw a lot of things I didn't agree with--homosexual groups being invited in, the budget agreement, the Clean Air Act."

While I'll admit to not having read up on it, I can't imagine too many ways something called the "Clean Air Act" would be something somebody wouldn't agree with...
There are more like different classes of work,

1. interruptible work
2. non-interruptible work

With interruptible work, you can get interrupted and get back to doing what you were doing with no/minimal disruption.

With non-interruptible work, it really disrupts you flow and may take some time to get back on track, disruptions just increase the Signal/Noise ratio.

And as the others saying, not only programming, but any kind of work can be disrupted by interruptions.
you can use COALESCE to remove nulls
Oh man, this brings back memories using SCAR as a kid to automate RuneScape. That was my gateway drug into computer vision.
Children never had this choice. Their parents do in some places. But in most of the world the choice is nominal, because proper portfolio of vaccinations is a precondition to education, healthcare and travel.
I wonder how much of the limitation are necessary in order for the query optimizer to have any chance at finding a good execution plan. As you add more and more abstractions and more and more general computations in the middle of your queries, it will probably become harder and harder for the query optimizer to understand what you are actually trying to do and figure out how to do it efficiently. Are you not running the risk that the database will have to blindly scan through entire tables calling your user defined functions as black boxes on each row?

I would also guess that we could have a better SQL but I do not think it could and should look anything like a general purpose programming language because otherwise you might get in the way of efficient query execution. Maybe some kind of declarative data flow description with sufficient facilities to name and reuse bits and pieces.

And maybe you actually want two languages which SQL with its procedural parts already kind of has. One limited but well optimizable language to actually access the data, one more general language to perform additional processing without having to leave the server. Maybe the real problem of SQL lies mostly in its procedural part and how it interfaces and interacts with the query part.
You stated that "RSS is dead because barely anybody knows about it" is the same as saying "TCP/IP is dead because barely anybody knows about it". This is false. You cannot use the Internet without TCP/IP, be it consciously or not. RSS on the other hand isn't widespread enough to be used by ordinary person without knowing about it.

And even if there are cases where RSS is used in background as TCP/IP is, then it doesn't change the fact it's in background. Average Joe still won't know how to subscribe to blog's RSS feed.

Podcasts are basically the only place where feeds still thrive (alas it's also changing). RSS may not be dead, but unfortunately it's a niche which to average consumer is as good as dead.
asdsadsadsdaasd
To me, SQL looks like something I should be using 79-char punchcards for.

Scalable databases are just so difficult that we’re still driving a ‘64 IMPALA

Most of this opinion comes from “SQL” being vendor-specific. Is JSON vendor-specific? Is anything else, that we actually use by choice?

Mad at you too, Graph DBs, for sending us on another snipe hunt by adding vendor-imposed innovations, because it makes the enterprise marginally profitable. It’s how the world works, I’m still not happy about it.

(Disclaimer: I possibly just traveled back to 2002 and said this on slashdot)
In most languages where unions are a first class concept, are they not generally warned against?
I think I had the best experience with Meson/Ninja so far. I am also interested in using Nix for building. As for Cargo, I did not like how it recompiled all dependencies when I changed a warning flag on my project. I also found it unusable because it provided no way to check for the hash or signature of the dependencies that it downloads.

I don't think that I have ever been able to successfully compile a project that uses CMake. Its code is horrifying too, for example cmake-3.21.0-rc3/Modules/CheckFunctionExists.c contains

#ifdef CHECK_FUNCTION_EXISTS

# ifdef __cplusplus
extern "C"
# endif
char
CHECK_FUNCTION_EXISTS(void);
# ifdef __CLASSIC_C__
int main()
{
int ac;
char* av[];
# else
int main(int ac, char* av[])
{
# endif
CHECK_FUNCTION_EXISTS();
if (ac > 1000) {
return *av[0];
}
return 0;
}

#else /* CHECK_FUNCTION_EXISTS */

# error "CHECK_FUNCTION_EXISTS has to specify the function"

#endif /* CHECK_FUNCTION_EXISTS */
It would be interesting to let consumers have access to adtech tools. Instead of a subscription, I could set bidding limits on the ads that would have been shown to me.

I appreciate there are commercial reasons why this won’t happen, but it would be interesting. I’d also personally never trust any of the ad brokers to be honest with individuals without an army of lawyers.
In Google Analytics?
Logging on Nomad and log aggregation with Loki
I wonder how well will this play with [VSCode devcontainers](https://code.visualstudio.com/docs/remote/containers) -- perhaps one could create a target to build a development image, that extends the CI image by adding development tools? I'll definitely experiment with this, sounds promising.
> The lineage is more like OS-8 -> TOPS-10 -> CP/M -> DOS

TOPS-10 predates OS-8
Create a new shitcoin

Look for trading ideas in r/wsb

Flip a house quickly.

Buy lottery tickets

Buy my course for $59
I was in this state for years, thinking in an imperative way. The change for me was realising that your starting point is every possible combination of the rows in the tables. Just start with that (regardless of how massive) and then filter it down.
Turčin
Help there
5he problem with pay-to-skip ads is that, as we learned with Cable and Airlines, companies don't like to keep money on the table. You'll pay, and still get ads. In fact, the fact the that you can pay to remove ads makes you even more lucrative target for ads. There is no winning against the targeted advertisement industry.
I'd add that the general outlook is also grim. I'm not sure the next generation will have the luxury of retiring. They will inherit a difficult situation wrt climate change on top of it all.
Well there were a lot of atempts to relace SQL. And there will be more. But untill then SQL gets job done®. By the way, why "replace" let people choose. If you have better tool for the job, pick that over SQL.
Cruise is a different company. Uber was developing their own self-driving cars, and gave up last year [0]. That's the failure they're talking about, Uber was betting on their self-driving cars saving costs in the long run since they'd not need to pay drivers anymore.

[0] https://arstechnica.com/cars/2020/12/uber-sells-self-driving...
I get that new software releases are exciting, but point releases like this without a changelog indicating any major changes seem pointless (no pun intended) to post here.
Drivers are (supposedly) independent though, and it’s that particular one that accepted your fare. The replacement in your scenario might not want to do the same ride.
I generally use a prefix for columns based on the relation name, but preserving the name of keys (so a foreign key to user_id is user_id, not order_user_id etc). You obviously can't use natural joins if you end up with _multiple_ foreign keys with different roles, but generally I find this a better way to live all round. Never having to rename five 'name' columns in some output to make it clear which is which etc.
Exactly ...multi-tasking only works for shallow/low impact work. The expectation of multi-tasking for all forms of work is simply ludicrous.
Europe can now suck people up from other countries, and only pick the ones that have potential to pay taxes.
Cool site but man it's all just text. Semi related: only aware of some concept like hot loading (Java) regarding code that can be modified while it's running. - following idea of code that writes itself.
Not an NFT? Very retro!
We also had tobacco for many many decades as normal accepted part of life. It took two generations of concentrated efforts, but we're better off without it.

Just because something has been common for long time doesn't make it quite right.
So you'd hold down all 3 buttons at once, or press them in a specific sequence, or...?

When you did this, did the floor indicator show anything different?

And where (what country) was this?
Evidence? This is just, like, my opinion, man. But nested subqueries and old style joins... ripe for rewrite if I had say.
In germany, taxis are more reliable and cheaper.

The good thing uber brought, was that taxi companies finally created an app / apps!
If a game can be easily played by a computer maybe it's time to start playing a more complicated game, worthy of your human brain
Tell me more about that course
> I think everybody agrees on that.

I think everybody agrees that you don't mean everybody but most, many, or possibly only the people I associate with.

It takes only one counter example to disprove a statement of universality and I'm fairly sure I am not the only one to disagree with you.