skysight-inc/HackerNews huggingface dataset:
> I hit in Postgres recently that is terribly documented.

I'm going to have to disagree with you there. This issue is quite well documented in the "SQL Functions Returning Sets" section [0]. The relevant bit starts thusly:

> ...Set-returning functions can be nested in a select list, although that is not allowed in FROM-clause items. In such cases, each level of nesting is treated separately, as though it were a separate LATERAL ROWS FROM( ... ) item...

And there's even a note about the crazy behavior pre-PostgreSQL 10:

> Before PostgreSQL 10, putting more than one set-returning function in the same select list did not behave very sensibly unless they always produced equal numbers of rows. Otherwise, what you got was a number of output rows equal to the least common multiple of the numbers of rows produced by the set-returning functions. Also, nested set-returning functions did not work as described above; instead, a set-returning function could have at most one set-returning argument, and each nest of set-returning functions was run independently. Also, conditional execution (set-returning functions inside CASE etc) was previously allowed, complicating things even more. Use of the LATERAL syntax is recommended when writing queries that need to work in older PostgreSQL versions, because that will give consistent results across different versions.

I agree that allowing SRFs in the SELECT clause is a wart that should never have been permitted, but I think the PostgreSQL docs do a pretty great job describing both the old behavior and the new behavior that has to balance backwards compatibility with sensibility.

(And, indeed, the 9.6 docs have this to say on the behavior of SRFs in the SELECT list: "The key problem with using set-returning functions in the select list, rather than the FROM clause, is that putting more than one set-returning function in the same select list does not behave very sensibly.")

I do think one notable defect with the PostgreSQL docs is that they were designed in a time before modern search engines. They are better understood as a written manual in electronic form. Almost always the information you need is there, but possibly not in the chapter that Google will surface. But there are all sorts of tricks you can use if you update your mental model of how to read the PostgreSQL docs. For example, there's an old-style index! [1]

[0]: https://www.postgresql.org/docs/current/xfunc-sql.html#XFUNC...
[1]: https://www.postgresql.org/docs/current/bookindex.html
It's really not comparable. Google is for companies and the smallest bill is $100 a month. Digital Ocean is for enthusiasts and the highest bill is $100 a month.
Hello and thanks for your suggestions!

- Dynamic metrics is coming very very very soon
- Good idea reaching out to publishers -- I might just do that.
- People just email me their requests anyway, but it might be a good idea to invite the interaction
- I'd love to host tech books, but as far as I know, most aren't in the public domain
- Keeping it free is the plan!
- Gamification is coming once I eventually get around to making user accounts. I'm not really sure how it'll create revenue streams though, so if you have something in mind, let me know!
This assumes that people will substitute their home gardening time with app development, doctoring, clothing production, etc. When, by my observation, it will be spent in a non-productive fashion. Not to sound like a Protestant, but this sort of work is good for the soul.

Also, I don't want to be dependent on a monocultured, government-subsidized, efficient conglomerate agribusiness if it's operations contain externalities whose price we could partially avoid paying simply by having a tarp filled with dirt and some potatoes and skipping one Netflix show a few times per week.
> remind myself I've been able to solve pretty much any problem I've faced.

I think this confidence is really important and part of it seems to come from having solved lots of problems in the past / working through frustrating periods. That's why "write lots of programs" is still my favorite piece of advice because it's a lot like "show up to the gym" if you want to get stronger.
I concur with you both, I badly phrased what I was trying to say. Thanks for saying it properly.
I would not be surprised at all if it were to come out that Samsung, Micron, and other major players are price-fixing just like they have been caught doing multiple times in the past. They seem to pay their fines as a cost of doing business and then continue to operate like a cartel. Seems this is the same situation, and I don't doubt this is directly responsible for inflated DRAM pricing.
Public access (any citizen being able to get on the Cable network) is different than educational access (only educational content) and Government access (city and county council meetings, community bulletin boards, etc.). These collectively made up "PEG access", and may have been a single organization or multiple depending on the municipality. Cable companies tended to view these as pure cost centers, and have tried to get rid of them through legislation.

Source: I used to work at a public access station. These were hit hard by the internet, when YouTube made it easy to put whatever video you wanted online, which was much more difficult to do with any sort of quality before the early 2000's. The public access channels that have survived/thrived embraced teaching the public videography, lighting, sound, editing, etc.
All good points, nothing to counter on my end lol
I'm not sure anyone was expecting to replace the grocery store with a balcony garden. If so, a lot of people would be doing it, I'm sure.
So, I'd actually push back on that and say you will find cities with a variety of "new" immigrants and related community cultures stacked on top of the older immigrant communities that are still there (think your various Eastern Europeans). It makes for a unique mix.

There's a variety of reasons for this I could speculate on, and three of the firmer ones are refugee resettlement (Minneapolis and Somalis, pre-cool Cali and Hmong, Michigan and Syrian refugees), Central/South American immigration patterns beyond the border states, and military bases which tend to show up all over the midwest/west/southeast/southwest (Korean, Vietnamese, German and maybe smaller ones but those stand out).

These communities exist alongside the traditional cultural elements of the city and can often be blocks away. But, the areas tend to look a lot less like Chinatown and more like Flushing - maybe more insular, but still plenty authentic.
> The goalposts have shifted from "having enough food to feed ourselves" to "having enough exotic spices."

boo hoo. I never set the first goal posts, nor the second that you imply. They're all only components of maintaining quality of life for our constituents and fellow citizens in a probability distribution of predictable things, including so-called 'black swan' events.

The risk of ending wheat/corn subsidies is so much higher than having them in the first place...
Is this XSLT for JSON?
I was under the impression that Cobalt-60 was more common for food irradiation (it's not soluble in water and has a shorter half-life, so less potential eco-impact). But, yeah, food irradiation is a really common process with few downsides once you get past the whole "made in a reactor" part.
Super cool. We just need more fiction with !@#$%^&*()_+{}:"<> etc
which of those two are easier to get started with?
Ryan Smith in the link above seems to suggest error correction will be done transparently anyway, so it seems like it won't reported to the OS. So it doesn't look like Intel could cripple it even if they wanted to.
This kind of proves my point. It doesn't lead to maximisation of profits therefore it is not being developed.
People might not be objectively racist, but if you grew up in a school district where the high school of 14,000 kids only had 10 black people attending, you will hear some disgusting stereotypical comments and some very off color jokes eventually whether you are a minority or not. People uttering these things might not even see how damaging these comments are to the groups they target, because they've never met very many of these groups or ever been around someone who would check their behavior. It's just a fact of life when you grow up lacking any perspective of another culture, and the national culture encourages you to adopt biases that aren't rooted in reality, and you have no personal experiences to disagree with them.

People also so kindly forget that the midwest experienced white flight like nowhere else. That sentiment is still in living memory among the older generation.
Since neither of you cited anything, webmd says parent is right. Looks like you're only off by a factor of 100x. If you're going to call someone out for inconsistencies, might want to get your data right?

> Coronavirus. These tend to do their dirty work in the winter and early spring. The coronavirus is the cause of about 20% of colds. There are more than 30 kinds, but only three or four affect people.

https://www.webmd.com/cold-and-flu/cold-guide/common_cold_ca...
55 years is half-way back to the time when galaxies-as-more-than-nebula-inside-our-galaxy was finally settled.
This reminds me that when I was younger, around 9 or 10 years old, we lived with my mom in some desolate place where Internet was nonexistent. We still had a computer though, so what I would do to pass time is that I would pick up some books from her library and retype them on computer. This really was an amusing experience and I could spend hours doing it. Wonder if I'd get the same feeling ten years later.
The conjunction here is purely to taste, since utilitarian implies functional, as well as not particularly attractive; both are correct (as would just 'utilitarian', since it's not a loss of information, implying as it does the functional aspect).
5 days later: Deaths in Sweden continue to fall, per your own source.
I'd say Chicago is such a dark horse that it's unfair to include it in this article. Well not unfair exactly, but it doesn't fit in with the rest of the list given its size. The list is about midwestern cities, but we all know it's really talking about the migration of people from large to medium sized cities, of which Chicago is not one
There's also another side of disgust that motivates you to improve things. Some of my favorite work were born out of sheer anger
Facebook removes Trump post comparing Covid-19 to flu
Bitcoin Won’t Make You Rich, and That’s Okay, Because That’s Not Its Purpose
Google rebrands G Suite as Google Workspace, gives Gmail a new logo
A little tidbit: everything you deploy on App Platform comes with DDoS protection built in.
Followup. Just noticed the interview with Michael Malice. So your concern is well founded. Darn.
Zoom alternatives to encourage casual chatting
I'm sure, at a push, a PC could be co-opted to do the work while a server (even online) could then be brought up to speed and the data migrated - but that's your use case.

What we're talking about here is a government department who do have access to servers, but choose not to use them (or so it would seem).
AWS allow to set limits on autoscaling groups, ECS, EKS. All the things with autoscaling really.

If you're worried about billing, S3 is not a great choice. S3 is precisely unlimited storage for enterprise.
I have created a tool to help people who are missing YouTube Community Captions
Can you consider expanding a 3rd data center to somewhere else in the US besides SF and NYC? Like texas, chicago, or virginia?
If Chrome could not exist, Google would likely pay Mozilla even more to fund Firefox and get Search traffic (or pay MS for IE or some thing). Sure, it'd still be supported by the ads business, but that doesn't mean it isn't a profitable enterprise.
In all the banks I know in Europe (France, Germany, Italy, Belgium and probably others I sent or got money from) , SEPA wire transfers are free. This is probably not a law, but driven by competivity.
Australia has done remote instruction for decades. It boggles my mind that we are not borrowing existing and proven educational technology.

https://en.wikipedia.org/wiki/School_of_the_Air
It's hard to say. I've lived din large cities in Europe almost my entire life and that experience was "normal" then moved to the US suburbs where almost nothing happens. But a few years later when I visited New York and stayed for 3 nights, oh man, it was such a weird energy. It felt like I needed to be out every second, it felt that if I spent an hour sleeping in my hotel it's an hour wasted somehow. The fact that at any point in the day or night there were people filling the sidewalks made me want to be out there with them. I don't know how to explain it, but there was an energy driving me to do more.
Developers directly touching k8s are hardly low/no code targets. So this doesn’t seem well placed.
Unless this imagines a world where devs throw over the fence and ops team is bunch of citizen users.
To paraphrase a blog writer- "a lot of people complain about feeling disconnected, but when I ask them to describe what it would feel like to be connected, they are unable to describe anything."

Many people are aware of life feeling too complicated, but very few actually have thought about what life would feel like if it were simple, and once they think about what they would need to get rid of in order to make life feel simple, most are unwilling to give up the privileges and freedom afforded to them by their "complex" lives.
looks like reddit, conceptually
If you want excitement, you can drive through parts of Chicago with bullet proof glass and experience a war zone.
"Dealing with failure is easy: Work hard to improve. Success is also easy to handle: You've solved the wrong problem. Work hard to improve." -- Alan Perlis
One of the "doctors" who recently published research on "psychobiotics" was
later selling a brand of "clinically tested" probiotics tailored for mood disorders. Gut microbiome studies, at this point in time, need to be taken with a pinch of allum.
This is laughable - billing is logically separated from droplet use, so unlike other providers DO charges for the potential to use a capability, rather than actual use, regardless of whether it is consumed. I got stung badly by this - charged for X droplets capability when zero droplets capability was being used for several months. Explained the misunderstanding to DO, got no sympathy & no refund. Won't touch them again, don't trust them further than I could throw them.
You also said that it was unreliable. Not in my experience.
I'm from Pittsburgh, my partner is from New Jersey. We argue about this (in a playful way) all the time; Pittsburgh is east coast, to me. Ohio is midwest. She counters with "a seven hour drive to the water is not on the coast."
The thing that's gotten smaller is the minimum feature size on a silicon wafer. The same types of etching and doping processes can be used to create many integrated circuits.

DRAM chips are integrated circuts that consist of individual transistors and capacitors for each bit, plus the wiring and logic to read, refresh, and write to those bits. They're substantially transistors.

It's true that logic, power, analog, flash, DRAM, SRAM, and mixed signal ICs do have some significant differences, and some manufacturers optimize for a subset of those capabilities, but they're similar enough that if one industry advances leaps and bounds (like Flash storage and low-power processing have).

So why does DRAM lag behind the others?
You know, we're living in a society!
They're listed in your pihole or whatever you use to block trackers most likely.

Same thing here, had to override the block
There is still a lot of room for innovation in the space, that is why you see so many attempts. WebRTC stagnated for quite a few years. The same people were building the same things, and everyone assumed the space was done.

I think it is worth building these things. You never know the impact it can have. These projects also inspire others. Even if this project doesn't take off it could inspire someone else to build something that has a lot of impact.
Exactly. Look at the average height by age group.

https://www.statista.com/statistics/935212/south-korea-avera...

A 12 cm (or 4/5 inch) difference. Amazingly enough, not too far different from the NK to SK average height difference.
That is irrelevant. Should a person who literally lived next door to the office then be paid the same because they saved less on commuting? What if I “work from home” but actually choose to commute to work from a storage facility on the other side of town?

No. Commuting is irrelevant to the cost because it’s unrelated to the work or the cost of doing business.

The cost of utilities not required on site is a literal and measurable saving for the business. That cost is directly transferred to the employee.
> I'm curious to see how you'd describe this distinction though.

One kind of "doing nothing" frees your mind to discover solutions and interesting ideas in a background process. Examples include talking a walk, talking a shower, or just sitting around and letting your mind wander.

The other kind of "doing nothing" occupies your mind with low-effort thought processes. Examples include watching TV or reading a book. This isn't necessarily a negative thing, but your mind won't be solving problems (unless you're not really focusing on the movie or the book).
You should use extreme caution around feral hogs. You could easily be gored or killed. A full grown feral hog can easily weigh. 3-900lbs. Imagine getting hit by an entire football team running at full speed. Or a small car with two knives strapped to the front.

Edit: A woman was killed this year by feral hogs: https://www.nytimes.com/2019/11/26/us/texas-woman-killed-fer... . Attacks that result in death are unusual but you don't want to be in that position.
I work a lot with address and place data. When I tested the API I was surprised how robust it is to name and address variation. It knows "MLK blvd #101" versus "Martin Luther King Blvd STE 101" are the same address. It also is robust to typos or variation in name like "Village Pizza" vs "Village Inn Pizza & Pasta". I also tested some of my favorite edge scenarios like two starbucks across the street with similar addresses, and the API knows that these are different places and does not merge them together. This natural ambiguity is what makes address and place data so challenging, and my tests show that the API is achieving something non-trivial. I'm impressed. The list of launch partners also includes a lot of major platforms (e.g., Esri, Carto). Definitely worth a look.
Nope. The risk is climbing rapidly at that age.
Me too; two weeks ago I traded a small house in Cap Hill, Seattle for a lot more space and friendly neighbors in more rural Washington about 20 minutes from the city. Loving it!
I used to think gevent was a Google made library about event handling. Turn out the g stands for greenlet.

I agree gojs is confusing as it seems to be "go-lang implementation in javascript" but I believe no one can claim the ownership over the word "go", as it's an normal English word as well...
Thats anecdotal and the memes were after it got popular.

Just because many of us purposely installed chrome, doesnt disprove that Google used many dark patterns to get people to click buttons or bundle it with other installs early on. Back then, Chrome used many of the same tactics as Yahoo and Ask toolbars, and even today the google.com home page warns you as if google doesnt work right in other browsers.
Yeah I wish they didn't let you do arithmetic on Boolean with int without explicit conversion. It can be useful, but the explicit conversion isn't a large burden and prevents many errors.
Is it just me, or is $15/mo for the cheapest Postgres-with-backups a bit steep? Heroku's free DBs (or $9/mo basic plan) support daily backups.

I've currently got a web app I'm just self-hosting on a DO VPS for $5/month. I have a Postgres DB on the same VPS (via a Docker image), with a 10-line shell script & cron job for backups to Backblaze B2 (which costs ~nothing/month for my tiny DB).

Additionally, my web app is a Kotlin API and a Nuxt.js SSR server, so I think I'd have to set it up as two separate "apps" on this platform. That means I'd be going from $5/mo to $25/mo.

On one hand, that's not a ton in the grand scheme of things. On the other hand, the whole reason I use DigitalOcean and self manage my infrastructure is to _not_ have to pay that kind of money for my projects with no revenue.
I'll echo this - when I've worked in polyglot shops, specifically on a team that did a lot of Erlang, we hired for "exposure to functional paradigms", not Erlang. The only places that looked to hire the specific language (and even that was negotiable) were places that just had Java. And the average quality of applicants was universally worse.
I think OP was just listing out the consequences of switching jobs.

They also engaged in agreements to not counteroffer in competition with each other above their initial offer so that employees couldn't negotiate between offers.
They have.
Giving the industry the benefit of the doubt after decades of price fixing is generous at best.

“To date, five manufacturers have pleaded guilty to their involvement in an international price-fixing conspiracy including Hynix, Infineon, Micron Technology, Samsung, and Elpida.”

It’s claimed to be a very high margin industry and supply is artificially constrained to maintain that margin.

https://en.m.wikipedia.org/wiki/DRAM_price_fixing

https://www.extremetech.com/computing/283081-dram-manufactur...
Schoolmax Review
I think its Schoolmax

Schoolmax is a diverse Social Networking Community where Students, enterprenuers and Aspiring Professionals connect among themselves, Discover Jobs, Scholarships and other opportunities and Raise fund for themselves via marketing of Products.

Whether you're an Employee at a company, a business owner or a startup who runs a small local shop or even college students looking for their first job after graduating, Schoolmax is for everybody who's interested in taking their professional life more seriously by looking for new opportunities to grow their careers and to connect with other professionals.

You can download it here for andriod:Schoolmax - Community for Entrepreneurs & Students - Apps on Google Play

or visit : https://schoolmax.com.ng
I provided all the data he needs to prove my theory (in previous linked issue) and his theory (in this issue). And now i'm the bad guy. Really?
BTW, specific VM settings doesn't matter for the purpose of issue replication, the problem is guest-OS isolated, but maintainer just denies it.
State of Independent SaaS
You might want to look into this invention, it’s called the telephone. It lets you talk to people over great distances. They even have ones now that have no cord and even let you see the person you’re talking to.

What a time to be alive.
Unpopular view, but unrecoverable encryption deployed at web scale is a cancer on society. While unrecoverable encryption provides additional privacy to law abiding citizens, it normalizes low level criminal activity at scale.

There has to be a better trade-off here that minimizes the risks of 3rd party access, and gives law enforcement and the intelligence agencies the tools they need to do the best possible job.

If I had to choose, I’d rather my consumer endpoints be hardened but have vetted and protected exceptional access mechanisms on the encryption.

In practice, this bill is likely to lead to cut corners by big tech, who won’t be legally mandated to actually build increasingly responsible encryption recovery mechanisms for LEO. This will enable big tech to say, “I told you so”, because they were simply doing the minimum amount that was required of them legally.
Ah but if Android was a separate company from Google, and Palm and Blackberry were in the field too, with separate app stores and revenue split between them, what would the landscape look like?