skysight-inc/HackerNews huggingface dataset:
> I think this new syntax is more imperative (you tell the DB "how" to get you the data). The old syntax is more declarative (you tell the DB "what" you need).

I think this syntax could accidentally give the impression that this is what's happening, but it's still an abstraction thanks to the optimizer. The "how" a pipe syntax describes roughly aligns with how a human would naturally want to construct a machinated process to sort through a file cabinet. Which may have been why it's been such a big hit for Unix and functional programming, despite poorly mapping to the machine model before the optimizations of modern OSes and functional compilers came along.

Any choice whatsoever might give a false impression of the machine model. Maybe SQL is doing the right thing by essentially having its syntax elements in random order, thwarting any attempts by developers to relate what they are typing to what is actually happening, but I think the authors of this paper are right in their desire to make it more ergonomic.
Show HN: Todoist Emailer – Send your tasks to your email on a schedule
Hey HN,

I'm excited to share a tool I built that has been a game-changer for my productivity: Todoist Emailer.

What It Does:
Scheduled Emails: Receive an email with a list of tasks whenever you run the script.
Customizable Themes: Choose between dark mode and light mode for your email templates to fit your preferences.
Task Grouping: Automatically group tasks by project or list them all together, depending on how you like to organize your day.
Email Configuration: Set up custom subjects, preview text, and other email settings to tailor the experience to your liking.

Why I Built It:
I needed a way to keep my daily tasks front and center without constantly checking Todoist throughout the day. This script sends me a morning email to kickstart my day and an evening email to help me plan for tomorrow and/or the week(s) ahead. It’s lightweight, easy to set up, and customizable to fit different workflows.

Let me know what you think!
... so dplyr.
100% agree. CORS is very clunky
It's a shame that this new API still doesn't support querying leap-second information within web-based JS, in any shape or form. The only solutions are either to store a big list yourself and keep it updated, or download it from someone else's website and trust them to keep it updated and keep their CORS settings permissive. Meanwhile, most OSes are fully aware of leap seconds (or at least, browsers could easily include an updated list), but there's just no way to retrieve them from the inside.
> "... number of milliseconds since the EPOX given this CET instant"

What? UNIX epoch? Central European Summer Time?
Knowing the specific multiplies and QKV and how attention works doesn't develop your intuition for how LLMs work. Knowing that the effective output is a list of tokens with associated probabilites is of marginal use. Knowing about rotary position embeddings, temperature, batching, beam search, different techniques for preventing repetition and so on doesn't really develop intuition about behavior, but rather improve the worst cases - babbling repeating nonsense in the absolute worst - but you wouldn't know that at all from first principles without playing with the things.

The truth is that the inference implementation is more like a VM, and the interesting thing is the model, the set of learned weights. It's like a program being executed one token at a time. How that program behaves is the interesting thing. How it degrades. What circumstances it behaves really well in, and its failure modes. That's the thing where you want to be able to switch and swap a dozen models around and get a feel for things, have forking conversations, etc. It's what LM Studio is decent at.
You're highlighting an important edge case here: The TZ database only splits regions reactively, not proactively.

But an actual lat/long pair is often neither available, nor desirable to be stored for various reasons.

Now that you mention it, I think I've seen some web applications that had a list of cities much longer than what's present in the TZ database for calendar scheduling purposes, probably to accomodate for just that future edge case.
I'm speaking from 1997-1999. TUI was still the way to install Slack/RH. X11 manual conf editing was still the way to configure X.

HW support was still garbage.
What is the modern equivalent of Google Groups?
hey everyone, been thinking a lot about where all the good convos are happening these days. like, im pretty young and grew up on reddit/twitter for programming stuff, but now im tryna do more serious work and cant find the right spots for it??

watched that node documentary recently (https://www.youtube.com/watch?v=LB8KwiiUGy0) and was surprised to see familiar faces like @Rauch on early node google groups. now twitter is just ai and teens and getting annoying.

saw this article about mailing lists (https://lwn.net/Articles/827233/) and got me thinking. seems like all the good ideas are stuck in these walled gardens now - mastodon, twitter, github discussions, farcaster channels, etc. not only is it politically siloed, but places like discord/slack are just totally underindexed.

what happened to google groups? do ppl miss it? are there any real open alternatives? whos working on this stuff?

where's the serious, nuanced work happening in 2024 and beyond? explain whats going on to someone to young to be born into what seemed like a more vibrant era of google groups and usenet.

google groups seems to have turned into some admin tool for GCP rather than a place for real discussions. anyone else feeling this or am i just being nostalgic for something i never even experienced lol

thoughts? experiences? where do you all go for the good stuff these days?
Ask HN: How do you manage/version helmcharts?
I run a small 3 node cluster out of my office at home for Kubernetes to selfhost a myriad of things behind SSO on a private subnet.

I actually do like Kubernetes and found it easier to manage than Docker swarm, but I've never learned helmcharts.

I added a couple, but it seems magical. What's the best way to version control all the helmcharts I have?
The same goes for secure and bug free software development (while the cost of errors in software rise all the time)

Looking at transportation, noise and air pollution or medicine as other examples: We are still just really bad at most things, if you consider how little fantasy is required to find major fault in our important systems.

Space flight is not even that, just really exposed.
Caesar III is an intriguing medium between simulating every citizen (like Tropico) vs large scale statistics (Like SimCity).

It does mean that Caesar is very sharp. A slight imperfection inf your design will cause the market-lady to be slightly off timing, leading to cascading failures as houses at the end of her run runs out of furniture or the 2nd food source of something

Or a a priest takes a wrong turn and collapses the entire economy of a neighborhood.

Cleopatra (the sequel of Caesar III) added roadblocks to make this more consistent. But the overall sharpness is there and part of the gameplay.

It's not a bad thing for sharp situations to occur in games btw. It does add to the stress of management, but you need some stress to make a management game.
If you want to display a time you have in UTC in the user's local timezone, what other choice do you have (unless there's a way you can ask them for their timezone, but I always find that incredibly annoying when traveling)?
I'm not interested in loading all the data in memory, or swapping it out if it doesn't fit, but also it may be a lot of data, and just moving it over the network is hard.

I have tests. I have reusable blocks (SQL functions, WITH blocks and views). I don't have logging though.

I can put the result in a non-materialized view and have it update in real time as the data changes. Or I can toggle it to materialized view and now it's snapshotted data.

Finally, views that depend on views that depend on views get automatically optimized by the query planner. You need a lot of very tricky custom code to start approaching that.
Which Kelly Biography - I read "Skunkworks". Is there something else worth reading?
Those books aren't in the "self help" section, they're over in "mutual aid"?

Lagniappe: https://images.cartoonstock.com/lowres/literature-epidemiolo...
Often referred to as Rods from God, but Syndicate Wars had the better name: Satellite Rain.
My trouble with this definition of never ever is that it prevents us from starting on endeavors that may take a long time--a self fulfilling prophecy.

We may never ever mitigate our climate concerns, which obfuscates that it is a choice we'll have made, not an inevitability.
Mad Max: Fury Road. Great with a surround system, especially the sandstorm section.

1917. Great cinematography

Tenet. Makes much more sense than the first time. Better on surrounds

The Hateful Eight. The small cast feels very much like Margin Call. Great storytelling

Prey. Very good

World War Z. Pure action.
That's a great article. Most of the problems mentioned don't apply to landlord price-fixing. That's an issue jurors can understand. There's a large class of identifiable victims. The collusion is easy to show.
Noting that the first line of the article links back to <https://news.ycombinator.com/item?id=41328133>
Thank you Elon Musk
> RFC 9557 Date and Time on the Internet:

> Timestamps with Additional Information

Oh, cool, we're finally adopting TAI!
It's always going to be slower than a hardware encoder.

I have an AMD Ryzen 7 7840U laptop which has hardware AV1 encoding. If I use preset 8 with SVT-AV1 on a 1080p encode I get 30 frames per second:

ffmpeg.exe -i "input.mp4" -c:v libsvtav1 -pix_fmt yuv420p10le -crf 40 -preset 8 -g 240 -svtav1-params tune=0 -c:a libopus -b:a 128k av1.mp4

With preset 12 I get 143 fps. With preset 10 I get 84 fps.

If I use the hardware encoder I get anywhere from 15 fps to 589 fps depending on the settings I use. I get 103 fps with this:

ffmpeg.exe -i "input.mp4" -c:v av1_amf -pix_fmt yuv420p -quality high_quality -preencode true -b:v 4M -c:a libopus -b:a 128k av1.mp4

Hardware encoder parameters: https://github.com/GPUOpen-LibrariesAndSDKs/AMF/wiki/AMF%20E...
Every time I need to fiddle with CORS is CSP, I have to read the MDN pages for them, could never get them to stick intuitively. This is a nice article but more info on CORS would be nice.
This post doesn’t mention the other reasons the same origin policy was necessary: intranets.

If your company hosts content on https://company-news.corp.internal/ it’s very important that some random malicious site on the internet can’t use fetch() or XMLHttpRequest to read that page and exfiltrate that information, just from one of your employees being tricked into visiting that site.

So it’s about more than just cookies.
The term "blocking" has diverged between various communities and it is important to recognize those differences or you'll have dozens of people talking past each other for hundreds of messages as they all say "blocking" and think they mean the same thing, and then get very confused and angry at all the other people who are so obviously wrong (and in their context, they are) but just can't see it.

It is obvious that a given "execution context", which is my generalized term for a thread and an async job and anything else of a similar nature, when it reaches for a value from an mmap'd file will be blocked until it is available. However, different communities have different ideas of an "execution context".

Threaded language users tend to see them as threads, so while a given thread may be blocked the rest of the program can generally proceed. (Although historically the full story around file operations and what other threads can proceed past has been quite complicated.)

Async users on the other hand are surprised here because the operation is blocking their entire executor, even though in principle it ought to be able to proceed with some other context. Because it's invisible to the executor, it isn't able to context-switch.

In this case, the threaded world view is reasonably "obvious" but it can be non-obvious that a given async environment may not be able to task switch and it may freeze an entire executor, and since "one executor" is still a fairly common scenario, the entire OS process.

(I am expressing no opinion about whether it must block an executor. System calls come with a lot of flags nowadays and for all I know there's some way an async executor could "catch" a mapped access and have an opportunity to switch. I am taking the original article's implicit claim that there isn't one happening in their particular environment at face value.)

As long as you do not distinguish how various communities use the term "blocking", you will get very, very deeply nested threads full of arguments about something that, if you just are careful with your terminology, isn't complicated for anyone from any subculture to understand.
> It does not matter - all the ports are closed.

Yeah and I have a lock on my door. I still won't post my address on HN. It's all about defense in depth.

Another thing I forgot to mention is that port knocking only works if your hypothetical friend has a dedicated static IP. If your ISP decides to reassign your IP address then IP allowlists are useless. Many ISPs in the US run this racket where they make you pay for a "business account" to get a dedicated IP, even if you only want an IP6 address (which are plentiful).
True, but it’s generally a lot easier to patch software than expect someone to update their whole OS.

(Generally. I know plenty of shops deployed Exchange in 2009 and it still works so why fix it, goshdarnit! Those people aren’t generally updating their OS either though.)
I didn't get this article. This first part explains common CSRF vulnerabilities, and then even explains the SameSite attribute, but it neglected to point out that SameSite=Lax is now the default on browsers, and has been for some time, specifically to mitigate the problems outlined in this article and to get rid of the need for CSRF tokens.
Tell HN: Replit Starter Plan Changes – Announced Friday Night, Effective Monday
Repl.it's announcement of significant changes to its Starter Plan on a Friday evening, effective the following Monday, left many of its users, particularly teachers and students, scrambling. The late-evening email provided educators with virtually no time to adjust lesson plans or inform students and parents before the changes took effect. Considering the platform's extensive use in educational settings, this move appears highly inconsiderate and poorly timed, and it feels particularly unethical. The timing of the announcement, immediately before a new week, suggests a deliberate attempt to limit user feedback and expedite the implementation of unpopular changes.

Email:
From: Replit <contact@mail.replit.com>
Date: Fri, Aug 23, 2024 at 9:47 PM
Subject: Replit Starter Plan Changes

Hello,

We’re reaching out to tell you about changes to your Starter plan.

What is changing?

Number of Repls: The Starter plan is now limited to 3 Repls. Upgrade to Core for unlimited* Repls.
Collaboration limits: 1 collaborator per Starter account, 3 for Core, and your entire org for Teams.
Storage retention: Repls will be subject to deletion after 1 year of inactivity on the Starter plan.
Deployments:
Starter plan users can Deploy a single static site without a credit card on file (1 GiB outbound data transfer limit). This change will roll out in the next few weeks.
Autoscale, Reserved VM, and Scheduled Deployments now need to be tied to a Core account. If you have active Deployments of these types, you’ll receive a separate email with more details.
Development
Development time: The Starter plan is limited to 600 development minutes per month. Upgrade to Core for no development time limits.
Development outbound data transfer: changing Starter plan limit to 1 GiB.
Development storage: changing the Starter plan limit to 2 GiBs.

Unless mentioned above, these changes will fully take effect on August 26th.

We understand that this may impact how you use Replit. We've carefully considered these adjustments to ensure we can continue providing a sustainable platform for all our users.

For a full overview of the changes, see replit.com/pricing. If you have any questions about the changes, please reach out to support@replit.com

The Replit Team
Ask HN: Consulting Gig Optimization Problem
I have been faced several times in my consulting business with choosing between consulting work that comes at unpredictable moments, but when the work shows up, it pays very well and much better than the average engineering contracting work and it is always full remote. This type of work cannot be easily outsourced.

On the other hand, there are the more regular engineering contracting gigs you can get, but which pay much less and might require on-site. Taking the lower paid work might make it impossible to take the better paid work. However, if the work is remote, it can be outsourced.

One possible approach is to wait longer until you have the lucrative work to avoid being booked for the cheaper work. At some point you run out of money. I've been following this approach but the long periods without incoming cash-flow can be stressful. I try to work on marketing while I "sit on the bench".

The other approach is to always take the cheaper work if you don't have a lot of runway left. However, then you can't take the more lucrative work. And you can't build up a cushion and when the cheaper work disappears now you have no cushion and are screwed. And you work a lot of hours which means you can't really spend time marketing your business.

Another solution is to take the cheaper work and outsource it (assuming it is fully remote). But if your subcontractor screws up you have to helicopter in and fix the situation. This might be impossible because you are overstretched or busy with the more lucrative work. Your client might sue you if things really go bad.

Is there some kind of optimal solution to this optimization problem? I cannot imagine I am the first consulting business to have to make decisions whether to take work or wait until more lucrative work shows up. There must be some kind of scientifically informed optimal policy to follow.
SELECCIONA * DE CLIENTES CUANDO TELÉFONO SEA NULO
it opens up in text on my firefox, and the mimetype is plaintext so that's surprising to hear
I believe you are saying that knowing (or believing) the probability of a group of papers being fraudulent does not help you (ex: in a high fraud belief of say 45%) make a better decision because the group probability does not inform any single paper probability meaningfully since a paper's findings are close to being all or none. Is that correct?

If so, I see your point.

I still think in a more diverse set of scenarios where an intervention has more than a single and binary outcome, knowing the group probability can still be informative. For example if an intervention in a possibly fraudulent study shows a large upside but other known to be unfraudulent studies show a severe but unlikely downside then it may not be a good idea to do the intervention unless there is a good reason to (ex: all known safer interventions have been tried, known risk can be mitigated, end of life and patient agrees, …).

But I am beginning to wonder how useful of a signal a known fraud percent would be given how long it takes for fraud to be discovered and then disclosed.

I still think something can be done here with public statistics and perhaps reputation but I’ll have to think about it some more. Certainly if an author or institution were more at risk for discovered fraud or fraud discovery was more likely they would do a better job of policing or not doing it. Other incentives (as mentioned in the article) are at play as well.
I wonder if there are books or articles that analyze how and why Boeing declined so fast and so spectacularly. Boeing used to be able to build 747 under budget and ahead of schedule, just like Lockheed could dazzle the world by creating U2 ahead of schedule and under budget with fewer than 200 people (or < 100?) in 15 months with the cost of a few millions. It can't be just the change of geopolitics post Cold War, right? It can't be just that the fixed-margin structure imposed by the government, right? It can't be just the mismanagement or the greed of the leadership, right? It can't just be that Boeing is in the phase of accelerated decline as any old-enough company, right?

I'm curious about such questions because on a larger scheme of the things, I really hope that Boeing is not a miniature reflection of the US - an empire in its twilight that got entangled in irreconcilable interests, doomed to watch its own inevitable decline.
IMO the shuttle program did a decent job of preserving American human-spaceflight know-how, especially when measured against what it was feasible to accomplish at the time.

The true problem is that the US government stopped funding space in a serious way and so NASA did not continue pushing the envelope at the rate they did before. We've had some pretty great robotic missions in that time though.
> personally, my purchase decisions do not include the personality or celebrity of the company (CEO or otherwise).

This is a normal hacker news commenter position, but not a normal consumer position.

One of the first things you learn in a freshman year marketing course is the fact that consumers in general make spending decisions on feeling, not on raw data. It's the reason commercials you see on television are all about vibes, and not remotely about the raw performance numbers. See also: Apple never wastes its time droning on about the specs of their devices in their commercials.

This is why the public persona of Tesla's CEO has a material impact on the company's sales, and why it's hurting the company. I'd argue that Musk has outright disdain for his customers and considers them 'woke,' and is enthusiastically running the company into the ground out of pure spite.
But their license probably doesn't cover that...
One of my favorite explanations of CORS is this one, which includes an interactive playground: https://jakearchibald.com/2021/cors/
It was also initially designed to be able to have nuclear thermal propulsion engines installed in later iterations, but that got scrapped.
> I wonder if there are books or articles that analyze how and why Boeing declined so fast and so spectacularly.

I'm sure there's a number of books on the topic in the publishing pipeline.

> It can't be just the mismanagement or the greed of the leadership, right?

It can.
I am well aware of INI files being used by applications on several operating systems. DotNet Core may not be the most popular platform but it’s blurred the lines here.

DOS has similarly been stripped from Windows but 3rd party DOS shells exist on many platforms. Honestly knowing Bash is more Windows specific at this point than DOS. https://learn.microsoft.com/en-us/windows/wsl/install

So again, none of your examples are Windows specific at this point.
Wait what

The main premise of this post is false.

The mentioned request can’t succeed without first completing a preflight check.
You could implement a family of poorly defined dialects using SQLGlot, sure, in the same way you could define a meta-language targeted at Algol-family languages. That's not a substitute for adding language features.
That afternoon headache is a sign of stale air
One benefit could be if the site only supports something like username/password with SMS/email 2FA compared to a sign in option using Google/Microsoft/etc that you can use a security key/passkey with.
Correct. They renamed FrostDB, here is the announcement -

https://www.polarsignals.com/blog/posts/2022/06/16/arcticdb-...