skysight-inc/HackerNews huggingface dataset:
... and once you've switched to INNER JOIN, the next question is "when is it appropriate to add to the JOIN clause vs WHERE clause?"

as in

join orders returns on returns.original_order_id = orders.order_id
WHERE <-------- Should order type be in the WHERE clause?
returns.order_type = 'RETURN'

vs

join orders returns on returns.original_order_id = orders.order_id
AND <-------- Should order type be in the JOIN clause?
returns.order_type = 'RETURN'

One argument was that JOINs are specifically for tickling indexes and only for structural joins between tables, not for describing the table itself, so it should go in the WHERE clause. ("ALL context should be in the where clause.")

One argument was that sometimes a definition is limited by context, so strategically it makes sense to add to the JOIN clause. ("the `returns` alias MUST be limited to return orders, so it should be in the JOIN"; you'd have to adjust your indexes to account for the "order_type".)
In accessibility setting you can turn the animations off so the screen just flips instantly.
Call for Participation: Microkernel and Component-Based OS Devroom
Good question - computationally expensive contracts will be removed automatically as part of a mechanism that keeps track of cost/benefit to the peer for each contract.
This is how most modern vector dbs work, you usually can store much more than just the raw embeddings (full text, metadata fields, secondary/named vectors, geospatial data, relational fields, etc).
https://rust-lang.github.io/wg-async/vision/characters.html#...
the US Risks Losing to China in the Race to Send People Back to Moon Surface
Why use celestial bodies at all? Let's bring the Soviet calendar back!
Shannon refers to two strategies which can be used together. A and B.
This is so cool! Flame graphs are super helpful for analyzing bottlenecks. The eflambe library for elixir has let us catch some tricky issues.

https://github.com/Stratus3D/eflambe/blob/master/README.adoc
something is wrong with one of their numbers, because 2 undecillion rubles is roughly 21 decillion USD, not 2.5 decillion USD
Globally it's the US that is the exception. Solars fall apart elsewhere be it solar irradiance or population density or prevalence of flying debris or whatever it might be.

Only in the US, Australia, and few other places it makes sense to just put up some panels for free energy. Incidentally also sometimes apply to EV arguments.
Never seen this before, always thought it would be tasty sugar though.. thanks for making me aware of it!
NNTP, and the Usenet built on it.
Treating this as a serious question: because the big reactor in the sky has a built-in gravity well and a very big sphere of vacuum that works as a free containment system while still letting just enough energy out to be useful. Also we don’t need to refill it or handle the spent fuel.
Why the Library of Congress or some other over budgeted agency can't archive the web is beyond me.
2024 Mercedes-AMG S63 S E Performance Review: It's Superman on Wheels
rephrased as "We took compute from everything else.... and gave it to AI"
Somewhat related: what software did you use to create the diagram?
So, there's no good fallback for `sa-east-1`...
Because what is implicit in saying that solar (or wind) is cheaper than nuclear per W produced is that it is a viable alternative to nuclear. But to be an alternative you need to be able to meet the demand whether there is light/wind or not (with a near zero probability of a blackout). And if you need to do that then you need either a bunch of alternative on demand sources of energy (UK is using LNG) or some big storage capacity (+overprovision to fill them when it is sunny/windy). Nuclear doesn't need that. If you don't factor those costs you are comparing apples and oranges.
It would be an interesting experiment.

You would have to give up many concepts that have local relevance, while gaining better understanding with non-local interlocutors. I think the balance depends on how many of your daily interactions happen at local or non-local scope.

Swatch tried it in the 90s and failed. Maybe we are more globalized today...
IRC. I mean I still use it, but I wish it was more common.
He meant unborn vs born.

The earlier the exposure, the worse the effects
> If it's all just an automated and finite offset, there's no reason for daylight savings policies to hew to 60 minutes adjustments.

For as long as clock sync for electronic devices has been common, I have suggested to anyone who would listen that we should adjust forward 10 minutes on the first Sunday of each month for six months, and then back 10 minutes on the first Sunday of the other six months. A ten minute change once a month is not only easier to adjust to (almost unoticeable), but if you miss it, it's not as big a deal as being off by an hour would be.
This.

I write in Clojure and "coding" is perhaps 10% of what I do? There is very little "plumbing", or boilerplate, most of the code directly addresses the business domain. "AI" won't help me with that.
How to Buy Shoes in the Fediverse
Height: Autonomous Project Management
Dropbox is laying off 20% of its staff
Absolutely agreed, it’s a really nice conversational tone. It is technical without being dry and entertaining without watering down the information. I strive to write like this.
wow. that almost perfectly summed up my thoughts about modern technology and its intentions.
This is common across East Africa, including Kenya where I’m from. The night ends at 6:00AM, with 7:00AM being saa moja (first hour) of the day. Similarly, the day ends at 6:00PM (thenashara). Intuitively, this clock makes much more sense than the English clock. There’s rarely confusion between times because it’s embedded in the language.
> Then I ran EXPLAIN for both of them and the query plan is THE same.

*according to a LLM. Did you verify this?
How I use AI as a technical writer
Alyssa for FSF's president.
Who is Ned Ludd?
I like the point of this article, but it takes a very long, winding, roundabout way to get there. I wish there was a better written article we could copy-paste when people make this suggestion.

I guess what I mean is, I should write one.
Next several years could possibly be devastating to the EPA and consequently the environment.
OK, you're in LA. You finish work at 2300 on Monday.

You have plans to go to the theatre on Tuesday after work.

Is that 0100 on Tuesday (after finishing at 2300 on Monday) or 0100 on Wednesday (after finishing at 2300 on Tuesday)
different kinda politics there.
Likely a judge or jury will decide. Law isn’t code.

If it’s two different things then it’s not the same thing.
Outstanding comic. But we’re past the relatively simple circumstances where groups together watched industrialization. And we’re past the complicated circumstances in which the simply-most-industrial nation would decide a World War. We now need technology that subdues the emissions sputtered by more-economically-important technology. The people behind Ludd would recognize we have a duty to suppress the growth of one and emphasize the other. I wish there was a frame in the comic about that, rather than the irrelevant detail that the first followers of Ned Ludd were white males.
I'm actually quite a fan of perennial calendars like that, I think the Ethiopian calendar is a much more logical system than the Gregorian system.
Assuming no own goals on Nvidia's side and continued execution on AMD's side.
> craning my neck

IIRC, some monitors have curved surfaces. Maybe that feature would help you?
> So your saying that these loans never get paid back in the lifetime of the borrower?

Yes.

> And they just keep taking out more and more loans during their life? X

Well, I'm not making any claims on that but probably.

If you took out a $200M loan and only needed to spend say $25M of that it's probably advantageous to re-invest $100M of that back into stocks and then if they appreciate (too much?) you'd want to do another loan again.
Native, vanilla, iOS development with GPS and Bluetooth LE (2024)
I have been working on something of personal interest: a native workout tracking app for iOS. How hard could it be to gather detailed Bluetooth sensor data using native Swift APIs?
> I doubt there are even real humans behind some posts.

I doubt there are humans behind as much as 40% of some subs.
Is it a rowstore or a columnstore? Have you considered an HTAP design?

It's a storage engine that offer's a key value type store.

You mentioned thread safe, is it multithreaded so it takes advantage of multiple cores?

Threadsafe as in multiple threads can access an instance at the same time with no harm.
These trees often gives good generic bearings for allergies and other aspects of life.

See also: the garden's evolutionary history: https://observablehq.com/@thadk/garden

and the make-your-own evolutionary history using pyodide and the python ETE3 library: https://observablehq.com/@thadk/life
My god, this is where we’re at? Asking an LLM to hallucinate a schema and the resultant EXPLAIN plans for given queries?

Postgres is incredibly easy to spin up in a container to test things like this, and the mentioned schema (Postgres Air) is also freely available.
> Moreover, the "fixed" version is less correct than the version I used 11 years ago, because previously it correctly handled filename command-line arguments even if they weren't UTF-8. Now it won't, and there's evidently no way to fix it.

Isn't fixing this the whole point of Python's "surrogateescape" handling? Certainly, if I put the filename straight from sys.argv into open(), Python will pass it through just fine:

$ printf 'Hello, world!' > $'\xFF.txt'
$ python3 -c 'import sys; print(open(sys.argv[1]).read())' $'\xFF.txt'
Hello, world!

Though I suppose it could still be problematic for logging filenames or otherwise displaying them.
I don't see this being raised as an automation issue. The GP comment is concerned with their work, including licensed code, being used by Microsoft to train LLM models without any kind of agreement or even compensation.

There isn't clear legal precedent yet whether training models is an acceptable use of licensed work, but it has nothing to do with automation.
>Not nearly enough testing is ever done on these things. Everyone is in such a rush to get these things into our environment and our bodies, no regard for higher order effects, which is why this pattern keep repeating.

It was discovered more than 50 years ago and the evidence for its harm is still "inconclusive". How much more evidence do you need? When does "precautionary principle" become crankiness (eg. vaccine skepticism or cellphones cause cancer)?

https://en.wikipedia.org/wiki/Glyphosate#Toxicity
Wow fascinating comparison. Who makes all the money in the airline industry?

Lobbyists?
Absolutely not. I love log structured merge trees and I worked on the algorithms for weeks and I'm fairly confident and happy with them.
Not if that cron file (you can have multiple cron files per user/system) is configured to run in the local timezone.
It's too bad some politicians get appointed for life.
Still doesn't make sense. Prenatal and neonatal, especially when breastfeeding, face the same problems with harmful pesticides and other stuff that has been marketed as safe for broad use, until it turned out otherwise.
Thank you for the kind comment! That's great! I do plan on the repository to have a showcase section so when you do get around to get let us know what you build :D
Gross Apple Marketing
Hm, possibly. My apologies :)
yeah simple sentiment analysis is a basic 4th year undergrad / master's level project.

can be easily done by one person, and with a fairly good level of accuracy and key-word tagging. emphasis on "fairly good", but diminishing returns and all that.
Same, not to mention I can wrap them around me better with mounting arms so that I'm looking at each head on just by turning my head a bit.
Many (most?) current TVs has either a game or PC mode which can be set on your HDMI to disable these "improvements".

I think this is primarily driven by console gamers to the benefits of PC users. Our needs align here.

If you check rtings.com they usually evaluate how good the TVs are as a monitor.

You might still have issues with local dimming etc. But that is the price of cheap. Better models works really good today.

I am using a really cheapo LG 43" 4K as a monitor. Properly adjusted it is usable. Would I like better? Yes. But it is worth the trade off. And there are only a few options for a "proper" 4K monitor at 43". I find that a little strange as it hits the sweet spot around 110ppi. I used to used dual monitors but I much prefer a (I know: comically) large screen.
Only real annoyance I have is that it does not turn off automatically like a real monitor using DPMS. This means that I have to turn it on using a button. It will turn off after 15 min if there is no signal. Like in the olden days.
totally looks like self promotion article lol
Compile is rather generous. The massive teetering dependency tree certainly is prone to breaking, but I am not certain I can draw much parallel between the API stability of JS vs the ABI stability of libcurl. If anything, I can still properly render some pretty dang old websites just fine and, for the most part, the websites will work just fine. Mainly benefitted by the light use of JavaScript using probably no external dependent libraries. Though your milage will vary depending on if you go back to browser specific APIs when all that browser war nonsense was going on. I love to bash on JS as much as the next guy, but a large portion of the blame is actually the modern use of it, not an inherent quality of the language breaking compatibility over time.
random question to a popular thread:

do any of you use LLM for code vulnerability detection? I see some big SAST players are shifting towards this (sonar is the most obvious one). Is it really better than the current SAST?
Any time I see a guide like this, everyone will go on and on about the types of cutters, toolpaths, speeds & feeds, etc. but will always gloss over work holding. For every action, there is an equal and opposite reaction. Without reaction forces, the best cutter in the world is useless. A sizeable chunk of your tooling will just be clamps and indexing tools needed to align and secure the thing you're CNCing, while also trying to keep them out of the work area. 80% of the end mills I've ever broken have been by crashing them into a clamp or vice by accident. This is another thing you tend not to see in 3D printing or laser cutting, or plasma cutting for that matter.
> The media at the time was talking excitedly about the launch of Microsoft Windows Vista and the new MacBook Pro.

Wouldn't Windows 7 have been the latest Windows at the time, or is this a joke calling Windows 7 just another version of Vista?
> The title of this blog might sound a bit dramatic, but everyone has different definitions and understandings of "safety."

Still in Rust community "safety" is used in a very specific understanding, so I don't think it is correct to use any definition you like while speaking about Rust. Or at least, the article should start with your specific definition of safety/unsafety.

I don't want to reject the premise of the article, that this kind of safety is very important, but for Rust unsafety without using "unsafe" is much more important that an OS dying from leaked connections. I have read through the article looking for rust's kind of unsafety and I was found that I was tricked. It is very frustrating, it looks to me as a lie with some lame excuses afterwards.
Great! But the EPA classified DCPA as a "likely carcinogen" 29 years ago. Why does it take 30 years to stop spraying the stuff?
OVH Is down (globally)
Not even their control panel loads but apparently everything is still green: https://bare-metal-servers.status-ovhcloud.com/
15 years after the EU.
That would be true if lights were simple point sources with simple straight ray behavior and no diffusion and no reflection but they’re not.
Meetings tend to start at most at quarter-hour intervales, or about 1/100th of a day.

If everyone used swatch times meetings would tend to start at intervals of 20, or maybe tens. Your meeting would start at @580 and last until @600 rather than 1300 to 1330 or whatever.
Readeck saves an archived copy of the links you save (where it can).

From their docs,
"Every bookmark is stored in a single, immutable, ZIP file. Parts of this file (HTML content, images, etc.) are directly served by the application or converted to a web page or an e-book when needed."

https://codeberg.org/readeck/readeck
It's definitely clickbaity. The author knew exactly what they were doing. Time to flag, hide and move on.
> Beating Nvidia is going to be a lot harder than beating Intel was.

Starting that to beat NVidia they also need to care about software ecosystem, which wasn't something to care about against Intel.
A fun read! My brother actually lives on Lord Howe Island along with his wife and 2 daughters. I’m visiting them in a few weeks too actually. I will share this tidbit with them haha.
What was said:“As CEO, I take full responsibility for this decision and the circumstances that led to it..."

And what was unsaid:
...but I shall suffer no consequences, and I'll upend your life instead. So, I'm good, right?

What even means "I take full responsibility" in this case, if there are seemingly no consequences.
Nice! Love the direction
Let’s all write long explanations of one another’s long explanations, then the people who couldn’t comprehend the simple point in the first place will definitely understand
Site seemed to be hugged when posting this comment, so:

https://archive.is/Eb7TI
> EU is finally connecting the various electrical grids together

European grids have been connected for decades, way before new renewables were a thing.
Ideally, but not always true. For various versions of MySQL and Postgres, the planner will infer when a semi/anti-join can replace a WHERE [NOT] IN clause, but not always. IIRC there are still edge cases where neither one picks up on it, and so it’s always safer (and much more clear to the reader) to explicitly use WHERE [NOT] EXISTS if that’s what you want.
> while revenue slid to the low single digits.

That can't be true. Dropbox made less than $5 in the last three months?
Because you also want to sell to customers who have older devices, which can't display WebP. People who are not computer enthusiasts can keep a machine around for a decade or more. The gains from using WebP are negligible, the downside when they break are significant.
level of effort vs. payoff. my interest level in a lot of twitter posts is very, very low, and blocking constantly just isn't worth my time. at some point you just have to concede the platform is dying and move elsewhere.
Because it's Google. Apple in particular didn't want to play nice for many years and tried to pitch HEIC support instead (or AVIF these days). WebP came out in 2010, right when the whole mobile app vs web app thing was heating up and Apple/Google were fighting for mindshare. It wasn't until 2020 that Apple added stable support for WebP.

Neither offered a big enough improvement for end-users to care.* Cloud operators did care, and Imgix and Cloudinary can automatically transform older formats to WebP or AVIF, for example: https://docs.imgix.com/en-US/getting-started/tutorials/perfo... and https://cloudinary.com/documentation/image_optimization#auto...

There are also a bunch of Wordpress extensions that can do the same, and FOSS proxies too.

* Hell, you think PNGs are bad? We still use animated GIFs and MP3s, even though both are terrible by today's efficiency standards. Sometimes good enough is good enough.
Look at it from the other direction for a moment: say we started with universal time. The whole world used UTC. Now try suggesting timezones. The idea would look absolutely insane. It would be a non-starter discussion.

On the other hand the transition from timezones to UTC has some challenges but the idea itself is very worth considering. What does this tell you?
> A measurement of a hypothetical human foraging in the bush is a useful one but a much more useful one is the energy expenditure to keep a human alive in our society.

Which society? An American one? A German one? What about the iPads manufactured in China for both of them? A human of what income? If you do not draw the boundaries of the system you want to observe, asking how much energy that system uses is not very sensible.
We could add support for something like `pg_vectorize` in order to generate embeddings directly from the database. We simply haven't seen enough demand yet. Perhaps we haven't listened hard enough :')
Why Astrology Matters (2020)
What we need is some of that supposedly conservative originalism: One justice for every federal circuit, and fixed ratio apportionment for House seats to make districts too small to gerrymander.
Not a lawyer, but I would expect you to be the one on the hook there as you shared code without permission and likely lied when agreeing to GitHub's T&Cs.

Microsoft wouldn't be able to pull that code out of already trained and, given that MS didn't do anything illegal when they used code that you said was yours to share, I wouldn't expect them to liable at all. That means MS wouldn't likely be fined, nor would they have to eat the costs of removing the models entirely.

If it were that easy to ruin anyone's model after it was trained no one would be able to make one at all. The training sets used to date almost certainly contain legally questionable content, and anyone interested in stopping GitHub (for example) would just pepper repos with content that violates licenses.
I think async Rust is far from entering the kernel.

Edit: I realize my comment might come off as a bit snarky or uninformative to someone who isn't familiar with Rust. That was not the intention. "Async Rust" is particular framework for abstracting over various non-blocking IO operations (and more). It allows terse code to be written using a few convenient keywords, that causes a certain state machine (consisting of ordinary Rust code adhering to certain rules) to be generated, which in turn can be coupled with an "async runtime" (of which there are many) to perform the IO actions described by the code. The rules that govern the code generated by these convenient keywords, i.e. the code that the async runtimes execute, are apparently not a great fit for io_uring and the like.

However, I don't think anyone is proposing writing such code inside the kernel, nor that any of the async runtimes actually make sense in a kernel setting. The issues in this article don't exist when there is no async Rust code. Asynchronous operations can, of course, still be performed, but one has to manage that without the convenient scaffolding afforded by async Rust and the runtimes.