skysight-inc/HackerNews huggingface dataset:
As a German, I am used to the idea of my Grandparent probably being immoral assholes.
And very, very common.
Another recent article on the topic from the New Yorker.

https://www.newyorker.com/magazine/2021/10/11/can-nuclear-fu...
This makes no sense at all. TLS encryption does happen on the client side.
> You're using the alias "r" here for two different things:

I agree this is a bit confusing. The user "BeefWellington" came up with a better idea, to skip the "= r" part, since it's redundant. That way, you would only need some new keyword, to indicate you want to perform a foreign key join, and specify the referencing or referenced table alias (depending on which direction the join is made, i.e. what table alias that has the foreign key), together with the name of the foreign key.

> The example that you are attempting to improve already operates on PKs/FKs.
> I don't understand the point of this proposed improvement at all

The example operates on PKs/FKs column, yes, but they are specified manually. I listed a number of possible benefits under the section "POSSIBLE BENEFITS" in my original post, I think these explains what improvements I specifically see.
Use a linter. Almost all of them warn about this footgun.
Disclaimer: I know nothing about AI.

I think the AI is now capable to reply to "how likely this will mean this other thing if you say it this way", that applies to text, pictures, videos, whatever, you name it. Is not intelligent in any way, but still gives meaningful responses back, which is useful for the use cases to which it is applied, search, games, etc. That been said, I have no doubts, that with time, it will reach understanding resolving basically almost any problem... but.. we always have doubts, and you can't just divine the future, look at the James Webb Telescope, we launch it to get some answers, so doesn't matter how intelligent a system may be, we would need more research, and the system will need it too, even if it's an AI, (because its needs to know things, to learn from them, in case that wasn't obvious)
It's important to understand that OP is also limited by his own particular personality and world view. He is a good example of a TWRP or 'bater.
It can make one go blind.
Just wanted to say, the best part was acknowledging the worst was being rickrolled. xD
Why do they need to when they already had the internal tool to fork?
This is 100% anecdotal and I'm sure other people have different experiences and ultimately it may not be directly relevant to the fact being pointed out in this linked tweet, but...

As a gamer with a lot of gamer friends (split among PC & console, though more console than PC, I play on both) I know quite a few people (close to 10) who bought both VR headsets (some Oculus, some not) and Xbox Series Xs over the past year and a half.

Every single person I know including myself used the VR headset a lot for about 2 weeks and then barely touched it except for occasionally pulling it out to show friends/family. Meanwhile we all play games on the Xbox nearly nightly.

I love a good VR game but it just feels like though the headset hardware is pretty close to "there" that its still really difficult to deliver good experiences in a flexible way due to input/tactile feedback (or lack thereof) concerns. So most people that try out VR will play a lot of beat saber, tool around with a shooter like Arizona Sunshine, and then go back to playing traditional non-VR games.
Measuring Oculus sales through mobile app downloads, lol...

I have 2 Oculuses and have the app downloaded on 5 devices at least.

Anyway, I feel like the popularity of Oculus is pretty limited. Unlike consoles, you have to be pretty physically active to play most games on it. I do think it's an excellent fitness device, though.

I think Google made a huge mistake discontinuing Cardboard/Daydream. They should bring it back. It really doesn't make that much sense to have another device when phones already are more or less as powerful as an Oculus anyway. Not to mention that the Quest runs on Android to begin with.
There's really no reason you need to switch. You can put raw LaTeX directly into Pandoc Markdown documents; it'll be ignored in non-LaTeX backends, and in LaTeX it'll just be reproduced verbatim. If you need to tweak the template that Pandoc puts "around" the Markdown content, you can do that too (and then centralize your changes so you don't need to do it over and over again). Eisvogel is an example of a project that does this [1].

I think this is really the best of both worlds, because you can produce documents that (fairly) easily generate print books via LaTeX while simultaneously generating webpages or ePubs for electronic distribution.

[1]: https://github.com/Wandmalfarbe/pandoc-latex-template
A lot of educational content on YouTube is made by people who have no idea (or interest in) how to optimize for engagement. I'd be willing to bet there is fairly competent basic EE instruction on YouTube that includes lab instructions, working with simulations, problems, and pulling in other exogenous resources to aid in understanding. Its not just a wasteland of pop science like Veritasium, et al.
And hookers! Don't forget those, meatbag!
It blows my mind how fast these things travel at cruising speed. It's completing a marathon every 21.8 seconds.
Jobs' estate, maybe. Hopefully Apple doesn't own his likeness.

But really it seems like fair use IMO. these short clips seem very benign.
Adding on to this the energy usage of my multi-head heat pump system has been quite surprising when it drops below freezing. I have a Mitsubishi unit which is rated down to something like -15F however below 32F it uses enough energy to get pretty close with fossil fuels on price. It looks like I will have to add on to my 11.85kW solar system to be able to get the projected energy use throughout the year. Winter time will have a significant deficit and summer overproduction will make some of it back but not all. I am also investing in air sealing and additional insulation.
>I guess the same could be said for gas, as some people are happy moving to (non induction) electric. But if your gas stove was holding up for >25 years, it was probably not the cheapest model they could get at the time.

That's definitely true. And the used resistive stove that replaced it was being sold on eBay for USD$250 around that same time. Which says that it likely was the cheapest model they could find.

Even with the new resistive stove, which was, at least, new, things are better. But still doesn't provide the quality of cooking (and consequently, eating) experience that the gas stove did.

I suppose some might recommend that I replace it with an induction stove, but that would violate the terms of my lease.
The conclusions this article comes to re: the reason for the shortage (that is, that pandemic unemployment and emergency assistance prevent people from looking for work) are backed up by an article that predicates all it's findings on studying lottery winners: How Americans Respond to Idiosyncratic and Exogenous Changes in Household Wealth and Unearned Income

This comes off as more than a little lazy at best, and totally disingenuous at worst.
Canada tracked 33M phones during Covid-19 lockdown: report
What "cards"?
The Chell voice is on point.
Now you're just making an argument equivalent to "it's not weird that some cars appreciate, look some of the classic Mustangs" instead of distinguishing it from housing in any way.

The reason housing increases in value to the extent that it does is that areas where it's in high demand prohibit creating more of it. It would be like prohibiting the construction of new cars. Obviously that would make existing cars cost more in general, independent of the fact that some cars are worth more than others.

The problem with your argument is that it's predicated on it being physically impossible to build more housing of the same type that people want. If people prefer to live close enough to the ground that they don't have to ride an elevator for an hour to get there then you build a thousand ten story buildings instead of one ten thousand story building. If people like higher floors because they have a better view then you build two hundred 50 story buildings instead of a thousand ten story buildings. You can build more of whatever the market demands, so the price falls to the construction cost (absent zoning), and remains there because increased demand causes more construction rather than higher prices.

To get to the point of true scarcity due to land you would have to need thousand story buildings because covering the city in twenty story buildings wouldn't be enough housing for its population. But even if that's possible in theory, it's not the case anywhere in practice.
The Xbox One was also a distant also-ran to the PS4.
> With lithium, the answer would be yes, because lithium demand is growing. With coal, hopefully not so much.

Yah, if nothing else the regulatory risks would make one pretty nervous about dumping a ton of money into a new coal mine.
Thanks for finding this.
Some comments from ~10 days earlier: https://news.ycombinator.com/item?id=29570640
I think these are all interesting ideas! I also think making changes to the SELECT clause of the SQL language could be more difficult though. You also have to think about what type of join something like "SELECT staff->manager.name" would cause under the hood, would it be a LEFT JOIN or an INNER JOIN?
Not exactly what you need, but this page lists best papers awards (with links) from all major conferences

https://jeffhuang.com/best_paper_awards/

And here's PapersWeLove Repo with similar sauce

https://github.com/papers-we-love/papers-we-love
Bingo – The missing package manager for Go binaries (Homebrew for “go install”)
Please don't do that here, regardless of how annoying another comment was or you feel it was. I've redacted the name and killed the comment. Please don't do it again.
Can this be a safety issue? I’d rather not have a 4k pound hunk of metal flying at me by someone that just wanted to try something out in a cars firmware.
> The reason housing increases in value to the extent that it does is that areas where it's in high demand prohibit creating more of it. It would be like prohibiting the construction of new cars. Obviously that would make existing cars cost more in general, independent of the fact that some cars are worth more than others.

Yes, and the areas that are desirable and the ones that are restricting the construction. Even if we suppose that you allow infinite construction, there will always be certain houses or parcels of land that will cost more, perhaps because of being closer to certain things.

Your example ignores reality. It is sometimes just not possible to build more housing that shares the exact same properties of existing houses.

If an area is desirable because of nature, then naturally those who first live there will prevent the destruction of said nature that brought them there to begin with.
Just a fun little tool I made during a Christmas flight. Happy Holidays!
The caveats built in to Tesla's almost, soon, about to be, near complete Full Self Driving really ought to have something like this in there so people read the 'find print' that you can't expect FSD to operate on snowy nights on roundabouts, etc., etc., etc.
Plenty of people are getting graphics cards, it's just that demand is massively outstripping supply.
City buses seem like a great use case for battery swapping!

Depends a lot on the exact bus system, but thinking loosely about San Francisco: maybe retrofitting ~10 terminals with swap+recharge capabilities means most routes only need 1-2 hours of juice between swaps?
Indeed, this is no baby, but a random blob of cells. Two things we can be certain of:

1. No economically viable hot-neutron Tokamak fusion plant will ever be built;

2. Every cent wasted on this, instead of being spent on building out solar, wind, and storage, brings climate catastrophe incrementally closer.

It is just barely possible that something learned while fooling with this stuff will turn out to be helpful for making a practical non-Tokamak fusion system for spacecraft propulsion. The plasma fluid-dynamics physicists employed on these massive boondoggles are who would make that. But the longer they bumble about with this, the longer it will be until they can get started on that.
There is plenty of non-entertaining yet informative and detailed educational content on YouTube. The "entertaining" videos are usually just a gateway to more dry and traditional lectures and courses that are provided by universities and other content generators that see YouTube as a general resource and not an income stream.
It's adjustable in the sense that there are different weights.
Totally agree, fail fast is nice. That's part of the benefits with the proposed foreign key joins, you would eliminate the class of bugs caused by joining on the wrong columns.
Land is what should appreciate, not the building built on top of it, which should deprecate. What make land valuable is the collective work and contribution of a community.

However, since lands are scarce and a collective effort to maintain, maybe it should be taxed for the benefit of the community and rewards given to the people who put it to the most valuable use, by not taxing buildings and other improvements built upon it.
I'm not sure if they were ever open source friendly in the past, but they most definitely are not today. The hardware is tivoized and the source code's license is literally "all rights reserved".
They aren't close; that's not what I was driving at.

China's problems and ours are leagues apart in terms of quality.

However, we do have a history of:

- assassinating and locking up political dissidents (see: Black Panthers. Yippies. Che.)

- selling out politics to elite private interests (see: congress)

- spying on our own citizens (see: COINTELPRO, snowden leaks et al)

It's a different flavor, but don't kid yourself; we suck real bad.
Maybe the demand for new gaming experiences is being satisfied by Oculus due to lower costs and better availability. Maybe it's not misleading at all if Meta starts to eat the share of dollars/hours.

Only time will tell if people will continue to use them beyond their initial novelty.
The GPU shortage was my deciding factor for buying a Quest2. Simple games like Beat Saber are indistinguable from PC, it's a marvel of optimization. My GTX1060 stuttered more than the Quest mobile chip.
Do you like writing code? What parts of your job do you like best? What if you don't get the work life balance ugly want? Would that mean you end up regretting the jump? Do you know devs who have better work life balance.

You're probably crazy but at least you can be methodical about it. Merry Christmas
What do you think is future scope in category theory?

I have been interested in functional programming, lambda calculus, type theory etc too as a hobby.
I'm that case the title could also be made more accurate
I'm curious, have you actually lived in China for an appreciable period of time yourself to come to this conclusion?

I don't really have any particular opinion on China either way, China definitely has done some bad stuff, but with regards to statements like: "and that the average citizen is equally treated by the law in each country" I'm curious.

Black Americans and White Americans, for example in the United States are treated very differently with regards to sentencing for very similar crimes. Would that contrast be the same as the one you say with Chinese vs. American?
I think that some real people (public persons) are ready to see/hear that someone mocks them, and the rest is not ready for such attention. It’s interesting that our voices and appearances are not unique. I knew people who look or sound like me or like someone else, but when it becomes “and”, we read it as an indentity theft or something like that. We are not far from calls and records to be signed by personal identity keys and fingerprints included into id documents, because otherwise it would be hard to recognize who is who.
Keep in mind that a lot of NYC's heat is provided by a steam system managed by Con Ed. I don't know if anyone is building new construction that leverages it, but it's there as an option.
Why Is China So Interested in the Video Game Industry?
Don't be silly. Heat pumps with water that go down drilled holes (the term for it here in Sweden is mountain heat) would work just fine and probably be cheaper too
I love VR, but it's far from having as much content as their console counterparts. Indie developers, it's time to shine in this new eldorado.
Is this like comparing downloads for "growth" apps against apps that everyone else has already installed on their phone?
You mean the original quest model, as opposed to the quest 2 i assume?
This has an interesting aspect to it.

Yes, it's AGPL with source code publicly available, but if you remove that license key check yourself, you have to make it public, effectively broadcasting that you don't pay for software. In a way, it's naming and shaming. The alternative is using the fork of someone else who has done so and complied with the license, but then you're suddenly dependent on some random downstream and who knows what else they have mixed or might mix into it or just give up merging from upstream eventually.
No need to dig, only to do some drilling. It is very common here in Sweden. You just need to check the map first so you don't drill into the subway.
I think the era of high-res gaming is over. The games are too expensive to produce and the hardware is too costly (or impossible) to buy.

What matters more is broad, international appeal, to multiple age ranges and both genders, on as many platforms as possible.

In particular, having social experiences in order to replace what has been lost due to COVID lockdowns.
In your case you would use geothermal energy. In countries like Finland, geothermal + electric keep everyone warm.
Ask HN: Anyone looking to fund a NFT Marketplace?
We have 2k pre signups.
> "select f.bar_id->some_bar_table_column"

Something like this was actually my first iteration of this idea, to join based on the column name(s). But then someone helped me think about what if the column is involved in two different foreign keys (to two different tables)? Not common, but absolutely possible. That's why just naming the column(s) isn't precise enough, except in most cases.

Even if no such ambiguity was allowed, i.e. if all unique sets of column name(s) referenced exactly one table, you would still need to think about how the syntax would look like for foreign keys on multiple columns.
So the solution to that is requiring specialized hardware that shuts you off from the outside world?
I wonder if it’s an another anecdotal that shows Oculus’ struggle without core gamer support and under almost a declaration of war from Carmack, that they had to resort to comparison against Xbox. Surely they’ve got no support from me, and while I’m not an important person, I can’t be extremely unique either.
Ok, I'm sorry—I probably overinterpreted it in the context of the surrounding flamewar.
Good luck - does your financial planning team say you can retire now? The one at your bank? They can help define the details, if you've not done that yet.
What is it with people pushing the c style "->" everywhere. Dot works just fine, is just one char, no shift key required and it is still unambiguous. Stop this "->" nonsense. Even in c it shouldn't be required, the intent is clear and unambiguous if dot is used.
I've been seriously distracted and lack the inner energy to focus on things that truly matter.
For a decade now, I've been trying to learn coding without success; always running around in circle, motion without progress. So, my new year resolution is to break this jinx and kickstart a career in tech.
Thankfully most of the cost is in drilling the hole, not in parts that may need to be replaced.
Do you think a random production code snippet is approachable for someone lacking the necessary background?

The notation in this paper is totally standard.

EDIT: \mu there refers to a probability measure. Nothing to do with averages.
Why would that be shameful? Putting an antifeature in software is shameful, but taking it out is virtuous.
How do they sound?
Edit: should be periapsis and apoapsis instead of perihelion and aphelion
Most people mentioning electric pressure cookers these days are referring to the "Instant Pot" or similar. Check it out.
Both. The Quest is practically a second-class citizen in VRChat. It can't run many models or worlds unless it's PC linked and running on desktop hardware.
This will NEVER happen. People rarely listen to urban planners, no one is going to tear up their cities and reorganize them around some untested ideological idea, and finally no one is going to give up their cars -- like it or not-- they are annoying.

It's much easier to just make them all electric and decarbonize grid production.
Easy there. New correlation coefficients get proposed all the time (eg. the introduction of the linked paper lists ~10-20 alone!). It's not a good idea to add every newly proposed coefficient to established wiki pages, just because they trend on social media. Yes, the paper looks nice, but if you read any new paper proposing a new measure, they all do! They're meant to be written that way. Let the community decide and test and discuss, and if in 10 years this new coefficient is well accepted and has proven itself, we can think about your proposed edit. Doing it before is putting the cart before the horse, and is a recipe for astroturfing.
> Even if we suppose that you allow infinite construction, there will always be certain houses or parcels of land that will cost more, perhaps because of being closer to certain things.

In which case those parcels of land would end up with high density housing on them so more people can live near those things, until such time as the cost per square foot falls below the construction cost.

> If an area is desirable because of nature, then naturally those who first live there will prevent the destruction of said nature that brought them there to begin with.

"Nature" e.g. Montana or Alaska or the Ozarks. Do you believe these to be the places with high land costs and restrictive zoning laws?
> Make spam expensive using proof of stake

That's already a thing. Hashcash [1], the PoW algorithm underpinning Bitcoin, was originally conceived as a method to prevent email spam.

[1] https://en.wikipedia.org/wiki/Hashcash
I doubt the science is infeasible. We do have working fusion reactors. Some time in the next few hundred years we will surely figure it out, if we don't go extinct first.

The economics are much more likely to make it infeasible. If fusion power is forever more expensive than solar+storage is there any point to it? Even fission has been priced out of the market and I never heard anybody claim that fusion will be cheaper than fission.
Have you tried gofundme yet?
Quest as a platform is nonexistent in “gamer” PoV. It’s just the cheapest and most robust _SteamVR_ headset.
Not yet as I am looking to have an angel investor on board.
HaikuOS on a PC: https://www.haiku-os.org/
Systemd's clock-epoch for RTC-less systems
There is that in my city. A new bus line able to recharge bus capacitors at some stops. It looked like pretty hard to implement but it’s working interestingly well.
I traveled frequently, for short and longer trips (months at a time), as well as having lived there (albeit not on a foreign passport when I lived there).

Most 4-5 star hotels are still dirt cheap in China. We’ve stayed in budget hotels (by Chinese standards) in non first-tier cities with no problem.

I’d say if you got turned away it’d be some combination of obviously looking like a foreigner (in which you could get them reported for some infractions) and not being licensed to accept foreigners.
Typical 'communist party' like response - they fear the competition so much they dare not let it show it's face.
If this is a high volume bot tended blog, you could add dashes in words or special characters, or misspelled name to see what the bot is capable of blocking absent a true mind.