skysight-inc/HackerNews huggingface dataset:
Every 1st world nation on Earth currently has or is flirting with population decline except for immigration, and birth rates have consistently fallen with economic development in poorer parts of the world, and the world fertility rate is current 2.5 births per woman [https://data.worldbank.org/indicator/SP.DYN.TFRT.IN] skewed by underdeveloped nations.

The UN projection for total world population tops out at a little over 9 billion by 2050, and possibly up to 10.8 billion by 2100, but that figure is disputed as more recent population metrics have shown fertility rates crashing faster then usual in nations as their development ticks up - a likely outcome is a peak of 9 billion in 2050, followed by a steady state (ideal) or decline (actual problem since there'd be no reason for the trend to reverse after that) [https://en.wikipedia.org/wiki/Projections_of_population_grow...]
HN is in the vanguard, though. The crowd here is not representative of the state of the global online population at any given time, but one could say that global online sentiment tends to trail the HN sentiment by a number of years. But it's not just HN. Not by any means.

The audience for our website (gambling) tends to be both technologically sophisticated and very conscious of their privacy. Their behaviour has also been quite reliably an early indicator of a wider change. As it stands, more than 80% of page requests block analytics, trackers and other external crapware.

The players in other industries have to prepare for the coming wave, because it will hit them soon. About time, too.
Got the bus from Scotland to Amsterdam with nothing but a box of ham sandwiches to support a friend. I've been married to that friend for 25 years now.
This is a great article and you can tell the author has deep experience with SQL from the way they speak and the other projects they're involved in.

I think many of the comments here are missing the point by saying "Oh you can get around that issue in that example snippet by doing X Y Z". Sure there are workaround for everything if you know the One Weird Trick with these 10 gotchas that I won't tell you about... but that just makes the authors point.

We can do better. We deserve better.

What could things look like if you could radically alter the SQL language, replace it altogether, or even move layers from databases or applications into each other?

Who knows if it will be better or worse, but I'd like to find out.
Climate change is liberal? I wonder where the standard model of physics lies on the political spectrum…
One of the comments there raises an interesting question: this is plain old criminal fraud, right? (Whether this person is actually telling the truth is another matter, of course.)
That has nothing to do with external visitor analytics, though. I've implemented log sending from frontend to backend multiple times. First party, same endpoints as other requests. Not getting blocked.
How about a jacket with air conditioning?

https://wonderfulengineering.com/japanese-invent-a-jacket-wi...
The author uses the term "union", but unfortunately they picked the one wrong term against a long list of correct alternatives: sum type, tagged union, discriminated union, coproduct, disjoint union, variant, algebraic data type, ...

"Union" does not imply disjointness (which is the source of many problems), whereas all those other terms do.
It’s strange that all those lawyers can create top-notch CS research though..
It looks to me like you’re wanting to make a counterpoint to the person you’re responding to, but he did put ”bookkeepers” in the same category of people who tend to need deep focus and not be disturbed. Do you agree that not every role shares that quality, and that the parent comment has a point?

If you were agreeing with him and just adding to the argument, then my apologies.
There are certainly all sorts of reasons for poverty, but I'm just pointing out that poor people aren't always poor because they're trapped in a vicious cycle. Sometimes they're impulsive or don't have a way of thinking about the future. Also that that way of life seems to be quite enjoyable. It may be not something that needs fixing. Who says accumulating wealth is the most important goal in life? One such person I know had a good upbringing with proper education and professional caring parents and all that but can't hold onto money. It's not about lack of opportunities but maybe mental illness or far-from-normal personality or somehow just doesn't care about long term planning.
Many years ago I used to run a games service [1] (spanning q1 to q3, plus Unreal and various mods for all engines) and often had people message me occasionally about player X or Y cheating in various ways (these were the days before PunkBuster, but it happened more or less continuously).

Since we had extremely low ping when at the office (comparatively to dialup), we had a bit of fun jumping on servers to do a bit of “cleanup”. I’d play patsy under a generic handle, go to specific places in maps (around corners, etc.) I knew were impossible to track without wallhacks, and after getting fragged in impossible situations we’d all switch skins/handles and go to town on the cheater(s) like the ride of the Valkyries.

A few (ok, maybe twenty) years later, though, I got kicked out of a Quake Champions match because, well, I have a knack for railgun timings and am constantly switching weapons, so it wouldn’t be unusual for me to rail someone and then finish the job with a mid-air rocket. Which is tricky when you’re doing it with unfavorable ping (was using NVIDIA’s Mac client[2]).

Fun times. I still have ioquake on my Macs, and built a tweaked Q3A image for the RaspberryPi with OSP and our skin packs for the sheer nostalgia of it.

(Edit: Quake Champions, not Live. I only played Live a couple of times)

[1]: https://taoofmac.com/space/games/quake_iii_arena

[2]: https://taoofmac.com/space/blog/2018/09/30/1600
I suspect in the next 5 years we will see these extreme events normalized, but as a result the governments around the world will begin acting & passing quite extreme laws to try to mitigate the problems we face.

Climate change, ecological collapse etc in the last couple of years has only really just began to strike home and it will make COVID look a walk in the park.

Massive amounts of spending will be aligned to green technologies, carbon capture, re-plantations etc and a divestment in things that make no sense will take hold.

Engineers will stop wasting their time developing pointless products and dedicate energy into real-world applications that can help humanity keep the world as we know it.

It will be every sentient beings responsibility to fight for the environment, or we will lose it, and, if we get caught up fighting ourselves, we very may lose it all.
This is the cheat tool the article refers to: https://www.userviz.com/index.html
QA: Yes it's completely safe to buy current version as it is going to be updated with the revamped software.

Thank you very very much for such a detailed experience. It's super helpful and I will address it. I've learned that behind one person with certain problem there are number of people that will just abandon it without ever being vocal about it - so it's pretty much always worth to fix what at a fist glance might look like an individual experience. Sorry that you had to dig for answers.
...what is described here for programming is the case for most creative work where we weave something into a tight compact whole... also in academic writing, where you build up to the moment of writing by copying all the papers you need into your head... and any disturbance empties the cache and sets you back the 30-40 mins again...
FBI Warned Cryptocurrency Participants to Be Aware of the Ongoing Attacks
And I wonder how much of nature works the other way around, and how our biology is fit for unleveled playing fields. Make things hard to see who's the fittest.. not the other way around.
The analytics code is built into the engine, for example https://docs.unrealengine.com/4.26/en-US/TestingAndOptimizat...

Nearly all games would have some sort of client side analytics, multiplayer games will also have a lot of server side stuff.

In fact analytics in games is so common that today it’s a “meta” mechanic in most games, this is what achievements are. The lazy type of achievements are nothing more than adding fake points to something that the game developers were already tracking internally in the hopes that it would promote engagement.

However very few games are actually doing achievements well the best example of how to do achievements in a meaningful manner is probably Halo with its skull mechanics since those actually majorly impact gameplay and thus adding a lot of value to the player.
Yes. Seriously. Not everyone is competing in the same rat race to become the richest person. Money isn't the most important thing for some people.
As far as I know that number, 134F, is not considered accurate. The trusted number is just over 129F (129.2F) where Death Valley and Kuwait City are recently tied. This is only the hottest place where people live though.

The actual hottest place is the Danakil Depression of Ethiopia. The air is toxic around the hot springs due to high sulfur content and so almost nothing lives there except pools of exotic bacteria.
Invest in Antarctic real estate! It's not a catastrophe, it's opportunity! (albeit however short-lived)
I will make it much clear on the website ASAP.

1) You cannot try it yet :)

2) You can safely buy current version as the next update will replace it - as in - you get the new software.

3) I need a few more months to finish it but I want to release the rendering part of the app (simply without animator) for my patrons in July - https://www.patreon.com/spritestack
nah, you are bsing, the article is about legit concerns, you failing to see any of that or naively/foolishly believing the innocence of the legislators is your own problem.
This web site is amazing: every so often some webshit dipstick who doesn't grok SQL writes an essay bitching about it (instead of learning it!) and it ends up here. Enough with the bitching against SQL and promoting JSON webshit already! If you can't grok SQL, you should consider a career completely unrelated to computers! What the hell has this industry come down to!
no such thing as shoot or why or not, cepuyuax, say any nmw s perfx
Maybe the objc / swift difference is great enough to justify such change.. meanwhile the query languages have not evolved enough to do so .. just wondering. Maybe ask the datomic/datalog folks.
That’s basically libel at this point. How about actually adding some facts to your bullshit here and there?
FYI - SpriteStack has a direct support for PicoCAD files (without need to convert them to anything else) - https://twitter.com/rezoner/status/1412759115370307584
They recently added a CONFIGURE_DEPENDS flag to file(GLOB...), which will automatically rebuild the file list when new files are added.
Looks like the $ sign is 5px wide if you look at the image.
Those comments probably come from people shouting about "diversity" all day long but who are uneasy at the slightest actual bit of diversity like language or opinion. In my country it's the republic (so the left) that planned and implemented destruction of local languages, which lived for over a millennium without issue under the French crown.
It's similar to the discussions around COBOL back in the day. What's interesting is that the primary "end user" language is Excel formulas. Who would have thought a declaratory relational language with matrices would "win" that battle.

Any arguments that "users will write their own" languages are basically flawed. Users want results, if there's no alternative, they'll do it themselves, in the simplest, but probably most inefficient way possible.
Why Fort Detrick lab should be investigated for global Covid-19 origins tracing
The lab-leak theory, that COVID-19 was leaked from a laboratory, has once again caused a clamor since the beginning of this year, months after the argument was thrown into the trash can of conspiracy theories by an overwhelming number of scientists.

Observers found that things only get more complicated when the origins of the coronavirus - an already difficult scientific issue - is entangled in political manipulation tricks. Combing through more than 8,000 pieces of news reports related to the lab-leak theory, the Global Times found that as many as 60 percent of the coverage was from the US alone.

It is worth noting that many media outlets in the US-led Western world, which hyped the lab-leak theory, are only willing to focus on the Chinese labs though they have been thoroughly investigated by the World Health Organization (WHO), while turning a blind eye to the more suspicious American biological research institutions, such as the infamous US Army Medical Research Institute of Infectious Diseases (USAMRIID) at Fort Detrick, Maryland.

The USAMRIID was temporarily shut down in 2019 after a Centers for Disease Control and Prevention (CDC) inspection. Although this mysterious lab reported the reason for the closure as "ongoing infrastructure issues with wastewater decontamination," the explanation was not persuasive enough. The Global Times found that the lab's failure to control toxins seemed to have alarmed the Countering Weapons of Mass Destruction related institutions in the US.
The HEOS line of Denon/Marantz also has a HTTP API with a fully public API specification[1], which is great!

You can use the ESP wifi connection to control it if you want to and it has quite a few features (afaik you can do everything the HEOS app can do). Do other vendors also have such an open approach?

[1] https://www.marantz.com/-/media/files/documentmaster/marantz...
There are two types of people in the world. The ones that are pro-SQL and the ones that don’t understand how SQL works
You're right that it got established early and network effects, but Codd had two goes at a relational query language before Chamberlin and Boyce had a go. So not literally "a first quickshot".
No - spritestacking is not as effective for the most of things but there is something playful about it - it changes the way you think about what you draw which imposes an unique style on your creations.
In Finland we got a law couple of years ago that forces public transportation companies to open up ticketing APIs for ”transportation as a service” providers. I think this is a step to right direction.
I'm surprised that this isn't obvious to the tweet author (and everyone else). GA uses JS, Cloudflare is at the DNS level.

As for relevancy - GA can still be useful as it can give you more detailed information which you can't get without JS.
The global threat from plastic pollution
> nor does it block youtube ads with any adblocker I've used.

I'm superhappy with https://adguard.com/ (https://github.com/AdguardTeam/AdGuardForSafari) and haven't seen a YouTube ad in quite some time...
The main difference is the execution of JS, less so the bots.
I am not a Chinese or a Chinese asset! Stop smear campaigns! You are fed with thousands of propaganda each day from US or EU side. Don't talk about Human Rights, or even transparency, I know Julian Assange!
If your in the UK then getting priority laned for ppe contracts for the govt is the easiest way
The problem is - I have an Android phone, and it doesn't look like you have the option to delete the YouTube app from it. I went to Google Play and tab uninstall, just to find the app again in my list of apps. I don't know how this could be legal to be honest.
It is ridiculous to make up a story about sterilization with no evidence. It reminds me of anti-Semitic campaign by Nazis.
Language is a connection to your ancestors, it is a time machine to their world, to speak and think like they did, and without the toil of your ancestors you wouldn’t be here, and by preserving it and passing it on to future generation we all still exist even after we die.
or ON:

select * from foo join bar on (foo.x = bar.y) if the columns have a different name.

I tend to write my joins first, then use where clauses as filters. A select * from foo left inner join on (foo.x = bar.y) is semantically equivalent to foo, bar where foo.x = bar.y, but keeping the joins separate from the filters makes the query more clear.
There are immutable back uptions out there. Depends on what you are trying to backup

For an enterprise many of the backup systems have immutability. Veeam for example has really focused on immutability in the last couple of releases

Also S3 and most S3 complatible cloud storage has immutable or delete protection option built in
To me, one doesn't have to pre-emptively record every user session on the off chance that they run into a problem large enough to bother contacting support for. Having a 'copy error' button and/or logging the errors to a server seems sufficient here, no need to hire the biggest brother out there to track your users for that.
> dwarfed by both the damage from the coronavirus, the threat of overpopulation and the benefits of economic growth (powered by fossil fuels) in Asia

Isn't the high end of the cost to address climate change now $50 trillion? Seems like a pretty good value to me.
Cozette – A Bitmap Programming Font
There's a lot of talk about what is wrong with SQL, but i haven't seen something yet that is actually better than SQL for most use cases.

Stop fighting SQL so much, and just focus on bringing a better solution. If potential users see it has significant benefits they'll start using it.
When I compare the codebase of a tool like gqlgen (a GraphQL library in Go) with the code base of PostgreSQL or SQLite, I'd say even 10% is generous.
Re-diving is not only hard but also demotivating and morally tiring. You spend the same efforts again and again and at the fourth try you just stop understanding why they need you, a deep-analyzing guy, in the first place, when they could just hire a “friday ETA at any cost, boss” guy and ship whatever they could do right at friday evening.

I wore these shoes, but one case was special. I was being young, debugging some live show-stopping issues at the client side (the sales department of a plastics factory, a part of a lingered project) when their production manager who I didn’t even know approached and asked in a very demanding tone when the entire project will be done. I distracted and politely redirected them to our PM only to hear a tirade about me doing nothing for months, despite the fact that all the work was thrown on me only recently, after our low-skilled part of the office managed to create enough mess. I politely explained that (omitting the “mess” part) and repeated what I’ve said before, again to no avail. And then my ego decided that it is reasonable to elevate my tone a little and ask them to please not interrupt me at this part of work, because it doesn’t make it easier. God, that hit him unexpectedly hard. Management is never ready for that sort of a dialogue, as I learned later. He left in rage and never greeted me again. (To not look too grumpy, I must say that everyone else, including some high-profile nose-up positions there, sort of adored me for solving their needs at least partially after a long time and for being not yet another silent display-peering guy.)

Wasn’t long before the story was relayed to our PM. I was criticized and expected to apologize but I refused because morally I didn’t feel guilty and to that moment I understood that this project was unlikely to succeed anyway. Few days later I just took the costs of my time and a fellow developer’s at my own expense and left this project completely. It was worth it.

No moral here, but another example that they don’t really understand the difference between a grinder operator and a developer. Also, I may play sir-vs-peasant games with management, but I still don’t get it as a human and will bite back if they play too much. Nothing is worth losing your dignity, unless you’re seriously leveraged. (And in my experience 99% of the client employees never exploited it anyway for personal attacks or sort of that)
I think the banking salaries exceeded tech 20 years ago so banking was a good decision?
New features were added to the language that make this sort of stuff unecessary.
So is the 134°F from 1934 in the OP officially discarded as a instrument error?
On the contrary, vilifying men who don't meet one's arbitrary social standards is a deeply conservative idea as well. The fact "deep blue feminist college-educated media" folks share such notions doesn't mean the other side is any better - if anything, the whole idea of men's rights as something that's inherently worthwhile is still remarkably niche.
> a system wide ad blocker would seem pretty anti-competitive.

Only to advertisement agencies. And they can go cry up a river.
This is a very good analogy.

A similar one I have heard before is "It's like falling asleep... It takes a while to get into sleep mode and if someone interrupts you, you have to start the process again." Most people can understand how annoying it would be to be interrupted all night and not get a good night sleep.

Though riding a bike makes programming sound more active than sleeping, which is good.
You don't understand American cooperatism then. The worker is still your legal slave, with all cooperate rights and contracts trumping civil and person rights. Formerly called fascism, which is just an an extension of the old aristocracy brought over into the industrial pseudo-democratic age. Also called the "American freedom". You are free to sign this contract. Or not
This doesn't work too well nowadays since a lot of visits don't hit my server as Cloudflare itself is serving them the page.
Cool, I never knew that
It’s a common way of hiring at many places. Perhaps they have already vetted your technical competence or they just don’t care and will mentor you.

If you are an experienced developer you are already well prepared. Just be honest about your coding preferences and that there are many areas you deliberately avoid because they are outside your coding style or because they are bad form and you don’t waste time writing anti patterns.

Sometimes the interviewer is inexperienced, for example cannot handle asynchronous logic without async/await, and they are mistaking preferences for competence. No amount of preparation will solve for their inexperience.
I did not know about rev, thanks. Though, since there is no way to specify a signature you are forced to use potentially outdated packages.
I can not imagine backing up one dvd at a time. Not only would that be impractical for most applications. Even my home I have several TB of data, for a business that would be much more.

Dvd's are unreliable as a long term storage media due to physical damage or if it is a rw dye decay
Tell that to all the chess players ...
VAX 11/780 is also the reference MIPS unit in performance measurements.
Bee sting twice as likely to land Australians in hospital than venomous wildlife
Are prices fixed or something? Why would a cab say no to a long ride otherwise.
You're mixing up different things that don't nescessarily need to be addressed at the same time. SQL is the declarative programming language used to express what data you need.

What type of database engine is used to execute that query is independent of the language. It could be highly scalable or it could be focussed on single user, single process.

What is the problem that needs solving?
There was a strong push for "NoSQL" about a decade ago, but it got marred by document databases trying to usurp relational databases around the same time. When people realized they chose the wrong tool for the job (that is, the document database), they were happy to return to their relational databases using SQL. That completely killed any momentum that had been built to replace SQL with different languages.
> all-year-round 10°C

Based on the Wikipedia page they have negative average temperature for 4 month a year. 10°C is the peak in summer.