skysight-inc/HackerNews huggingface dataset:
They are effectively the same but only because the set theory algebra lets the optimizer move things around.

The first one says 'put these two tables together then apply the where conditions that link them together and other stuff'. The second one says 'put these together but pay attention to this on condition when doing so and some other stuff'.

Now the set theory algebra lets the optimizers pick out parts of the where condition and move them up to the matching part. You see that in your query plan. The optimizer will also add other coditions such as what you see with the index pick and the type of matching/filtering it is using.

I personally have used/abbused the on condition to make things more clear things that really only apply to that table and matching.

Now he does ask is it the same with MySQL. Probably but someone would need to look at the query plan it spits out. But my guess is yes.

The question is sort of like asking is x + y = z the same as y + x = z. Well yeah sorta mostly. You can get weird cases where doing the order of operations differently gets you different speed profile results though. But the output is the same. But that is the fun of playing with optimizers and your knowing your platform characteristics.
Investing with someone poor is a good way to lose your investment. Trickle down economics are not real and investment is not a progressive tax.
I'd just like to point out how stereotypical of a modern mechanical engineer it is to want to print everything out of plastic and not appreciate the greater versatility of a CNC router.

I can't count the number of times I've converted gasketed joints into O-ringed joints, slotted holes, casting lines and welds I've smoothed out. Yes, there are better machines for performing these tasks in metal but I can just tell the CNC router to go nice and slow and come back hours later. In addition to that there's all buffing and polishing operations you can do with abrasives and the ability to cut cheap wood templates and test parts. The 3d printer can make complex things relatively quickly and easily but it can't work with existing things.
> Nobody has to worry about ignoring deprecation warnings in libcurl, or for that matter in C, in English, in Unicode, or in linear algebra. There's no point at which your linear algebra theorems stop working because the AMS has deprecated some postulates. Euclid's theorems still work just as well today as they did 2000 years ago. Better, in fact, because we now know of new things they apply to that Euclid couldn't have imagined. You can still read Mark Twain, Shakespeare, or even Cicero without having to "maintain" them first, though admittedly you have to be careful about interpreting them with the right version of language.

I mean, that last part really unravels your point. Linguistic meanings definitely drift significantly over time in ways that are vitally important, and there are no deprecation warnings about them.

Take the second amendment to the USA constitution, for example. It seems very obviously scoped to “well-regulated militias”, but there are no end to the number of gun ownership proponents who will insist that this isn’t what was meant when it was written, and that the commas don’t introduce a dependent clause like they do today.

Take the Ten Commandments in the Bible. It seems very obvious that they prohibit killing people, but there are no end to the number of death penalty proponents who are Christian who will insist that what it really prohibits is murder, of which state killings are out of scope, and that “thou shalt not kill” isn’t really what was meant when it was written.

These are very clearly meaningful semantic changes. Compatibility was definitely broken.

If “you have to be careful about interpreting them with the right version of the language”, then how is that any different to saying “well just use the right version of the Python interpreter”?

> Today I opened up a program I had written in Python not 2000 years ago, not 200 years ago, not even 20 years ago, but only 11 years ago, and not touched since then. I had to fix a bunch of errors the Python maintainers intentionally introduced into my program in the 2-to-3 transition.

In your own words: You have to be careful about interpreting it with the right version of the language. Just use a Python 2 interpreter if that is your attitude.

I don’t believe software is something that you can write once and assume it will work in perpetuity with zero maintenance. Go doesn’t work that way, JavaScript doesn’t work that way, and Curl – the subject of this article – doesn’t work that way. They might’ve released v7.16.0 eighteen years ago, but they still needed to release new versions over and over and over again since then.

There is no software in the world that does not require maintenance – even TeX received an update a few years ago. Wanting to avoid maintenance altogether is not achievable, and in fact is harmful. This is like sysadmins who are proud of long uptimes. It just proves they haven’t installed any security patches. Regularly maintaining software is a requirement for it to be healthy. Write-once-maintain-never is unhealthy and should not be a goal.
(thinking aloud/voice in my head)
If 'those things' are recharged by sunlight, I wonder how will they get the energy to continue transmitting (assuming they have whatever source AND solar panels - for when the fuel runs out and they can't catch any sunlight?)

my dialogue with ChatGPT:

Voyager 1 and Voyager 2 are powered by \*Radioisotope Thermoelectric Generators (RTGs)\*. These RTGs use the natural decay of \*plutonium-238\* to generate heat, which is then converted into electricity using thermoelectric materials.

Here’s how the process works:

1. \*Radioactive Decay\*: Plutonium-238, a radioactive isotope, decays over time, releasing a consistent amount of heat.
2. \*Thermoelectric Conversion\*: Thermocouples in the RTGs convert this heat directly into electricity.
3. \*Power Supply\*: This generated electricity powers the instruments, computers, and communication systems on each spacecraft.

Each year, the power output of the RTGs decreases slightly as the plutonium decays, so the Voyager missions have had to shut down non-essential systems over time to conserve power. Despite this, both Voyager 1 and Voyager 2 have enough energy to continue transmitting until at least the late 2020s, when their power levels will likely drop below the minimum required for communication.
Are you asking for help because I will help you. I love to read sci-fi novels as well as discuss them.
Ironic that iPhones are both expensive _and_ come with planned obsolescence
Some people have opinions that are outside of the purview of the two parties, for example ending the forever war.
That loop is not a short one though. LLMs don't actively incorporate new information into its model while you're chatting with it. That goes into its context window/short term memory. That the inputs and outputs can be used when training the next model, or for fine tuning the current one doesn't change that the distinct steps of training and inference.
There’s JavaScript code we have that won’t compile after 3 months. Pretty sad state of affairs these days.
We are Jaimru Technology Private Limited - Results-oriented <b><a href="https://www.jaimru.com/digital-marketing" rel="dofollow">Digital Marketing agency in Delhi</a></b>. With the best industry experts working with us. Our work always speaks from us. We are dedicated to providing our clients with the best strategies and solutions. We are committed to helping our clients reach their goals and achieve success. We focus on providing high-quality services and delivering results in a timely manner. We look forward to working with you and helping you achieve success. https://www.jaimru.com/digital-marketing
Which is why it's part of the greater universe, not the regular one.
>>I need to double and triple check the updated code

Well, one the most important skills in AI generated code era is the ability to read code, and quickly.

Another thing is, writing smaller functions helps.
2% is not a lot. If it takes 50 years of accumulation for things to get bad, saving 2% means it'll be bad in 51 years. And remember, that's for all of the airplanes in all of the world (tens of thousands from commercial alone).

The actual savings from Bezos' and Musk's planes is something like 0.000_024 percent. So if it takes 50 years until it gets bad, it'll take about 50 years and 8 minutes after you take away their planes.

Whether something counts should be done with math, not feel good sentiment or pandering to people's envy.
So…. Antman?
Please do! Announce his arrival using his favorite time zone, and see if we can figure it out...
There used to be at least one airport in a tribal area in the US, that had the timezone of the reservation (not same as state) but the DST of the surrounding state (not same as reservation).

Can't remember the code for it now, had a lot of interesting timezone issues in a previous job.
I live in France, so in a place where manual was the norm.

I hate it compared to automatic. Automatic is so much more comfortable (in my Toyota Hybrid RAV4 at least), driving in yraffic us much easier etc.

I will never buy a manual car again.
> For teams you can measure meaningful outcomes and improve team metrics.

How? Which metrics?
Companies where bureaucrats are in charge won't allow it.
It is not available on play store, but that is to be expected. You cannot be there with a such product.

It is not available on f-droid, which is a bummer, because I use f-droid.

Installing things from a webpage like an old barbarian. I cannot find nowhere sha for the builds on page. The same is for their 'releases' on github.
I am enjoying Odin myself but I have to admit, I do wish they kept with * rather than ^.

I know -- it is a personal preference due to my experience with C. On the other end, I understand the change because it is more inspired by Pascal.

Also, the ^ can be used on the left side of the variable (meaning pointer to var) or ^ can be on the right side (dereference pointer to var)

It is using the Pascal usage of ^ -
A diff of a diff is just 2 diff. It’s not a product of diffs.
This sort of makes me sick as a software engineer with licensed code on GitHub. Am I understanding correctly that they have trained data on my code despite my license? Do I receive monetary payment from the deal? Or have I misunderstood this?
I am financially ruined (agricultural futures)
That’s standard traditional Hebrew time still today.
Sadly FTP didn't seem to have a smooth TLS transition. There is FTPS (among SFTP), but I have rarely seen it in use.

I think it will survive as a protocol as a fallback mechanism. Ironically I used FTP on a smartphone here and there because Smartphone OS are abysmally useless. Don't get me started with your awesome proprietary sync app, I don't do trashy and they all are.

Otherwise I do everything today through scp and http, but it is less optimal technically. It just happens to be widely available. FTP theoretically would provide a cleaner way for transfers and permission management.
Reunification therapy sounds like it might be a First Amendment (U.S.A. Constitution) violation since you generally cannot compel actions or speech, especially thoughts.

The author writes that, "many more Americans are being forced to have children. Legally, these laws serve to make having children a requirement, not a choice." That seems like a disingenuous oversimplification. Americans are not being forced to have children; they are just required not to abort children that are the consequences of actions they chose to take (sex), assuming they weren't raped (and thus had no choice).

I do agree with the author that children seem to be generally treated as political pawns or by parents as extensions of themselves, rather than as individual people that need assistance learning and growing up.
Some products do better as Veblen goods than others. You can't show off your dishwasher as easily as your new Ferrari or iPhone :)
India is UYC+5:30, and doesn't do daylights savings time, which is interesting for interacting with the rest of the world. Of course, China famously has one time zone despite being really wide which makes things interesting both internally and externally.
Taking (policy) action to enhance the sustainability of AI systems [pdf]
> This one appears to have been published in the summer of 2024.

"Summer" in certain parts of the world, at least.
Would you say the rise of science had any effect on the levels of aggregate stupidity on the planet?
Wait, hold on.

Let's make the doorbell an NFC payment touchpoint. Tap and pay 25 cents to ring the doorbell.

The more you tap (and pay), the more the doorbell will make an effort to reach the person on the other side.

Wanna pay $20 to the doorbell? Sure, I guess it can ring my phone to let me know someone shows up...
They said to follow the guidelines for writing your CV that are posted in the job ad. So I did.
It seems to have a hickup in production when saving, there are errors.
The good thing: it's on GH :) let's fix it!

https://github.com/stagas/ravescript
>> Some early flight simulators draw a top-down flat shadow when on a runway. During my research I expected to see examples where the shadow is also seen when in flight but couldn’t find any.

F-29 RETAL aka F29 Retaliator aka F29

That shadow was another small tidbit what gave this game the enormous feel of speed.

https://imgur.com/a/hOgxr7a

https://www.mobygames.com/game/6233/f29-retaliator/
Voice, rhythm, and genre in children's early writing
Ask HN: What countries provide the best incentives for startups?
Incentives such as startup funding, Intellectual Property protection, tax exemptions, ease of starting a startup, costs to run a startup, insolvency regulations etc.
This is the https://en.wikipedia.org/wiki/Jevons_paradox and it's what always happens in these cases.
The appreciation of the stock.

Later you die, your stock is now worth $1000 of which your estate pays $0 tax on it (see: stepped up cost basis) and then they pay off the loan and pass the proceeds to your trust.

in the interim, you've been able to enjoy the $100 from your stock (which may have a cost basis if $0.0001 since you're a fonder) without paying any taxes.

---

Also your interest rate of 10% is a bit high but still basically lower than the appreciation of stock so it kinda doesn't matter.

https://tradethatswing.com/average-historical-stock-market-r...
Recreational math and games boosted both computing and science.

Unix was born to play games. And Curses was born for Rogue.
You don’t go into debt by printing money.
It's possible to decrease costs faster than usage can rise.
I feel like the opposite is true. Money is all that matters because it seems like everyone has a price.
In case you're wondering whether this works on a Mac, like I did, I found this source[0]. In short, you need an M2 Pro or better, and may need to edit a plist file to get it to work.

[0] https://scottstuff.net/posts/2023/10/10/samsung-8k/
Pretty sure the farmer who spooked us knew how to do that too. It's just an example of how someone who, even though had some experience with the tool, still didn't know how to use it in a novel context.
It is already illegal to fire people based on their religious beliefs.
Greenland is one of those spin-off movies that is part of the cinematic universe, but is generally considered to be non-canon.
Plenty of people buy secondhand equipment. Manufacturers want to stop that; spare parts are hard to get or needlessly expensive, and manuals are woefully incomplete or nonexistent.
The logical conclusion of going down that route would be to dispense with the concept of time zones altogether, and just revert to using local solar time.
Actually -- I belive someone known in the Odin community is writing a book!
https://www.youtube.com/watch?v=j5BGZyz01lk

He also have some good tutorials online...
https://zylinski.se/posts/introduction-to-odin/

Odin may not be officially production ready (ie no v1.0 yet) but it is being used in real-world applications! I believe gingerbill, the creator of Odin.. also works for them!

https://odin-lang.org/showcase/embergen/
Designing Robust Cyber-Defense Agents with Evolving Behavior Trees
I'm curious how far away we are from a robot that can pick up LEGO pieces and stack them together according to the assembly-booklet.

And what kind of DL models would it use?
Thanks. I don't need the pic, I can picture Maxine immediately. I absolutely don't see Teri Garr in that face and I don't remember her voice well enough to go by that.

Wow. All the times I've seen that movie and never even noticed her name in the credits. Gotta say, I love these little surprises.
a small 3d print can solve that for ya

apple wanna 'show it off'
That sounds like an interesting interview question. I would never hire someone who thinks like that.
Like how Spider-Man actually belongs to Sony, not Marvel, and it gets loaned back to Marvel? Or more like how Blade isn't part of the MCU, but totally belongs to Marvel?
Perhaps Microsoft, so they can push the losses to the shareholders of Microsoft instead of their own balance sheet.
Find a hobby machinist.

People who aren't trying to expand their business don't want to deal in non-gravy projects from customers who don't seem likely to shovel them a bunch of gravy projects later.

Machining is a slowly dying industry in the west so there's far more people not growing their business at any one time.
An interesting aspect of ACWST is that it has no legal status - it's observed purely by local convention, though it's still managed to make it into tzdata.
"Look where the sun is"

Well, maybe that was another problem with Scotland... ;-)

No wonder they built a few walls and retreated south....
This was the rhetoric at the time and it just doesn’t fly.

You can’t force people to do something to their bodies in order to make you feel safe.

If you’re that worried, just stay home.
Not something that makes me want to update the screen right now

That about sums it up.

I alternate between 120hz and 60hz monitors depending on where I’m working.

For software engineers: 120hz is “nicer”, and if you are buying a monitor today I’d say it’s well worth it to pay another $100 or whatever to go for 120hz+ versus 60hz. Certainly not worth upgrading for this alone however.

For designers: Same as above but it perhaps leans a little closer to being worth the upgrade. The mouse cursor is noticeably much moother and if you’re doing digital painting or something all day, 120hz+ might really be worth the upgrade all by itself if budget allows. Working with the 120hz (or is it 240hz now?) stylus on iPad Pros is revelatory for that kind of work.

For gaming: For any fast action gaming (for games and platforms that support high frame rates) it really is worth the immediate upgrade. Your world now looks and feels fluid. It feels real. Input lag is usually halved as well.
I disagree :)

I think we are heading towards a future rather similar to a SyFy called Incorporated.

https://en.wikipedia.org/wiki/Incorporated_(TV_series)

The world will be much warmer than now even if we stopped all CO2 emissions this second. I think that series was rather close to what we are looking at.
Still not weirder than Lunar calendar
I love that as well, I hate bloated sites just as the next one here.

But for any more complex form with dynamic content, JS is still inevitable. I guess for HN the input form at the bottom is enough. But Algolia uses a custom input component already.
On windows, you just create one then do a "runas TrustedInstaller"
Sounds like they might be running out of money and trying to put an AI-flavored spin on it.
My dad's regular 208 (new, a few years ago) was <10k euros after they took his old beater

22k is a lot of money
https://github.com/karthink/gptel

https://github.com/lanceberge/elysium/tree/main
They would have, 1.5 years back. Now there are other players in town.
If costs have dropped to the point that Ethernet is less expensive than LIN, it would definitely be a surprise.
You can do it but don't expect top notch results.

Routers don't have enough rigidity (this is why you don't see gantry mills except in huge sizes) for the kind of work you'll want to do. So much of your stuff will be one off that you're not going to have any speed advantage over a guy with a Bridgeport.
I agree with the author - introducing a vector database often isn't worth the extra complexity.

Personally, I can vouch for ParadeDB: https://www.paradedb.com/

It adds extra extensions to PostgreSQL which enable vector indexing, full text search and BM25. Works great and developers are helpful!

The major difference is that you must generate the embeddings by yourself, but I consider it an upside - to each their own :)
It can also cause trouble if you store past events but do not store the user's local offset or timezone at the time of the event. If you aggregate these events later into a dataset of "events by hour", they may be grouped wrong (from a user's perspective) if you convert them all to the user's _current_ timezone.
Show HN: ScrapeWebApp – The Simple Web Scraping API for heavy scraping jobs
This is my story. Last year, I built a chatbot builder and ran it for a year. We needed to scrape many websites to train each AI on various websites.

My experience was:

- I started with my own Python scraper using requests, Selenium, and Beautiful Soup. It was okay at first, but then there were too many edge cases, and it wasn't scalable...
- So I checked many third-party API tools for scraping. Well, many fell short. I used one for 1 month, then moved to another one and settled with it.
- While it was good, it was still hard to set up, choose the proxy, handle retries, manage scheduling, and concurrent requests. So that's where I want to help.

Features:
Retries
Logins
Scheduling
AI prompt

Use Cases:
Price Tracking
LLM Training
Lead Generation
Competitor Monitoring
News Collection
SEO Tracking

That's why I built [scrapewebapp.com](http://scrapewebapp.com) to handle retries, logins, background jobs, and scheduling. ScrapeWebApp API handles the complex parts of web scraping, so you can focus on building your product.

Please give it a try and I would love to know your feedback.

If you are a serious power user, I am happy to give generous credits for a 10-minute call about your use case.
Enterprise PBR Shading Model
SOTA AI companies are modern airlines. They're selling a capital intensive commodity that has little meaningful differentiation once you pass a certain threshold. Customers just want the lowest price available.
This is nothing to do with async Rust; monoio (and possibly other io-uring libraries) are just exposing a flawed API. My ringbahn library written in 2019 correctly handled this case by having a dropped accept future register a cancellation callback to be executed when the accept completes.

https://github.com/ringbahn/ringbahn
I figured I'd check the RSS feed to see the timestamp there, only to discover that this "blog" doesn't even have a feed!
Poor integration, mostly.

It’s fairly easy to get into an irrecoverably broken state using an intermediate-level Git operation such as an interactive rebase (as of a couple of years ago). (It’s probably recoverable by reaching into the guts of the repo, but given you can’t do the rebase either way I’m still taking off a point.) The distinguished remote URLs thing is pointlessly awkward—I’ve never gotten pushing to places where those remotes are inaccessible to work properly when the pushed commit updates the submodule reference. (I believe it’s possible, but given the amount of effort I’ve put into unsuccessfully figuring that out, I’m comfortable taking off a point here as well.)

I like git submodules, I think they’re fundamentally the right way to do things. But despite their age they aren’t in what I’d call a properly working state, even compared to Git’s usual amount of sharp edges.