skysight-inc/HackerNews huggingface dataset:
Text to SQL in Production
> Is there a way people can continue their normal lives, but still eliminate the green house gasses emissions?

Yes, but real change can never happen as long as those who are in power continue to remain in power. Though green house emissions are a smokescreen used by serial climate offenders to present a “green” image while causing immense ecological damage behind the scenes. It’s important, undoubtedly, but one of many issues such as habitat destruction, chemical dumping, e-waste, etc.
"To this point I believe most companies don't hire green for the devops team."

Yes. Devops people come from a SWE background generally + they understand infra. They usually have 10+ years experience. Most specialties work this way in software: security, devops, AI, ML, ... etc. You need to be a SWE first, then specialize.
> Let’s get rid of devops and hire platform engineers. The problem is it’s a really weird and rare combination of skillsets, in a field no one really wants to do except complete weirdos (I am one). I’ve long said that DevOps isnt a career you choose, it just happens to you.

It always has been. Always!

This is why FAANGs paid their SREs top dollar.

The problem, as you noted, always starts from the top. Cultural change needs to be championed by someone with power inside of the company. However, cultural change is slow (site starts to scale) and expensive ($150k hacker nerd) and many executives still think of tech as a cost center to be optimized (see also: ChatGPT).

Platform Engineering now is where "DevOps" was in 2014 or so, but with more Kubernetes and Rust. But as long as executives who do not (or refuse to) understand the value that strong engineering teams bring forth, the Platform team will just be interchangeable with today's DevOps team.
The #1 method of population reduction is to increase education and opportunity for girls and women in developing countries.
That applies to OpenSSL 3.0. 1.1.1 and other versions are more MIT-like, but with advertising clauses that make them incompatible with the GPL: https://www.openssl.org/source/license-openssl-ssleay.txt

https://news.ycombinator.com/item?id=13945492
Old Japanese Vending Machines [video]
who seem to be actively working to get their homeless to move to other cities.

It's probably not "seem." A number of cities have been caught, sometimes repeatedly, buying one-way bus tickets to other cities for homeless people.

It's immoral, but not illegal. When they get caught, there's a brouhaha in the local newspapers for a bit, and then everyone forgets and it starts up again.
The traditional way of schooling, where it starts with small pieces and works its way up to something grander, is decidedly backwards.

In practice, one is best served with starting with something grand and then breaking it up into smaller and smaller pieces until those pieces are digestible. Learning becomes infinitely easier this way.

On the surface it may seem like the same thing: The learning takes place around a concept of of small pieces of a larger puzzle. However, the process of breaking down the puzzle is where the most important information is gleaned.
Mastodon needs a downvote button.
A lot of important art is practically in permanent storage in places like Geneva Free Port, a collection of nondescript warehouses where the art can be sold and bought tax free.

And of course nobody ever gets to see it. Maybe not even the new buyer unless they’re particularly interested in art rather than just trading as an investment. The documentation shows that the Picasso is in Geneva building D section F room 37 shelf B, that’s good enough to buy it for $10M and sell it for $15M later.
knowing reddit admins they will just ping them without bothering.
This is going to be a one-sided vote: people who log into Reddit and want their content back might vote out the protesting mod.

But people who agree with the mod and the protest are less likely to log into Reddit at all, and thus they might not vote.

So the expected turn-out for the two opinions is going to be quite different; in favor of Reddit.
Tax reasons. What you typically see isn't just any warehouse but a "freeport" -- a warehouse that's outside a country's tax jurisdiction.

The idea makes sense: you ship something (some part of a jet engine) from the US to Nigeria, and the trip involves a cargo plane change in Geneva. You don't want to pay import duty to switzerland just to ship it out a few days later so you store it in a guarded warehouse for those days and legally it never enters the country.

Then some folks got the idea that they could simply store other expensive assets in such a place. I assume most of it is for money laundering and/or big transactions for illegal goods.
Is GDPR only for PII? My understanding was that it applied to your data, regardless of PII status
The protection is practically an illusion as well. Take a gander at the latest Pixel or iOS security update:

https://source.android.com/docs/security/bulletin/pixel/2023...

https://support.apple.com/en-us/HT213757

Yikes!
Congratulations! You've just made it impossible for the people who operate every essential service on which you depend to get to work.
While the charts are nice for illustrating the flows, they could use a little bit more love. The process flowchart doesn't need to have any crossing lines, but it has multiple. While removing the crossings is a small change, it reduces cognitive load considerably.
look at you, overpaying! how cute.
You can't free a buffer/object twice in the proposal. After a free, you can't use the pointer any longer.

But it might very well be that this approach is not hard enough for use in e.g. the kernel. It might still be useful for userland applications, though.
I dunno why this was passed by HN. Those results are fantastic.
> How come 4chan and Wikipedia are both profitable, but not Reddit

reddit has 1.7 billion visits per month[5], with an astronomical amount of persistent storage, with the content never being deleted. reddit is ranked #18 globally.

4chan has 51 million visits per month[4], has very little persistent storage (posts are deleted once the thread slides to the bottom of the board list), and strict size limits for the posts that exist at any given time. 4chan is ranked #708 globally.

Wikipedia does get 4.7 billion monthly visits[3], but they do have a public list of large donors[1], and the entire wikipedia catalog can fit onto a 20gb microSD card [2]

So I can't give a solid answer, but it seems like the other 2 sites you mentioned have a slightly better design when it comes to infra costs.

1: https://wikimediafoundation.org/about/2018-annual-report/don...

2: https://meta.wikimedia.org/wiki/Data_dump_torrents#English_W...

3: https://www.similarweb.com/website/wikipedia.org/#overview

4: https://www.similarweb.com/website/4chan.org/#overview

5: https://www.similarweb.com/website/reddit.com/#overview
Oh hey, please fix the link to macrobase; it redirects to pornhub
> Just looked at the settings on my phone, can’t see any ‘ads’ for iCloud at all. Am I doing something wrong?

For one, it's on macOS and shows up for anyone who doesn't log into the App Store with an Apple ID. It will be a red notification badge in Settings that does not go away unless you log in.

> if there are ads, are they modal and stopping me doing what I wanted to do?

I mean, yeah. This is the default behavior for Apple Music on Mac - when you put on your headphones, it auto-launches Apple Music with a modal blocking the app and asking you to try subscribing to Apple Music. I haven't seen default system behavior this sycophantic or contrived since Windows 8 came out.

> but what is wrong with upselling services? Is it any different to YouTube being native on Android devices?

No, it's not. Both fucking suck.

When people pay for a device (especially a premium experience) they expect that cost to get recouped somehow. I used to daily-drive Mac because I expected a premium experience, but you cannot look at the past decade of Mac releases and say there have been less advertisements. The desire for you to pay for more services is now an intrinsic part of MacOS like it is on Windows, and honestly that's the worst.

> what is wrong is the how, when and where that takes place, and what the advertisers are basing it on.

What a shockingly vague and nonspecific example of what "wrong" looks like.
Cool, then I guess they can start their own Reddit soon. With hookers and blackjack.
I believe you, but I think this experience/job varies pretty wildly. That is, there are organizations where your job does involve writing software that's more than short scripts. If a company chooses "best of breed" for their pipelines, for example, there's quite a lot of integration between SCM, build tools, security tools, deployment tools, and so on. Doing that in a way that serves the end users well isn't always trivial.
When I was a teenager first learning the basics of coding, I usually found programming books that focused on actually making things to be the best tools for learning. Books like "Beginning C++ through Game Programming" and "Teach Yourself C# in 24 Hours" were way more engaging and picking apart the code samples probably taught me more than what most of my peers did in the intro to CS class in college.

When you can actually see the changes to things and have a real interesting project to work on its way more engaging that just going over the theory of things. Obviously, one should follow up with actually learning the theory as well to get a deeper understanding, but I often just can't grok things unless I can play with them.
For the experts in the thread complaining about the simplicity of the excellent introductory text in the OP, here's an exciting reading for you:

Statistical Consequences of Fat Tails: Real World Preasymptotics, Epistemology, and Applications by Nassim Nicholas Taleb

https://www.amazon.com/Statistical-Consequences-Fat-Tails-Pr...

Beware that it may be way more advanced than what you'd expect though.
Mostly false.

Overlapping confidence intervals does not mean > x% chance that the two variables' expected values are the same. If the intervals overlap, the difference is not statistically significant.

Your example about random variables is largely misinformed. You're talking about things as if they are individual values. But we're talking about sample means. The probability that a sample mean for a large sample is above the 90th percentile is massively lower than 10%, and depends on n. The joint probability of getting two sample means above X threshold is irrelevant.

Confidence intervals don't tell you what the probability of the true mean being above X is. They tell you, bluntly, the range of values where the true mean could be, with 95% confidence ("If i were to do this experiment 100 times, based on the results I got, I would expect the true mean to be within this range")

You can play with some numbers and methods but you can rest pretty sure that a material effect size is probably not rigorously evidenced if the intervals overlap
How would this work on Reddit, exactly?
> On top of that, would you earn your usual rate for that time?

This is the key! I do these kind of things on my spare time!

On my spare time I could (1) do nothing; (2) try to cram more screen time into my life, and give the money earned to someone to do my repairs for me or; (3) do some things by myself, learn while doing it, and feel like a super-human that can control is own life (well, some of it). I prefer number 3!
I'm kind of with you, but I suppose its a culture/mind-set thing.

I hate reinventing the wheel, but who knows what kind of innovation could happen by combining unique experiences and lessons someone can learn for future use.

For instance, I made a laser pointer, I could have bought one for $10-$100, but I decided to make my own, learn about Electrical Engineering and optics. I never finished it, but it taught me a ton about EE along the way. Now I am quite comfortable with EE, except the parts I'm uncomfortable about ofc :)
Considering how conscientious most reddit mods I've seen have been, the "reddit mods are power hungry" sentiment is starting to feel like astro turfing to manufacture consent for this kind of action by the admins.
> from people who are clearly planning to invest in the IPO.

It's not that, it's about siding with power and revelling in watching the uppity peasants get their due. I saw the same thing on HN during the Twitter and other tech company layoffs. Little sympathy for the workers, but lots of HR quarterbacking about "bullshit jobs".
Listen here now, this isn't a democracy! Beatings will continue until I get more money

-reddit's CEO
I think the lack of activity since the conspiracy theory started could be easily explained by the user being creeped out by the witch hunt and abandoning their account. I know if I was accused of secretly being a hated figure like Maxwell on an account that wasn't connected my real identity, I wouldn't come out and deny it, I'd just ditch my account and make a new one.

It also seems unlikely to me that someone like Ghislaine Maxwell would have the time to be such a prolific Reddit user, and that she would write like a Redditor - for example calling someone "butt-hurt" in one comment.
This is a fantastic insight!
Thanks cryptocurrency! What a useful technology. Wasting electricity, enabling wild financial speculation, and best of all shutting down critical public institutions like hospitals by enabling rampant cyber crime.

Is there anything this miracle technology can’t do?
Hey there, I head up the engineering at Procoto! Totally understand the need for data to be hosted in EU servers as I come from a company that primarily works with European orgs. While EU hosting is something we have discussed, it is definitely lower on the priority list for now until the feature set is a bit more built out. This is the first time we have gotten a request for EU hosting, but GDPR compliance is on our radar as we understand the need for privacy and security!
Wouldn't it have made sense for Reddit to get the official app in some kind of shape, with all the needed accessibility features and moderator controls, before killing third party apps?

They just seem to be doing things out of order. Another example: alienate long-time users and mods by making it abundantly clear that they're product and free labor really should have come after the IPO.
Maybe the problem isn't Reddit, API pricing, or mods. Maybe it's Steve Huffman. I'm sure Advanced Publications would be receptive to anyone who thinks they could monetize Reddit while being 1000x more relatable than Steve.
Yeah we mostly don’t do the start/stop thing with timers. For the most part we just have folks guesstimate the hours spent when the close or reassign a ticket. Hour or half hour precision is good enough.

We don’t hide hours and use them as a tool for raising flags as part of our weekly or bi-weekly reviews with team leads and part of our client reporting. If a lead sees someone spending too much time on a task it raises a flag on whether the task is unexpectedly large, impacting schedule and/or scope or if someone is potentially slacking off or having some other personal issues etc.

We are primarily remote and, like most agencies, will backfill sometimes with contractors. We’ve been hosed a few times with people sandbagging hours so making all this data public and reviewed has been a great way to hold everyone accountable.
I was very interested at the results of my spouse's antibody test! It was negative, and we thought for sure she had antibodies from infection. I have no scientific evidence, but she has genetic abnormalities in certain blood proteins, and I wonder if that assists with her resisting the infection!
If you are an American citizen who is not against American interests, sure, go with iOS Lockdown Mode. They won’t come after you. If you’re not, then you can get an open-source OS device like GrapheneOS, be careful not to emit any information to the internet except without over anonymity networks like Tor, and use E2E messengers in your day to day comms for your baseline security for today. I don’t know what will happen when AIs will be able to identify any person from a paragraph of text they’ve written. Best to move to a place where no technological State exists and live self-sufficiently then, maybe. Still you’ll be visible to satellites and thus targetable for States, unless you live on hydroponics in an underground mine or something.

For people who are targeted or in risk of being targeted by three letter agencies, it’s a different story.

It’s so easy for any three letter agency to install a mole or buy someone in those open-source projects like GrapheneOS, for example to publish compromised binaries. The best option is always to not use anything connected to the cell (GSM, 4G, 5G etc.) network and carry all comms encrypted over internet, with pre-exchanged secret keys and preferably over a network like I2P and over public Wi-Fis. You can use I2P outproxies to connect to visible (normal) internet. I do NOT recommend Tor, there were reports of Tor being compromised and it’s too suspiciously popular to be trustable IMHO. Pay attention to CCTV cameras as well, don’t sit in a mall to connect its public Wi-Fi. All these things obviously introduce a lot of friction to your communications, but if you are such a high-value person you should have set up your network of people accordingly beforehand as well, to relay messages and such. QubesOS is a good OS for such people. If you have the means, custom device solutions to communicate over radio with encryption is by far the best option you can have, especially for receiving critical comms on time. This only leaves the risk of triangulation when you transmit, but you must be a really high value target for this to happen. And you can always still use internet as I described to transmit.

Don’t ask how I know all this.
Reddit has never respected its users. Spez's continued user-hostile antics over the years show that this is the case very clearly.
I agree with both points, fair statement!
Nvidia is now has > $1T market cap
well, that was encouraging. perhaps games like D&D could help socialise these guys?
> We need a new form of social media where users and communities can easily export their content and data. A reddit clone with a similar UI is not enough.

If a site allowed imports how would it work? It could work for all of a user's top level tweets, but for something with threads like reddit I don't see any solution.
as a middle aged veteran i still get frustrated by the lack of intermediate-level examples in lib/framework documentation. even a link to a suitable github repo showing a full usage of features would be useful. i can stare at the auto-generated API documentation or look at the source (or maybe even your test suite) for hours trying to hunt down features and flags and methods i can override and undocumented tricks i can use but why not just give people a useful example beyond hello world?

the best libs start with examples. here's a great one. it covered my entire use case in the first page of documentation.

https://tenacity.readthedocs.io/en/latest/

like, how did you actually test this lib? surely you wrote something - anything - that uses some more of these features other than a test harness?
That could be interesting. I have seen accounts making racist or violent remarks and just deleting them afterwards after a few hours.

That accounts seem of normal people engaging in normal conversations. But they spit hate everywhere they go, it is just not reflected in their history.
That's fair, and a good observation.

I'm not sure what to make of it as far as general narrative.

If people are creating stuff they don't really care about, of course it won't be very good? And there's a lot of money spent paying people to build things that honestly nobody would reasonably care much about?

One way or another, the pining for a software engineering world where we all collaborate on creating things that are maintainable products with high-quality user-facing experiences, and have the time to do that... well, that's not the one we've got.
From their roots they used sockpuppets to make the site seem like it had more users than it did. I consider this fact as a counterexample to your words.
IANAL but having dealt with GDPR lawyers in a past career, GDPR allows you to anonymize user data as in, if there is no link between the user and the data, that satisfies a right to erasure request. That is not what is happening here but it is not as if reddit has no way to keep deleted comments and still be GDPR compliant.
Respect, tolerance, kindness.

There are a plethora of articles like this that capture the feeling of retrospective. I don't see any difference.

Though comments here are quite heated.
It's not much of a moat if Reddit hasn't derived a single cent of profit from it.
just hope they dont edit them too
In college I wanted to learn how to code.

My first class was in C, the instructor read from the book and then we did exercises from the book. I dropped the class, moved on in life.

20+ years later I was between jobs and ready for something new. I had an awesome instructor who was energetic and explained why we do things, we built silly apps, and it all made sense. I’m enjoying my new career a great deal.
I have been a paid software engineer for about 30 years. 10 to 15 years in I learned to love computer science, but for the first huge portion of my career what motivated me was making things. Demos, Games, etc... Maybe the key is to start building things immediately? Things the learner is interested in making.
No. You walk in and take a written test. If you pass, then you have to take a driving test. Assuming that you have a car. Or a friend with a car. Or money to rent a car.

Assuming that you can find a car to drive, you will take a lap around the block to demonstrate that you can steer, stop and maybe parallel park.

The barrier to entry is pretty low.
Outside of court, the preponderance of evidence changes with a history of operating in bad faith.
No. And definitely not for a CDL.
Is this sarcasm? What's stopping whoever does have the permissions from "sneaking code into production?" This seems like something pretty easily addressed by a combination of code signing and time-gated permissions. A small dev team may not have the time or energy to stand those systems up, but a blanket statement that it's a security concern seems like a bit much.
Personally I'd love to have an upvote and subreddit filter. So "delete all comments except the ones on /r/askscience or the ones with above 100 upvotes".
I can’t speak to whether it was purposeful or not, but many of the comments I have deleted on Reddit have also been restored.

It seems unlikely that their comments specifically were targeted, but it seems entirely plausible that a site-wide restoration took place that included their comments.

It also could be a bug.
That baidu link is rebranded chatgpt.
That's crazy, most of the comments I read are months if not years old.
With no driving experience? No… And they were talking about a commercial license anyway.
My outsider view is the desire to account for all labor output. If the labor of painting one's own house goes un-accounted for it distorts the view of the current state of the economy.
Most kids don't know what they're interested in. It's best to expose them to a lot of things and hopefully most of them will develop an idea what they like.
> Humans are bad at estimating stuff. Software engineers doubly so.

Where did you get that factor of 2 from? /s
Yeah best practices / structure/ strategies beyond the basics are often a mystery.
Hey give it time in the case of Twitter. Last I checked they have a distinct strong lack of profitability, which tanked further the second Musk started spooking advertisers. Obviously he can afford to personally bankroll it, though, but it seems like a bad ROI.