skysight-inc/HackerNews huggingface dataset:
>LookML does seem to have invested a lot in compilation to different SQL backends, generally using the best syntax for each.

To some degree, yes. Yet far and away, users of Looker use engines like RedShift, BigQuery, and Snowflake because they’re extremely effective at the types of queries that Looker sends at them — not because Looker spends a huge number of hours optimizing for each engine (that’s not to say none is done); these dbs are great at analytical queries.

Looker in its earlier days (early/mid 2010s) took a bet on analytical database engines getting better as opposed to other technologies; for example, Tableau had its own datastore and largely did not “push queries down to the database” for execution. In the end, BigQuery was radically faster than SparkSQL and was compelling for customers, for example; it was not that Looker spent a ton of time optimizing BigQuery as opposed to SparkSQL.

Source: I was an early engineer at Looker
> Two weeks into President Trump’s sweeping freeze on foreign aid, H.I.V. groups abroad have not received any funding, jeopardizing the health of more than 20 million people, including 500,000 children. Subsequent waivers from the State Department have clarified that the work can continue, but the funds and legal paperwork to do so are still missing.

> In children who acquired H.I.V. at birth, the infection can progress very quickly to illness, with death occurring as early as eight to 12 weeks after birth — shorter than the 90-day pause on foreign aid.

So much pain and death will be caused by Trump, Musk, Rubio and their enablers in Congress and at large.

This is unconscionable and evil. Don't ever believe them when they claim to be "pro-life".
Completely unrelated to this blog post but I really dislike Fintech saying "Get paid early" in their promos.

It's clearly marketing at someone too stupid to be able to see right through how utterly useless that is. If you are celebrating getting your paycheck 1 day earlier (every time) then your financial literally and financial health are probably in the toilet. They _must_ know they are preying on people with statements like that.

Then again, 90% of Fintech seems to be just a heavy layer of lipstick over an archaic system. Often with very little care of if any of the tools actually help people and more of a focus on how flashy or how much people think they are being helped.
Correlation does not imply causation (but it does stare at it from across the room and suggestively waggle its eyebrows)
How much of and what parts of the executive branch would turn over, and to what period are you referring?
Although I don't use it frequently, I love that LibreOffice exits. I was wondering if there are any online resources that summarizes some of the cool tricks and features of LibreOffice for an occasional user like me?
So what should Canada do? Spend 100% of their GDP preparing for an American invasion that they'd probably still lose?
Exactly.

The US has unrivaled force projection capabilities; half the worlds carrier fleets, the largest navy by tonnage, and the technology to execute unprecedented combined arms maneuvers.

China has insane defense-in-depth; more missiles than you can shake a stick at, the largest navy by number of ships, a vast arsenal of countermeasures, and a 4:1 population advantage.

China can't stand toe-to-toe with the US anywhere except the immediate vicinity of China. In that vicinity, nobody can get close if China doesn't want them to.
Whether one should bias to allow more false positives or false negatives depends on the next steps after a false positive vs the risks after a false negative.

False positive: more costly scans

False negative: untreatable terminal illness
> Software development is a social activity, especially with relatively high-visibility projects like Asahi, and it comes with just as usual burden of social troubles as any other kind of social activity.

Yes.

> The only way to do that is to never collaborate with anyone else.

Not necessarily. You can also treat project politics and social skills like any other technical skills that you need on your team like network engineering or database optimization.

If you can find trusted collaborators with those social and political skills, you can make a lot of things happen without necessarily being very good at it yourself.

Team building has a lot of parallels with building a full stack technology. Or building a sports team.
Show HN: Spaces.market – a trustless and no-fee marketplace for Spaces
Scott Alexander posted about this: https://www.astralcodexten.com/p/money-saved-by-canceling-pr...
Thank you! I’ve updated the content from "wheel" to "valve handle".

Please feel free to contribute—there’s still so much to uncover!
I can easily think of 50 more references, and I’ll be adding them gradually over time.

This project is an invitation to dig deep into the meaning behind each reference—to explore their significance and understand how they fit into the historical context of Unix’s early days. I tried to capture that in the README (https://github.com/drio/unixmagic):

"When contributing, remember that this is an opportunity to dig deep into the history behind what you’re describing. Feel free to share what this particular component means to you personally, but also aim to frame the explanation within the context of Unix’s early days. How did this functionality compare to other operating systems at the time? What made it special or innovative? This project is not just about explaining what things are, but understanding why they mattered—both technically and culturally—in the evolution of Unix."

I’d love to see a PR from you—I bet your take on one of these references would be fascinating.
It’s insane to me how all these companies have profit numbers up and to the right for half a decade under hybrid policies, but then are like “you know what will make us do even better? Pissing off the whole work force all at once for no good reason.”

It’s just comically stupid.
I don't entirely agree. Internet was a tsunami. Mobile was a tsunami. Both seemed impactful at first, but we didn't know exactly how right away. We all figured it out and adopted, some better than others.

Schools are way ahead of us. Your kids are already using AI in their academic environments. I'd only be worried if they're not.
Homo sapiens did this
As an academic researcher, it's most frustrating in that it feels like IRB scrutiny doesn't seem to align with risk.

I do accounting research. My human-subjects research involves surveying practitioners about their jobs, interviewing them about their experiences, and conducting very simple experiments online that ask them to make decisions. There is virtually 0 real risk to any participants of my studies. IRB does always give my studies "exempt" status, but it still has to be reviewed. And they will pester me about different things like where will store our data (Onedrive is fine, but dropbox is not for some reason). This process will typically take a couple weeks of back and forth.

Yet I have a friend who participated in a Kinesiology dissertation study where they were asked to do extremely strenuous physical activity. He fainted(!) at one point from the activity. And it seemed to them that there were relatively few safeguards from that happening. Now, I'm sure that study did have IRB approval, but it really got me thinking... are we really scrutinizing studies optimally?
Shoot I was going long on the Nancy Pelosi ETF.
I'd agree with this. I tried Phind just now and found it still behind Perplexity for the product search use cases I tried it out for. Glad there's competition in the space though.
Garry used to run/host the Facepunch forums which strongly remind me of better times on the web. They were good times.
Asahi Lina is almost certainly marcan's vtuber persona. This has been discussed for quite a long time on HN, reddit, etc, especially after he started interacting with his own sockpuppet on GitHub.

Dug up my old comment on the issue here: https://news.ycombinator.com/item?id=36972907

> The project itself is popular, but HN allows people to talk about the fairly compelling circumstantial evidence that Asahi Lina is marcan's alter ego. Per previous discussion, they have /home/marcan and /home/lina on the same box [0], have the same hostname [1], and have similar accents and speaking patterns [2]. Marcan is free to do this, but it's completely bizarre behavior acted out in public which is now impacting the actual Asahi project. Doing v-tubing under a pseudonym is one thing, but maintaining a sockpuppet contributor on a major open source project and pretending to interact with it is a giant red flag.

[0] - https://news.ycombinator.com/item?id=35242010

[1] - https://news.ycombinator.com/item?id=35238601

[2] - https://news.ycombinator.com/item?id=35238601
You can't trust third party compute.
> And you might wish to consider whether there are any implications to your argument given that you and the billionaire CEO agree

Why? Are we now saying anything a billionaire (gasp!) says is automatically wrong or nefarious? Come on people, I expect better from the HN crowd.
Yes, multi-device is definitely not easy. We've played with a few ideas, but it is definitely not a question with an obvious answer. For now, our rate-limiting allows you to use Privacy Pass on a few different devices by having each generate tokens independently. We will see how this goes and listen to user feedback before going back to the drawing board.
I said I thought you would feel a certain way in that situation. Do you disagree?
TANSTAAFL [1]

One of my collaborators would say we got seduced by the idea that it wasn't about the money. That is, it was cheap enough that we could go for a while without thinking how to pay for it, then the advertising model looked like an answer.

Early on one would make the comparison to advertising on TV, radio, magazines and such. Little did we know that personalized advertising would lead to something much worse. I mean, Proctor and Gamble, who gave us the soap opera, has been around since 1837. Do any of the big YouTube advertisers like all the fake food companies or the scam supplement subscription companies or Established Titles expect to be around in 2 years?

If people had been thinking about how to pay for it from day one we'd be in a different place.

[1] https://en.wikipedia.org/wiki/No_such_thing_as_a_free_lunch
Please remember this next time there's an election.
that AMT struggle is real, painful, and needs legislative changes when it comes to ISO exercise in private companies. especially when you have to set up a payment plan for the taxes owed, which are ever increasing due to fines and penalties, while the owed credit is ever losing value due to inflation and the lost opportunity to put that money to work. and on the state tax side you should plan on not moving and losing a job in that state as if you dont have any taxable income there you are shit out of luck on getting your money back. my only advice is that if you are offered a large chunk of options without an 83b and have faith in the company, exercise as soon as possible before the value goes up.
There's also an underlying validity to the "property is theft" argument. They both have a correct underlying principle. And both are wrong in the totality.

> a deficit

A deficit in little pieces of paper they print themselves, and most of that debt is to themselves.
Title could be: Becoming Partner of Open-Source Initiative Key to Online Safety Approach
How a computer that 'drunk dials' videos is exposing YouTube's secrets
Unbundling the BPO: How AI Will Disrupt Outsourced Work
who should share the data Tesla is collecting? Tesla? or should some one steal their data and share it?
My acquaintance who moved to the US a few years before I did (both from Canada) said it this way: if you have a good job / are wealthy, US healthcare is miles ahead of Canada. If you are poor, it is much, much worse.
So funny that blocking Pinterest comes up in all discussions on Kagi (I've mentioned it myself in the past). I almost think people might pay $1 a month just to block Pinterest.
Ironically, I couldn't access this page while using Tor. Reading it from another device though, it seems like a great announcement, I love the idea.

I also would be interested in a service like this for attestation on other sites. Device attestation has chilling privacy implications, but if you could have a paid service with a presumably trusted entity like Kagi attest that you are a legitimate user (but hide your identity), maybe more of the Internet could be browsed anonymously, while still minimizing spam.

I get why many sites currently block Tor and VPN users, or even users in incognito or without a phone number, as the Internet is essentially unusable without anti-spam measures. That said, I do think anonymity has its place (especially for browsing, even if commenting weren't allowed), and maybe ideas like this could allow for anonymity without the Internet being riddled with spam.
NYT reported this is on hold.

https://www.nytimes.com/2025/02/13/us/politics/state-dept-ar...
We have a products UI on the way :)
This and so much more.
Who else can share the data Tesla is collecting??
You have to generate the tokens while signed in, but once you have the tokens, you can use them without your searches being associated with your account (cryptographically provable).
This is very cool. I'm curious about why there is a limit on the number of tokens generated per month, when this is only currently offered to unlimited accounts. Since the tokens all expire at the end of the month, tokens can't be horded to use Kagi after a subscription ends. Perhaps it is instead a resource issue where token generation is expensive. In that case though, I would think limiting tokens/day would be more appropriate - there is already going to be a spike to generate new tokens on the first of the month, so if the server can handle that they can handle some users generating a batch of tokens each day.

This is not intended as criticism, just inquisitive.
Interop 2025
Maybe, but if you compare paying 30-50k per year plus living expenses for an average masters program for 2-3 years and then paying student loans for a really long time because you couldn't afford it in the first place vs paying no tuition and getting a $30k-40k stipend for 4-5 years. The advantage of a year or two of additional work isn't as great as you think, when you subtract out tuition and the stipend they give you during the PhD and compare the pay differential and job prospects when you finish.
The irony is he died of prostate cancer. He ignored his own advice and treated it. It did not change the outcome or buy him much time, if any.
It's really common now for phishing kits to use interstitial pages that require solving a captcha before the actual phishing content is shown

Victims just click through the captcha without thinking, but it makes automatic verdicting by security scanners a pain because they just see a captcha page: can't tell the brand being impersonated, or even if it's a phishing site

I wrote a post about a number of these which actually pretend to be Cloudflare! https://phish.report/blog/fake-cloudflare-interstitials
I think I've said this before, but 'free' seems to attract the worst of humanity.

When I want to give something away, I list it for some nominal fee like $10, then just tell them to keep it. Because when I used to list things for free, I got the dredges of society bothering me. Asking for delivery, asking me to hold it for 3 months til they can find a truck, cussing at me for saying no to both of these, cussing me because I sold it to someone else already, telling me long sob stories to guilt me. I've never had any of that happen when asking for money(except one guy wanted me to deliver it for $20, which was a fair-ish offer).

I wonder if that same 'pay but you'll get it back under the table' model could work for software? At least until the word got out, I guess.
> There is nothing partisan about resistance to Trump.

Trying to characterize undifferentiated resistance to the leader of a party as non-partisan seems like a stretch.

> Resisting illegal acts causing damage yo the nation is not in any way partisan.

There are so many laws that basically everything is now illegal. If you want "illegal" to mean something you'd first need a legal system in which a non-zero number of people exist who follow the laws.

Choosing which laws to care about in a partisan way is partisan.

> Pretending Trump cares about waste isn't just silly its ridiculous and should be dismissed out of hand.

This is your non-partisan argument?
A problem with "zero knowledge" proofs is that Kagi needs to verify that the user has paid for the service, which requires the server to have some knowledge about the client at some point.
I’m not insinuating for even a second that Kagi actually do this, but as a general rule, isn’t any privacy claim dubious at the moment given that more and more governments appear to be able to compel companies to identify their users (especially those searching for illegal content) and further forcefully insist they not disclose it?

It’s disheartening to think the great progress we’re making in this sector could be undermined in a few seconds against any companies efforts with a trivial backdoor.
> averages less than $100k per person

tsk tsk tsk, using averages in tech forum...

100k for a good developer is US is kinda low, but IMO too damn high for most bureaucrats. On flip side you wanna keep salaries high so they aren't too tempted by fraud.
I considered a PhD in machine learning. It’s mostly downsides. Granted, most fields are not like this but:

1) The field moves too fast to focus on a single thing for 4 years. A lot of people were devastated when ChatGPT essentially solved their NLP tasks.

2) Cutting edge NLP/vision research is being done in industrial labs as much as universities. And industry will probably outgun you with equipment (GPUs) and high quality data.

3) Pay sucks. You can make 3-5x working in industry. The opportunity cost could be a half million dollars.

4) You can get a lot out of a Masters in half the time or less.
At this point you just order the same antibiotics off of Amazon for your "fish" and self administer?
Send, via registered letter, a request for the following:

- the name, license #, and board-specialty of the physician making this determination
- copies of all materials used to make this determination
- proof the doctor making this determination has maintained registration in your specific state and documents proving they meet all their continuing education requirements
- the aggregate rate at which this specific condition is denied or approved by this specific doctor making your determination

Registered letter to CVS Caremark legal department. What they’re doing its blatantly illegal. You are entitled by law to this information and if they cannot provide it they must approve your treatment.

(YMMV, I haven’t had the opportunity to try this, though it comes highly recommended from a physician’s assistant who deals with this bullshit endlessly)
I wouldn't say i stopped developing it- there are always features that could be added, but it serves the purpose it's meant to! You can directly interact with an LLM and it can work just like any other chat, but can also perform its own debugging / investigations
> Later acquired by Sun if I remember correctly, then open sourced.

Sun named it OpenOffice. LibreOffice was forked from OpenOffice after Oracle acquired Sun. OpenOffice was subsequently donated to the Apache foundation.
>Think of a song you know best, one you've listened to hundreds of times: can you sing it or hear it in your head pretty accurately? If so, congrats, you have the capacity for perfect pitch

No, this is relative pitch. You might be singing it in the wrong key. That's why you can sing something a capella and it sounds right and then you add an instrument playing the correct notes and it doesn't.
If you move from Germany to Brazil you might also hit edge cases.

Yes that is 2 different countries. But it is similar. States have their own laws.

You can't expect the law across 3 jurisdictions to work out every permutation and legislate for it. There are 52 (I guess more... lots of territories) * 51 permutations of moves so 2652 moves that are possible.

In addition you are talking RSUs and not some vanilla thing like claiming an expense.
The right way to think about Medicare and Medicaid is on a bathtub shaped graph, where everyone who is young is covered, everyone old is covered, and everyone poor is covered.

It's just "above income threshold between ages of 18 to 65" that isn't covered.

We just need to get the social/political will to fill the bathtub.
Agreed. My parents in Canada both had cancer treatments without delay, they both recovered, etc. With $0 out of pocket. I'd at minimum have to pay the Kaiser max co-pay here for a similar problem.
Automatically Upload Zoom Recordings to Google Drive, YouTube, & Vimeo
There are only two elected officials in the entire Executive Branch.
Show HN: Slipstream, bringing business process management to small businesses
Our landing page is here if you'd like more information: https://www.goslipstream.app/?utm_source=hn

I'd be happy to answer any questions on how we built it! I've had a blast using Phoenix Liveview, and I'll be coming out with a post soon about the code changes that we made to take advantage of Fly.io's suspend and spin-to-zero machines. Thank you!
To be fair, the app being posted is the server application which you can run locally. You do not need the phone application to use the web application.

The mobile app is also open source https://github.com/wger-project/flutter

I don't know how but I imagine you could build it and side load your own build to your phone?
You can't expect world percentages to match US percentages. The US is only 5% of the world's population and has a very different relationship to search. Also, only 63% of the world is online, so what does "90% of global" even mean?

Back-of-the-envelope:

- 2tn searches per year.

- US is 20% of all searches.

- Us revenue is 76bn

$76bn / (2tn * 0.2) = $0.19 / search

So, getting 300 searches for less than $0.02 per search sounds like a pretty good deal.
If this ever works/worked I would agree, but the linked paper is not at all convincing.
Makie has grown to become a very powerful tool and an important part of the Julia ecosystem. A few Makie features are especially worth highlighting:

1. Using the "observable" system, it's quite easy to put together simple GUIs with toggles, sliders, etc. This is really nice for interactive data visualization, real time physical simulations, etc.

2. One can (for the most part) smoothly switch between various backend options. GLMakie is the high-performance OpenGL backend. WGLMakie builds on WebGL and can be used in browser context, which is nice in Jupyter notebooks, or in HPC scenarios where the calculation is being performed on a remote cluster. CairoMakie allows for exporting publication-quality vector graphics.

3. A couple years ago there were severe issues with "time to first plot". I'm happy to say that this issue is now (almost completely) fixed! The initial Makie installation will take a couple minutes to precompile and cache object files. But after that, the time-to-first plot in a new Julia session only takes about 1 second.
I think the feature comparison against MS Office is a pretty good resource https://wiki.documentfoundation.org/Feature_Comparison:_Libr...
Always enjoyed the meme that it's a syntax error without wearing stripey leggings and/or cat ears.
Well, what did dey evah do fuh us???