skysight-inc/HackerNews huggingface dataset:
There's a lot more wrong with DDL than the inability of expressing it as DML. Some SQL doesn't scale well, but DDL fundamentally scales really badly. It needs either an async or resumable execution model, for one thing, which doesn't map well to connection-oriented transactions. Big migrations take days to complete. That's too long to be very reliable in a distributed system when operating on a synchronous basis.
Thanks for linking to the original thread. The top comment was a great reminder that the internet is filled with different types of people.
BS.

We need carbon extraction plants and Nuclear power to reverse the changes we are making to the planet.
One day init7 is going to poach you :)
Unfortunately How to write a FUD article on Nuclear,

1. "we don't know if the reactors will save carbon over lifetime".

Surely this is better than strip-mining most of the ocean and asia for rare-earth metals for circuitry and/or batteries.
(Li-ion ones will be needed at a local (and hyper-local) level to store supply/demand fluctuations from renewables).

2. "boogey man". This used to be something like "Nixon backed this over thorium-salt", or "something, something, nuclear-weapons". Here it's "big bill" himself.

The fact the gates foundation is investing in something should make the product be seen as common-sense, e.g. "in the future we need clean water".
(And they want to be in a position to sell it back to you for nominal profit).

3. Bringing up long lead times.

Lets be honest a huge amount of this is public opinion/pressure and political manoeuvring. Nuclear as a word has all of the cold war rhetoric (from all sides) attached to it. If governments wanted Fission plants built within a decade it would happen.
As it stands globally many factors are squeezing Nuclear construction projects due to their admittedly _very high_ up-front costs compared to technologies such as Wind.

The alternatives to starting this now and having it available in 10 years are, realistically, more coal plants.
This is until renewables and energy storage take the next quantum step.

Wind, sun, wave and other renewables are only useful for non-baseline energy production until we invest in huge (normally gravity derived) batteries, and these take a long time to plan/construct/build infrastructure for.

4. Safety

Frankly I've always viewed this as a mute point. Had the Fukishima plant been in a country which doesn't have regular earthquakes/tsunamis it would still be 'just working'.
Why the accident here should mean a plant in the lowlands of Germany (arbitrary geo-location) should close is entirely a political/posturing decision and not one based on science.

5. Not this article, but people mix the fusion/fission work into a mess.

Fusion has been bigger on promise than it's delivered so-far. But frankly this is a no-brainer small annual investment given the potential cost/benefit ratios for clean power, and frankly how close we now are.

Fission plants unfortunately do have nuclear waste.
But then so do dead solar cells, dead lithium batteries, aged coal plants. There is nothing for free. But, when the nuclear waste can be captured in nice small drums and put at the bottom of a disused mine-shaft and sealed off from the environment isn't this the same ethos as carbon-(re-)capture on steroids?
https://news.ycombinator.com/item?id=20577416 114 comments, July 31st 2019
Why is it so easy to believe that there are incompetent fools in power who encourage tech debt and bureaucracy even though it's obviously bad for the business, and so hard to believe there are incompetent fools in power who are suspicious of people who don't look or act like them even though it's obviously bad for the business?
Show HN: vim-profiler – A vim profiling tool written in Rust
Decided to write a little wrapper around the `(n)vim --startuptime` command in Rust for fun. Hope you find it useful!
None of these laws ever apply to political campaigns. Politicians write the laws.
I made the switch back to Apple Maps a while back. It’s great. I’m not sure what specific features you want to know about.
But can you can not (in a simple way) prevent that both a circle and a triangle point to the same user and you can not enforce a NOT NULL for a user to must have a favourite shape.
> This email group is monitored by two people in the banks offshore centre in Hyderabad. They worked super hard and always SMASHED their job; but holy crap it was soul crushing.

4-hour workweek and such books have taught Westerners to de-humanize Indians and give them the most menial jobs imaginable at next to nothing salaries
Uber Eats has been spamming my email with coupon codes for a while so I decided to try it. A one time half-off an order seems like a good enough deal for me to get past the annoying marketing.

After filling in my order and trying the coupon code, I was rudely told that my account wasn't allowed to use coupon codes. Not that there was an unspecific error or anything, they must have specifically coded this path in. Afterwards, I tried the same thing with my girlfriend's coupon code (also rudely spammed) and another account, and no cigar.

Why spam me with coupon codes that I can't use? Was their strategy really as crude as "maybe he'll be hungry enough to not care about the extra cash we are going to charge him after all"? I've sworn off Uber Eats completely now, pulling such a bait-and-switch is unacceptable.
As I said in response to a sibling:
But can you can not (in a simple way) prevent that both a circle and a triangle point to the same user and you can not enforce a NOT NULL for a user to must have a favourite shape.
Regardless, their monthly (annual actually) fees are the same for 25G/25G as for 1G/1G. Only the setup fees are higher, which they attribute to more expensive optics. 10G/10G is completely identically priced to 1G/1G.
Really? That’s not clear to me at all yet.
I agree with the notion. It was pretty terrible for the first 3 years. A second place contender for a few years after that, but for the last few years it has been clearly as good.

I am not going to enumerate strong and weak points. It’s a matter of taste at this point. Just try it again.
Thanks for answer, I got why it can be useful
Among the various languages I use, why is SQL the only one that favors ALL CAPS EVERYTHING? When writing ad hoc queries I ignore that convention just to be ornery.
Yes! Carbon negative should be the goal.
5-MeO-DMT: Light and Shadow in the Psychedelic Toad
Thank you. I've been torn about a private vs. public life. I have always enjoyed the immediacy of the moment in life having lost friends while still in my teens. I am very tech savvy, and I love GoPros and smartphones for what they are, but I rarely film or photo myself. I do journal, so perhaps when I stop playing around, I'll try writing a book for my children.
"probably consuming like x100 the power" is greatly exaggerated.

A typical PC might have an idle power consumption of less than 50 W, while a very small computer with ARM little cores might have an idle power of 2 ... 3 W, so at most the power consumption ratio would be 20.

However even that is not realistic because a computer or appliance with less than 3 W power consumption will not be able to route 10 Gb/s or faster links and it will struggle even with multiple 1 Gb/s ports.

A dedicated router appliance able to route 10 Gb/s or faster links will probably have an idle power of around 10 W or even more.

For routing only 1 Gb/s links, you can use among the standard PC's a NUC-like model, which will have an idle power consumption between 5 W and 10 W, quite close to a dedicated appliance. This is actually what I am using for my own Internet router/firewall (which also runs many other services, e.g. DNS server and proxy, NTP, e-mail, HTTP server and proxy etc.) with 1 external 1 Gb/s port and 4 internal 1 Gb/s ports (4 of the 5 ports are made with USB to Ethernet adapters).

Some of the more recent NUC or similar computers have multiple Thunderbolt ports or 10 Gb/s USB ports, so those can be used to route multiple 10 Gb/s links (using Ethernet adapters), with an idle power of around 10 W, similar to any equivalent commercial routers.

For 25 Gb/s Ethernet links, a commercial router is unlikely to be much cheaper or to consume much less than a standard PC.
If they were interchangeable, they might start to look like employees. No, best to keep them looking like snowflake contractors… for tax purposes.
Why Netflix movies look so weird
You can see the beginning of new languages evolving with the the mix of multiculturalism, taking words and expressions from their old languages and adding to the new language where they live. And because the majority does not have these words and expressions, and probably never will, eventually they will diverge. Yiddish is a example of this.
I always thought "serverless" referred to AWS Lambda style services. Recently I saw it used to refer to cloud computing. Is this a common interpretation? It really took me by surprise.
I almost entirely use Apple Maps. I live in a large city so the data is very accurate. And I only really use it for driving, so I can't compare transit, hiking trails, etc. When I travel to less populated parts of the country Google Maps is far more accurate and complete. That's the only difference I've noticed.
I had the opposite experience with chipotle the other day. I had a coupon code and nowhere to enter it. They clearly thought the same thing and hid it in the account settings screen
> I'm still waiting for the Republican (formerly alt-right) alternatives to YouTube, Facebook, and Twitter to get anywhere near the formers' popularity.

"In 2019, Fox News was the top-rated cable network, averaging 2.5 million viewers."[1]

They've not only become as popular, but the most popular with TV. Why are you confident that this can't happen with social media?

And the metrics of money and users don't really capture the whole problem. You're right that Parler never reached the popularity of similar non-insane services, but they didn't need to have the majority of money and users for a mob to come less than 100 yards from lynching members of congress. Reaching a majority is a barrier for peaceful democratic movements, not violent totalitarian movements.

[1] https://en.wikipedia.org/wiki/Fox_News
Thankyou for posting this. It makes absorbing the article content so much easier!
The basic premise of the relational model is that the physical storage structure and optimizations (including indexes) are independent of the logical model. A table could be stored row-by-row or column-by-column or any other clever way without it affecting the schema and queries - although it will affect the performance of the queries.
Certainly not a term I've heard used to refer to licenses but it sounds less political than copyleft and I found it immediately understandable.
I’m not sure those rules are as hard and fast as you think they are
Why your friends have more friends than you: the friendship paradox
> they would evolve the language in such a way that it would become capable of expressing these nuances.

Would they? Or would they need to fork the language away from the common base?

Nuance and expression are produced by the speakers of the language having distinct experiences and finding distinct ways to express them.

Understanding other people doesn’t magically come from having the same language. It requires learning to understand their experiences.
This sounds like the kind of neurotically self imposed stratification that could lead to socioeconomic and cultural segregation for dating circles.
Rather than go into a long rant about how this is bullshit FUD, I’ll just remind everyone that the founding donation to Friends of the Earth (anti-nuclear NGO) was made by Robert Orville Anderson, an oil baron.
Second that,

the first email I get after I unsubscribe will be reported as SPAM
I used it occasionally, at one point it was better than GMaps when data connection was spotty. But sooner or later I'd always go back, because directions-related features always felt better in the Google world.

This is in Northern England though. In the Big Smoke it might be different.
what if i said i think its dangerous that you operate a car, and worse, you encourage others to drive cars when they see you driving a car.
I tend to use slack this way. Writing out my thought process helps to clarify things, even if I don't ever hit the send button. And if I do hit send, then it gives a good sense of what has been done, and how.
It's definitely an interesting approach. I imagine it makes the parsing much easier.
That is an awesome little demo video. In 10 seconds I understood what the tool does, and it looks pretty useful too.
I think this is telling us to drop X windows / Wayland, it's time to acknowledge that's a failed experiment. We should go back to just terminals and load firefox in framebuffer when we need that. ;)
It looks closer to 3.5Mwh:

http://shrinkthatfootprint.com/average-household-electricity...

But still that's far lower than the US at 11Mwh. Maybe A/C and home size accounts for most of it.

We're a family of 3 and on track for around 8Mwh this year. We only use AC on the hottest days (Southern Californian climate so it's quite manageable throughout the year), water and dryer are gas - but I have a homelab which could be optimized.
If anything, he is complete opposite of webshit.
Nuclear waste storage is the most histrionically exaggerated environmental issue of all time. Yucca Mountain is rated to hold the stuff for hundreds of thousands of years. We really only need about a hundred. After a hundred years, we'll probably have effectively unlimited energy sources and a space elevator, and we'll be able to chuck the stuff directly into the Sun if we're still fussed about it. Which we won't be, because the lack of accidents will have completely inured people to the existence of the waste storage sites, and my great grandkids will be whining about how they can't get funding for their cool Chuck Nuclear Waste Into The Sun Project. (And they will be right - society has always been stupid to not divert a little money into mitigating long-term existential risks!)

People would rather let the planet literally burn to death with 100% certainty than take a 0.0001% risk on a leak of the scary radioactive stuff.
Apple Maps has a different tracking/lag time on your location compared to Google Maps such that every time I try to switch I start missing (a lot of) turns while driving. Maybe it’s time to just get used to the different cursor…
safety furze.

i like it.
> Isn't this description also an assumption? Do you have an example of this? Groups of people who have the same language, but have hard time understanding each other?

There are two obscure tribes found in a remote part of the North American continent in which this phenomenon can be observed. I believe one calls itself ‘the Democrats’ and the other ‘the Republicans’.
Yeah, I had a French friend call me “Anglo-Saxon” and I was very confused. Most Americans aren’t even nominally familiar with the term and I only knew it in its historical sense.
Solar panels and wind turbines are ready to go. They can take you to at least 50% renewable electricity without help of any other more experimental technology. Heat pumps are ready to go in most climates. They can electrify almost all of your heating needs. Electric cars are ready to go for many use cases. They can electrify a large part of your transportation. Of course there is also technology that is a hundred years old and could help: better insulation for houses, better public transport and the like.

While you introduce all of those technologies until they reach some point where they're not completely suitable yet, you have time to improve the cost effectiveness of the puzzle pieces that are only kind of available, like grid scale storage, long range transportation, various industrial processes, etc.

Maybe it turns out that by the time we've electrified everything and taken renewables as far as they go without killing the grid somebody has come up with a modular molten salt Thorium reactor that can cheaply cover the remaining electricity needs. Maybe power2gas becomes amazingly cheap, or we discover awesome batteries. But it doesn't really make sense not to build as much renewables as you can and electrify as much as you can while you wait for that.
Send bank staff in sensitive operations on leave without intimation: RBI
> They wanted to move up, they wanted to speak French.

As a native speaker of one of the languages that France is successfully removing, I find your words deeply offensive. The suppression of languages of France has not been a peaceful or voluntary process, but a very violent one. Shit; school kids were ridiculed and reprimanded by speaking other non-french languages at the recreation yards! How evil is that?

We have agency. Problem is that we are overwhelmed by a much powerful opponent that is actively trying to eliminate us. Now I'm living in Paris, and I'm sad and dismayed at the incomprehension of most native french speakers to the plight of the people of their own country.
I'd buy it if he has the right permits and building approvals. House with a tunnel and underground bunker - count me in.
If you are OK with external USB drives, I did just that with my Atomic PI [1] (Atom-based, 35$ SBC, 3.5W idle, running Debian on its internal EMMC, with two external USB drivers in ZFS-mirror configuration).

[1] https://www.thanassis.space/atomicpi.html
can you please share more details about the tool and what did you do? I feel I am in the same boat, and a bit lost :)
what about driving cars.

are you against that as well?
Tell that to the non-senior SDEs whom either (1) don't have the clout with management yet, (2) don't know any better, or (3) have drunk the the lines of "work hard, have fun, make history" a little too deeply.

Enjoy your seniority; you're harder to replace. But don't apply that experience liberally to the rest of Amazon SDEs.
Yes, this seems to me like mostly FUD, because there is no line of reasoning to be found (I read it on outline.com). It says it takes too long to innovate, without any concrete evidence, afaik there are many innovative reactor designs waiting to be constructed. Maybe not next-gen, but better than past ones that need to be shutoff at some point. Also the old design PWRs still work well and can be constructed today within a few years, so definitely worth pursuing.

Economically more viable than burning stuff that literally comes out of the ground and there is near endless supply but destroys the climate? Definitely not, but neither are renewables. The economy won't safe the climate.

Arguments against nuclear would probably be fuel availability/harvesting and safety.
You can do that with a check constraint, although I don't know if you consider it simple. It would be cool with better support for common constraint patterns.
We are currently building new fossil fueled power plants all over the world, and in some cases as an response to closing down nuclear plants. If the argument is that nuclear power plants take too long to be an effective solution to climate change, building new fossil fueled power plants can't be the alternative.

Rather than advocating against new nuclear power plants, start by advocating a complete stop against new fossil fuel power plants. As long we continue with renewing and expanding the capacity for fossil fueled energy, all the discussion about nuclear in the context of climate change becomes silly.
I think "few days" is also a sort of baked in phrase from the early days of large email lists.

I managed a multi-million member mailing list in the late 90s. It would take 24+ hours to send a single mailing, despite us writing our own multi-threaded SMTP senders, per-destination optimized number of concurrent connections (too many and you get blocked, too few and it's too slow), highly managed hard/soft bounces to keep the list clean, etc

Aside from the "day to deliver", it was still pretty common for mail providers to have deep SMTP queues that were very far away from real time. They would very commonly hold mail in batches and deliver them a couple of times a day.

So, we would say "a couple of days to unsubscribe" to account for all that. I noticed other large email lists using the same terminology.

Then, the smaller lists would sort of "cargo cult" this messaging because the lower expectations made their life easier.

My guess is that everyone held onto that as email delivery tech improved to give themselves more leeway, or sneak in a few extra "last" emails, etc.
These are all pretty slow on 32-bit integers, which you're using for testing. Could you please include a comparison with pdqsort, or at least mention that pdqsort is to be preferred when an element fits in a register (as it certainly will be if you're only beating timsort by 20% or so)? It's frustrating to see sorting algorithms with some effort spent on benchmarking and still have to guess at whether it's practical based on how much slower the comparison points are than the state of the art.

Radix sorts (like your own wolfsort!) will also be much faster on the benchmarks presented, although that's sort of misleading since they are very good at uniformly random input and not so good at other distributions.
I'm sorry, but duh? Is this controversial? Solar, wind and batteries are all now in the steep part of an S-curve and fundamentally have far stronger economics behind them on Earth for the foreseeable future. They don't require special military risk materials or restrictions, the core materials are widely available and cheap, they have massive multiple use, both centralized and highly decentralized usage cases, capability for amortization across a huge range of industries as well as residential, etc etc etc. Just like we've seen so many times before, it is unlikely to even matter if other solutions have certain strengths in certain cases: sheer scaling leading to enormous R&D, capital investment and refining of implementations trumps somewhat better features nearly every time. Same reason hydrogen is total dead end, debates about its merits frankly don't even matter in the same way debates about POWER/PowerPC or MIPS or Alpha or whatever ISA's merits vs x86 didn't particularly matter. Even thermonuclear fusion is probably just plain too late at this point to have any critical impact on AGW.

Now, I strongly support both nuclear fission and fusion continuing to get development and investment, even if it needs to be government to do it. Fission has a lot of other non-energy very important use cases like medical or utility isotope mass production for which net energy production is a nice cherry on top. We'll also need nuclear power longer term for outer solar system exploration and development. Even in terms of pure power production, modular micronuclear could have a valuable role to play at latitudes near the poles or exotic situations.

But there shouldn't be any illusions about where the train in general is going. Solar and wind resources are so abundant they can cover all energy needs, storage and grid improvements are massively efficient and help everything anyway, and they've all got the market behind them. Tipping point passed awhile ago. That's that.
My honest take is that it's rare to name your tables and columns with all caps, whereas there are various cases where people do so with camelCase and snake_case.

In the end this makes spotting SQL-specific functions much clearer. I find it much easier to read SQL with this convention since my brain immediately knows when it's looking at context/project-specific data or a FUNCTION.