skysight-inc/HackerNews huggingface dataset:
In Johnathan Swift's “Gulliver's Travels” (published 1726) it is stated that fraudulent behavior needs to be punished systematically since the erosion of trust will eventually destroy a market. Your comment describes a situation where exactly that happened. It is frustrating to see such an important (and simple) lesson, known literally for centuries, get forgotten or ignored.
I wrote a "linter" for database (postgres) schemas. It doesn't currently say anything about indices but I am looking into that because that seems like something that you could make qualified guesses about.

github.com/kristiandupont/schemalint/
Quite a bit of discussion yesterday in https://news.ycombinator.com/item?id=26403614.
The wasted fruit has already been thrown away by the store in the case of Amazon.

Fruit and veg just doesn't need wrapping - but you do want a way to keep stuff you're going to eat raw from touching gross stuff.
Thx for the heads up, I appended it to the readme.
That's excellent. I'm usually pretty good at these either-or things, but I was 2/10 on that.
If everybody were such a pessimist, we'd never try to improve anything because there's a risk it might not always work or need adjustment in the future.

And a certain someone would also be there telling everyone not to go outside of the cave because there's tigers :)
Yep. I guess what could be done is a two-tiered status page: automated health check which shows "possible outage, we're investigating" and then a manual update (although some would say it looks lame to say "nah, false positive" which is probably why this setup is rare).
"Knows (most of) the rules of chess" would be an accurate description of my level.
This resonates with me. I notice my gas tank rarely depletes because of technology. It doesn’t matter how brain dead the 00’s oracle forms app with absurd unsupported EDI submission excel thinga-ma-bob that requires a modem ... <fill in the rest of the dumspter fire as your imagination deems>. Making a tech stack safe is a fun challenge.

Apathetic people though, that can be really tough going. It’s just that way “because”. Or my favourite “oh we don’t have permission to change that”, how about we make the case and get permission? _horrified looks_ sometimes followed by pitch forks.
Dated? They're probably the only place that isn't $comedy "bare metal cloud" pricing that not only has an API for their $5/m servers but also the panel is a reasonably modern SPA that implements that API and uses OAuth for login
The same is probably true for scientists.
Meta commentary: huh, the site feels off, it looks like yet another content farm. The author byline is "jenifferruffalo" and she writes all the articles on that site?

OK, at the bottom of the article, it shows the site just ripped and machine-translated content from Dutch, explaining the weird translation of "Not really proud". It even saw the "subscribe to our newsletter" box, "invalid email address" error message as well as the source news site's "read our privacy policy" and integrated those things into the article.

I guess the reason why this site exists is clear: steal content, get the Google hits and AdSense money.
Working with geographic features and spatial data in MySQL 8
For question one, Wikipedia refers to the source as a “fossil” aquifer, meaning the water has been in place for many thousands of years. It also claims the source is rainwater and doesn’t make an estimate about balance of inputs to pumping effort outputs.

https://en.wikipedia.org/wiki/Nubian_Sandstone_Aquifer_Syste...
Since the introduction of APFS I've taken to creating a new APFS volume formatted as case-sensitive, and put my git repositories there.

This has mostly been useful for working on shared repositories where, say, a Linux user (or other user on a case-sensitive filesystem) pushes two branches, say `feature/foo` and `feature/Foo` which works fine for them, but on a case-insensitive filesystem, git gets very upset.
One giant bad event vs generational damage. Quite a lot of difference.
Check out @kingprotty's Twitter posts and Zig Show presentations.
Technically it's based on whether the output is a tty or piped/redirected into something, not whether it's run from the shell's prompt or a script.

So for instance if you run a bare `ls` from a script that outputs straight into the terminal you'll get the multi-column "human readable" output. Conversely if you type `ls | cat` in the shell you'll get the single column output.

It can definitely be surprising if you don't know about it but technically it behaves the same in scripts and interactive environments.
Sure, depends on how one chooses to define need as you point out.

I don’t disagree, there are a lot of factors going into prioritization and I don’t agree with all of the decisions but at the end of the day, and at least in my state, the notion that this is slowing things down is simply untrue
The humble cassette was a core part of my upbringing. Creating and sharing mixtapes a great way of signalling affection. I treasure the few times it happened, because as a nerd with social anxiety my interactions with the opposite sex developed a lot later than most people. Forgive me:

Oh Frances, how beautiful you were,

Mixed Dinosaur Jr tape I did share,

You returned another, so eclectic,

My crush on you fades electric.
I've used computers all my life and I find iphones really difficult to use.

Not just unfamiliar, difficult.
At the same time, it’s important to understand that the relational model is independent of (and prior to) SQL. SQL is by far the most commonly used language implementation and is important because of that, but it also deviates from the relational model in subtle (and sometimes not so subtle) ways. Understanding those differences and how to accommodate for them can be important to understanding how to write schema and queries in more holistic and powerful ways.
Does “Craft using an inertial mass reduction device”[1] use the same concept as described?:

I don’t know if there’s a difference between this and the Alcubierre drive.

Perhaps the tic-tacs were prototypes, given the patent and claims made by others. They may not be FTL capable, though, at least not within Earth’s atmosphere[2].

If the technology were to exist, it would be seen as a serious weapon and threat to security as much as a tool for colonization and exploration, so why a patent would be filed and left as much is beyond me.

I don’t want to legitimize make-believe things, though, if that is what they are, which is tough to say with much certainty.

[1]- https://patents.google.com/patent/US10144532B2/en

[2]- https://nymag.com/intelligencer/2019/12/tic-tac-ufo-video-q-...
It can also quite easily be solved by using something like nginx's proxy_cache_background_update and/or proxy_cache_lock, depending on wether it's permissible to send stale responses.

Then you could have the cache serve stale content until it's updated, and/or only allow one upstream connection to refresh the cache.

But yeah, unless you allow stale responses or refresh the cache periodically as you suggest, you would still have requests which takes 10 second to complete, but you would at least not crush the upstream service.
OVH is a European equivalent to Digital Ocean.

It has twice the revenue, and is the third largest hosting provider in the world.
I had a boss who would put one simple instruction at the end of the job posting - "Please send your resume as a PDF". This was for a technician job at an MSP. He would immediately delete any applications that didn't have a PDF attached. If I recall, it was something like 60% of the applications he got that he deleted immediately.
That border controls the sources of major rivers for both countries. Water is a critical resource.
I never have. But I've worked with people who did.

One such person had done so effective a job of BSing that he got twice the going rate for contractors in his role. It didn't last long enough to count for much, though, because he couldn't do the work. He was on his way out when I was on my way in; my first major project was salvaging his last one.

Another, with more modest ambitions, joined as a junior on the team where I was then operating as a de facto senior and co-lead. He was a little slow getting up to speed, but he got there, and then spent the next year doing good work, entirely consistent with what I'd expect to see from someone in that stage of their career. When we took him to lunch on his last day, he admitted he'd come in with zero real experience in our tech stack, and snowed his way through the interview with the plan of figuring out how to do the job once he had it.

I won't work with the first guy again. I'd be happy to work again with the second.
Not necessarily. It might not be about the lack of the particular skill they lied about, but the fact that they lied at all and what that indicates about them as a person/employee.
This, plus some form of sum types would be amazing to have imho.
Seems like the US didn’t enforce antitrust laws and allowed YouTube to grow into a monstrous monopoly, because they wanted Internet revenues to all flow into America rather than into a variety of companies, some of which might end up not being American if YouTube was split up. Seems like a pretty bad deal for literally everyone.
They are different physical buildings. OVH does not generally claim anything regarding AZ or distance. SBG1, 2, 3, etc is just denoting the building your server is in - they are not like AWS style AZ or similar, quite literally just building addresses.

I have used them for years and I don't believe they've ever said anything like deploy in both SBG1 and SBG2 for safety or availability, because you don't get that choice.

When you provision a machine (eg via API) they tell you "SBG 5 min, LON 5 min, BHS 72h" and you pick SBG and get assigned first-available. There is no "I want to be in SBG4" generally.
I never inflated my resume but I can understand that some *GOOD* candidates might inflate their years of experience out of a bad suggestion from recruiters, or because they see other candidates do the same, or because many companies greatly inflate the requirements.

Even more so if exaggeration is part of the culture they come frome.

HN loves to play armchair psychologist and make claims about people's honesty and trustworthiness based on a CV.
I can sympathize with the tone. I recently attempted to move to the latest `tokio-postgres` as the old synchronous version is no longer supported (the new synchronous version uses Tokio under the hood which plays havoc if you use with actix-web [two different executors]), the problem is I'm using it with CockroachDB which effectively requires transaction retries (for savepoints). I've yet to produce a ergonomic tx::retry wrapper that doesn't have lifetime issues (for primitives supporting Copy it's all good).

With the asyncification of the Rust ecosystem it does make life difficult. Maybe the Rust async implementation is fundamentally sound, but the user experience for non-trivial cases isn't quite there.
Used to work for a small Ad-Tech firm in Germany. GDPR massively dented the business WITH NO BENEFITS to privacy. Advertisers still collect shit tons of data, your website performance is still crappy and the end result was that EU users now have to navigate MBs of Javascript popups, that try to trick me into selling data using dark patterns (blue highlight on accept all instead of Reject all).

All it succeeded was in consolidating the ad-tech space into a few big players and resulted in acquisitions of many small ad-tech firms.

An acquaintance of mine started a medical Tech firm and is now a consultant for dealing with govt. rules on medical stuff. Not sure why he quit , but I believe that consulting for dealing with German/EU bureaucracy maybe far more lucrative than having a medical startup in the EU.

Not to mention, despite the first world status, internet is Germany is Dog-shit. I mean worse than 3rd world crap. I was in Bangalore and I had way better internet 3 years ago.
Many global apps start as CRUD apps, and only become high-tech with scale. And even at hyperscale companies a lot of software engineering work is probably "basic CRUD" - reading from one system and writing into another, without applying a radical transformation to the data in the process. And even doing that well is quite challenging, which is why the average software developer gets paid well.

It's great if your talent allows you to do much more than that, but I wouldn't deride it, and much less hate it, when your own success is likely going to have to rely on competent people around you doing that job extremely well.
Nonsense told to me repeatedly by recruiters over the years:

- (your point) no incentive to send you for an interview if not a good fit.

- "I make more money if you make your money" often said to spin the "what is your salary requirement" question

Most recruiters work for an agency. Agencies have accounts with businesses. The account is central. You are in no position whatsoever to make determination as to what incentives drive the recruiter's business.

Recruiters also routinely b.s. young developers by "I get more if you get more money" when pressuring them into agreeing to a "salary expectation" right at the beginning of the employment negotiation.
I don't have to "backup servers" for a long time now. I have an Ansible playbook to deploy and orchestrate services, which, in turn, are mostly dockerized. So my recovery plan is to turn on "sorry, maintenance" banner via CDN, spin up a bunch of new VPSes, run Ansible scenario for deployment and restore database from hidden replica or latest dump.
Apple has been sued multiple times in the EU because of onerous warranty practices and lost. Obviously their working warranty doesn't work so great.

There's at least one website tracking GDPR fines. It's gonna take a while given that everyone is illegitimately collecting data on their visitors/customers.
Review to consider feasibility of Scotland-Northern Ireland tunnel
Ask HN: Audiobooks that you can enjoy during a run?
I spend nearly an hour everyday walking or running. I would like to have a few good audiobooks that are more enjoyable to listen to while moving. Since I am outside, I can get distracted sometimes. I still would like to be able to follow the audiobook inspite of the distraction, if possible.

For reference, I found these two talks most enjoyable to listen to inspite of moving at a fast pace. The speakers are so engaging, I was riveted and totally focused. I want to discover audiobooks which are similarly engrossing in different fields.

https://www.youtube.com/watch?v=vtIzMaLkCaM

https://www.youtube.com/watch?v=Unzc731iCUY
Looks like Keycloak's certificate is only valid with `www.`: https://www.keycloak.org/

> - Keycloak (you won't get fired for picking this)[0]

Curious what you mean with "you won't get fired for picking this". Do you mean that it's good and easy to run, or something else?
The last update I got from them said:

> In the last two months, we have been actively working on hardware validation, covering all the use cases with tests, and now we are almost ready to lock the BOM and start Flipper's production in EVT (Engineering Validation Test) phase. Devices from the first batch will be sent to contributors who participated in the development.

That seems like they're pretty far along.
With FTL you could wish yourself a good trip before you left.
Would you have one example of "how Obama is still seen as the messiah to socialist[s]"?
I actually don't mind the acronymed stuff so much. My primary complaint is that the names are so generic that you can't differentiate the products by name except by memorizing them. For example:

* BigQuery vs BigTable (though, there are at least some hints in these)

* Cloud Storage vs Filestore vs Datastore vs Firestore (vs Firebase? How are these related?)

I can of course make an effort to keep these straight, but then having to clarify in every design convo because my manager can't, or having a hard time googling (lol) things germane to the product I'm on, etc, is just a huge hassle.
Yes, it's a bit like a Steve Jobs situation.

In a Dutch eulogy I read yesterday it has the anecdote of him showing a wooden block that would fit in the inside pocket of his jacket and decided for the team: this is how small the music cassette should be. He also quickly negotiated with Sony when they started to copy the design to make Philips' design the universal standard.

Edit: Found this quote in Cassette: A Documentary Mixtape (2016):
"You can credit me with a few ideas. But the designers developed the device. I haven't done anything special. "
> restore database from hidden replica or latest dump

You do have backup servers.
Show HN: Weferral is an open-source referral or affiliate management software
The current ruling government (comprised of a shotgun marriage between two opposing parties) disintegrated, right?

My understanding of Israeli politics is that it's two major parties (roughly, conservative and liberal) + a few smaller bloc parties that generally line up with the same major party.

And that the math of this vs the majority needed tends to result in a larger number of elections.

I believe something similar tends to happen in Italy? And maybe Spain?

The flaw, in the sense that overly-frequent elections are unproductive to the business of governing, as I see it is matching a static legal mandate (a government must be able to compose a strict majority) with a variable system (number and size of parties), that leads to some edge cases that make the former difficult / unsustainable.

I'm American though, so I'm looking at this from our (probably to the rest of the world) crazy winner-take-all tilt.

It seems like parliamentary democracies would be improved by either (a) implementing policies and laws that ensure a larger number of smaller blocs, with which alliances can be made (preference voting?) or (b) having "deescalator" clauses if election churn happens, to lower the threshold required to form a sitting government (which then presumably ramps back up over time).
I updated "many" to "tens of thousands", since the word "many" is too subject to interpretation.
Absolutely, but the events are not comparable. Sacrafice at Chernobyl might save thousands, sacrafice at %xcorp% saves a fat bonus for the guy responsible for the whole mess in the first place!
Can't we just ban online targeted advertising?

Because I'm getting tired of all these stories. When will it stop?
> After extensive, long-term, high-quality studies of the effects of (mid- to low-level) radiation on populations after Chernobyl

Ever heard of the Chernobyl babies born in Poland and Ukraine? My wife happens to be in that category and safe to say she has plenty of similar issues to other people in the same 'category'. Thyroid issues are a serious problem for many young women around here and it cannot be a coincidence.

But I still do believe that nuclear is the way forward without doubt though. Just that these studies seem to be way off with the ongoing effects.
it's not a digital EURO, it's a cryptocurrency scam

EURO is not something random people can use to promote their ponzi schemes
I had my server in SBG2 and sadly the backup failed since the end of january. Yep it is my mistake for not checking the backups. Now I lost about 1 month of data.

The only good thing is that my backup was offsite.

Does OVH offer automatic snapshots for VPS? I know Hetzner does it for 20% addidation of the cost of the server. If they do the next question would be if they are destroyed too?
OVH STARTED as a budget VPS service some 20 years ago... but they grew a lot since 6-7 years, adding more "cloud" services and capabilities, even not on par with the main players...

Why not use AWS/GCP? From my personal point of view: as a French citizen, I'm more and more convinced that I can't completly trust the (US) big boys for my own safety. Trump showed that "US interest" is far more important than "customer interest" or even "ally interest". And moreover, Google is showing quite regurlaly that it's not a reliable business partner (AWS look better for this).
iCloud Secure Backup Comes to macOS
That seems like something that would cause talent to nope out of the degree of apparent incompetence.
Seconding ‘El incidente’, definitely worth a watch.

Also Blame on Netflix although different sort of theme to this is worth a watch if you want your megastructures itch scratched.
Are “bring your own storage” apps a thing?
Are "bring your own storage" apps a thing?

I'm being inspired by draw.io, a web app for creating diagrams. Notably, it's not crammed with useless information and the user remains in charge of their data. A diagram can be stored as a file to your local device, Dropbox, Google Drive, OwnCloud or any other similar service.

In contrast, let's look at MyFitnesPal. Upon opening the app I'm faced with news, cookie confirmation dialog and sometimes promotional pop-ups. All this to simply input my body weight.

If MyFitnesPal followed a draw.io model, it would be a simple app with a couple of .csv files as a backend.

Is there a market opportunity for new breed of apps that are:
- minimalistic in design and features
- user remains in charge of the data by using text files as storage and by giving them a choice on where to store them

Where do I find people who think alike?
Tennis is one on one, typically. And there is vulnerability in trying your hardest at anything.
So your defense of Coldfusion is a javascript templating language that is over a decade old and has implementations in 30+ other languages?

And then you further defend it by admitting, "The problem with ColdFusion was that it went in the wrong direction"

I'm confused.

Yes. That's why it's terrible. Most things that go in the wrong direction usually are terrible.
Counterpoint: There's a constantly updating timestamp at the top of the page that suggests it's automated and real time.
Probably I'm missing something here, but anyway, I think a definition of life should not be based on self-reproduction.

Indeed, most of what we perceive as 'alive' does self-reproduce. But that might be just a consequence of the fact that a bulk of autonomous material is complex and can rarely occur on its own.

There have probably been some forms of life that could self-reproduce, as well as species that you would really call alive but could not self-reproduce. However, only the self-reproducing ones did grow in numbers and that is almost all we see today.
Sadly, it’s not as rare as it should be. Most of us here have limited experience with jobs where the company doesn’t respect you much and is confident that you can easily be replaced. Unless there’s a union the odds are pretty good that you can find a manager like that at a large organization once you get out of the high-status areas - especially when it’s something like an outsourced labor company where margins are low and replacing people doesn’t have much visible impact on customers.

At a tech company, anyone from the helpdesk down on the status ladder probably has a risk of this. Think about what it’s like being a cafeteria worker or janitor at a place like Google or Facebook where the managers probably joke about you as the example of where you end up in life if you don’t work hard.
Log streaming: What it is and why it matters
I've been developing mostly in Rust for the last five years. C++ for decades before that.

It is always comforting to dismiss something that you haven't made much effort to understand as unnecessarily overcomplex. I think we're all guilty of that at times.
Log streaming helps you respond to incidents in near real-time #Log #Streaming
Don't be silly Have a plan
Simple Bipedal Robot