skysight-inc/HackerNews huggingface dataset:
It wasn't anything that fancy, it's just the solution was something you usually try not to do so it just wasn't coming to mind for him. The data being looped over came from solr, and some of the fields were primary keys used in lookup tables in the database, for getting translated text. Instead of doing the lookup inline, load the entire table into a python dict before the loop (<100 rows for each of these tables) and do the lookup from the dict in the loop.

And like I said above, usually you don't just select out the entire contents of a table and handle it in the application, so I reflexively did the wrong thing as well, because of how easy it was to do with Django's ORM.
30 year decommissioning is somewhat optimistic average based on current plans.

https://en.wikipedia.org/wiki/SAFSTOR “For nuclear power plants governed by the United States Nuclear Regulatory Commission, SAFSTOR (SAFe STORage) is one of the options for nuclear decommissioning of a shut down plant. During SAFSTOR the de-fuelled plant is monitored for up to sixty years before complete decontamination and dismantling of the site, to a condition where nuclear licensing is no longer required. During the storage interval, some of the radioactive contaminants of the reactor and power plant will decay, which will reduce the quantity of radioactive material to be removed during the final decontamination phase.”

For example, Crystal River 3
(Florida) “Duke Energy announced in Feb-2013 that the Crystal River NPP would be permanently shut down.” “Systems Removal & Building Remediation(2070–2072)“ and that’s if things go well. https://en.wikipedia.org/wiki/Nuclear_decommissioning

As to indoor farming.

“It’s not just that the 4 billion tons of uranium in seawater now would fuel a thousand 1,000-MW nuclear power plants for a 100,000.”

That sounds like a lot, but of you want ~100w of power per m2 that’s 0.1GW of power per km2. So your 1,000 GW power plants are only replacing 10,000km2 of farm land. Meanwhile agriculture takes 51,000,000km2 worth of land. In other words replace 20% of global farmland and you got ~100 years worth of uranium from all the worlds oceans, it’s replaced by rocks.

But, “And those rocks contain 100 trillion tons of uranium.” gives you 2,500 years which is not bad, but that’s not going to be replaced.

PS: You might be able to beat 100w/m2 indoors, but remember this is also for 20% of farmland.
I was hoping someone would give this answer.

OK... so what exactly is "ownership"?

A buddy of mine mined ~160 BTC (currently about USD $8.1m) back when it was fairly worthless. He left it on a hard drive on one of his many machines. BTC became worth something. He look for said machine and HD. Couldn't find it. That BTC is effectively gone forever. So... who owns it?

There are a not small amount of stories like the one above for various levels of non-trivial amounts of money (tens of billions). https://www.nytimes.com/2021/01/13/business/tens-of-billions...

Situations like this point to a desire for many/most people to want some sort of custodianship so that they don't accidentally lose something that might be worth millions one day... or even hundreds or thousands one day. At that point, one is looking at banks and banking systems, so we're back at square one.

If one is looking at an alternative to banks, we sometimes/often get stuff like Mt. Gox and Bitfinex -- a situation in which a group of people who want to be independent of the banking system learn the lessons of the value of the banking system the hard way.

So I guess where I am at is that I appreciate a desire to rebel against banks -- they wield way too much power. That said, I don't think that it's particularly prudent (or maybe even possible) to throw the baby out with the bathwater on this matter. The banks definitely do some fairly nefarious stuff, but they also do a metric shitload of very pedestrian-but-useful stuff extremely well on a daily basis. Until a coin can replace that pedestrian-but-useful system with equal grace, I doubt that a coin will be able to replace our current system. Furthermore, somehow if it does, it will be because the current system integrates coins into the current system rather than coins usurping the current system.

So again... what is distributed consensus and verifiable transactions with no central trusted authority actually useful for?
Blockchain Crowdfunding Application – Launch your campaign now
Hi there, I'm a developer at the Token Republic, a blockchain crowdfunding application. We are currently looking for great projects and entrepreneurs to launch campaigns on our platform. I'm excited to share this project and am very willing to answer any questions you have about this project, would love to discuss it more!

https://dashboard.tokenrepublic.io/

We at the Token Republic offer an efficient crowdfunding platform for entrepreneurs and developers to build their business with fewer intermediaries, allowing them to focus on development. Crowdfunding is the ideal industry for blockchain to enter into and augment.

You can choose the model that suits your campaigns needs, whether you take on a rewards based approach like that of kickstarter, offer shares, the incentive to invest is yours to create.

You can list crowdsale campaigns on the Ethereum Main-net using our application, you will have to pay a transaction gas fee for this to proceed, or you can launch on the campaign frontend for free using our "Initial Interest" system we have developed, where investors can contact you to request to fund your project, giving you the ability to gauge the popularity in your project before proceeding to issue tokens.

The process is simple and you can launch a campaign within minutes. If you need additional help with a project launch or want more information you can message us at hello@tokenrepublic.io

We are also about to endeavor in the creation of an NFT (Non-fungible-token) marketplace on our web-app, where users can sell their art or other assets, using blockchain technology.

-
More information about our team at: https://tokenrepublic.io/about-us
Visit our Medium Blog to stay up to date with announcements: https://medium.com/token-republic
Join our Telegram to get in touch with the community: https://t.me/Token_Republic
Follow us on twitter at: https://twitter.com/token_republic
"have to?" No you don't have to study for job interviews. Maybe if you are coming out of college, but you really shouldn't be studying for the interviews. You should know most of it.
But I'm guessing there are other jobs it there that all technical questions that require people to study up for before the interview.
So just getting this straight here, the VOA news article that you link to is your evidence that the pandemic is the cause of the increased homicide rate?
Correct?
I don’t think it’s purchasing power so much as risk pool. Or really a bit of both, it’s number of healthy vs unhealthy people in the pool. Employees of a company tend to be healthier. People on ACA tend to be part time / low wage, and have more health issues. Insurance companies pass that through by charging based on risk. I imagine what would happen is this would average out, the total cost(including employer contribution) would go up for most of the hn crowd who can afford it, but down for others who currently can’t
Completely apart from whether they did the right thing before the accident, I was boggled by the disconnect in the language used by Intel, even though I know it's just standard corporate speak on autopilot:

"Intel has a well-known safety culture and the safety and well-being of our workforce is our top priority...We are disappointed in this decision"

How can the last sentence coexist with the first sentence? I mean, they don't have to fight over a few hundred thousand if they want to leave the impression they care about health and safety at all. Negligence is one thing; the response to mistakes is another.

And no, they don't owe it to the stockholders.
How would you like a job at Greenwashing Incorporated?

You can start on Monday!
If you’re having trouble finding a battery due to OEM only choices, here’s an anecdote that may help: I used thinkwiki years ago to get info on flashing the embedded controller firmware of my T430s to a patched version that didn’t query batteries for authenticity, opening up a whole new world of prior gen and cheap aftermarket battery compatibility... perhaps the same can be done with your X230?
> Yes I understand. Imperial is awesome because you can divide a foot by exactly 2, 3, 4 , and 6, which of course, is the main problem everyone has every day.

Great, we agree.

> Metric on the other hand sucks because none of my measurements will ever be nice round numbers.

Depends on the situation. Metric units can be useful.

> The hardware doesn’t think in base 10, but having more than that in imperial makes it better?

No, it means neither system has an advantage so just pick one. Or invent a new one that allows better hardware utilization.

> Your document lists 12 mass units alone. I rest my case, what could possibly be more logical, convenient, and need less conversion.

I don’t convert, I just pick the unit that fits the problem.

> If communication was your major goal, then the system that is used by 7.3 billion people on this planet would be your choice.

Yeah I use the metric system all the time. Just like NASA.
Frank Rudolph Young – How to Get Immediate Power to Perform Any Skill
60 cm of near infinite resolution is still a crazy amount of data
That’d be my guess: prefetch_related is great but you need to guard it with something like an assertNumQueries test to avoid accidental regressions.
Can you install a Mercedes OS on BMW board computers? No. Can you install a BMW engine into a Mercedes? As much as you can install macOS on a Lenovo laptop. Car manufacturers have their own part standards and their own tools specifically designed to be incompatible with each other and needing special tools that are only available to the manufacturers and certified service partners.

This is nothing about Epic “outgrowing” Apple App Store. They had quite a bit of growth, but compared to Apple or even more directly to Steam they are still small.

This is mostly about trying to get Apple to give them access to their platform for free or close to free. Nothing prevents them to build their market with Apple’s cut in place.
Because you can put the solar panels above a parking lot. You can't directly compare land area for growing with land area for solar panels, qualitatively, they are two very different lands. We have more of the latter.
The math is wrong. If we can't identify most of the people that have immunity by infection, then we have to assume they will also be vaccinated and so we can't just add the two numbers.
They both make roughly the same logical sense.
You don't have to use BTC directly to settle transactions.

For example, Lightning is built ontop of BTC:

https://lightning.network/
I remember reading a story about this: https://scifi.stackexchange.com/questions/166938/story-about...
Does it also cut the power consumption in half? If so that just means miners will buy more cards not less since their marginal cost of mining won't be affected.
Definitely agree, I'm happy to write raw SQL, but SQLAlchemy Core is even better than that because of composability.
Here are a couple of 2010 Satoshi forum posts on the topic: https://satoshi.nakamotoinstitute.org/posts/bitcointalk/thre...
I’m not sure how that sanity check works, can you explain? Do you mean checking conversion between meters and kilometers? Because sure, that’s easier but you could just do everything in meters instead and not run the risk of crashing a spacecraft because of unnecessary conversions or bad assumptions.

I estimate my bike ride progress in landmarks and time. Not feet per second. Did I get to the boat ramp in 20minutes? Better speed up and get to the park by 30.
I favor a hybrid approach: use the Django ORM to define models, do migrations, auto generate the admin, etc. but don’t be shy about using the extension points (extra, raw, cursors) to put in an optimized query for a hotspot. You can get pretty far using the ORM but it’s really valuable to be able to be comfortable dropping down for things like reports or bulk processing.
> replaced a cracked palm rest and odds and ends for a few bucks on eBay

Heh. I did exactly this with my previous T520 after half a decade. I've been meaning to dig it out to play with coreboot, but haven't had time or desk space lately.

Speaking of EC firmware -- one of the annoying aspects of the T480 dual-battery system is that the switchover point is fixed at 5%. It would be nice to be able to set this to something like 20% for better battery longevity. I don't really want to do firmware experiments on a system that I'm using as a daily driver, but at some point it would be nice to try and hack around this, assuming someone doesn't beat me to it.
Chessbase still has the most popular database software, which is used by many (most?) good players. That's not really an expanding market though.
They do need some small margin of the loan value to actually exist I think?
GitHub Removed Cookie Banners: Why Can't We?
Recently GitHub removed all non-essential Cookies from their website, claiming that they are committed to protect developer privacy. How can we do the same.
This horse will be flogged for as long as possible. People get to work from home, the media is making money, unemployment benefits, new stimulus, politicians get to look like heros, and more. Everyone kinda has an agenda. They go to restaraunts and take off their mask to eat and simultaneously chastise the anti maskers.

We're going to pay for it in the long run but it's great for now.
The comfortably rich are getting richer because they are closer to the money spigot.

They get to spend the money right now, before the inevitable asset inflation that occurs when 2T gets printed.

By the time you -- YOU, the regular person -- see the money that was pumped in 10 months ago, in the form of your salary, it is already too late. Your salary does not give you any actual increase in any concrete thing, because inflation has already occurred.

If, somehow, that money that was printed goes into actually useful things, like RnD, infrastructure, or education, then perhaps your salary could buy more things because the economy would be more productive. But it can't because it's not... instead, dog walking apps are worth a billion dollars.
It GTFO with its remaining fuel and then crash lands. Going back to orbit would require enormous amounts of fuel.
I find it extremely hard to believe you could kill every human being on earth at this point. We’ve reached critical mass, we aren’t going anywhere. When we had that few thousand individuals population bottleneck in the past was when it was dicey. What sort of event could kill every human and end our species? I can only think of planet-wide extinction events like massive asteroid impacts that sterilized the whole earth. And we haven’t ever had one of those in billions of years. Call me too optimistic but I think humans are too resourceful. Some of us would survive anything smaller.
Mars Ingenuity helicopter testing in Mars-simulation vacuum chamber (2020)
So are you also opposed to aluminum production?
Sort array of objects by multiple properties with Swift Tuple
Yes! Just today I was wishing that I could have syntax highlighting on commented code that I was refactoring. Just dim it a bit instead of turning it all grey.
The Australian government wants Facebook to pay for linking to news websites.

Of course Facebook and other countries have no desire to pay every time someone posts a link to a news website, so they’re cutting it out completely.

The legislation hasn’t been enacted yet, so I assume Facebook is using this move for leverage to show people what the future looks like under the proposed government legislation.
Slaves and opium, now, let's set the record straight.
Our sun is shooting out so much energy that is not getting used at all. That is flushing (sustainable) energy down the drain!
shaggyfrog says >They are asking that he no longer be honoured as a consequence of what he said.<

But he said a lot! E.g., Millikan contributed greatly to science and had some views that are unacceptable today. So do we celebrate his useful contributions or do we punish him after death by un-naming buildings, etc.? Could we not possibly do both?

What if we found a letter written by Albert Einstein that derogatorialy used the N-word? Would we never again speak of Einstein, of his opposition to nuclear warfare, of his personal trials as a Jew, etc? Would every reference to Einstein initiate a conversation that ended with the mention of his (here hypothetical) N-word letter?

The end-game of this woke attitude is the death of history (since no history will be acceptable and all will be subject to revision downward at any time) and, in the long run, the end of social knowledge.
Perl and Ruby have this. In Perl it's kind of an abuse of the perldoc system, like this:

print "foo"
=pod
print "won't run"
=cut

Ruby basically copied it, although I don't think these have documentation uses:

puts "foo"
=begin
puts "won't run"
=end

When I get to choose, I prefer sticking to // in C code so that I can use /* ... */ for hiding large blocks of code . . . although #if false ... #endif work too.
Sure POSIX job control is old and janky, but it's still in modern POSIX.1, as it has been for 20 years now; while POSIX.2 has been dead for 20 years now.
Funnily enough, I recently optimized some code along these lines.

The way I sped it up was to call `.values()` on the query, which serializes the data into a dict and prevented me from accidentally making subsueqent calls.

PS: Indent by 4 spaces for code formatting.
I was hoping someone would link this video, it describes the various phases with a ton of details that.

Some of the other videos on this channel are just as in-depth: the ones about the plumes/exhaust of rocket engines as well as star occlusions are incredibly detailed.
alfred p sloan prefers the term 'dynamic obsolescence'
>If one policy makers were the one who had to freeze in the dark but that's life.

Exactly.

Sen. Ted Cruz just was discovered flying with his family to Cancun because they lost power and water like the rest of us.

Had to return in disgrace a few hours ago and is currently still not able to offer a consistent excuse for abandoning his constituents.

https://abc13.com/politics/it-was-a-mistake---ted-cruz-tells...

In each media interview he gives a different shade of the story as he tries to walk it back. He's got to be lying in at least all but one scenario he explains it as.

Definitely not good enough for Texas.
One and a half seems natural. What about something like a quarter meter? I guess that just becomes some number of centimeters?

> How do you divide 7"3/8 by 5?

Same way I divide 4.7625 cm by 5. With a calculator.
My understanding is that the life expectancy in a given year is how long the average newborn would live if the by-age mortality was the same every year was the same as this year for every age. Or in other words, if we had a pandemic like this going on all the time, life expectancy would drop by rather more than the 0.5% IFR.
Switch hydrogen for methane and produce that methane in a bioreactor from the food scraps. These technologies are already here, no need to wait for a future hydrogen car.
What issues do you see with Ethereum's upcoming PoS+Sharding system?
"First commercial fusion power station will start construction between 2050 and 2060" is mostly guess, but it is an educated guess based on some trends/predictions/achieved work.

But compare it to "First commercial perpetum mobile power station will start construction between 2050 and 2060" or "First FTL spaceship will be launched in 2050s".
Without looking could you tell me..

How many pounds does a cubic feet of water have?

How many BTUs do you need to heat 10x10x3 ft water pool 20 degrees F?

How much work in ft-lb is done by gravity when a 10 oz mass drops from 19 yards?

How many HP are needed to rais 2400 lbs 74 inches in 30 sec?

It is obvious you have 0 experience doing back-of-the-envelope calculations for scientific or engineering purposes. It is a no-contest between the metric and the imperial systems.
How does react connect to your experience using the site as a host?
> "When a doctor interviews for a job, they don't ask them to do a day of "trial surgeries". They just assume they have the necessary skills."

They have a grueling residency period that lasts three to seven years to make damned sure that they do. Can't imagine that anybody in the software industry is going to want to sign up for that.
python comes up in way less than a second on my old mac air?
> 1) Bob has money, which he lends to Dave. Dave has possession but it's still Bob's money.

That's not the way a loan is structured legally. Legally, a loan is a bargained-for exchange (a contract) in which the lender gives the borrower money and the borrower promises to make payments according to a schedule. (Note: It can be more complicated than that.) When the borrower receives the money, it becomes his money. If the borrower doesn't make the payments, then the lender can sue for breach of contract or to foreclose on a security interest if there is one.

> ... there's no contract or agreement outstanding that obligates him to do anything ...

By default, a lender is entitled to receive the stream of payments specified in the loan contract and is not required to accept prepayment if he doesn't want to (e.g., if the lender is receiving interest at 10% and the current rate is 5%, the lender does not have to allow the borrower to pay the principal all at once). Prepayment rules can be modified by the loan contract terms (e.g., imposing a penalty for prepayment) or by statute (e.g., a state law requiring housing mortgages to allow prepayment without penalty after some amount of time).
> my Plex server transcode more streams at once

And... why do you need your Plex server transcoding multiple streams? Just curious!
No, this is a common misunderstanding. There are a lot of false narratives floating around that Bitcoin is the only way to avoid inflation, but it’s just false info meant to spur more Bitcoin buying.

Inflation means the price of assets goes up. That means the purchasing power of cash goes down. If you don’t want your purchasing power to go down, you buy assets instead of holding cash.

If you really believe inflation is going to be high, you could take out USD-denominated loans to buy inflating assets. The inflation would increase the value of your assets and decrease the value of your loan balance at the same time. Of course, if you get this wrong you’re stuck with a house that’s worth less than what you paid.

This isn’t new. It’s basic investment knowledge that holding wealth in cash will slowly devalue it due to inflation. Anyone who wants to avoid inflation must invest it somewhere.

Bitcoin’s value is driven purely by demand. Buying Bitcoin isn’t so much a hedge against inflation as it is a bet that demand will continue to rise. The technical term for Bitcoin’s price increase is demand-pull inflation.
They are welcome to pay facebook for the service it provides them
Shouldn't it be "had he looked."? Also the second rendition makes doesn't include what the rest of the joggers are doing, yet the first one does. Not sure if intentional.

At first I gasped at your practice, because I never do that, but I see the point now. Mastery of language.
This is correct, not sure why you’re getting downvotes. Feature branch for WIP makes sense.
A common code style rule for C# is // for comments and //// for commented out code (/// is reserved for documentation generation). StyleCop analyzers can enforce this during code analysis passes.

While this isn’t a language construct (a comment is a comment after all), Visual Studio can key off these stylistic differences to show code comments vs commented code differently. I find it to be a neat trick to improve code readability.
Yes you told us, and we didn't listen. You are so right, and we are such fools. We are so sorry.
s/ident/indent/