skysight-inc/HackerNews huggingface dataset:
Well, I would say you had bad sectors on your disks, if there weren't too many of them, most modern file systems can handle it but still there are possibilities of losing data. But nonetheless, it's a signal to start migrating data.

What I meant for disk failures was really disk failures, there would be no way directly get data out of the disk unless you open it and directly read the plates, in your case, all your data would be totaled as RAID0 offers no redundancy and thus tolerates no single disk failures at all. Your data seems not much and it would not be that hard to migrate a 4TB array. Things would be completely different if you will have to rebuild more even worse migrate a much bigger array i.e. 4x10TB ones. Even if everything goes on well, it will take a few days just to copy the data somewhere else. If there were cascading failures, then there is really not much you can do. I can promise you that once you went through all those nightmare, you will never ever want to do it again. Take into those cost/effort needed, whenever I need to build a personal NAS, I always go with 2/3 biggest capacity NAS/Enterprise HDDs available and leave at least 1 vacant bay so that I can easily add more space without fiddling with existing drives. Even if the NAS eventually become full, I can still simply replace smallest drive with a bigger one and copy the data back.
.replace('"tarzan"','12345678')
The economic cost of climate change is around $16 trillion right now, and still growing [0]. The economic cost of COVID-19 is probably about the same [1]. It seems hard to argue that climate change is a "minor threat" and "completely dwarfed by" the damage of coronavirus. I dunno about overpopulation per se, since part of that drives the economy, would be tricky to count the cost.

[0] https://www.theworldcounts.com/challenges/climate-change/glo...

[1] https://www.weforum.org/agenda/2020/10/economic-cost-covid-g...
Am surprised that in such a long thread nobody mentions RethinkDB.
Maybe I didn't get your point correctly but this seem actually doable in PostgreSQL.

You could create a custom type based on jsonb type with a trigger to enforce the types inside the jsonb. You could as well write some functions to ease manipulation of such custom type.

There is no out of the box light syntax to do that right now but this could be implemented in a future update/extension. Just look a the complex and successfully implemented geodata types brought in by the PostGis extension.
The GROUP BY section is odd:

> You can use as to name scalar values anywhere they appear. Except in a group by.

-- can't name this value
> select x2 from foo group by x+1 as x2;
ERROR: syntax error at or near "as"
LINE 1: select x2 from foo group by x+1 as x2;

-- sprinkle some more select on it
> select x2 from (select x+1 as x2 from foo) group by x2;
?column?
----------
(0 rows)

Looking at that first one I'm just kinda like "well duh, there's nothing special there" - it doesn't work with ORDER BY either, you use that to rename columns (on SELECT) or tables (on FROM and JOIN).

And then it goes on to show ways to work around that:

> Rather than fix this bizaare oversight, the SQL spec allows a novel form of variable naming - you can refer to a column by using an expression which produces the same parse tree as the one that produced the column.

Instead of just... using the renamed column?

select x+1 as x2 from foo group by x2;
Depending on your database, it may be worse than just shorthand syntax. I encountered once a DB (that shall remain nameless) where replacing this syntax with the actual JOIN keyword resulted in dramatically better query plans everywhere it was used.
The article isn't against declarative programming. The author alternative declarative solutions throughout the article.
It doesn't look like it follows links though, so it's much more of an alternative to "Save As -> mhtml" than to HTTrack.
> People: write simple, portable code!

that does not work as soon as your users are on both windows and a unix-like platform and you are making a non-trivial app (for instance, an app with networking, audio, and video support).

A simple example: how do you share a GPU texture handle across multiple processes portably with a single code that works across windows / mac / linux's graphics APIs ?
It's true that interruptions are a source of significant cost for programmers, but the other side of the coin is that talking through problems and design decisions with other programmers can generate a massive gain in productivity.

Let's say you are struggling with a design choice, or something in the production system looks screwy, how do you know who you can approach to discuss this?

Well, the way i've worked in the past (when we used to all sit in an open plan office which seems like an age ago) was that you signalled 'do not disturb' for those times when you needed to be in the zone by putting headphones on. You weren't necessarily listening to music, some of us did, some didn't, but it was used as a clear signal that you shouldn't be disturbed.

The result of the headphone rule works pretty well. I've worked places where there's been a full production meltdown, serious money being lost (well, not earned) due to the downtime, and all sorts of people and teams being pulled in to help identify and resolve the issue, meanwhile on the same desk someone in headphone mode being totally unaware of the problem.
go Svalbard, a visa free territory of Norway.
But it wasn't about the "stalkee's life" it was an imagined story inspired by imagined characters inspired by the situation she observed. Cat Person wasn't like Charles - Charles seems to have been someone else entirely. I can imagine going to a BBQ and meeting Charles and liking him, I don't think that would be the case with Cat Person. The people who are the villains are the ones who looked at Charles and decided that Charles was Cat Person - they are like people who look at blond girls and think "idiot" and people who look at black people and think... well I won't go into what racists think. It's not the same - but it's similar, it's prejudice - less harsh and less pervasive, but it's how dumb people operate.
SQL is often conflated with the relational model (hence the term NoSQL for non-relational databases), but the article is careful to explain that the relational model is great, but SQL is a clunky syntax/standard.

Going to graph databases is certainly throwing the baby out with the bathwater. The relational model was invented to address shortcomings in the hierarchical and graph database models.
> Also, in some traditions, having an old dude suck on their dick after having said portion cut off.

Curious to know which culture is that?
It is your free time, you build it to whoever you want it to.

Most often this will be you and people similar to you.

Less often you build it for a friend and people like them, or an organization you care about and organizations like them.
It was: Fan-fold paper and ASCII art
It's a pretty good story though - much to admire about it.
GDPR has exceptions for fraud detection.
I find that the use of this technique, plus banning NULLs (handle them in application code), promotes user sanity. My 0,02€.
In other words, "it's a bad argument but it's okay to use it to push liberal causes"
If you ever played OpenArena I would be curious what you think of the communities playing OA or QL. Coming from the small OA community when QL launched, I found QL players somewhere between hostile and mute, so I only played a few weeks before leaving that scene. There isn't always constantly friendly chatter in OA, but on occasion there is. In QL I often wouldn't even get answers to direct questions (I don't remember what, but I remember it was a thing I'd expect most players to know). The number of cheaters in OA was also, well, normal to me, but I suppose very low by other standards. The number of people that wouldn't stop and had to be banned from servers can be counted on one hand during the years that I had rcon on some servers.
Surely that's how all characters are constructed - from the authors imagination? Where else can they come from but via the lens of the writer?
I find that I have to put myself in a state of deep dissatisfaction in order to develop the motivation to dive in. If I get interrupted before accomplishing anything then I'll remain in a bad mood. And if I think I am going to be interrupted then I won't even start the first dissatisfaction step because I don't want to be stopped halfway. One workaround for that is to define the work in smaller pieces so that interruptions are less likely, but that also takes work.

I'm reminded of a scene from the movie 'Never Cry Wolf' where the bush pilot, while flying the plane, puts himself into a state of rage before stepping outside to fix the problem.

https://youtu.be/9i90_-HpVz0?t=120
This reminds me of a recent post on HN, The Algorithmic Beauty of Plants:

http://algorithmicbotany.org/papers/abop/abop.pdf

https://news.ycombinator.com/item?id=27240927
There was a shift to Anglo-Saxon culture already after World War 1 because of the outcome of the war. As an example you can see that in first names of people born in the 1920s
They meant that you cannot once a piece of code is released by GPLv2 you cannot unrelease under GPLv2. So even if every new version and contribution is required to specify a GPLv3-or-later license all previous contributions and versions are still in GPLv2-or-later, which is more permissive.

I think the comment was addressing a misconception around how the project as a whole is licensed and its individual contributions or past versions are licensed and the fact that GPLv2-or-later works cannot be revoked as the user can always freely chose between the GPLv2 and the "later".
I wish all the CMake haters invested a fraction of their energy putting together a tool that they feel was superior to CMake, or at least a better alternatice.

CMake has been around for a few decades, and perhaps a dozen alternative makefile generators and higher-level build systems already popped up, but still each and every single one of them failed miserably in gaining any traction.

Why is that, given that CMake is indeed far from perfect?

The truth of the matter is that CMake is, by far, the best buildsystem/makefile generator for C and C++ projects that there is right now. And this has been the case for a couple of decades. Not only does it work reliably but it is also extremely easy to setup and use in the happy path. With cmake anyone can easily create a project that includes multiple libraries and executables that consume system libraries in a matter of minutes right on their first try as a "hello world" onboarding project, and that project will work on multiple platforms and on any CICD pipeline.

I would very much prefer to see a fraction of the energy wasted in hating CMake being channeled into making a cmake alternative. But for some reason, all we see is hate.

Why is that?
> Why should we cater to the lowest common denominator?

The options aren't just complete beginner vs math PhD though. Imagine an experienced software developer who has written these kinds of algorithms in other languages and has never used latex. That's the kind of person you're also keeping out. Are they "the lowest common denominator"?

I also don't know why you assumed that the people who are most likely to use this code like this are automatically people who already know the glyphs.

It's gatekeeping not just because there is barrier to entry. It's because that barrier is artificial, unnecessary and comes with a smug feeling of superiority (you aren't the first person to use "lowest common denominator" in this thread).
But the article here makes it clear it was fiction - Charles wasn't that guy, "the hostile text messages were alien to me".
How to Show Hidden Files and Folders on a Mac
There are lots of people making money off photos taken with phone cameras. Of course photography snobs will not consider these people to be “serious” photographers. Serious photography means taking photos of bored-looking attractive women in awkward poses with a blurry background :)
Note that Lytton commonly gets over 40C in the summer.
> SQL is often conflated with the relational model (hence the term NoSQL for non-relational databases)

Still not confused enough? Check this out: http://www.strozzi.it/cgi-bin/CSA/tw7/I/en_US/NoSQL/
The first statement is pretty close to a sentence in English. A non-programmer is somewhat likely to understand what the first statement means, but is not likely to understand the second without training.
Not really, I would say France is closer to Ireland culturally than Oklahoma.

For example, Catholics are the largest religious group in Ireland and France. Oklahoma is only 4.9% Catholics with Baptist being it’s largest religious group.
I'm afraid browsers stopped being "user agents" a long time ago. It's one of my pet peeves. They're agents of whichever company rolls them out. Basically Google or Mozilla. And they defer to the whims of whoever built the website you're visiting for a good chunk of their (insane) behaviour.

If they were actual user agents, you would still have control over a lot of behaviour that's now been removed. Like actually remembering form fields you want to remember (instead, some websites tell the browser that it can't remember the user name, and the brower foolishly obeys). Or like copy/pasting text. Or like using the right mouse button (some websites disable it). Or like having control over keyboard shortcuts, which some websites override and which can't trivially be fixed.

In my book, a user agent acts in my interests and on my behest. Sure, most of these behaviours can be corrected using browser extensions, but requiring a boatload of extensions to have an actual "user agent" doesn't make me happy.
Programming is like riding a bike. It takes time to get on the bike, to get momentum going. Interruptions are like someone hitting you with a stick while you ride.

Getting hit, falling off, and climbing back on the bike takes a lot of effort, and you have to rebuild your momentum each time it happens. The more times you're knocked off in a day, the more tired you get of climbing back on.

Rebuilding the momentum when programming can take 30 minutes or so. Then you just get whacked with another stick.
SQL is not controlled by single entity? Arguably there is foundationdb (sort of) from Apple.
I believe it's which half of the story she fictionalised which bothers people.

She didn't take two fictionalised people and give them someone's perfectly normal, boring sex life.

Instead she took two real people including detailed descriptions of them accurate enough that they could later be correctly identified.

She then twisted their relationship to make one a victim and the other, her former romantic parter, a cartoon misogynist.

Those that recognise the people involved may well still think "well there's no smoke without fire" regardless of her claim that it's all "fictional".
That is not a bad idea at all. I could maybe travel via Russia, if cannot enter Norway.
Fascinating. Thank you for that, Let's reproduce that success in France
It's just karma wh*ring.

Notice how I will go negative karma just by pointing it out.
I don't think this is a great example. The Objective-C to Swift transition going smoothly is only because of Apple's almost total control of the ecosystem (I mean this positively).

Apple is automatically the loudest voice in the room for iOS development. If they embrace Swift, the writing is on the wall for Objective-C. It's not just sticks, I'm sure they also put a lot of effort into making the transition as easy as possible.

In SQL - there is no equivalent. I think a better example is x86.

It took a generational new form of computing (mobile) to give ARM the momentum to seriously challenge x86. It's been almost 15 years since the original iPhone and we're only now seeing ARM based processors in computers.

SQL IMO is EVEN harder to displace than x86. x86 has a massive ecosystem but only only two serious manufacturers. SQL has a similarly massive ecosystem AND is the de facto language of the vast majority of major databases. Going to be very hard to unseat.
I really like the core idea behind this – an easy way to permanently save & categorising important messages from ephemeral team-based services such as Slack and Teams is an ongoing problem.

Breaking information into smaller pieces managed by individual users instead of large team knowledge bases is a lot more maintainable. It also makes sharing knowledge a lot more useful and flexible – that's something I've learnt from building my startup [1] based around short-form note-cards rather than long-form documents.

I know it's early days, but it did take me a little while to figure out what AirClick actually does just looking at the landing page. Maybe have some specific examples of different use cases instead of "Topic 1", "Topic 2". You've already done the hard bit with the UX!

Also I would encourage you to distinguish your logo a bit more from AirTable. Your name is already similar, and the last thing you want is new users thinking all your hard work is another AirTable product. Hope that helps!

[1]: https://supernotes.app/
https://news.ycombinator.com/item?id=27789380
Replacing SQL is a tough sell because at its core, it really does work pretty well for what it was designed to do. (i.e. not most of the things they've bolted onto it and the corresponding databases this century) But it's not a silver bullet and people should stop trying to jam things into relational databases that aren't a good fit. There are already a number of potentially useful alternatives out there depending on your particular problem.

In the event that nothing exists that is right for the job: don't worry about replacing SQL, worry about creating/using a matched DSL/API/(whatever is appropriate) and data store for the particular problem you're trying to solve that SQL isn't a good fit for. If you create something that solves its particular problem even half as well as SQL did for relational databases you'll probably have a winner in that space that people with the same problems would be happier using.
Asking the user yes/no on first start would be easy. Then it’s opt-in.

They stopped tracking by default in safari which is similar.
I still don't understand.

If you're using, say, SBT and you like it, why do you need Earthly again? And if you don't like it, why don't you replace it if it's possible to replace?
An 80yr old friend said, "the third job is the good one". I would worry less about changing job if I was unhappy.
Me too. I always say: You can wear warm outfit, but you can't strip cold.
Hardly any vaccinations? https://en.wikipedia.org/wiki/Pulse_Polio
This. It’s what the C64 (and I guess many/most early home computers) did. No need to draw the whole vertical line if it doesn’t reasonably fit.
> So, what is the difference here?

If one company had all of SQL market share and they switched to a new lang, everyone else would have too.

But that's not the case here.
Ink programming language
> Most of this opinion comes from “SQL” being vendor-specific. Is JSON vendor-specific? Is anything else, that we actually use by choice?

Two things that come to mind are Markdown with all its flavors and Regex with multiple engines.

edit: and to a lesser extent maybe C/C++ compilers and JS engines.

edit2: also JVM, Python and Ruby runtimes

But both edits describe technologies with an official spec and slightly different implementations. Markdown/Regex are more comparable to SQL because they have vendor-specific syntax.
I totally agree.. I like the idea of YAML and source control for pipelines, but unless you're already very familiar with the system it is much slower. Fortunately there's a "Use the classic editor to create a pipeline without YAML" option to use the previous system.
Cautionary Tale
For me the opposite is true. The value of multiple vendors with a similar product is that it drives prices down and liberates me from a lock in. I genrally avoid managed services that are not available from all three major cloud providers, and put abstractions between my suff and their so I can move my workloads around.

As to SQL. Its a weird feeling to read all that; I've spent 15 years working with very large relational databases -- and about 5 years ago I ditched it all in favor of using key-value object stores, wasting some storage but saving a metric ton of manhours of development work. Not looking back.
> some glyphs are bigger than the 5px by 11px bounding box

Out of curiosity, which ones? Did anyone find them?
People with a lot of skill in video games also cheat, BTW. They're not all zero skill relying on the hacks to compete at all.
I think that in some highly developed societies, and in particular in Scandinavia, this trend is actually good for endangered languages. The lingua franca of Scandinavia is English. The region, which is comparable in population size to a large German federal state or a medium-ish US state, has four different majority languages (Danish, Swedish, Bokmål, Nynorsk, all mutually intelligible, which increases the acceptance of imperfect language) and dialects play an important role for local identity. Of course, as a Scandinavian one has to learn one of these four languages to some extent, but the growing importance of English -- as a consequence of almost universal English proficiency and an influx of skilled foreigners not only to the capitals but also to the periphery -- narrows the gap between these languages and minority languages like Elfdalian and Sámi. As a consequence, the appreciation of the general population of language as a form of local identity also grows.
Introduction Guide to FP-Tree Algorithm
Depends if you are making or buying one.
If the difference between GA and Cloudfare is only bots, then the problem is pretty terrible..

"80% of my traffic is bots"
Incredible little detail. I'm pretty sure I have a bunch of disks with similar issues that I couldn't diagnose because I'd never consider this a critical failure point.
We do - https://www.whisper.cash/whispercash.pdf . WhisperCash is completely P2P and offline and bank policies are enforced by an on-card component (the "policy enforcer") that can require certain transactions to be performed online.
It's a rather crass phrasing of it, but GP is referring to Judaism.

https://en.wikipedia.org/wiki/Brit_milah#Metzitzah
I think I'm experienced enough to understand the article, and I agree. I've written multiple optimizing SQL generators (altering generated SQL to access better plans), and rewritten hundreds of queries for better performance, which involves trying many semantically identical rewrites of the same query.

I agree with Jamie. I think SQL is irritatingly non-composable, many operations require gymnastics to express, and I'd like a more expressive and regular language to write queries in.

I also suspect that such a language would be harder to optimize, and might be more practical to implement if it was less declarative and closer to the plan.

I also think that as you scale up, offloading computation to the database is a false economy. It's closer to the data, but the database itself is a bottleneck. As you scale, you want to limit the complexity of your queries. But this is actually an argument for things like Materialize, i.e. making copies of the data elsewhere that bake in some of the computation ahead of time.
This comment seems unnecessarily combative. If you just said “beyond the effects of climate change, I think a major threat is the depletion of fossil fuel stocks which will lead to regional conflicts” pretty much everyone would be on board.
I guess that’s cultural then - here it’s polite to stay quiet in a cinema.
I keep some alive but they are really just burning my budget which is quite poor since I am a full time indie wannabe so I consider shutting them down.

I will probably leave Wanderers tho - https://wanderers.io/