skysight-inc/HackerNews huggingface dataset:
Note you can already reference select list items in GROUP, HAVING, and ORDER BY so it's not that big of an extension.

I've implemented the ability to reference select-list aliases before; it's not that hard to do if implemented basically like a macro expansion. The main problem is user confusion due to ambiguous references, e.g.

select 2 as x, x as `which x?`
from (select 1 as x) t;

we ended up adding a warning for the case where a select list alias shadowed a table column, suggesting using a fully-qualified table name if they actually wanted the table column (t.x in the above example).

IMO only allowing references to previous select list items is a perfectly reasonable restriction; loosening it isn't worth the implementation headache or user confusion. Though we did allow using aliases in the WHERE clause.
HN doesn’t seem like a very niche community to me, it’s far bigger than it used to be
TIL about the Tokay gecko, and that its name is derived from its mating call - plus this little nugget:

> The tokay gecko's call is also responsible for the name given to it by U.S. soldiers during the Vietnam War, the "Fuck-you lizard".

My first thought was "why did they name it after a wine?" (https://en.wikipedia.org/wiki/Tokaji, sometimes also spelled Tokay)
You can eat more slices if it is thinner. Also I like a crispy pizza.
Nebullvm, new release Easy-to-use library to speed up AI inference by 2-30x
Did you try the AirPods though, or some other brand? I literally had no problems from the ones you listed: they don’t cut out, they connect to all my devices automatically (they are paired to your every device that is logged in to your Apple account) and it takes only a few seconds to do so.
Apple and Samsung had waterproof headphone and charging jacks before.
I used BBC Basic in my undergraduate thesis too.

I designed and built a board with multiple Transputers on. We didn't have the Occam development software so I had to write an assembler, which I did in BBC Basic as the transputer board interface connected to the BBC micro.

Transputer instructions are all variable length, and their length depends on their arguments. This includes jump instructions which used relative addressing. This meant that the assembler would take as many as 7 passes before the output converged into the optimum result.

Because the BBC micro had so little memory (32k) the intermediate result of each pass had to be written to floppy disk! I seem to remember it taking about 15mins with an awful lot of clonk clonk clonk from the floppy disk to get my code assembled.

I finally got my physics simulations (Ising spin models) assembled and with 3 Transputers they ran a little bit faster than the Fortran program I'd written for the university mainframe which I was very pleased about.

Happy days!
I just have a 50ft ethernet cable running across the floor.. 3 years and I haven't yet tripped.
> 1. Why should it need to do this?

I vaguely remember from the time (~10 years ago) is that this was a requirement for phones (eg, when Qt is used on a Nokia phone) that the network request go to the interface preferred by the user (so not to use the cell network when wifi is available).
Anyway, the whole thing was implemented in a "bearer manager" plugin, and that thing was quite buggy. https://doc.qt.io/qt-5/bearer-management.html

I think apart from people running Qt on phone, this had virtually no use. And yet this was enabled by default on all platform, and causing lots of troubles. What we ended up doing for the application we were shipping was to make sure that this plugin was not included in the final package.
I made a free website called City Filter that aggregates a lot of data from cities around the world and lets you filter them by different criteria including temperature and rain, but also safety, development, population, distance from your location, etc.

If your goal is to identify your favorite cities based on your own criteria, you will definitely like it:

https://www.city-filter.com
@wruza, @wenc: These are both very good answers, and you are of course both right. Check the symbol table, anything you can't find should be defined in the same context (in the select list, as a new expr).
In which case, match each symbol use (eg. x in x * x as y) to the definition (eg. 1 as x) to establish a set of dependencies, then do a partial order sort, then spit out the results.

I can do that I just don't fancy it, and more to the point nobody is giving me an example of where it would be particularly helpful. So if anyone can, I'm interested.

(also, consider human factors; although an acyclic definition could be extracted from an unordered expression set, a consistent left to right (in the western world anyway, matching textual layout) with dependencies being introduced on the right and depending only on what came before on the left might actually be better for us meatsacks)
> Wireless headsets are something I understand because I'm someone who never wants to go back to wired headsets.

That's also true for me. Ultimately, I think it's a matter of using good judgment. All my major devices - even laptops - run on cables by default, tablets/phones wireless of course. For keyboards and mouses (OK, not WiFi in a strict sense) it depends.
I think this is how Last.fm works (and it works quite well!)

The weirdness in disparate interests is smoothed out by having a large sample size.

I'm trying to find details of the algorithm. In the meantime, here's an interview with the inventor of AudioScrobbler, which merged with Last.fm to provide its recommendations system: https://www.wired.com/2012/11/richard-jones-scrobbling
The mean is attracted to quality, but doesn't 'get it', and drags it down. So you end up with regression to the mean. It happens to everything 'cool' everywhere, all the time.

When a community is young and niche, it only attracts those who seek it. These seekers get it, but they have that 'je ne sais quois' that is often envied by people whose motives have no resemblance to the theirs. Once the second wave hits, it is downhill from there.

tldr hipsterism.
CDD isn't Pizza but a pizza inspired casserole.

'Detroit style' ... shudder technically still pizza, but I don't get the cotton candy like dough or the typical choice of spices.

New York style is fine. California tends to have weird toppings but is also OK. Though IMO pizza requires a 'bread', tomato (usually as a sauce), and cheese, in a 'flat bread' style format.

Thick or thin can all be good, and every type is going to have it's fan, even if that person happens to hate some component or another.

Even if it's Pizza Inspired, it can be tasty.
What about uMatrix is broken?
By your definition (ie universal suffrage), the USA has only been democratic since 1965. So that makes Sweden's democracy twice as old as the US democracy.

But that is not what I mean when I say "democratic traditions". Especially for countries that introduce democracy gradually and (mostly) peacefully, I consider the whole transition period to be part of those traditions. A country like Sweden had more than 100 years (1809-1921) of public discussions and political manouvering to build up the institutions, culture and education that provide stability, legitimacy and public support to such a system.

Finland underwent a similar development from the end of the Civil War to 1990, which mean that in 1990 the democratic institutions and traditions had already been built.

Other Warzaw pact countries had varying amounts of democratic traditions at that point. Some (like Hungary) had seen little democracy. Others, such as Czechoslovakia had been mostly democratic in the interwar period, while most had seen some democracy and some authoritarian rule in that period.

I would argue that those traditions from 100 years ago play a part, even today. And in the case of Sweden vs Finland vs Hungary, Sweden and Finland both have very strong traditions for democracy (even if the age of those traditions are different), while for countries like Hungary and Ukraine, those traditions are still shaky.
A few years back I saw something similar where subreddits were presented like a tree, based on topics (and popularity, I think). Made it easy to drill down to interesting niche subreddits.

Haven't been able to find it since.
I used to hate meetings full stop, now I have a more nuanced take: my purpose at work is to create solutions, not code, and all other things being equal, the less code that needs to be written towards that solution, the better.

A good meeting with a clear agenda and outcomes can save hours, or even days or weeks of writing code. A bad meeting - poorly organized and led, clashing egos instead of reasonable arguments, and so on - is something nobody needs.
But porn is allowed to be posted on twitter at present.
> And most people only run Hotwire in production

eh?

Aren't you confusing the full "Hotwire" suite with just Turbo? I don't think you cannot run "Hotwire" in development.
> Practicality? Eh.

The "supercharger" network is something that no other manufacturer was doing or was seriously interested in doing, and it's an extremely practical concern.

> When the IC companies convert over

... a lot of them they might well end up buying batteries from Tesla. Tesla will also continue to be the benchmark against what EV will be measured, in the same way Ford continued to be a reference for decades after competitors matched them.
Rents are price-inelastic and are determined by the economic opportunity of the land.

Translation: landlords eat taxes.

(Landlords also eat pay-rises.)
I have always known there is something fundamentally wrong with Sweden... Thankfully we are not enslaved by them anymore.
It is actually a widely accepted model by many economists to increase the efficiency of the land market. The reason why it is rarely adopted is plain corruption.
By default git diff works on entire lines, but try this:

git diff --word-diff=color --word-diff-regex=.

It highlights only the parts that have actually been changed/added/deleted.
As a user I don't love having the sound keep dropping out because I went too close to the train station, or because my phone was rotated slightly wrong in the pocket.
[What I wrote above] is a comment on a submission, not a thesis.

> Studies are done precisely to remove fallacious logic and isolate variables.

Studies could be done to isolate variables, but the standard of care is to 'diagnose' and 'treat'. The sealed court papers in my possession, and my friend's public guardianship court record, is a case study in 'make believe medicine'.

My experience is that allopathic psychiatry is a fallacy. I was more comprehensive in my Mad In America essay (link above)

All patients are harmed by the modern mental health industry's allopathic standard of care, yet it persists. Why is that?

[edit] just finished the article. The conclusion is reasonable:

> After nearly 50 years studying mental illness and following these trends, what hope can you offer us?

> Hope, in my opinion, is not yet in sight. Before we get there, we need to take a few steps.

> First, I think psychiatry has to be more honest about its limitations and not treat biology as the primary cause and recognize the social dimension of mental illness. It needs to stop chasing magic bullets. [...]

So close, so close... "social dimensions" have "biological" implications. IMO 'hope' is in sight, we just have to deal with the businesses that make a business of palliative mental health 'care'.
Iain M. Banks and the culture novels speak of post-scarcity...

https://en.wikipedia.org/wiki/Post-scarcity_economy
If "minimal bloodshed" means "the war must end in Ukrainian victory as fast as possible" then I agree. If Ukrainian victory is not as important as swift end to hostilities then I disagree.

I believe Ukraine needs all the weapons and support so the war can end in a clear Ukrainian victory.

My current view is pretty much aligned with PM of Estonia Mrs. Kallas: “I think what everybody has to understand is that peace is not an ultimate goal if it means that the aggression pays off”

https://www.newstatesman.com/international-content/2022/05/e...
Checked your profile, I have no idea who you are and you're not even in the same country as me.
Many dialects already support using aliases in GROUP BY and HAVING too, btw.

IMO it's most useful (though somewhat more difficult to implement) to be able to use the aliases with window functions or large case/when statements, something like

SELECT
page,
SUM(clicks) AS total_clicks,
100. * total_clicks / (SUM(total_clicks) OVER ()) AS click_pct,
100. * SUM(total_clicks) OVER (ORDER BY total_clicks DESC ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) / (SUM(total_clicks) OVER ()) AS cumulative_click_pct
FROM weblog
GROUP BY page;
MacOS and iOS don't have one but many dictionaries. I have a thesaurus and a few multilingual dictionaries. It makes reading really pleasant.

I wish that Android did this better.
Those all sound like good things to optimize to make a really good headphone driver, but they aren't strictly necessary are they? "Standard" line level analog audio has been a thing for what, 90 years? I could explain to an 8 year old how it works. It's very simple.

Embedding an IC into a cable that talks USB 2.0 doesn't seem like a simplification to me. I'm a staff level embedded engineer, and I wish an 8 year old could explain to me how that all works.

Any DAC still ideally does all the things you listed optimally, so you're just externalizing the same complexity by leveraging the marvels of modern technology. It's a pain to have to carry another dongle. They feel like they're going to damage my USB-C port when plugged in inside my pocket. Do buttons even work at all with those adapters?

I'd rather the smartphone engineers build an awesome DAC and charge me an extra $15 for the phone, rather than have to buy a $15 dongle of questionable quality on Amazon, or a $50 dongle of even worse quality from Best Buy or something.
What? Snow is way worse. There's basically no comparison.

If it rains, you can still drive, walk and cycle. If it snows, your car will get stuck in the snow, your bike will get stuck in the snow, and you will completely soak your boots and pants as you slog through the snow.

Things get somewhat improved when they plough the roads, but the big problem with ploughing is that it polishes the road surface. So if you're walking or cycling, you're constantly in danger of slipping, and it's much harder to control and stop your car. And obviously if you live where it snows, you have to switch between summer and winter tyres twice a year in order to deal with it. Haven't heard of people switching between tyres because it rains.

If you're walking and it snows, you basically want to wait until someone ploughs the roads and then carpet bombs it with grit. Grit that will stay around when the snow melts and has to be cleaned up. And when they clean up the grit, it kicks up a bunch of dust and you get to breathe it in.

I don't think the elderly start falling and breaking their bones whenever a rainy season starts somewhere, but they most definitely do when it starts snowing. The couple of times that I've hurt myself in the past years have been because of snow and ice. My grandma got put in a wheelchair after breaking her leg in icy stairs.

That snow also has to be stored somewhere, so the sides of roads, sidewalks, parking lots, will all be full of massive piles of snow that will obviously eat away space that you could otherwise use. A whole sidewalk might turn into a one-person wide path.

If you're driving and it rains, it'll wipe off pretty easy. If it snows, it wipes off way worse. And if it's heavy snow, it will actually get stuck in the wipers and basically make the wipers useless. Obviously heavy rain is also an issue for visibility, but at least your wipers won't stop working.

And when spring comes, the snow melts and everywhere it wet for weeks. And since it usually fluctuates above and below 0°C, that water will freeze, melt, freeze, melt, freeze, melt, which is once again a shitty experience for all road users.

There's so many downsides to snow that I can't probably think of all of them right now.
I guess he's confused me with someone else, as I'm on the other side of the planet to him. Happens a lot with short usernames in general.
removing the headphone jack solves a problem i don't have while introducing new problems i don't want.
I am interested in looking into your collection. Text editors facinates me a lot.
'On a vegan planet, Britain could feed 200M people’
do scale testing across all the parameters that can grow. profile and see where the bottlenecks occur. whack and repeat until your benchmarks are acceptable for whatever you're anticipating.
> Health care: The U.S. has fewer physicians per capita than almost every other developed country, [...]

Interestingly, the U.S. has about twice as many firefighters per capita than other developed countries.
Right, this. Plus, the paper was probably written by teams, in sections, and giving aggregated feedback.

Rather than attempt to disentangle, large physics collaborations normally have a “You are on all papers we publish while here and X years after you leave”.
You could say that about almost anything difficult that requires a lot of feedback and/or practice.
The reason for that is that the renter's are already paying economic rents and taxing those economic rents does not increase them. Ground rent is a residue that is left over after everyone else took their cut (income taxes reduce land value taxes for example).
Voxel scene with GPU rendering in Python
What’s behind China’s boom in company formation?
> Note you can already reference select list items in GROUP, HAVING, and ORDER BY so it's not that big of an extension.

You're just looking for symbols in the symbol table, I think it's a big difference!

> IMO only allowing references to previous select list items is a perfectly reasonable...

agreed, see my other post where I say the same.

> Though we did allow using aliases in the WHERE clause

And the SQL standards people didn't go for this, and I'm sure they were very far from stupid. And nobody's asking why they didn't allow this, which really bothers me.
I'm sure the irony isn't lost on anyone here that the company that has abused privacy more than any other over the last twenty years is working on this problem. It's like Zuck and his ivory metaverse where he's going to be the only user, because we all know now what he does with our data.
Hardware acceleration in robotics news. RobotCore: an open architecture for hardware acceleration in ROS 2, RISC-V CEO seeks 'world domination', NVIDIA Jetson AGX Orin, Qualcomm unveils RB6 platform and RB5 AMR reference design, Intel sticks with FPGAs and ASICs for next-gen IPUs
I decided to move to Canada after a few years on an H1B for this reason. I got a PR card literally on arrival at the airport! I can do everything but vote and can choose to become a citizen whenever i want. Border agents are nice and don’t make me feel like a criminal, companies cannot exploit me, i can be unemployed or start a business anytime. Zero immigrant stress. Salaries and taxes are worse but its worth the freedom & peace of mind.

Putting aside politics & whether you agree/disagree with US immigration policy, i think going elsewhere is simply a better option for Chinese/Indian immigrants as of now. Most of the West is staring down an aging population and is desperate for young labor, so there’s tons of options. A lot of places have well functioning governments and the demand for technology is global.
Thanks, that sounds mostly sensible.
This guide should point people at a better board than an Arduino Uno. At least recommend something with a 32 bit processor.

This board looks good for a beginner since it has interesting sensors built in:
https://www.adafruit.com/product/3333

Shopping for electronic parts is kind of involved actually. It seems like a kit with a bunch of basic electronic components would be a good idea.
I've imagined utility in making a crown molding be a c.a. 10cm angled piece with space behind, for just these reasons.

Held with screws of course, or otherwise removable and replaceable.
New York is full of the more traditional base but different toppings. Lots of places in Australia are also doing the same. But grand parent is right. The popular vision of pizza is what Italian immigrants exported from the US not what was exported from Italy. And if you want to play the numbers game, go to Asia and ask them what a pizza is.

I’m not sure many people prefer the Chicago deep dish style or “Sicilian pizza”. I’ve not tried either. But dominos and Pizza Hut seem to be some in between thing.

Edit: Rereading mlidners comment and other comments, it's a bit too dismissive of Italian pizza. Italian pizza is still pizza. It's just that American pizza is also pizza. And Swedish pizza is pizza. This is what happens when food is popularised and spread across the world.
> How would you go about showing someone you love the dangers and harsh reality about crypto investments?

Show her the posts about people committing suicide after losing everything investing into LUNA.
> Getting started with embedded systems is being repeatedly told "you're wrong" or "that won't work" until you give up and do something else.

I had no idea I was doing embedded systems for so long.
I've seen quite a few production queries that use indexes in GROUP BY and ORDER BY; it's quite common. Probably partially because linters/code review/etc are lightweight to nonexistent amongst the analysts/data science types that I tend to work with.
If wife is unhappy get a new one:)
I love this idea, i've been thinking about this for a few years under the pseudonym 'compile to cloud'. Would be really cool if I could write some code that uses a dictionary & threads which automatically get transposed to a dynamodb instance connected to a bunch of lambda nodes. I'll keep an eye on this project.
UK Government Blames IT Systems for Decision Not to Raise Benefits
If the legal system is not infallible, is the moral compass of every random NSA worker supposed to be less infallible? If you asked 10 different NSA employees at the time whether they thought the mass surveillance was ethical or not you'd probably have gotten 10 different answers. That's why you really do have to rely on the law to tell you what's right, not any single person's own judgement. Yes, Edward Snowden ended up winning in the court of public opinion but I don't think his victory is deserved.
But this is like complaining that 'the road does not support two lanes of traffic and traffic both in directions at the same time'.
I agree that it's ugly and don't use it myself, but I find that I modify the last item in a list far more frequently than the first. Probably because the grouping columns tend to go first by convention, and these change less.
In Portugal it has to be an investment (350K+ depending on where) which ideally is a house. Purchased with the visa in mind, has to be mentioned in the contract. You should involve a lawyer for that. The house (or apartment) can have a mortgage and be rented out. I learned this from selling a house in Cascais to a Taiwanees woman.
Agreed. The question of whether the build or its location should be taxed is at the hear of the property Vs land value tax. For some reason people think that they are dedicated eviction tools while completely ignoring that they are meant to align economic incentives with human desires. There is no need to have extremely high taxes, just don't keep them laughably low.
Oddly, Iceland rarely if ever gets really cold and even snow is mostly transient. Temps mostly hover between 0 and 10 C (30-50 F), and it rains quite a bit.

It has often been suggested that the names of Greenland and Iceland should be reversed, and/or that "Greenland" was thus misnamed for marketing purposes to entice Viking settlers.