skysight-inc/HackerNews huggingface dataset:
> 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.

Care to explain why you think NULLS DISTINCT is the "right" default behavior? What problems does it solve to warrant additional complexity by default?
You don't even have to leave London to see a night and day difference. I currently live in a new-build flat and have multiple choices for fibre (Hyperoptic are great). I am hopefully soon to be moving less than a mile down the road into a house where my choice is either an offensively slow BT-backed service or an offensively unreliable (so I have heard) Virgin Media service.

If you have a new-build flat in a major UK city you probably have a similar decent choice but the rest of the housing stock (the majority by far) is stuck with BT/Virgin.
When I store tree-structured data in a relational database I generally add a 'path' column which is a denormalized string containing the names of all the parents with a path separator between.

The biggest reason is it makes finding all descendants very fast with a prefix search (foo/bar/%) on the path column when it's indexed. It's not unusual to want to find or update all descendants because descendants are usually related. If you don't have a path column, then you need to write a recursive CTE, which is Slow, or recurse in your application, which is normally even slower. The reason they're slow is they require a number of seeks which is exponential in the depth of the tree.

It also makes lookup of a node from the path fast, and producing a qualified path to a node fast, but these costs are linear in path length.

Anyway, this path column is also a good place to put your unique constraint.

If you don't want to restrict names from containing the path separator, you can escape application-side. For example, if using '/' as a path separator, consider '::' to escape ':' and ':s' to escape '/' - don't use your path separator in the escape or it'll muck up prefix searches.
The Death of Politics (1969)
What non-thermal part?

When a compressed gas expands and does work, its thermal energy is converted to work, and the temperature declines. There is no "energy of compression" in the gas aside from its thermal energy content. The internal energy of an ideal gas is a function only of temperature, not of pressure.

Adiabatic CAES ideally stores ALL the energy invested during the compression into the thermal store. The compressed gas is just there as an entropy sink, so that this stored thermal energy can be converted back to work efficiently. But that's just what the "cold" in a PTES system is, too. Ideally, the efficiency of the two systems is the same.
I spend quite a lot of time alone by myself. I usually go for a walk or ride my bike. Going to the library is another way to fill your brain with other peoples’ ideas, just like scrolling social media.

But I have to be honest: there are zero profound thoughts when I’m alone. I sometimes get ideas for what I could work on. Write this article or that, make a standup comedy show. Write some junk porn novel. It’s entertaining while it lasts and after a while, the thoughts are gone and having thought about them, the drive to implement them is gone, too.

It’s literally like writing things on a TODO list and feeling good about having it written down, but the desire to do them is gone.

So, since I don’t get profound motivation or breakthroughs or whatever, I treat time alone as some kind of mental garbage collector. At least I get to move my body.

So, what’s the lesson here? I don’t know. Maybe that being alone to improve something is bullshit. Go out alone if it suits you, don’t expect profound thoughts. At least that’s how I am :)

Edit: last paragraph
> How do you trick the native kodo firmware?

You just change the API endpoint in some file in .kobo on the device.

> Does it work outside your home network?

If you expose calibre-web publicly, sure. In my experience it takes a bit of effort to do that right, but it's doable.

Its wiki is fairly good and usually answers all the questions I have: https://github.com/janeczku/calibre-web/wiki/Kobo-Integratio...
1. White

2. Black

3. Colours (mostly blue)

Still disappointed?
People without social connections die earlier statistically, but that can be explained by outside effects (e.g. if you do not live in a family structure, chances are you'll be found too late after suffering from a heart attack or stroke; less people around you means less immunisation for common diseases; no friends means a house fire may stress you out more and you becoming homeless ...). Calling that "most would be dying from no social connections" still seems a bit a far reach.

Also, the "we need to be around people at all times" seems to be less determined by genes, but by culture: people in other cultures and at other times seem to have been fine with extended periods of no human contact. Think the 'forest dwellers' in Hindu culture, or monastic hermits.
Manage Hybrid Work – Home vs. Office in Soon
Emmanuel Macron aided Uber lobbying drive in France, leak reveals
If it looks like organized crime, acts like organized crime, and quacks like a duck, then it probably is a duck.
Only for 4 years, 206 days and 16 hours.
Everyone is for social justice but somehow it always works best at the expense of someone else's children.
…and what would you do in a colour election?
A model of gravity can be used to generate abitary night skys, but correlations of pixel patterns in sky-images isnt a model of gravity.

When I say "not a function of" i mean, explicitly, that the model does not have a term which depends on these correlations. Just as F=GMm/r^2 does not have a term for "image pixel weights".

Real Language is what wrote all those books, as much as gravity is what made the night sky. Pixels and word frequencies are symptoms, a few of an infinity of symptoms -- distant effects, whose correlations are not models of their causes.
The practical purpose of public schooling is to A) catch the odd prodigy to send to the big leagues with the private school kids, B) get the well-behaved used to 9-5 hours, and C) have somewhere to keep the rest while the parents work.

University used to be just the first group, nowadays it includes the second.
So it's a two-stage attack; increase the frequency of up/downlinks, and then send the bricking payload!
I think this depends a lot on the person. For example, my brain is apparently good at completely memorizing a biology book. I fill in gaps in my knowledge (which seems to exists as a series of images and animations in my head, call it a "world" model perhaps) with what I read. It all makes sense.

Maths however... It takes me seemingly endless amounts of energy to grasp things. My PhD was in Biophysics, and my colleagues were mostly physicists and they felt the other way around. They didn't understand how it could be harder to derive almost everything from basic principles and techniques than to memorize a colorful story about how life works.

Together we could do nice things though, me drawing pictures on one side of the white board, colleagues writing equations on the other side. It was a nice time.
Yeah GP seems to be missing something. PhD programs at top schools are somewhat hereditary at this point. It’s so competitive and there’s too much stuff to just know how to do; spending time with a family member who’s done it before is a huge leg up vs. figuring it out on your own.
SML – a new language in the ML family
Another thing that hasn't been mentioned, while it doesn't directly affect the experience, is how well Costco treats their employees. Almost all of their policies are progressive and employee first, and that's something I'm also willing to support.

https://www.huffpost.com/entry/costco-pay-benefits-glassdoor...
This is something many people overlook when they glorify this character
The legal example is actually maybe even more interesting than you may think. The big traditional databases have always employed human reviewers to identify cases that overrule or question other cases. Attempts to automate this process by e.g. Casetext have had somewhat limited success, despite the fact that this is a restricted context with formal language. It’s getting better, but whether it will ever be good enough is still an open question.

See https://en.m.wikipedia.org/wiki/Shepard%27s_Citations

(By the way, signals are not much used in opinion writing; that aspect of the Bluebook is geared more towards law reviews. Approval or disapproval of prior authority is in the opinion text itself, as this is a formal activity of the court. Notation as to whether a given cited case approves or disapproves another case would be in a parenthetical after the citation, e.g. “Smith v. Jones 123 Foo2d 456 (1999) (overruling Jones v. Smith 12 Foo2d 345 (1989)).”)
Also, do not order a vanity plate that says "NULL" - you are likely to have a very bad time.

https://www.wired.com/story/null-license-plate-landed-one-ha...
That's all is valid only if you have geography and water for such stunt.
It's also well known that connections are extremely important for academic positions, especially so in humanities academia where TT positions are so rare and hyper competitive. The name appeal of the Ivy's can have huge sway, and it leads to a flattening of intellectual diversity in scholarship as whole fields are shaped by certain "schools" or movements that are more often just former fellow students mutually citing each other and their former supervisors. A lot of brilliant research gets passed over because it's not coming from the right school.
An Olympic javelin is about 2.5m, but note that it's not optimized for throwing distance, and in fact has been made more difficult to throw several times since 1986. If it were optimized, or even kept at 1984 specifications, some athletes might be able to throw it out of the field.
There is Leopard codec implementing very similar approach in GF(2^n). AFAIR, it's a bit slower, but overall it looks more useful than FastECC

(OTOH, since we anyway store hashes and other info, we may store there extra overflow bits required for recoding into GF(p). That said, FastECC on practice works like a slightly non-MDS code, but at least there are guarantees how much extra data we need to store)
Medical insurance is covered by the state. We have public pensions furnished by the state but those amount to very little on their own. 90 percent of Danish workers are covered by occupational pensions that are (usually doesn't have to be) a mix of a mandatory contribution by the employee and employer.

So the result is a percentage of your wages end up in this occupational pension that gets added to the public pension when you retire. But because our elderly are getting older, the age at which you can retire is getting pushed up and up.
>We put distinctions on the world because we think it's necessary to be able to actually live here

You'll find that living on the world without distinctions in some places will get you shot or eaten by wildlife. Which does make your life in the world a wee shorter, yes... Although at that point I guess someone truly enlightened wouldn't mind it
Loved the movie as a kid; it changed my life (even though it took me a few times of watching it to fully understand what was happening.)

The sequel, "Tron Legacy", was a fun action movie, with a great sound-track but it's computer world felt "smaller" than the 1982 original and it didn't deliver on the deeper themes.

I would still watch either one today and am hoping for a third. Until then, there's always riding light cycles at Disney World: https://disneyparks.disney.go.com/blog/2022/07/celebrate-the...
Oh yeah, totally. But not always. I'm very glad that we now have an option to have both behaviours.
Constant temperature in such thermal stores is achieved by some flavor of counterflow heat exchange. One could, for example, send a fluid through a long bed of some granular material, in one direction for storing heat and in the opposite direction for withdrawing it. The temperature will be hot at the charging input end and cool at the discharging input end.
The way I'd do this, is by separating concerns into separate tables. If you have a table with (id, name) and a table with (id, parent_id), any doc with a parent will have a corresponding record in the second table.
If the notes on the Arch wiki are anything to go by, SDDM doesn't support Wayland quite well. The issue tracker seems to agree: https://github.com/sddm/sddm/issues?q=is%3Aissue+is%3Aopen+w...

I'm not so sure whether this is an nvidia issue or an SDDM issue.
Soliciting Advice Rather Than Feedback Yields More Actionable Input [pdf]
And the obviously hyperbolical nature of that model still doesn't prevent you from creating it or from it leading to potential further research oppurtunities (in fact,please do release the paper that results from such,I'd love to read it.) and following logically from that it still doesn't prevent anyone from creating a model that disagrees or from following any potential research opputunities that such would lead to.

The validity of a mathematical model is dependent solely upon it's internal (and,depending on the extent of the research,external) consistency.Whether it possess any form of 'accuracy to the real world' only comes into play when people who don't understand this attempt to use it to justify their preconceptions.
For EV battery makers, it's go small or go home
https://github.com/kbd/binrun

I just wrote it today and still need to package it. I was tired of alt+tab + up arrow + enter constantly to execute builds etc. in my terminal. It calls out to a kitty wrapper script I wrote[1] that (eg) queries kitty for its running windows so that when I launch from vscode it can find the right kitty window for the vscode workspace and execute there...

Point is, Kovid Goyal is awesome and the extensibility he wrote into kitty makes all that possible. I didn't know he was also the author of Calibre for a long time.

[1] https://github.com/kbd/setup/blob/master/HOME/bin/kw
Boolean capabilities of meter per every entry? Shouldn't impact size that much, easy to index. As a bonus, you can track failure of a sensor per each meter, and know when it first failed.
https://www.google.com/maps/place/Transport+System+B%C3%B6gl...

This is their test track, on the right-hand side of the road (edit: click on the picture, there's also a 360° panorama of the track)
Scrum Teams are often Coached to Death, while the Problems are With Management
I loved biology but knew it was intractable to me compared to simple machines made by mere humans ;)
Is it really that surprising that people might have wanted to model "preferences for segregation" in the middle of the civil rights era? That's when controversial policies such as school busing were started, and the implied argument for those was not very different from the one that's surfaced by this model - segregation was understood as self-reinforcing, and only very strong policy choices could drive a "mixing" outcome.
This is a cool project, but this is a bit embarrassing:

> I started building a text recognizer algorithm specifically designed for Impact font, and it was actually working pretty well, but I kind of misplaced the code somewhere. So, until I find it or replace it, you'll have to use Tesseract configured with the "Internet Meme" language.
This, along with wind turbine bird death thing, is one of the more bizarre objections Ive heard emanating from the carbon + nuclear public relations lobbies.

There isnt a shortage of up. The geography to make it work isnt rare:

https://www.sciencealert.com/scientists-spot-530-000-potenti...
Personally I want to store my notes as local files and manage them using some open source software, if possible version them using git. Although there are plenty note taking solutions available I find it hard to find something truly exceptional. In total I have used Vim Wiki and Cherrytree the most. Tried most of the tools available and generally most of them offer either too much or too little. In my opinion Notion is a mess.
How do I hit my deductible if I didn’t pay for the first dose?
Awesome is disbutable. The amount of awesome parts is equal to the amount of aweful parts. Calibre is really a prime example of product which shines despite the manifold deep flaws. And this makes it really problematic, as it seems to dominate it's space so strong, that no many even care to work on an alternatives. Very problematic for the health of the ebook-space.
> Yes. China and Russia are the biggest geopolitical threats to the world.

It's all perspective, China and Russia say the exact same thing about the US.

Can't believe people still fail for that kind of propaganda...
> Berlin offers developers the biggest bang for their buck, with high offered salaries and a low cost of living.

That's not really correct (speaking as a former Berlin resident who left mid pandemic).

Berlin has become incredibly expensive due to the housing crisis, and developer salaries just aren't making it worthwhile living there - as opposed to other cities where you pay about the same rent/bills, but make 50%+ more.

Berlin can be cheap rent-wise if you are willing to live in a WG (shared apartment), or manage to take over someone else's lease. If you are a new resident, or move to a new apartment there? You are basically fucked.

London gives better "bang for buck", financially speaking, than Berlin these days, and I never thought I'd be saying that.
Yeah, you are right probably someone behind the WARP vpn, i didn't know they allowed SSH trafic through that.
What is surprising is that the IPs i am seeing do not match any of the ranges Cloudflare is publishing on that link (typically as sub range of 8.0.0.0/8).
That was the starting point, sure, but by the late 80's and into the 90's (production didn't cease until Commodore's bankruptcy in '94) it was still in the game because it was a cheap toy.

I don't have time to go looking for prices in '94 when production ceased, but even as prices for other machines were dropping rapidly, C64 prices remained lower. An issue of RUN from '92 has ads for the C64 at $140-$150. At that point the 1541 disk drive was the most expensive part, at <$165, but you could get the 3.5" 1581 for $109.95

For comparison, an Amiga 600 cost $399 from the same retailer, the same magazine has PC's starting at $500+. Far more capable at that point, sure, but you'd end up paying more than that if you wanted decent graphics and sound, and you needed a monitor whereas the C64 could connect to your TV, and suddenly the C64 was sufficiently cheaper at that point to be seen as a toy.
Legit masterpiece, btw. I wish there was a version with the entire world.
Simple solutions to all of these that ultimately land on the desk of leadership:

>> employee turnover, lack of consistent skills across the software sector, negligence at any level, incompetence - even if not malicious, tired engineers

Pay better, give raises that keep up with the market, and train your people. Basic stuff.

>> ancient software systems that would be impossible to replace in any reason time etc.

Second best time to start is now. Ancient software systems with tons of legacy cruft and obsolete tech aren't going to get any better.

All this costs money, which is the real problem. If there's a market wide failure, as there seems to be in credit reporting, then serious consequences for cheating out on this stuff to undercut your competitors at the cost of security seems fully justified.
The catch is that other forms of energy are also greatly incentivised. Arguably even more than renewables (sorry can't be bothered to find a source).

I live in a European country, and the first reaction by most governments here to rising gas prises was to subsidise gas [insert captain Picard facepalm here].
Not all of Europe was like that. Lithuania built LNG facilities and now can get by with no Russian gas and supply part of Poland too.
you know,,,, there was a april fools day annoucement on torrentfreak years ago, maybe a decade, it was describing this behaviour.
that was nice
Place them on basically any commercially unusable and economically “worthless” space. Instead of mowing down forests to lay them 5 inches off the ground, put them on highway noise barriers, build ceilings over commercial walkways (Europe is full of these but without solar panels), spread them out and put them high over parks to provide shaded areas that allow for greenery to grow underneath, and so on.

The way solar farms are built now, or at least what I’ve seen, is wasteful. Solar has a great advantage in that it can be built alongside virtually anything, but a lot is currently in cleared out areas that can’t be used for anything else.
Cabling in a solar farm is also a big part of the costs. If inverters were designed to output higher voltages - eg. a direct-to-10 kV output, then cables could be far thinner and cheaper. 3 phase silicone cable thinner than your baby finger rated for 20kV at just 20 amps could be run along (and carry all the energy from) a length of panels over a kilometer long.

Such a design generally isn't used today because you have to design for someone potentially breaking in and trying to use cable cutters on a wire - you aren't allowed to electrocute the thief! But higher voltage cables could be used with a metal 'detection shield' sitting at just 50 volts which can detect someone starting to cut a cable and de-energise everything.
Since when do you need military bases to defend against economic war?

Furthermore, the US is waging economic war on half the world since I have memory of it, isn't it time the rest of the world starts to protect themselves?
It is not bad faith at all. He is pointing out that the watches are an example of artificial scarcity. The original engineering may be impressive but once the tooling and quality control has been setup the process will be, to a reasonable extent, automated.

Whether 10, 50 or 100 or 100000 of these watches are made, is the process any different? Is it more like a limited edition print. High DPI printing is an example of technology magic but you can't argue that the choice to limit the output of a printer to a few runs means that the print itself is not mass produced
I 100% agree with the outlook of Dalio, but if that is the plan then why provoke the war now? If they wait 5-10 years the US might implode and not even be able to resist them in the Pacific. The US economy is pretty questionable.

It isn't lost on Chinese high command that the longer they wait, the easier it will be to fight the US. All their planners would be saying "lets not start the war with the US now, lets wait a few years".

Now maybe they go in Putin-style anyway, but Russia is being cornered. China isn't under that sort of external pressure. They can afford to drag this out, Russia has been losing vs. the US for more than 40 years.
I have made ice cream like this using Gellan as a stabilizer. It's just too much of a pudding to melt. It's not really what you want in an ice cream. You at least want it to melt completely in mouth temperatures.
I'm not the person you're responding to, but also think NULLS DISTINCT makes sense in many cases. NULLs often represent missing data. Imagine storing a customer's address and the street name is NULL. If several customers have a street=null, it doesn't mean that they have the same street. So from a data perspective, it makes sense to treat these unknown values as distinct.

For filtering and aggregation I still welcome the change, as it makes sense in many cases to treat them as not distinct.
Not parent commenter, but to me it seems "obviously correct".

As explained in the article NULL means "unknown". Let's say I have two people, and a "tax identifier" column. Let's say two people can't have the same tax id. Obviously "don't have one" or "unknown" fit very well in NULL, and two people can both be missing a tax id, even if those who have it need it to be unique.