skysight-inc/HackerNews huggingface dataset:
Relevant snippet:

> It is important to understand the interaction between aggregates and SQL's WHERE and HAVING clauses. The fundamental difference between WHERE and HAVING is this: WHERE selects input rows before groups and aggregates are computed (thus, it controls which rows go into the aggregate computation), whereas HAVING selects group rows after groups and aggregates are computed. Thus, the WHERE clause must not contain aggregate functions; it makes no sense to try to use an aggregate to determine which rows will be inputs to the aggregates. On the other hand, the HAVING clause always contains aggregate functions. (Strictly speaking, you are allowed to write a HAVING clause that doesn't use aggregates, but it's seldom useful. The same condition could be used more efficiently at the WHERE stage.)

Thank you for linking this, it's very concise and actually helpful.
I think docker can be made to work but it's a tech that is heavily based on Linux containerisation. I think it's currently broken, as per https://wiki.freebsd.org/Docker

FreeBSD has its own mechanism for that which is jails (and which predates docker!). If you're not using docker containers you pull from docker hub, I would recommend to use jails.
We can say "muy agradecido" or agradecida in formal context. It's unusual, but works as an example
> It seems to be a universal truth that computing people try to solve all problems with another level of indirection.

This isn’t about computing but about specialization. Should McDonalds be in the business of operating Data Centers? Or should they just buy it from those who do it best and focus on selling food?
Thanks! I have perused some of the configs and will definitely take a few snippets from zshrc. Also, kdiff3 looks quite interesting. I have been relying on vimdiff/colordiff.
I don't have an answer for you, but I do wish them (and you?) good luck with the endeavor :)
Have you checked out the Wikipedia current events page?
https://en.wikipedia.org/wiki/Portal:Current_events
Yup.

I've never purchased a gift card. I've received them (for participating in a COVID survey actually - but I'd have participated for nothing), and I gave them to people. If they'd given me cash, I'd probably have kept it.
Sebastian Markbåge to Join Vercel
I love the idea. It would be nice if events (Miss Universe, Tornado outbreak) would be put on a timeline, and there would be a separate section for ongoing things (Covid, russian troops).
You could find some irony in Microsoft not supporting software that fails to implement modern security but this really is Firefox’s problem, not Microsoft’s.
>Do the exchanges allow for the sale or transfer of a ticker symbol?

Oh, I really hope so. Tableau had "DATA" before they were bought by Salesforce
Why You Can't Name A File CON In Windows -- https://www.youtube.com/watch?v=bC6tngl0PTI
Make software products or services that people want to buy, and sell them.
It seems like you're saying that I should let the racoons out of my closet. I'll consider it, but then getting my clothes every morning will be a lot less exciting.
Ada was not made for the consumer space: it was made for situations where being provably solid was more important than any other consideration.
The ones who fight corruption are the ones who make a difference in the world.

THAT is cynical.
I always wondered to what extent aphantasia affects mundane tasks, like setting something down, turning out the lights and picking it back up in the dark. I always seem to use a mental image of the thing in the space where I left it.
Totally agree... but if I have to choose between him writing papers and spending more time perfecting APIs, there's no question. The man is one of the most brilliant interface designers ever to live.

Dplyr was already great in its first version, but Hadley and company have worked incredibly hard to make it much, much better. It's hard to think of another system that has improved so much from such an already high starting point.
What do you mean pixel level? I just want to see living conditions being similar. It’s quite an obvious request, for such bold claims made by you.
> Building up an IT infrastructure that can provide services at roughly the same quality and cost as AWS takes a large investment in talent and infrastructure

no, you missed an important point here.. no one, at any scale, has been able to compete directly with AWS on the combination of service, scale and cost per unit.. its intensely competitive
Why can't we tether the spaceship that carries the astronauts with a separate spaceship that carries the cargo (that will be only needed on mars) via a set of long, thin cables (to act as a counterweight) and spin the two around their joint center of mass? That solves the problem of needing a really large ship to make the rotation not uncomfortable, and allows for artificial gravity
Oh ok, I heard this in the IRC channel. Maybe it was just someone who was having issues. Someone mentioned about wayland and one of the maintainers was like "Yeah we know, it's broken, working on it". It was probably some specific. Sorry for the incorrect information.

I use KDE by the way, I know of sway but never used it.
Developing a SSD driver does not require unlocking the device, though.
It's not available in SELECT (barring some non-standard implementations). That's because SELECT is executed after FROM, WHERE, GROUP BY and HAVING. I've made it a habit to start composing my queries in the logical order first, and rearranging it in my editor afterwards.

I learned this (and most of my understanding of SQL) from https://blog.jooq.org/10-easy-steps-to-a-complete-understand... (point 2.), which was recommended by Hadley Wickham (of R tidyverse/dplyr fame).
Those are great points to consider, thank you
Show HN: I made a free course, 'NLP for Semantic Search'
Hi all,

I'm James, past data scientist, ML engineer, and now dev advocate at Pinecone.

I've been dedicating much of the past few months to building a course on what I've found to be one of the most fascinating emerging technologies in AI and ML, Semantic Search:

https://www.pinecone.io/learn/nlp

The course is completely free, it includes written and visual explanations, code implementations, and video walkthroughs. It focuses on the NLP side of semantic search and the first seven chapters cover:

1. Dense Vectors

2. Sentence Embeddings and Transformers

3. Training Sentence Transformers with Softmax Loss

4. Training Sentence Transformers with MNR Loss

5. Multilingual Sentence Transformers

6. Question Answering

7. Unsupervised Training for Sentence Transformers

There is more coming soon and I'll be around to answer any questions, let me know what you think.

Thanks all!
That's why I always search with a site:python.org filter.

I created special "search engines" on my browser, so I start typing ":p" and whatever I write next it automatically searches using the site:python.org filter.
I like algorand
Given the article says the customer explicitly called the restaurant to check their tipping policy in advance; and to ensure their favourite server would be waiting on them that evening, it seems pretty clear that's not the case.
Reasons to Hire Professional Movers in Calgary for a Safe Move
When relocating across countries, there are several incontrovertible facts that suggest that enlisting the services of highly experienced long distance movers in Calgary is the best alternative. Professional movers are taught to employ the most efficient and suitable moving strategies to guarantee that your belongings are carefully wrapped, transported safely, and delivered undamaged and intact to your new place.
From one of Simon Tatham's replies on the blog:

> In fact, the most recent commercial fork caused us to get a worried email or two – the company's publicity made at least some users worry that the PuTTY team might have been subjected to one of those "buyout and radical change of project direction" scenarios I mention above, and they weren't happy about the idea. [Emphases added -- CRC]

So there is a "team" besides mr Tatham. That's good to hear; I always thought it was just he himself.
I'm American and I can't help but think many of you just lack social skills. It's very convenient to think that everyone's hyper-sensitive and there's nothing you could do to change that, but usually people are pretty receptive to just about anything as long as you respect them. Avoid leading/gotcha questions, don't smirk, appear to genuinely listen and seek to understand the other person, resist the urge to tool on them if it's shown they're lacking basic knowledge, try to find common ground. I'm relatively conservative and I've never had a problem.
> if you do good you can make good cash

Let me fix that for you: "if you look good (young/sexy etc) you can make good cash"
I'm pretty sure since the linked page here (https://legiblenews.com/) is a just more readable version (typography) of Wikipedia's current events.
Surely for any company of size you understand there will still be people managing the AWS infra. Having tens to hundreds of small dev groups go at it willy nilly is a recipe for disaster and overspending. Someone still has to patch the server instances, manage the people who access it, train them on how to use AWS, etc. Those costs don't go away because you've moved to the cloud.
> The USA stole tech from the British Empire when the US was trying to build itself up.

The US contributed as much new, prominent technology to the industrial revolution as any other nation. A quick trip down the list of prominent US inventions of the era nicely demonstrates that. There's no foundation to claim that the US stole more technology than Britain did going the other direction. It's a Reddit-knowledge bumper sticker claim that is almost exclusively utilized in threads like this one, and is never substantially supported in discussion (because it's exceptionally difficult to prove that US technology theft was meaningfully out of line with what eg major European economic powers were doing during the industrial revolution).
Multiprocess python code massively benefits from hyperthreading and it's not bottlenecked by instruction decoding at all. It's bottlenecked by chasing pointers.
I never thought I would be pro-violence, but if separation from the undifferentiated is violent, then violence is a good thing.
More than that when you consider modern Mac OS X initially ran on 68k black NeXT hardware, then 486, PA-RISC and SPARC... plus PPC and Apple Silicon.
Do you mean like solar-powered nighttime lighting where the "battery" is just a big rock and the "photocell" is a temperature drop because the sun went down?

That might take a bit of engineering to work well, but it's a pretty good idea :)
Hydrogen car ... not likely at all to become relevant. FCEV Methanol car ... much more likely to become relevant.

The simple evidence that leads me to this conclusion is: battery powered electric trucks ... as far as I know these are highly unlikely to become relevant (as in getting a significant market share of all trucks).
Methanol fuel cell powered trucks (and not only trucks, but also ships and airplanes) appear to be a very relevant field of interest for companies at the moment.

As soon as methanol fuel cell powered vehicles become economically viable, battery powered electric vehicles will have a hard time competing with them except for specific niches.
Omen2: Python Database/Object Interface
I know this could be seen as "yet another object manager", and it is. Thing is, I have a real issue with typical object managers and their interaction with an organization.

An ORM layer should always serve as your primary object interface, not just a weird way to execute SQL calls, while your real objects do the work.

Also, I like my DBA's to be DBA's: to know everything about how to optimize databases, indexes and to do so with SQL. I don't need or want them to be experts at some ORM.

omen2 takes a unique approach to object management by generating "convenience code" based on an existing database's schema. Also, the codegen layer is completely optional.

I'm not going to claim it's done the best possible way, but it's good enough for the dozen or so databases we're using it for, and it's makes far fewer assumptions and has no built-in limitations.

omen2 allows a full separation between marshalling, serialization and databased design.
System 7.1 -- it didn't become Mac OS until sometime in the 7.5 era.

EDIT: Correction, I said 8.5. Sleepy.
I am not sure who's to blame here.

I understand Microsoft's reason here, SHA-1 is not suitable to OCSP requests (because it's a cryptographic-sensitive matter), and SHA-256 hashes for OCSP has been already standadised. On the other hand, there's no signalling that Microsoft, or indeed any PKI/CA operator, to switch to SHA-256 (except for the tenuous case of Microsoft announcing that it'll migrate to SHA-2 for all its cryptographic systems).
Maybe you should also mention that you are affiliated with this project. This reads like an ad.
Well take the 7% from the tips not the wage then.
> the ones who fight x are the most x

Are we sure about this one? Do we have evidence that safe spaces in college universities are worse than South Africa’s apartheid regime or the systemic genocide of natives in Canada/America? Do we have evidence that the southern poverty law center is performing hate crimes worse than the kkk?
Visit employee-owned restaurants more often. In San Francisco, there's Zazie and Arizmendi Bakery, they don't take tips.
good read but ends with no circling back to address the start of the article. Starts with a lot of intrigue but just ends on a blah note?
I always thought "picture in your head" was a figure of speech. I was also really confused how police sketch artists worked. I have zero mental imagery of even my wife's face, yet people could somehow describe features of strangers? A lot of things made more sense once I learned about aphantasia.

I can play back very long and complex pieces of music in my mind. I can recreate tastes and smells from years ago. But nothing visually. Even my dreams are missing the visual element.
He knowingly lied to the FBI, and the IRS. If found guilty the jail time is a must. He's a liar and cannot be trusted
Title inflation is real.

2 years ago I was hired as Staff with pretty high bar to clear.

This year I know a team where all the seniors complain they’re not Staff, and now half the team are Staff engs.
It is your choice to be offended or not to be offended. If you choose the former, it’s not the OPs responsibility to soothe you.
https://en.wikipedia.org/wiki/Effect_of_spaceflight_on_the_h...
Almost all “on prem” business IT is managed by external contractors. I was one of them. We served about a third of the commercial premises in a small Midwestern city, driving out to visit the server closet, change backup tapes, click through Windows Updates, and perhaps make the rounds of desktop users with any questions or concerns. We sold a monthly package of so many labor hours, and we’d visit each customer site about once a month. We’d get the keys from an office administrator who perhaps knew how to provision user accounts. The biggest, richest customers might have had 1-2 help desk on staff, probably not domain admins and certainly not empowered to do any decision making or design. That was for us.

It was quaint, adorable, personal, and hilariously inefficient.
You bring up some great points. There are two that I see.

First, there are internal processes. All too often they end up needlessly slowing velocity. This isn't a technology problem but a people problem. Using a public cloud enables people to circumvent these issues, in some cases.

Second, there are costs. What does it cost to give someone the features they ask for in the time they want it? This is a requirements, design, time, and cost problem.
> Those costs don't go away because you've moved to the cloud.

Sure, but you can go from "I have 5 people managing my 150 instances of SQL Server" to "I have 1 AWS sys admin". The point wasn't that the costs are eliminated, it's that they are baked in.
I've personally noticed them work faster with Firefox than Chrome (macOS Monterey, Firefox 95)
Surprised Cloudflare was mentioned so late in the article and almost a footnote. I think that's not representative of its impact of their strategy on the industry.
We simply don't know. Omicron hasn't been around long enough to make declarative statements. That being said, I think there is still reason for hope:

1. Omicron seems more infectious, but less lethal. Science still needs to collect more data, but the evidence seems to be leaning in this direction. [1]

2. Two shots of an mRNA vaccine still seem to show some protection against hospitalization and death. [2]

3. Three shots of an mRNA vaccine seem to be nearly as effective against Omicron as two shots were against previous strains. [3]

So, from my reading, the best case scenario is that Omicron becomes the dominant strain, is less lethal in unvaccinated populations, and no more dangerous to vaccinated populations, assuming booster shots are administered. If this is all true, it's a very good development.

The caveat is that all of these links are news reports, not scientific papers. I'm not a doctor, and neither are the people who wrote these, so they might be blowing smoke.

Also, it's common for vaccines to require multiple boosters before immunity "takes hold." The polio vaccine is given at
2 months, 4 months, 6-18 months, and 4-6 years, but then you're pretty much good. COVID might be defeated by a three-shot course. It might require yearly vaccinations. We don't know yet.

[1]: https://www.independent.co.uk/tv/news/omicron-covid-variant-...

[2]: https://www.reuters.com/business/healthcare-pharmaceuticals/...

[3]: https://www.reuters.com/world/middle-east/israeli-study-find...
I am willing to try anything that what we have right now in healthcare BUT looking at Medicare by itself, I am a bit wary of Govt's involvement completely. I think we should cut out the middleman mafia a.k.a Insurance company from EVERY visit and instead let care providers compete in the market. i am ok for a nephrologist to charge $x more than the next door nephrologist as long as their service and care is better and let the patients decide that. I do agree that Govt. should step in to probably regulate price gouging so that no one can charge me $500 for a toilet paper roll.
> the restaurant normally takes a cut of servers’ credit card tips to divvy among other employees

This is the problem.

Management should not handle tips -- it should be done among the workers themselves. Some places split the tips with the back staff e.g. kitchen and porters.

Once management have collected the tips -- there is too much incentive to keep some of it. Staff will not know how much the tip "pool" is. The transparency is lost and thus trust or accountability.
that is what I meant by "the slower bitwise logic".

I didn't know GCC was able to optimize that down to cmov.
The problem is not OneDrive but Windows and is not easily fixable without breaking backwards compatibility.
I'm not an expert marketer, but I'm a dev. I would say that it would be great if you could take time to learn some marketing basics to get your projects on anyone's eyeballs. Yes, there's every aspect that we need to consider as marketers specialize in marketing, but it would be healthy for us individuals to learn a little bit of everything.
Did all conservatives and right-wing people storm the capital?
> A. Cryptographically verify the final version

How?
Your characterization is comically uncharitable.

That said, don't think of it as meeting the other pole in the middle. Realize that there are lots of other people between your pole and their pole, and the pole you despise is representative of a lot less people than you think.
It's not a "site" per se, but I have been thoroughly enjoying winno https://winno.app. It's news that you subscribe to based on very specific topics and/or categories.
Your fellow may want to link up with these people:

https://twitter.com/eevblog

https://twitter.com/Chris_Gammell

https://twitter.com/mikelectricstuf

They could also talk about it on https://www.electro-tech-online.com. There are many good, knowledgeable, people there.
Now I have; Thank you! This is probably the 80/20 solution that doesn't abuse my attention too much.
Would be relevant for folks like Backblaze and the Internet Archive, where you write once, read many, but rarely delete. 60 72TB drives gets you 4.3PB per chassis/pod, and assuming 10 pods to a rack, 40PB racks. For comparison, 3 years ago, the Internet Archive had about 50PB of data archived and 120PB of raw disk capacity.

https://news.ycombinator.com/item?id=18118556
I agree it feels more and more that general purpose search engines are no longer the tool for looking for code documentation.

But I wouldn't go as far as to say that the person who writes the website is not the problem. The content in these sites is usually borderline spam.
What kind of "tech"?
The official docs appear to be https://support.microsoft.com/en-us/office/restrictions-and-...
To be fair you will have the same problem if you ever change the name of the alias.
> where the rest of the world was still either under communism or recovering from the ashes of WWII.

That is history: English is a living language, and today first world mean rich industrialized nation (developed), and third world means poor industrialized nation. Those Asian nations in todays English are first world countries even though they weren't Nato or Warsaw pact which is what third world meant in 1950-1970.
Back in the 90s we had novell intranetware, and internet explorer on our computer room machines which opened up on login.

One IT lesson, I changed the front page it opened to something like "<img src='c://con/con'>", very amusing :D

Nowadays I'd probably be arrested.
This effect has been mentioned many times on HN. Some comments attribute it to Google intentionally slowing Firefox to make Chrome seem faster. Some comments attribute it to Google utilizing API's in Chrome that they have specifically optimized to make gmail faster that are not so "specially optimized" in Firefox.

In the end, only the Google chrome and gmail teams can answer the true why, everything else is guesswork on everyone's part.

As to youtube, as with @PaulHoule) I too have not noticed any slowness, but my use of youtube in firefox is only to obtain the URL to hand off to yt-dlp (youtube-dl successor). Watching videos with my local client player is worlds superior to playing a stream in any browser (Firefox/Chrome/otherwise) that I simply do not play the streams in Firefox from youtube at all.
The dock was rewritten in Swift, a few other parts of macOS have been too.
Christmas in 19th-Century America (1995)
What's the source of that stat?
I'm working on something that you might like - though it's not released yet.

It's a news site that doesn't write articles. It just organizes links to other peoples articles, and links to original sources, into sagas that unfolded over time.

For stories of sufficient note I'd like to offer the ability to subscribe to them and get email notifications when something major changes. Unfortunately I suspect that for the long tail of other stories I will need to rely on a wiki-style model for gathering links, and probably can't send notifications without it becoming a source of spam.

The brief version of the motivation for this is basically three fold:

- Most stories of any interest really unfold over a period of weeks to years, but the current news cycle really only favors reporting on them as a single one time event. I'd like that to change.

- Most news sites seem to have a severe allergy to linking to original sources, but often the original sources have a lot of value.

- I'd often like to be able to compare new articles to what I've already read on the topic.

Edit: Send me an email (my email is on my profile), and I'll send you one back once I have a MVP released. That's just my personal email, and I promise not to add you to a mailing list or anything.