skysight-inc/HackerNews huggingface dataset:
This feature is absolutely outstanding, I use it all the time. Unfortunately they buried it in the "File" menu recently. It was so much easier to reach when it was unter "Version Control".
PostgreSQL: Some regular-expression performance hacking
sqlc can do this: https://sqlc.dev/
Software Engineers struggle to write “chunks” function
Yeah but you'd have to get out there with a pump to change pressure, I think that's the real benefit with this technology. I ride on the road to get to my trail head, and ride at about 20-25psi on 2.8" tubeless tires once on the trail. They're a real drag on the road at that pressure, so I have to stop and pump them up or just deal with the drag. If I could hit a switch and have them inflate themselves back up to 40-50psi for the trip home that would be so awesome.

Even on the trail it would be good, downhill at low pressure then put some pressure back in for the climb. Or maybe a bit more pressure for the jump trail and so on.
I wonder if any of these politicians actually believe what they say, or if its craven self interest all the way down.
The connection to the monitor is physically located on the video card. So the gpu could display whatever it wants without asking or coordinating with the motherboard.
Nah, your concerns are 100% reasonable - they just operate on a different context. On Earth, latency is king. On Mars, especially until the Primary Mission is complete, it's all about risk mitigation. Since we're light-minutes away from Earth, a few frames of latency is nothing. At the same time, you want to avoid breaking your $3B machine, which is hard to operate given the time-of-light delay and comms limitations. Just a different set of tradeoffs. IIRC they first tested on-device deep learning for hazard avoidance in Curiosity, but don't quote me on that.

-Worked at JPL for a few years and have dozens of friends, a few in the vision system.
It is a high level policy agenda, not a 10k page regulatory document. There are literally dozens of references to making infrastructure robust to the impacts of climate change, for example:

"Americans deserve infrastructure they can trust: infrastructure that is resilient to floods, fires, and other climate threats"

If we are going to criticize Democrats for not explicitly discussing an extremely niche grid infrastructure issue in their platform, maybe we should also criticize the fact the republicans didn't even bother to publish one this past election cycle[1]

> But this issue is about winterization/maybe connecting Texas to the national power grid. Can we just argue about that here?

What is there to argue? Texas failed to adequately winterize. They should make sure to fix that. End of argument.

[1] https://www.vox.com/2020/8/24/21399396/republican-convention...
Nassim Nicholas Taleb's Amazon Book Reviews
I remember watching that show as a teen, always a pleasure to watch.

Fun fact, the presenter played the Baldrick character in Blackadder
Netlify is great, I was on GitHub Pages and Neocities before, but after I got my own domain, moving the site to Netlify was a matter of minutes.
https://vimtricks.com/p/vimtrick-time-travel-in-vim/

Commit often and use reflog?

https://www.w3docs.com/learn-git/git-reflog.html
In my opinion naming it global warming was the biggest mistake. People hear it‘s getting hotter, don‘t see this effect and „don‘t believe in it“. Events like this is another point why people don‘t believe in global warming, they see very cold weather outside where this is very untypical and say global warming is bullshit.

It should have only been named climate change, drastic wheather change or something incorporating your naming of shifting wheather patterns.
Is it similar to Twitter with additional functionality of subscribing to external RSS feed?
Require that the power companies in Texas winterize their equipment. Done.

The electric company in El Paso, which is not part of ERCOT, did spend heavily to winterize their equipment after the 2011 cold snap. El Paso did not suffer outages this year like the rest of Texas.

Producing heat in the winter is a solved problem. If power companies are not applying the known solutions to a recurring problem, then apply state force to require them to do so. Done.
This is part of the IntelliJ IDEA platform, so all of the JetBrains IDE products have it. I don’t use it often, since I normally rely on Git, but it’s saved me several times after I accidentally deleted a file or made a mistake with Git.
I really want to thank Tom G. Lane[1] for his work on postgres.

[1] https://en.wikipedia.org/wiki/Tom_Lane_(computer_scientist)
I think the reasoning behind keeping those cancelled accounts for such a long time is to keep the account's watchlist and/or recently played items - I'm not sure about the latter, though.

Either way, I agree with you that this is not right.
SQLite did get support for renaming columns recently [1].

Anyways, the process you describe is also used in MySQL for doing online schema migrations. [2] "proper" database migrations cause downtime

[1]: https://stackoverflow.com/questions/805363/how-do-i-rename-a...
[2]: https://github.com/github/gh-ost
I have the feeling JetBrains do not understand how important this feature is for some developers. It does not have a shortcut and recently got buried in the File menu, almost as if they are ashamed of it. I am using it all the time and life would be much harder without it.
And some of us have been cooped up with spouse and kids for almost a year. When I get a little alone time I'm especially grateful.

Still, I'd love to go to this bar! Or the pub down the street.
But in this particular case, all signs point to the panic being significantly hyped-down: the world is in a much worse shape than most mainstream predictions, and global warming is accelerating faster than many "worse-case scenarios" even a decade ago.

It's also important to remember that this isn't a gradual phenomenon - there are certain break points that, when we'll reach, we won't ever be able to go back. And by all accounts, unless we significantly change the global economy literally today, there is no chance that we won't reach those breaking points in 50-100 years. And even if we did today, there's a good chance it's too late.

The mess we're leaving for our children to fix should make all of us feel deeply ashamed.
short airbnb. this is clearly their priority
It might be the same space needed, but in another area. It's much easier to transport electricity than goods and definitively better for the air quality.

If you can produce electricity 50 km away and then produce produce in the city center, you are sparing the transport costs.
You're right that we are all complicit...

In my mind, I sometimes get this visual of that scene from Full Metal Jacket, the one with the towel and bar of soap...

I get that sense that we're all taking turns thwacking our biome/biosphere/relatives a couple of times and then passing it...

I commend you on your efforts to reduce your complicity and sharing your successes for our inspiration. Thank you.

(I still think anything is better than brand new when it comes to electronics, but you're way ahead of the pack.)
And increased sedentarism because of lockdowns.
What’s the recommended practice for CN on a certificate with multiple SANs? I imagine many tools and org process still require at least some value to be present.
I don’t really care what the GP was doing. Tourists come to the puget sound and fuel an economy of boats that swarm an ostensibly endangered group of local whales. Why would I care what a person who thinks that is funny thinks?

There are seventy five resident orcas in the puget sound. Seventy five. Their lives are disrupted by 100 years of industrialization and we’ll be lucky if they’re here in 2121.

For what it’s worth I went on a whale watching tour a few years ago. I regret it.
The author wrote a blog post about it: https://just.billywhizz.io/blog/on-javascript-performance-01...
Before Microsoft bought GitHub and killed Atom, they were working on Xray[1] & Memo[2]:

> Memo is an operation-based version control system that tracks changes at the level of individual keystrokes and synchronizes branches in real time.

[1] https://github.com/atom-archive/xray
[2] https://github.com/atom-archive/xray/tree/master/memo_core

So, it would fix this problem, and also enable real-time collaborative editing, had it been completed.
Everything Everywhere Is Securities Fraud (2019)
After a while, reality comes back to bite you.
Yeah, people wearing too much concealer put them right into uncanny valley too. Like a "bad shader cosplay" kind of thing.

And it's one of those things I don't get (or, I do get it, but I disagree with) - I think imperfections and character are things to be celebrated, not hidden and removed.
It's likely because of this (custom Postgres client, request pipelining and not doing sync/commit after each query):

> [Multiple Queries] This is the first test where Just(js) has quite a big lead. This is likely due to the fact it is using a custom postgres client written in Javascript and taking full advantage of pipelining of requests. It also avoids sending a Sync/Commit on every query. As far as I am aware this is within the rules but will be happy to make changes to sync on every query if it is not.

https://just.billywhizz.io/blog/on-javascript-performance-01...
>> That is an idea from the 70s.

No, that is an idea from economics predating the 1970s. Did you mean the 1870s? It predates that.

You can value a stock however you like. Good luck, I wish you well.
> The code weaver approach doesn’t sound like something like hat is accessible to small time people... did they have to build their own thunking layers?

It wasn't easy, no. They had to do two things:

1) Fork clang and extensions to C to support mixed 32-bit and 64-bit address spaces

2) Get a special code-signing entitlement from Apple allowing them to call the API to enable 32-bit code execution (not required if you are okay with disabling SIP)

Lots of technical details here: https://www.winehq.org/pipermail/wine-devel/2019-December/15...

Yeah, this is a monumental effort that few other than Codeweavers could replicate, and I believe they got some help from Apple engineering to do it.

They've open sourced their code, but they aren't upstreaming it into mainstream Wine – having to use a forked C compiler is just a bit too much.
Are there any alternatives?
If you buy the legal fiction that Uber drivers are independent owner-operators of their own businesses, this would be illegal collusion in restraint of trade.
Thanks, SOD32 looks interesting. It also led me to find this: https://github.com/kt97679/relf
Have we any idea when that video will be released (roughly).
> Goes to repost on facebook

Oh yeah
The way things are going at the moment, I'll have to emigrate to somewhere "sane" like Belarus in order to even meet another person.
I flagged this because it's a screenshot of a Daily Beast article via Yahoo News hosted on imgur. Just post the original. Images are an incredibly backwards way to share text on the web.
Simonw (creator of Django) has also big list of contributions, so it is perfect for this
This is my most used IntelliJ feature
Well, people in Latvia were very upset about plant in Ignalina - not because of the distance from Riga, but because of a very close distance from border of Latvia(because not all of them are living in Riga).

I guess, this is a very political topic and that has nothing to do with technical parameters of plants, because Belarus is constantly polluting rivers and that pollution is coming through into neighbouring countries. And there is nothing that these countries can do about and power plant belongs to the same issue.

Yeah, your commenting activity doesn't seem to be Russian troll at all to readers of NH, but for someone who has to encounter similar active trolls in Baltic sources, this doesn't seem like credible non-troll activity(paid or unpaid - doesn't matter). So, under a threat of being blocked here, I think, that it should be noted that some of the behaviour of cbmuser(and accompanying friends and "opponents") ticks most of the flags of what in Baltics is known under a name of "Russian troll factory", where they are actively swarming on specific topics.
Any positions open currently?
> C - catastrophic - there is no evidence in the historic temperature record that anything unusual is happening.

There is no evidence in the historic temperature record that the Earth has ever been this hot in the past million years.

> A - anthropogenic - the human contribution is small, compared to natural sources.

The human contribution to CO2 and other greenhouse gases is not small, it is almost the entire quantity. There is very little contribution to greenhouse gas emissions from non-human sources (of course, methane from cows for example is a human source).

> G - global - not local.

Not sure what you mean here.

> W - warming - see above.

see above.

> In addition, there is no good evidence that the slight warming in the last 50 years is causing extreme weather events, and there isn’t any good theory to support it, either.

The brainwashing propaganda from interested science deniers is not better informed than the practically unanimous conclusions of all the earth's climate scientists.

The Earth is headed for catastrophe, both ecologically and geopolitically. Sea level rise is already above initial predictions, and that effect alone will displace the 300 million people currently living in one of the lowest plains by the sea in the world, in Bangladesh. The coming migrant crisis at the confluence of India, Pakistan and China, three nuclear power with an uneasy relationship, would be cause for serious concern alone.

Of course, the ever increasing droughts and extreme temperatures (including >50C wet-bulb temperatures, which can kill healthy adults outright) in those same regions makes them a literal hotbed for social and political upheaval like the world has never seen.

You are simply deluded if you think everything is fine.
This is an effort from the French « Ministry of Europe and Foreign Affairs » to reduce the impacts of information manipulation on the Internet.

In this particular case, to follow the changes to various Internet service terms (other initiatives exist, apparently).

I’m impressed, because it shows an amount of Internet business literacy from my governement, aiming at helping people and businesses.

It shows they’re not blind, that they care, and in an open / free attitude.

It makes me feel good today!
Not from the perspective of an ISP. Doing this would transform broadband from a value added service to a commodity. In a commodity market, competition is stiff and this often drives profits down to an absolute minimum. The cushy profits they are currently enjoying would evaporate in short order as soon as anyone sensed that there was money to be made by drilling fiber and racking a switch in that colo.
Does part 2 exist yet? This is basically an explanation of what FPGAs are and a "hello world" nMigen example.

That said, high-level HDLs like nMigen are very promising for education, and I hope more people take the same first steps as the article's author did. It's a fun field.

And along those lines, here's hoping that MIT updates their free 6.004 edX course to reflect the in-person class' new RISC-V focus soon.
I believe Clickhouse is competing with other analytical, OLAP databases, not something like vanilla Postgres or MariaDB or Oracle.

This is not your application backend database.
> A simple example is, say, foreign keys. Trying to access the foreign key of an object by doing `book.user.id` does an additional query for the user table to get the ID. It's less known that the id is immediately available by just doing `book.user_id` instead.

Hibernate (on Java) at least optimizes this specific use-case. At first, accessing a lazy-loaded property-object will give you a "proxy" and you can access the ID without incurring a database load (since it knows that anyway). And when doing a query, the object won't be joined when requesting book.user.id unless it needs to be (like you have some other WHERE clause that requires an actual join on that row).
Nobody had a problem with it being "global warming" until the mid 90s when political interests made a culture war point. They would have done so regardless of how accurately the phrase described the phenomenon.
It's a little bit more complicated than that. The primary "extreme weather" predictions I remember from 20 years ago was more hurricanes. We do seem to observe and name more hurricanes (in part, at least, due to much better weather equipment), but fewer hurricanes have made landfall in the United States. https://www.statista.com/statistics/621238/number-of-hurrica.... Other extreme weather statistics are similar - we spend a lot of time talking about polar vortexes (vertices?), but many of the cold records are from back in the 1930s. I don't doubt that the world's temperature is rising, but I continue to view the extreme weather predictions as fairly speculative and a distraction from the core issues - temperature rising, ice melting, sea level rising, with unpredictable effects. If you had some more academic (and less click-funded) sources to share related to data demonstrating the extreme weather hypothesis, I'd be interested in taking a look.
Update: I have written a follow-up post in response to the above thread

https://blackshaw.substack.com/p/pay-2
This is the one thing above all else which has kept me off Go. Tentatively comment out a line or two and the whole compilation process may come crashing down because now you have a declared but unused variable, and mere warnings apparently aren't Gestapo enough in this particular universe. You then find and comment out the offending declaration, only for the compilation to die in flames again because now you reference a never declared variable. It gets tiresome after a while.
Not usually the case in foreign relations. See arms-producing countries vs. arms-consuming countries.
https://gossips.cafe/
Rewrites succeeding is the expected outcome, only articles of when they resulted in a catastrophe will bubble up.

Typical scenario: A team rewrites their code, they succeed, nobody notices since things are still running, end of story.
Yes but read the article. It's the way the "author" presented the work as novel that's indefensibly hucksterish
> This is silly, we are all observed by other people almost all of our lives, but that's fine because they don't conspire behind our backs to create a comprehensive record that's handed over to the government.

While I agree with most of what you say, and also almost everything from me is relatively easy to find, my parents and family experience living under Salazar´s dictatorship, or the lasting effects from Stasi over here in Germany, keeps me always aware to keep a good price in what we give away.
For Firefox there is the 'Auto Tab Discard' addon. It has the ability to discard (unload) tabs after a certain amount of time or the number of non-active tabs is greater than a number, these are set in the addons options. Also has the ability to whitelist tabs, web sites, so that they never get unloaded.

https://addons.mozilla.org/en-GB/firefox/addon/auto-tab-disc...
Are unused variables really compiler errors in Go? That does seem very harsh, and very counter productive while developing. -Werror is all well and good, but while I’m in the middle of writing the code, it’s a bit much.
10 years ago I did exactly this for the University of Wisconsin. My job was entirely to facilitate data extraction out of oracle databases / PeopleSoft for longitudinal studies done by faculty or other interested parties.

There were a few dozen of us spread across the UW System who's sole job it was to extract and massage data from these databases... One, very large, central database that handled data for UW and every satellite college they had.
Sometimes old software can't keep up with new hardware. E.g. the FOSS alternative nvidia drivers for linux Nouveau. Totally uncompetitive - no support for the last 3-4 generations and the ones that run are just better than software rendering.
Maybe it's the rural setup where I'm from, but I'm glad that in 2020 and 2021 I barely visited bars. Summer was spent by lakes and forests, drinking beers, cocktails, appetizers, and eating freshly grilled BBQ for a fraction of the price, having quality time in the sun with friends.

I don't miss commercial society, I don't miss their tropes and their rituals. Fake friendship and banter from people hanging around to get some of my money in exchange of half a glass of ice and a dribble of liquor.

Bonus annoyance this year: the eternal covid lamentations of bar and restaurant owners, as if governments purposely wanted to destroy their businesses, as if one's bar is more important than other people lives, as if they didn't paint themselves and their stupid restaurant for years as an example of entrepreneurship (apparently the free market is a good idea only when your business goes well).

To hell with paid service, picnics and aperitivi in the main square with cheap liquor and (honestly) friendly smiles.

"I command this dump to wither, board its doors and windows forever" as Dan Feeder says.
Nuclear energy is the Amiga of energy sources.

Ahead of its time, it was unjustly rejected and persecuted by the ignorant masses. Its advocates are bonded by the quiet pride that at least they weren't unthinkingly siding with those masses. (And they're right!) Meanwhile, as the Amiga stagnated for terribly unfair reasons, other, scrappier technologies like the i386 and UMG-Si grew from being worthless boondoggles (except in special circumstances, like spaceflight) to being actually far better and cheaper. But the Amiga advocates keep the faith, sharing their suffering and resentment. They inevitably try the alternatives a little and perhaps even start to like them. Gradually their denial recedes, decade by decade.

But they know that however much fab costs go down and leave their beloved Amiga behind in the dust, you'll never be able to run nuclear submarines and Antarctic research stations on solar panels.
And they only need to provide the modifications to people who downloaded it I think.
It's funny that they never say. (My mother-in-law asked if it would go back to orbit, too.) Saying "it flies far enough away to be sure it won't hit the lander when it crashes" would sound funny. They never seem to drive over to check it out, either, AFAIK.

It started with ~800 lbs of hydrazine fuel on board that had to slow tons moving at 200 mph to a dead stop, and then hover for 10+ seconds while the lander spun down; and then boost away and crash. ("Crash-land" sounds like entirely more control than what really happened.)
Thanks for introducing me to the French Space Guy! I am hooked.
Had Texas been attached to the eastern interconnect, and remained connected through 25-30 GW of shortfall, yes, rotating blackouts would have been spread across dozens of states.

The blackouts in the MISO and SPP areas were not as bad, but still had to happen to weather (pardon the pun) generator failures.
Apple should tone down the way they promote their products.

They can't keep pretending to be aligned with the environment and then put on a big show every year for products that provide tiny incremental benefits. I'm thinking mostly of the iPhone, but even things like M1: yes it's a step forward but that doesn't mean I *need* one right now.

For the record, I'm using a 2012 MacBook Air (8GB) for everything. The fans will spin up sometimes when browsing, or when Docker becomes uncontrollable, but it does everything I ask and it doesn't feel at all slow.
There's no normal, there's only what you create now
It's also accessible from context menu in the editor, I use it from there.
I feel like this has the potential to damage the NewsCorp media here in Australia far more than it might damage FB. It would be fascinating to see what happens to their web traffic before & after this change.