skysight-inc/HackerNews huggingface dataset:
This isn't really my experience. I learnt ASM because I wanted to reverse engineer a C binary. I learnt kernel stuff because I needed to write a device driver. I learnt low level networking by writing an HTTP server in C. I learnt programming language design by writing my own programming language.

This was, of course, before LLMs, but I don't see how I am missing "fundamentals." They generally come if you are building something non-trivial and are genuinely interested in technology.
What’s wrong with CTEs though? I have never thought of them as busywork and start with them if I know my query is going to be a multi-step process. I already thought them as “pipes” (in the abstract, not related to this paper). If the query flow is linear so is the sequence of CTEs.

The only slightly annoying thing with CTEs is that you always have to name them. You might consider this an overhead if the flow is strictly linear. But when the flow is not linear (eg when doing two different aggregations over the same data, to join them later) you need a way to refer to the intended CTE, so always requiring a name does add some consistency and doesn’t seem a big deal overall.
They added this wallet feature with a lot of different cryptos, which implicates that they are also now providing maybe a financial service. The regulation with those is heavy.
Most companies certainly won't be using "commercial grade internet" in the way that term is usually used. That would usually be reserved for large enterprises, which really only covers a small part of the workforce in practice.

Many businesses don't bother even subscribing to a business package, because something like a static IP is unnecessary for them.

Further, the point regarding VPNs still stands -- think of the chaos it would cause for many people working from home (on residential connections). And that's just one example.

I don't find it plausible for an ISP to block this.
By that definition JavaScript is also legacy.

> having to hint to the optimizer or write meta-SQL to get it to generate the query plan I already know I want dammit'

That's not in the domain of SQL. If you're not getting the most optimized query plan, there is something wrong with the DBMS engine or statistics -- SQL, the language, isn't supposed to care about those details.
A script running curl on my browsing history would collect the html. I’d solve the 200 result problem if and when it was an actual problem in a way that addressed the actual problem. There’s a lot of success before too many results is a problem.

The idea that it might be too much friction than it was worth is why I didnt build it. Probably why nobody has built it and perhaps why you just listed a bunch of imagined problems as reasons not to build it.

I mean it would probably be shit if I built it and I liked my idea better than the idea of the work. That’s most things.

—

For what it is worth, I would default to google for the things google does better and use my personalized historic search when I wanted to see what I had seen before. Its both-and not either-or.
Can I bind arbitrary hotkey combos to different window positions/ sizes?
Like in better snap tool?

E.g. “cmd opt >” to put the window at 1/3 width on the right side of the screen?
I mean, I guess! I can’t say I feel damaged by it in the least (rather, enriched!), but I’m sure not every person will have the same experience.
Telegram has public and private groups. They probably want to jail him for not pre-moderating every posted message.
Browsers don't have native support for opening WARC. It doesn't solve the safety problem either: you can still construct a WARC that phones home, AFAIK.

It's a great format for the problem it solves, but if browsers supported offline-only files the container format wouldn't (and shouldn't) need to be that complicated.
presumably because they have people shopping for them
https://x.com/filosottile/status/987376021589692416?s=21

I'm not sure that counts as an impeccable track record.
Pro does not, and that is the version you should be on. Clean install w ISO.
That sounds like a dream. I have a distinct memory of doing in class writing in 3rd grade where the teacher would force us to redo it if there were mistakes and give minimal feedback. As far as my 3rd grade memory can recall, I rewrote it several thousands times and never got it all the way right.
I have friends who grew up in the Soviet Union. None of them have ever mentioned a longing for Soviet quality.
The suit is part of the spacecraft. In the case of Dragon, it pressurizes, inflates and deflates at times depending on the phase of the mission.
I'm not sure I'd say I'm "messing around on the Unix command line", but I've been using Linux for about 3 years on my desktop and do some hobbyist development. Have never seen head before.
> Do you unironically believe it's not already backdoored for Russian government?

Yes. You should read the history of Durov and why Telegram was created in the first place.
> A lot of SQL engines don't support aliases in the HAVING clause

We're moving from SQLAnywhere to MSSQL, and boy, we're adding 2-5 levels of subqueries to most non-trivial queries due to issues like that. Super annoying.

I had one which went from 2 levels deep to 9... not pleasant. CTEs had some issues so couldn't use those either.
It’s kinda why I don’t boast about my affiliation with an Ivy. I am proud of everyone from the plant science department to the sprint football team and the food service worker’s union. I don’t want anyone to think that I am better than anybody else or I think I am better than anybody else because of it though.
I am aware of how it works, that's why I front-loaded the part about the brassiere being MIA at the moment. I just don't care, and I don't take it outside except on the airplane. Next flight I have, I'll probably dig out the brassiere.

Also in my experience, the brassiere was never perfect about guaranteeing the AirPods Max were put perfectly into a sleep state. The same exact issue could sometimes occur, maybe an alignment issue. The AirPods Max sound fantastic, but there's a lot of little details about them where Apple just kind of dropped the ball.
Thanks for the feedback! We aimed to make database migration easier and found that AI could really enhance this process by handling the complexities of different DB dialects. We'll also explore more deterministic approaches, as you suggested, using a common internal representation. The "Examples" link is being fixed—thanks for catching that!
With that much overtime money surely they can get an excellent accountant!
It’s sad that he’s left Nomadlist to rot. There is currently no way to see any billing info, no way to close your account, zero support, and the site is a broken ad-infested mess in multiple places.

We had a similar experience with Remote OK recently and had to chargeback because there is literally no way to contact anybody.

Investing a little in basic support goes a long way. The guy just needs to hire a few smart people to answer the bulk of inquiries.
Haha this made me laugh. If our ancestors could see us commenting… “it took 4 milliseconds… should be faster”. So funny, I don’t understand how you even notice the difference win 4ms vs .4!
Maybe you need it if pointers are 16 bytes?
What would happen to the messenger? I have a lot of useful connections there. And using it to read HN.
Funny, a low performance solar sail is actually a high performance sunshade, you’d actually do better with a black sunshade than a highly reflective one.
You didn't learn how to use these tools properly. If you did you wouldn't have that opinion. Karpathy doesn't just write code snippets for educational purposes. Most of the code he writes is for real world systems and it's not publicly available.
Not clear right now if France thinks he was actively complicit with the four horsemen listed, or if just the act of running Telegram makes him complicit in their eyes, or something in the middle, e.g. they asked for help and Telegram turned them down.

This will be an interesting case to watch -- I don't believe there are any western nations that want non-locally-backdoored messaging of any sort -- but generally my understanding is that harassment on border entry has been the order of the day, rather than arrests.
Attacking the knapsack problem
> Tesla was actively cut out of Biden administration EV programs and awards

Incidentally this was the inception of the Tech Right. Before that, Elon exclusively voted for Democrats.

I didn't realize the impact back then: https://x.com/mualphaxi/status/1817562306764566824
Basically as he did not provide access to the encrypted messages and communication in Telegram, they accused him for supporting the criminals. That's all to it.

It is basically the part of the current politics in EU where they are trying to force access to all encrypted traffic across devices.
> If you jump at a large project but lack the fundamentals you are going to wasting energy on stuff you shouldn't be.

"Wasting energy" in this case would be learning. This learning happens faster than following a tutorial and "mastering" the basics.

> The problem now is we have LLM which kind of negate the need and we have lot of engineers who don't have good fundamental systems design.

Yeah if you use LLMs for everything you are just going to struggle 10x harder when you encounter a problem. This does not discount my point.

Also why is your name a slur.
That’s my question, if messages are end to end encrypted then the company does not have access to censor, right?
You may want to check out [rcmd](https://lowtechguys.com/rcmd/).
That's not what news is at all. That's biased news. And not facts either. You might be confused with talking about how one projects feelings on to stories, filter internally, and, inevitably, bias them all by oneself.
Is the inverse much much more concerning.

Like vaccines, we have very little idea just howngood it is to identify preventBle dieseases and reduce suffering
"Most people are bad at math" doesn't matter, "When someone has those issues they are more likely to be bad at math" is what we're talking about.
Ask HN: How do you feel about interviewing process
-
> HAVING is different from WHERE because it filters after the aggregation, without requiring a separate query with an extra SELECT.

Personally I rarely use HAVING and instead use WHERE with subqueries for the following reasons:

1-I don't like repeating/duplicating a bunch of complex calcs, easier to just do WHERE in outer query on result

2-I typically have outer queries anyway for multiple reasons: break logic into reasonable chunks for humans, also for join+performance reasons (to give the optimizer a better chance at not getting confused)
You can't glide back to the surface. Kind of feels like you should be able to but it doesn't work out like that. If it did then that's how all spacecraft would descend.

Scott Manley did a good video about it.

https://youtu.be/5kl2mm96Jkk?si=Uf9ntP6R39SJrVBm

Skip to 3:45 for your exact "well meaning suggestion from people who aren't rocket scientists".
They're treated the same because they are the same, which people with domain knowledge (i.e. power users) are aware of.

A terrible way to get them to stop doing something you don't personally agree with is by starting your post with a bad idea, support it with a lie and close it with a personal attack.
No plans for acquisition :)

Building product, talking to customers and making something people want!
> I don't believe there are any western nations that want non-locally-backdoored messaging of any sort

But that's what exactly they want no? EU is literally implementing a regulation that will allow to "circumvent end-to-end encryption to address child sexual abuse material". I believe it failed to pass recently, but they will try again - and nothing stops countries to implement it independently. I think France is the one who was pushing for that in the first place.
The latest evidence of wide cooperation of telegram and Russian officials: https://roskomsvoboda.org/ru/post/shutdown-v-baymake/
Of all the problems with SQL, this solves one I absolutely don’t care about at all. Kill SQL or don’t kill SQL, but don’t add pointless syntax sugar to make normal queries look alien.
(This was originally a reply to https://news.ycombinator.com/item?id=41339138 but I detached it so the useful link could float higher in the thread - thanks!)
A typical human being’s fingers can reach both its anus and its mouth.

In other words, no shit.
Can someone explain to me why this huge success?

Is it because of the back story of it being based on a Chinese mythical book and that it rings a bell with this billion person sized market?

So far, only looking at the trailer, I did not see anything particularly special that would differentiate it from other recent AAA games.
Unexpected as in Apple was expected to offer something less clunky.
Why don't you post it yourself. And why should I care about what he says when telegram has some of the worst default encryption settings among commonly used messaging apps in the west?
I've just update the EBNF for rarilroad diagram here https://github.com/google/zetasql/issues/134#issuecomment-14... with the full grammar.
According to this source he’s accused in non-cooperating. He’s not accused of terrorism, drug, or slaving directly.

Very interesting to see where it will all go.

I don’t understand how they’re going to convince French judges that he’s guilty for not being able to decrypt chats that he has no keys for…
You can't operate a successful company (i.e. with a decent ROI) if you're sitting on a Scrooge McDuck cash vault.

It wasn't Boeing's fault that the governors shut down the economy, something that had never happened before in the US.
Personally I am amazed just what the focus on safety has achieved.

The 737 Max was objectively surprisingly safe to fly at the time of the groundings. As in for the average flying passenger their odds were significantly higher to die of something else on the day of their flight than from a crash. But still we know how to do better and things improved.

Imagine if we treated each individual car accident as a failure and millions of like could have been saved. It may have involved making breathalyzers a mandatory feature etc, but I suspect there’s a lot more we could do even without that.
Technically crypto wallet is a third-party app and not a part of Telegram distribution.
> What’s wrong with CTEs though?

Depends on DB engines I suppose. I've come across that certain operations were not allowed in CTEs, and they can be an optimization barrier.

However if your query is dynamically modified at runtime, then CTEs can be a no-go. For example, we have a grid component which first does a count and then only selects the visible rows. This is great if you have expensive subselects as columns in a large table. However to do the counting it turns the main query into a sub-query, and it doesn't handle CTEs.
Maybe just wait a moment for things to come out through the natural course of justice rather than getting yourself all worked up here.

The accusations are serious enough that it’s probably reasonable to assume that they have some serious evidence for this and if that is true then this is a good outcome that should be celebrated.
Please don't introduce extraneous grumps at the top level. It's not that you're wrong, it's just a poor starting point for conversation—especially for a Show HN.
> Do you unironically believe it's not already backdoored for Russian government?

To people arguing against this, Russia's Sovereign Wealth Fund RDIF has an ownership stake in Telegram after co-raising with Abu Dhabi's Mudabala in 2021 [0]

Either way, Telegram is at the whims of MbZ, and if the UAE ever needs something from Russia, they'll use Durov and Telegram as collateral. The UAE's done the same thing with Pakistan (Musharraf, Nawaz Sharif), India (Dawood Ibrahim), Israel-Palestine (Mohammad Dahlan), Serbia (Belgrade Waterfront Project and Mohammad Dahlan), Turkiye (Mohammad Dahlan), etc.

If the Telegram founders were truly opposed to Russia, they would have immigrated to Israel, the UK, Germany, Netherlands, or the US like most business dissidents in Russia. If VK wasn't stolen by an oligarch, they would have remained in Russia to this day.

[0] - https://www.bloomberg.com/news/articles/2021-03-23/russia-mu...
Maybe related:

„Putin and Telegram Founder Durov in Baku at the Same Time“

https://x.com/JAMnewsCaucasus/status/1825889800634733025
A clean history and the ability to roll back to any point is still useful when working solo.

Git bisect is one example of this. If you know roughly when a bug was introduced, you can do an O(log n) binary search to find what commit introduced it.
Thank you first of all! ChartDB stands out with its one-query for visualization, AI-powered migration for easy cross-DB transitions, and interactive editing, all free and open-source, combining these features in a user-friendly way.
Do you have any proof of this whatsoever or are you just making this up?
You can reopen the window you're missing with ctrl+shift+n, the same way you open a formerly closed tab (only that's not n, that's t). I do agree it's irritating this isn't made more plain.
“Track record” is an incredibly poor indicator for the lack of a government backdoor, thinking back to Snowden, for example.
Interesting, thanks for sharing. I did some digging on the linux-kernel mailing list and it seems that after the first patch series in Dec ‘21 and the LPC talk there was no further work on this. Too bad if true. Also I wasn’t able to easily find which hardware supports this today. I did see a reference to a RISC-V project that is adding a similar feature.
> Average summer temperature 72.6 degrees Fahrenheit

Must be different, out there. I lived in MD for over ten years, and the average was ... slightly higher ...

It is real purdy, out there, though.
Previously: "science of learning" -
https://hn.algolia.com/?q=%22science+of+learning%22
Feels very much like a political crime, how soon until Mark Zuckerberg is arrested for WhatsApp?
It is not encrypted by default. By default, everything goes through Telegram servers and can be read there.
Well, they are failed because the society they need to prosper can't be sustained for long and their are more and more "commodity" people do not like much so a bursting bubble at a time they'll loose enough to fail while not so fast of course...

Big tech during the last decades have done much harm, but also much toward digitalization of the masses, GMail, Maps, smartphones, VoIP (even if as walled gardens) was still large leap ahead for the society. In the last years they go toward finance so much they can't really present any "new revolution", all converge on similar concurrent solutions, and start to infiltrate other sectors with not so much success (like in automotive, healthcare, smart homes and so on). That's for me is a sign of a final down turn.
That's a 20th century solution.

The right thing to do now is to shutter the company and make all it's patents and designs public domain
Question: Would provisioning a very large single server to run multiple apps or things be considered a valid Cloud pattern?
What do you mean by professional that doesn't include Karpathy?
Ask yourself why juries and prosecutors and judges and police are not anonymous but voting is.

> What is your perspective, why would you not like it?

Authors should be hidden from reviewers. Reviewers should be made known to authors. Why?
When some reviewer dings me because he/she doesn't understand a fundamental concept, or some technical detail, or because I didn't cite their work, I should be able to have some/any recourse. Right now these people are completely shielded by anonymity.
From the article, that's a massive pile of charges they're dumping onto him, all apparently because people use Telegram in ways the French state disapproves of?

> Why was he under threat of a search warrant?
> The justice department considers that the lack of moderation, lack of cooperation with law enforcement, and the tools offered by Telegram (disposable number, cryptocurrencies, etc.) make him an accomplice to drug trafficking, pedo-criminal offenses and fraud.
If I recall correctly, we discovered and fixed the leak because the ground around the meter had become a mud pit, then the meter was read some time later. The size of the bill was still a surprise.
The extent of the accusations is evidence that all that is made up in order to get access into Telegram. Telegram is too important to the other side in the Ukraine war. If Telegram goes, then the other side is silenced.
> Don't forget SpaceX was the first private company which achieved orbit without external money...

No; SpaceX received DARPA (https://ntrs.nasa.gov/api/citations/20060048219/downloads/20...), Air Force (https://www.space.com/2196-spacex-inaugural-falcon-1-rocket-...), and NASA funding (COTS, in 2006) prior to their first orbital success with Falcon 1.
Obviously FSB is not going to make a press release and be like "We have the keys LOL" so there would never be definitive proof.

Fun fact: Telegram at some point was blocked in Russia for not giving FSB access to data. Later telegram was unblocked and is used extensively in Russia. It's not hard to figure out why it was unblocked.
>Do you unironically believe it's not already backdoored for Russian government?

Yes as Telegram was banned in Russia for a long time (or at least they tried) before giving up.
Ha I really hope you're right about JSON being a fad, and something better will come along.

I would bet against it though. JSON's flaws (ambiguous spec re numbers & duplicate keys etc; no comments, strings aren't zero copy...) are pretty minor compared to XML's (completely wrong data model, insanely verbose, not even basic data types).

There was much more motivation to replace XML than JSON.

Also even though XML has been broadly replaced, it's still widespread and I don't think it would be out of place to have it in a standard library. Go has, and Go's standard library is one of its highlights.
Telegram has, by design, message content accessible to whoever runs the servers. WhatsApp has gone to great lengths to not have that.

Obviously there’s client security, potential backdoors, unencrypted backups, and many other things to worry about. But I don’t see a scenario where it fares worse than Telegram, and many where it’s significantly better.
As someone responsible for the fall out from these tools being used to cut corners, I doubt it. And I'm talking about senior developers here with 10y+ experience.

People don't bother to understand problems now. Only the happy path is considered. It takes real intelligence to understand the side effects even a simple thing can have. What was a whiteboard session and a thinking process is now blindly trusted to some 3rd party agent.

Consider reliably receiving a message from a queue and processing it at least once. So far I have encountered at least 0 times processing on two separate occasions. That is a big problem. Turns out the code was generated and no one even knows or cares enough including the people reviewing it because their magic friend wrote it and their other magic friend reviewed it and the management is happy that they were sold magic because some other magic thing wrote some marketing spiel that absolved them from any decision making responsibility.

In some contexts a mistake like that has an actual tangible capital cost if it's a trade or a transaction in a regulated industry. It's not "just a mistake you can learn from" at that point.

People tend to lazy, to steal a mathematical expression, and these tools bring the worst out in people.
He is co-founder and worked there 2015-2017 came back later for a year.