skysight-inc/HackerNews huggingface dataset:
Wouldn't a meter value that doesn't have distortions just have a value of 0 (that is, not null but just zero); the properties of a meter in this case belong somewhere else, either in a "meter properties" table if you have many meters with many properties that can change, or just hardcoded.

Alternatively, a key / value table, e.g. `meter_id, property, value`. But that isn't very optimal, works better for things like a shop product with many different properties per product.
> the interesting question here is "why would they do that?"

China is not Russia. But Xi is weak. There was no reason to rush on Hong Kong when it was going to, without controversy, revert to Chinese law in a few decades. By being impatient, Xi undermined Chinese interests there, in Taiwan and internationally in favour of his personal political interests. If China invades Taiwan, it will be in recapitulation of Galtieri’s junta in the Falklands.
There’s always some kind of bias that direct your research, be conscious of it or not. Thinking that there’s any kind of pure truth seeking in any research that has social implications is utterly naive.
Mapy.cz even used to have a great Symbian client with navigation and all, very low battery drain. It was awasome.
You're talking about two different things. Google, Microsoft, other FAAGs's H1Bs are not the same as Infosys or Wipro.
Maybe it's what you meant be "subsequent query", but you don't actually need to do it in a separate query; you can do the partition & rank in a CTE and select from the resulting table, all in a single query. It's quite tidy actually.
> A separate article by Investopedia [1] also asserts that Costco mostly opens stores in affluent suburban areas, and originally targeted college-educated and financially wealthier customers.

This is obvious simply by searching for Costcos on a map. Or the fact that any time your total is less than $100, the cashier and the customer joke about how lucky and rare the sub $100 receipt is.
This seems to be a magnetic levitation solution.
You know, floating on air cushions, (almost) no friction, but needs specific new tracks.

A prototype was developed in Germany some 50 years ago [1] but never caught on.

[1] https://en.wikipedia.org/wiki/Transrapid
Those are predominantly elite schools right?
Your comparison is missing the day when the Neanderthals (purportedly) built these circles.
I cheated in Arma3. Moneyhax - just wanted to practice flyin` some jets in a decent combat environment without grinding endlessly. Glitched invisibility - real hillarious for couple hours. Occasional item duping to jumpstart combat readyness of our group (somewhat hated this one). Cliff glitching to enter inside of them and store loot on persistent servers. Most of the cheating came out of curiosity - to explore and push the boundaries of game. Nevertheless, the very best Arma3 gaming experience came out of fair and square pwnage operation of our group on public server. Infil via chopper, 2 snipers @ south / east hills, 1 AT/spotter, 4 people assault squad, myself as a commander miles away on an island watching through UAV. We cleared like 20 people in couple minutes and got a thropy tank without taking (!) any casualties. Planned and prepared for about an hour (+ ~3h to build up necessary supplies).
When people like Asimov expressed their view on death--nothingness--they probably meant the same thing this Author is trying to say here.
I would say when most people say death is nothingness, they don't mean there will be a remnant of them expericing nothingness, they just mean nothingness.
I feel this author is just intentionally misinterpreting people's words.
Great, we can stop all incentives for renewable energy now that it is the cheapest way to generate energy.

More seriously, where's the catch?
> It allows specifying a constraint - that you can't have two rows with the same values even if one of the values is a NULL. That's prohibiting duplicate NULLs. The change allows you to prohibit duplicate NULLs.

Sure.

> Here, "Kim" is car-less (NULL in the CarID field) twice, which makes no sense.

The relation makes no sense to start with, it didn’t need duplicate nulls for that.
This is very interesting. I have build a lot of services that authenticate against LDAP or request user attributes (99% domain controllers in Microsoft land) and I believe this can be a very solid basis for user management for anything outside that plantation. Will certainly keep an eye on this.
I really hope no one takes this analysis to heart. If I was moved onto a project without logging for this reason I would be pretty pissed. If you already have the quarkus project, why not get some metrics in real use-cases, instead of a weird do-nothing loop?
> America's chip land has another potential shortage: Electronics engineers

Last i heard there were some universities that had an EE curriculum, for example MIT, Berkeley, Caltech, JHU. Is this not the case anymore ?
I can't think of a situation where I'd want "only a single NULL"; that seems much weirder. Another comment described a tree data structure where it could make sense, but I can't think of others. Nullable unique indexes usually describe some kind of optional identifier; if it's present, you want it to be unique, but it's perfectly fine for more than one row to omit it.
One of the downsides of having a large "community" and a great mindhsare around a single SBC manufacturer.
It's a convenient excuse to keep the pipeline flows as hostage for further negotiations. It happens every year, this year it might not come back on the expected schedule and from then it becomes a dangling carrot to be negotiated.
> either military or economic, that dependency on Russian Oil would bring war

This is something you conjured - it was not in the original post.

> Nor was it 'doctrine'

And this is something you cannot state.

The documents were there: I read articles about them many years ago.

> surprised

May that possibly be because of a "they would never" bad reasoning, as mentioned in the other sibling post?
By the way, regardless of the exact place the best way to enjoy the mediterranean coast is to dial your habits/schedule. I can literally see the mediterranean sea from the office I am writing that comment and only have to cross the street to enjoy some beach time. By 11am the beaches are just packed. What I usually do during summer time is go to the beach/sea before work and 2h before sunset when most tourists are leaving the beach to take a shower and dress up before going for dinner.

When I go doing standup paddle between 7 and 9am the beach is the cleanest and empty.
We have endless accounts of animal sacrifice across nearly every ancient culture from which we have either their own writing or the writing of other cultures who visited them. I doubt it began with the invention of writing.
I am the author of this feature. The background here is that the SQL standard was ambiguous about which of the two ways an implementation should behave. So in the upcoming SQL:202x, this was addressed by making the behavior implementation-defined and adding this NULLS [NOT] DISTINCT option to pick the other behavior.

Personally, I think that the existing PostgreSQL behavior (NULLS DISTINCT) is the "right" one, and the other option was mainly intended for compatibility with other SQL implementations. But I'm glad that people are also finding other uses for it.
There's a lot of nutty stuff under the hood like ensuring that covers are sized optimally for each device, which often have their own aspect ratios, DPIs and what not.

It also does a lot of database management ie; for Kobo, inserting things into the Kobo database, where schemas have varied over time etc etc.

You can of course just copy paste files as a baseline and it'll work.
There's an entire sub chapter and a bunch of tables on current storage technology costs.

Mainly focused on battery banks at scale, and pumped hydro, with a side note or more on hydrogen generation with peak excess for off peak turbines, etc.
Kim being car-less would be represented by Kim not appearing in this table at all. The design you've presented makes no sense.
Magnetically levitated, meaning up to 500 km/h (~300 mph), silent, and it's driverless.

Downsides are that you need to build completely new tracks with limited curvature (and new stations).
Your statement is wrong in the general case. It probably depends on the DB engine and several parameters, but, at least with MariaDB/MySQL, allowing NULL increases the disk usage. See https://stackoverflow.com/questions/13207838/disk-space-impl...
> Ukrainian's army potential drastically reduced (i.e. "demilitarisation" that seemed to have worked)

Ukraine’s army is being modernised by backers that eclipse Russia’s industrial capacity many times over. This is a war of attrition Russia is spending decades-old back catalog on to fuel a domestic narrative.
Also, as an avid reader (average five books a month), I also cannot see the need for calibre.

Contrary to music, I consume my ebooks on one device: my e-reader. My laptop, phone and tablet are terrible for reading.
Why would I need my ebooks on my phone or tablet.

The only thing I do want, is to process my annotations on my computer. Which calibre cannot do (but a python and bash hack does provide me).
The internet and our society has a problem with nuance. Surprisingly people have different backgrounds, different experiences and different expectations.

I always try to filter out all the positive reviews from Americans when travelling in Italy or France as Americans tend to view things more positively, romanticize average food and places and in general cant really judge the quality of the establishments in those countries.

On the other hand I very much value americans commenting on Michelin* and similarly priced restaurants as americans visiting these places usually have more experience (and obviously $) dining in such places and can objectively judge quality of the food.
Different null types are the worst :(

One of the worst offenders was one API I was working with Optional<Something> could be null.
would a new elite emerge? Probably, if there are certain traits which tend to predict success in a given endeavor, the new elite would tend to have those traits.

But one would hope for an elite rather like the Navy SEALs, where selection is based on the ability to handle difficult conditions, not one where selection is based on being born to the right family.

Yes, there is evidence that intelligence is at least partially hereditary, so if we assume intelligence is correlated with academic success, one would expect children of academic successes to have a slightly higher chance of academic success. Similarly, if we assume that height is correlated with success in basketball, since height is partially genetic we should expect children of basketball successes to have a slightly higher chance of success in basketball.

Still, I think an elite based on "fair" selection in the form of some set of hard-to-game test (for an unfeasible example, give everyone who wants to apply to a PhD program a 3-6 month mini-research internship, select the best ones and ignore all other criteria) would create a society where the people in charge tend to make better decisions/increase the global utility function more/produce better research in the case of academia than one where it's just rich kids aping their parents.
It does what people want/need - - mostly conversions, metadata edition and sync with an e-reader - with a relatively frictionless interface.
> I would like to understand why people are so enamored with Costco

I’ve been going to Costco since it was Price Club in the 1980s. I can explain why people love it. There’s an aura of mystery to the shopping experience because of the philosophy behind the layout. They basically want you to shop around the whole store because nothing is ever in the same place and product longevity beyond basic consumer staples is unheard of. In other words, it is unlikely the special product you find one week will be there the next. This kind of unpredictability goes against the grain of the reliability built into the shopping experience, and it’s what I find so attractive about it. Not only will you be exposed to something new and different, but you’ll have to settle for an entirely different product than the one you planned on buying because of the surprise factor at work. Obviously, this consumer approach won’t work for everyone, especially those who stubbornly buy the same thing every week or month.
>My advisor taught me that the point of a citation is not to give your opinion on which other papers are good or bad; it's to tell the editors which other scientists should be on your paper's review committee

As a professional consumer of academic papers paying commercial rates for decades I appreciate your candor profoundly. Nevertheless what you say is a statement at least of disingenuity
and in my opinion prima facie admission of the existence of a defrauded system.
6.0 scales correctly for me on win 11.
It's a math paper, not one in evolutionary biology. Only the mathematical aspect is of relevance here, and either it holds water or it doesn't. You can assume a seven-dimensional space, and for analyzing the geometry of such space it is irrelevant whether it actually exists somewhere in the universe or beyond.
> I'm not arguing against the parallel with Ukraine which I know nothing about. Just against the analogy with a hypothetical US state leaving the union.

Ah, ok. Yeah, I know basically nothing about the US and that analogy was indeed not a great one. I was thinking about Ukraine more, as it's both close by (to me) and happening right now.

In any case, thanks, I learned a bit more about the Taiwan history and will spend some more time reading about it, as it seems quite interesting :)
Not really.

In Cold War context, Switzerland used to mandate nuclear bunkers maintained and stocked for that purpose, they’re been decommissioning those for decades.

Starving in a tunnel is not helpful, and if you’re supposed to plan for an asteroid hitting New York directly affecting Switzerland, a network of cargo tunnels are more likely to collapse on you than save you.

Even tunnels which were built with that purpose in mind (like Lucerne’s Sonnenberg) have huge logistical problems caused by their scale.
uh, that's interesting! what's the name of the extension?
The situation is like highlighting the British empire's horrible actions while downplaying Nazi Germany's because they haven't invaded anyone (yet) and not knowing what Hitler and his friends have in store because of the language barrier.

And that's not a Godwin because the CCP's rhetoric these recent years is extremely racist and aggressive. They are feeding their population with a warped view of non-Han, non-Chinese people.
Simplicity is something that got completely lost in most (not all) modern Internet protocols. As an example you might look at QUIC & HTTP/3 and its many extensions. The IETF draft of the QUIC specification is already many times longer than the one for TCP, and then there are the many extensions like MASQUE, HTTP3-DATAGRAMS etc. that are themselves quite complex. This complexity makes it in turn quite hard to implement these protocols completely and correctly. For example, Cloudflare's official QUIC implementation still lacks support for TLS key updates, which leads to QUIC connections simply timing out after the server requests a key update. So if you use a quic-go QUIC server and a QUICHE based client you're currently out of luck unless you patch the server to not perform any key updates (which is really bad for long-lived connections due to lack of forward secrecy).
> block based knowledge base

What does that even mean?
Honestly it's what you want way more often than not. A unique index on a nullable column is usually representing some optional identifier. You wouldn't usually want only one row to be able to omit the identifier.
Really the progress started with Deng Xiaoping, so just in the last 45 years. But China has 20% of all humanity, so really just stepping back into its rightful place after the disaster of Maoism.
Working in the software industry, circa 1989
>A University investigation cleared two University of Chicago mathematics professors of wrongdoing after they independently criticized a controversial mathematics paper [...]

I'd like to know the sense of "independently" that the author had in mind here, considering the two are married to one another. Also worth wondering whether the paper was intrinsically "controversial", or merely made to be so by virtue of the complaint(s).
If you start mandating companies do proper authentication, then you kinda need proper authentication to be possible. Really, the way to do that is through a government-issued ID, but the US does not like that idea.

Without government-issued ID as a base, doing authentication right is difficult. Especially account recovery simply becomes a mess. Having high fines might cause certain users to be permanently locked out 'because we cannot properly authenticate you'. It would light a nice fire under efforts to properly handle authentication, but that fire would burn a lot of people first.
Quoting from a past comment[1]. This is from the late Mihály Csíkszentmihályi (of "flow" fame):

"The ultimate test for the ability to control the quality of experience is what a person does in solitude, with no external demands to give structure to attention. It is relatively easy to become involved with a job, to enjoy the company of friends, to be entertained in a theater or at a concert. But what happens when we are left to our own devices? Alone, when the dark night of the soul descends, are we forced into frantic attempts to distract the mind from its coming? Or are we able to take on activities that are not only enjoyable, but make the self grow?"

[1] https://news.ycombinator.com/item?id=28942369
What are the taxes like in Germany? Post taxes to what amount does 80-90k come down to?
These all seem like fine examples of solutions that are worse than the problem they were meant to solve. A separate table will be harder and slower to query and will enable M2M relationships even when you don't want those. Sentinel values must be dealt with at every query to ensure they are always filtered out.
Agreed. Also the context matters: the taxi lobby is extremely powerful in France and had successfully blocked the market from any competition, extracting an outrageous rent on the back of a licensing system that was terribly designed. They'd block roads and cities at the first sign of change in their market.

Unblocking that situation required some discretion otherwise it would have never happened.
Ice cream in China doesn't melt, even under a flame, sparking controversy
Curious about what might happen if a company/product changes their domain... would you have to change your password?
I pretty much have to use it for some things, but as sibling commenters have pointed out, there are some serious flaws with both it and its maintainer. I've mostly moved to using [Calibre Web](https://github.com/janeczku/calibre-web) which is a software intended as a companion, but I use it almost exclusively.

It has a web interface, and you can deploy it using a container. The killer feature for me that Calibre itself lacks is that has over the internet syncing with the native Kobo firmware. You essentially trick the Kobo into thinking it's calling home to get ebooks from their servers, but you're accessing your own instance of Calibre-web.

This makes my workflow of adding a new ebook as simple as uploading it to my hosted instance of calibre-web, and then next time I pick up my kobo it will automatically download it.
The second poll is not about world peace, but about democracy. Historically, the US has been promoting democracy worldwide (and this has been a major contributor to their belligerence). With their ongoing schism between MAGA and WOKE, there is a risk they will end up non-democratic themselves, either as some kind of facisit or socialist.

THAT, and the fact that this conflict is being exported to other democratic countries is a threat to democracy, although not so much to World Peace.

2013 was before Russia's first hostilities against Ukraine and also before China started to flex their military muscles. Also, at that time, the Obama administration was involved in several wars as well as the use of drone warfare against their enemies elsewhere. I don't find it surprising that many would feel that the US was the greater threat at that time, even though the threat level overall was much lower at the time.
How North Korean operatives are trying to infiltrate US crypto firms
Postgres uses 1 bit per NULL value, though the reality is more complex as everything is padded for alignment. So fewer than 8 nullable columns are free, and above that you pay probably 8 bytes at once (I'm not totally sure on the exact numbers here).

So for Postgres it is generally true that storing NULLs is very cheap in most cases.
I want to see a "solar dispenser" that can drive very slowly across open land, leaving behind a trail of solar panels.

Installation costs are a big part of current solar farms, and a big part of that is the labour to assemble frames, do up all the bolts, connect all the wires, etc.

If we could make a single truck drive along at 0.5 mph leaving a trail of installed panels, it would really make installation far cheaper. The truck could take as 'input' a container of solar panels with the necessary legs and supports, maybe even concrete bases, all ready to go, shipped direct from the factory.

Other components could be combined to save costs too - for example, the inverter could be built into the panels. The panel frame and the mounting frame could be combined to save weight and assembly time. In a big line of panels, only the end ones have high mechanical wind loads, so middle ones could use far more lightweight plastic supports.

Then creation of a 1 acre solar farm could be as little as a couple of days work for 2 people driving the truck.
Yes, it was originally "... things you can do with a kilobyte."
Sorting by "controversial" can occasionally be illuminating.

This of course depends on whether or not mods remove unpopular opinions, and/or ban people providing them.
You seem to presuppose that we would need to build new fossil fuel generating capacity. When in fact it's already installed.
And I'm not sure they would always need to burn fossil fuels anyway. Coal fired power plants can burn wood, gas plants hydrogen or methane.

I don't really get the 2 grids thing either. Everything is being plugged into the same grid. Instead of replacing a coal fired power station, you just plug in a wind farm. We already have to maintain peaker plants now.

Yes if you had a grid that was as renewable heavy as we could make it, you would be factoring in the costs of these plants into running the grid. But currently most (all?) Countries aren't at that stage, and if/when it does get to that stage, those peaker plants will still have to compete against other forms of peak energy generation / storage.
The Latin word cultus had no negative connotation and described this activity. Anything classicist and classicist-adjacent continues to use the word "cult" because that's how it was used in Latin and in English. The negative connotation did not arise until much later, probably in the mid-20th century.

The "technical" usage is simply the normal usage of the word for anyone who mostly reads books published prior to the 1960s.
Ask HN: Quality first content creators community?
Hi HN

Do you know of a place where I could find content creators (non tech, there is Github for that) that are not after sucess / likes / monetization but strive to create something of what they think is (very) high quality for the sake of it and do it consistently ?

I am very tired of these platforms where memes get rewarded and hard work is ignored.

I'd be happy with a list of blogs / websites to explore.