skysight-inc/HackerNews huggingface dataset:
Maybe I'm high? I mean, I haven't used a mind-altering substance in the past several months (I'm kind of boring.) But I did have the window open and I think I smelled someone down on the sidewalk toking away. I mean, more power to them. I slept through most of the US presidential debate, but the little I did see makes me think I should have a stiff drink. I'm not dissing anyone's politics, but you have to admit, the US has had better presidential candidates in the past. I mean sure, JFK supposedly slept around, but what a guy.
While there are lots of cases where referencing "through" foreign key relations would be useful, this specific example is one for which dereferencing & check seems to be LESS convenient that what is available today with just composite foreign keys.

CREATE TABLE permission_overrides (
-- (...)
granted_in_tenant_id BIGINT NOT NULL,
granted_by_user_id BIGINT NOT NULL,
granted_to_user_id BIGINT NOT NULL,
FOREIGN KEY (granted_by_user_id, granted_in_tenant_id) REFERENCES users (id, tenant_id),
FOREIGN KEY (granted_to_user_id, granted_in_tenant_id) REFERENCES users (id, tenant_id)
);
This is a UNIX System! I know this!
And every surface can be a speaker with lasers..
Really what's the point of asking this question? Did you do a search and not find anything and you're convinced this is false? Or are you just here to fight? [1] shows a pretty clear negative correlation between car ownership and poverty. Do you have a source that shows contradictory information?

(I love social medi... sorry HN oops how can I get this wrong, the quality of discussion is so high! :)

[1]: https://wellango.github.io/posts/2021/06/who-owns-cars-in-ny...
Reposting my proposals regarding copyright:

Any content, once published/distributed/broadcast in the US, that is not made readily available to the public going forward loses copyright protection. This includes revisions.

* A film, TV show, sound recording, book, or any other copyrighted content must, once made available for public purchase, always remain available. If the only streaming service willing to pay to stream your movie has the smallest market share, too bad; the market has spoken on the value of your content. An ebook can fulfill this purpose for a print book; streaming can fulfill this purpose for a theatrical or physical-media film. But it must be available to maintain copyright.

* Compulsory licensing should apply; if Netflix wants to pay the same amount of money as the above-mentioned small market-share streaming service for the film, Netflix must be allowed to do so. The film's rights owner can demand more, raising the price for all, but if every outlet refuses, the film immediately goes into public domain. This process is reversible, but it would set a ceiling to prevent the owner from setting a ridiculously high price to prevent its availability.

* If a Blu-ray of a film or TV show has excised or modified scenes for whatever reason, and the original isn't also made available (whether on a different "theatrical cut" release, or as a different cut on the same disc), the entire original version immediately goes into public domain.

* If NBC posts Saturday Night Live skits on YouTube that have removed "problematic" scenes[1] without explaining the differences—a diff file, basically—the entire original skit loses copyright protection.

Separate issue, but also very worthwhile:

* Streaming services must make all data regarding their content available in some standardized format. Consumers should be able to use one application to access all content they have access to. The creator of SmartTube (a very nice YouTube-compatible player) should be able to add the appropriate API support to search for and play Netflix/Prime Video/Disney+/Paramount+ content.

The above applies to software, too. Legalize abandonware!

[1] Something I understand already happens
What else would you have expected? You can't index what's not there. It makes sense that DROP COLUMN would also cascade to DROP INDEXes.

The author of the question writes:

> If you overlook such situation, you can get serious problems in production.

Really? I hope you think it through before you DROP COLUMN in production!
my intuiton tells me my emacs shows me a colorname, rgb, hex and hsl or whathaveyou in color.

confirmed - and a valid color name gets converted to #hexval; on spacebar it seems
A book like If I Did It by O. J. Simpson?
Ten Science Histories – Science
The nicotine is what makes it addictive, but everything else makes it deadly.

This distinction is well known here in Sweden where we have snus, and also lower rates of lung cancer and cigarette use than the rest of Europe by a LOT.
What's amusing about this is Cloudflare converts HTTP/2 to HTTP/1.1 and then back again.

HTTP/2 just seems like it is designed for Google, CDNs, advertisers and a web full of even more behavioral tracking and ads, where even more HTTP requests are not initiated by the user. For that I am sure it is great. But that's not in the interests of me as an end user. I do not use a graphical browser, I do not request ads; the way I use the web, as a data source, HTTP/2 offers me nothing. For me, it removes one of HTTP's most useful features: HTTP/1.1 pipelining. I use this feature every day.
Do you have any idea about how expensive it is to audit your entire supply chain to ensure that it is 100% free of allergens? You'd essentially put that cost onto everyone for the benefit of a small minority. I'm sure you can see why that is a political non-starter.
Too bad C doesn’t have a “do this 3 times” loop.
This is very hard to understand
> but all those things you "were doing with improper form" are easy enough that people had been informally teaching each other to do them plenty well for thousands of millenia.

I suspect you're idealising a past that never existed. I don't think there is any particular evidence that people were ever in good physical health or easily in touch with their bodies. The evidence I have seen is they were malnourished, parasite- and disease-ridden and often lived relatively short lives filled with pain and discomfort. There are surely some lifestyle diseases that came into existence since the 1000s but there are also a lot more that disappeared.

I think this stuff is just generally tricky to get right and people struggled then about as much as people do now. For some easy things like diet there is no real question that they had it much worse.
Especially for grid storage sodium ion is looking very promising. As are several other chemistries. But most of the current production is still lithium based for now and it will take time for that to change. I would say non lithium storage might become dominant from the mid 2030s and onward.

As for battery capacity. There will indeed be way more batteries than energy generation. But that's only a problem if you assume all those batteries are being cycled to capacity continuously. IMHO that's actually not the case. Most car batteries don't get drained on a daily basis. It's more like once a week or two weeks for average drivers. Same with grid batteries. They are used more intensively of course but also oversized so they don't constantly run out.

My point was that most batteries are, on average, holding a charge that's probably close to fully charged (or 80%, which is more optimal for some battery chemistries) and that only fraction of that aggregate capacity is discharged and recharged on a daily basis. Having that much batteries is really good news. IMHO it's a trend that will accelerate as batteries continue to get cheaper. We'll just buy more of them and find more places where it's nice to have them. Think of an e.g. AC units with a battery that can charge during the day and discharge in the evening.

As for the IEA, take their numbers with a grain of salt. They are notorious for having to correct their own predictions regularly. And there are some well known issues with their modeling and assumptions. Generally, you can subtract at least a few years from most of their predictions.

I'd recommend reading some of the reports by Bloomberg NEF they've had a few interesting reports on investments for battery production. Apparently we can look forward to over production and price drops next year already.
> Stockholm’s congestion tax was approved by voters after a 7-month trial period.

How dishonest must you be to lie in such a blatant way?

From the Wikipedia page referenced from the article: "Local consultative referendums regarding whether to permanently implement the congestion tax were held in Stockholm Municipality and several other municipalities in Stockholm County on September 17, 2006. It was only the referendum in Stockholm Municipality that the at the time reigning government would use as a basis for the decision. The municipalities surrounding Stockholm in Stockholm County, especially those that are part of the city of Stockholm, showed discontent with the fact that the people of those municipalities get no say whether the congestion taxes will be implemented permanently."

And the data shows unambiguously that it was only the resident of the centre tha voted yes.
I just set up a donation page, you can find it on the github repo page, on the right. But please keep in mind that for now I have to finish my exams so you may have to wait a bit for new features. Also, any feedback and suggestions for improvement are appreciated especially since you work in the field.
No, "row" is a generic type, all concrete rows have concrete types narrowing the generic type with an ordered sequence of element tags and element types. (Relations are typed similarly to rows, since they are containers for rows of homogenous type.)
It's not entirely out of the question that dropping column `b` could convert an index on `(a, b)` into an index on just `a`. An index on `(a, b)` can be used to optimize queries on just `a`, and you might have created the index to accommodate queries on either `a` or `(a, b)`, so this behavior would change query optimization less than dropping the index.

I'm not arguing this would be correct behavior. It would probably be too magical. But it does make some sense why someone might expect this behavior.
I don't think there is a mechanism in the Democratic party for removing Biden - he has to agree to it. It may come down to whoever he still listens to, so maybe Jill Biden is the most significant figure right now.
A bartender mocked my brother for getting Aspirin for his broken arm.

"man you got nothin', you should get some oxy for that!"

I'd been living outside the US and this in my first few hours back on US soil. A few hours later my friend (working in criminal defense) explained how opiates accounted for roughly 1/3rd of his income (other sources: drunk driving and domestic abuse). They all followed the same trajectory: minor condition -> prescribed oxy -> illegally obtained oxy -> heroin when the money ran out.

This wasn't normal. It didn't happen anywhere else in the world at the time, or at least not where I was living.
Noise can be excluded.
> As I understand it, flame graphs add to normal x-axis-as-time ones by merging repeated calls to the same function, so if one function is called a lot it shows up as one wide chunk and not many small chunks spread out.

Not if the graph is sorted on time axis. Not if the callstacks look different in different cases. Not if the program is recursive and thus have different depth all over the place. There is a lot of places that merging can fall over and not happen.
On a second read, I would like to rewrite your workflow as follows:

I would prefer to be able to:

[x] buy a GPU, -> [v] Download SimReady USD of your GPU from nVidia website.

[v] whip up some CAD

[v] import USD of nVidia card into CAD

[v] measure the geometry using CAD

[v] Design cooling element

-> Export CAD to USD

-> Import CAD as SimReady Asset into nVidia Omniverse with tests you need.

-> Once simulation is OK send final CAD to production (or better from GPU simulation into simulation of production on one of the factories or 3d printers)

In this scenario:

- SimReady USD of a GPU must already exist inside nVidia. They could make it available for simulation inside Omniverse. (or build open high level model yourself)

- Thermal simulation app is something that nVidia needs for their business now and in the future. They could share current software with public and let people like you download it, change it and run simulations with your changes (or build open high level model yourself)

I'm wondering how difficult it would be to simulate important effects on your models. Do you think the above process has potential to improve your process or did I miss some important detail of your work?
Just to emphasize how efficient a dishwasher is with water, I had a clog in my kitchen pipes (turned out to be much deeper than my drain snake could handle and we had two clogs) and the plumber couldn't come in until a few days unless I was willing to pay for an emergency plumber. I would run the sink for 30 seconds and it would clog. But I could run an entire dish load and it would only fill a bit of the sink and everything would drain okay. Now I have a nice modern dishwasher, but it just goes to show that literally handwashing a handful of dishes is probably as efficient as doing an entire load of dishes in the dishwasher.
100%. Our local bus system can't hire operators because they're priced out of the area for housing, so all operators have to come from a 4 hour Metrolink ride away.
If you split feature flags into a different repository, then you're losing the benefit of having everything in a single repository, of having consistency and avoiding situations where your codebase refers to feature flags that don't exist, old feature flags that are no longer checked by the codebase, etc.

At this point, your production infrastructure is no longer solely one stateless server + one database, but two databases: your RDBMS and your GitOps repo tracking feature flags. Do you really get enough value from the second GitOps database compared to putting your feature flags in your main RDBMS?
The ETF Innovation Black Hole
Only for the updates of the base OS. Updates to flatpak apps and distroboxes don’t need an update

And the actual download and install happens in the background before the reboot

So a 20 second reboot is hardly a huge cost for a much more solid update mechanisms
Heck. I came here to make essentially the same comment.

I miss the 90s when we did XP.

Another complaint I have about Scrum is its structure assumes you have a good idea of what you're trying to do. Agile was supposed to reduce the cost of design changes.

Also... is there anyone who uses Scrum who doesn't use Jira? At this point Scrum is essentially the same as saying "Our organization uses Jira. No one in my organization knows how to configure it because we don't want to pay to send the guy who manages it part time to training. And when we paid for the consultant, they asked all sorts of questions like 'how are your projects laid out?' and we said 'uh... we hired you to tell us how we should do that' and they said 'you need to know how your projects are laid out' and we said 'heck, batman, we don't even know what the hell we're really building because we're waaay early in the requirements gathering and design' and they said 'how cute, call me when you know what you're doing' and we said 'yeah... i think we can randomly click buttons on the Jira interface without your help' and our VP said 'we need to monetize our synergy by leveraging our learnings and develop asks for cross departmental interfaces' and i said 'absolutely, Bob, I'll just be over here writing a distributed map reduce function in Erlang' and my management chain said 'CI/CD is hard, let's just do GitFlow and hire interns to randomly type YAML files we upload to AWS' and at this time I tried to wake up but it was not a dream."

Which is to say... Scrum adds structure to the things that are easy to add structure to and seems to avoid having people think about the problems. You ABSOLUTELY can do Scrum without it devolving into a crap-fest, but it's not easy and you wind up using other tools, often without telling your management chain.
Functional programming is not just about monads. I bet it’s easier to explain

numbers.map(x => x * x)

than

let result = [];
for (let i = 0; i < numbers.length; ++i) {
result.push(numbers[i] * numbers[i]);
}
Thanks. I always read headlines like this with skepticism and try to find the license used right away. They score easy feel-good points throwing around "open source" without going all the way.
In Aeon you can have a distrobox of whatever distro you like

So it isn’t a huge PITA to run Ubuntu or Fedora packages on Aeon
They can mess with response to make redirects/checks before my content is served, but my content is mine they should only cache it and that is it.

If they serve ads on their captcha or some redirect I'd say well it is not nice - but for me fundamental difference is messing with my content even in a good faith - send me a notification an email or stop serving my content if it is active malware but don't change it.
The ketogenic diet enhances health span and memory in aging mice, suggesting potential benefits for brain health. Speaking of losing weight, for those considering weight loss solutions like buy wegovy online https://www.canadapharmacy.com/products/wegovy , consult a healthcare provider for guidance and ensure you're making informed, safe choices.
Pretending China/Russia/Iran companies are evil while US companies are not because of some preconceived notion is a great way to let that world order crumble.
ULA/Tory Bruno has definitely given tours to YouTubers as well
Advanced Meditation Alters Consciousness and Our Basic Sense of Self
> AGI safety

I genuinely laughed. Oh no somebody please save me from a chatbot that's hallucinating half the time!

Joke aside, of course OpenAI is gonna play up how "intelligent" its models are. But it's evident that there's only so much data and compute that you can throw at a machine to make it smart.
I can see where the no firewall argument is coming from and definitely on my own Linux laptop, I try and keep the number of ports listening down as much as possible, but it is tricky and it requires a lot of vigilance as sometimes applications you wouldn't expect to, will start services. Things like Spotify and Steam can open ports.

So having a firewall running can provide a bit of extra protection in case you don't always check to see what ports you have open/listening.
New Boeing Whistleblower Warns of 'Devastating Consequences' from Plane Flaws
This is art! I wonder... What if the depth at which a package first appears depends on its release date? And what if each universe evolves in terms of package releases?
Bitcoin (BTC) Donation of More Than $500K Received by Assange
I’ve never had that happen.. what password prompts are you referencing?
oh man. i came here to forget about politics tonight.

still... thanks for just commenting about reddit rather than making a political jeremiad.
This feels like a fairly disingenuous interpretation of how this gets implemented.

Normally, commits must match a particular pattern to be included. Those that start with "feat:" might appear in the features section, while those starting with "bug:" show up in fixes.

A few simple rules are enough to ensure that an intelligible changelog is generated. Minimal cleanup can then focus on making it presentable.

You could even set up your pull request rules to handle this for you. On approval it could look at the linked issue and include the title and appropriate pattern for that issue as the message for any merge/squash commits it creates.
The difference is that for solid-state logic, the heat is purely a waste byproduct, whereas for thermionic valves, the heat is the energy used by the electrons to move between the electrodes, hence the name. If the valves are cold, you have to wait for them to warm up before they can do anything.
* What is the figure on the magnitude of power Australia needs?

* How many 2MW molten salt reactors like the built and being tested TMSR-LF1 reactor would Australia need to meet that figure? What would be the cost and time to construct that number in parallel?

* There's a 10MW version planned - what's the cost | timeline | number for those?

* Eventually there might be a ~ 300MW version built and tested .. what's the timeline on that?

https://en.wikipedia.org/wiki/TMSR-LF1

The CSIRO GenCost report seems to think the costs of batteries + renewables will be far less overall and more immediately available in Australia as we scale them out .. rather than waiting decades and still having to fudge about in the meantime .. thoughts?

https://www.csiro.au/en/research/technology-space/energy/Gen...
Now do this when you are late 40s
.
> TikTok IS the primary news source for the American youth

TikTok never forced their users to use TikTok

I mean, people have choices and made the decision to use TikTok.
Framing this as some "green" measures is just falling for corporate propaganda.

Of course Emirates is desperately trying to save on fuel, so is every other airline. Reducing fuel usage directly increases profitability, of course every pilot should fly in a fuel preserving manner.
I wonder if you could use LISTEN/NOTIFY so when a task name and payload are committed to a 'tasks' table, then it enqueues the job as if you had done so via gRPC?
Food safety laws don't impact the end customer. You can legally take ham out of your fridge, leave it in the hot place for 24 hours and eat it. You just shouldn't.
It has in-app purchases! Apple doesn't reject shady apps that bring revenue unless it's really bad for PR.
Same here, I can't read in a moving small car but I can read just fine in a train or a plane. Haven't tried reading in buses or trams.
Has anybody tried Spiral and Gecko? Same developer adapted Debian Sid and Suse Tumbleweed with btrfs snapshot after each install. How did they/similar systems work in practice for you?
Core Java 13th Edition at the Printer
Oklahoma Superintendent Ryan Walters orders Bible taught in schools
As for Go, the dataset looks very-very old and outdated.
At least 5 to 10 years old.
A Swedish keyboard layout works for Norwegian, as long as the Ö maps to Ø and Ä maps to Æ. Or the Danish as well, except there for some reason Æ must map to Ø and Ø must map to Æ, otherwise they're identical. So most keyboards sold in Scandinavia just has one button with ØÖÆ on it and another with ÆÄØ on it, and then based on OS keyboard setting you get the correct one.

Point is, I'm curious why they also just don't release in Norway when they have made the layout? But I guess it's because we're not in the EU that makes it harder?
> I have no idea where you'd get that notion from, did Dutton hand wave that in during a press conference?

No this is just my mind connecting vaguely related things together in an attempt to have some logical rationalisation behind the idea of civillian nuclear power plants. We are going to need trained operators for the subs, so having a comparable civillian industry might also have some synergies.

> The "digging out" part isn't a great expense or challenge, maybe you might want to read up on processing requirements to isolate isotopes of uranium - raw yellowcake isn't a ready to rock and roll fuel.

I know, just as with other things like rare earth minerals it's the processing that is toxic, expensive, and difficult.

I guess I'm longing for Australia to do more than just (stereotypically) digging things out of the ground. If given the right incentives there could be an entire nuclear supply chain with good jobs and good safety providing relatively clean fuel to power the country and as export to select partners. The current plan does not do this to my knowledge so I don't really treat it seriously.
…and a microphone?
The Four Freedoms of free software or the Open Source Definition may clear things up, for those who haven't read them. You can sell CDs with Emacs on them!
Yeah, but then again this is like SAL from VC++, and unfortunely adoption hasn't been great since 2010.

At least now, in theory, WG14 is paying attention.