skysight-inc/HackerNews huggingface dataset:
Re: ad-hoc queries impacting production, you can mitigate this by pointing your data mesh to a read replica of the prod DB (which you can colocate with it to avoid bandwidth costs). Admittedly at that point you might be approaching a warehousing use case.

Re: maintaining the mapping. Sure that's a tradeoff. But I'd rather manage declarative FDW definitions than a programmatic ETL pipeline. Yes, handling schema changes is non-trivial (a naive starting point is periodic introspection of the remote table), but that's true in an ETL pipeline too. As you say, you're moving the cost from the ETL pipeline to the FDW definition. But what if we can lower the cost of the "FDW definition" (a.k.a. setting up and maintaining the data mesh)?

From our perspective, at least with the product we're building, we think we can make a data mesh that's low maintenance enough that it makes sense as a first default before ETL. But the two aren't mutually exclusive. A data mesh can connect multiple warehouses just as easily as it can your production databases. For example, you could move data (ETL) from your data sources to your Snowflake and BigQuery warehouses, and then connect them both to your data mesh.

Also, a mesh can add value as a unified access layer that proxies queries and applies data governance rules (e.g. sharing data, access control, column masking, query whitelisting, rewriting, rate limiting, auditing, firewalling, etc.). It would be hard to do this in your warehouse, because as soon as you have another one, or there's some data that you can't ETL into it, you lose any benefits of its access layer. (e.g. Maybe you have two warehouses because you haven't fully migrated to one, or for cost reasons like storing FireBase clickstream data in BigTable that you can't move to Snowflake with the rest of your data. Now you need to maintain two sets of accounts and ACLs for each warehouse.).

(And for what it's worth -- this is a bit off topic of the current thread -- we do recognize there is often a use case for warehousing when the tradeoffs of federation aren't worth it. We can actually act as a warehouse too, which makes it easy to start with a data mesh but have the option to bail out to warehousing for the specific data assets that need it. Ideally, you can just click a button that says something like "snapshot data" or "schedule query" or "replicate data source." To ingest and store the data, we can leverage the concept we introduced of "data images" for storing versioned snapshots of data in delta-compressed, content-addressable chunks of hot-swappable cstore_fdw files. You can create data images with a declarative, Dockerfile-like syntax called Splitfiles. They look something like FROM upstream:tag IMPORT { SELECT x, y FROM ... }). You get full provenance and can `sgr rebuild` an updated image only when its upstream changes, just like Docker.)
That's where making commenting a perk (among others) of being a __paying subscriber__ would be a change in business model that might be beneficial. Though that alone wouldn't get me to pay. Weight towards focus of research I find valuable might.
That link doesn't mention anything about the amount of land required to mine the copper needed for wind turbines.

It must be far less than is needed for mining the uranium needed to generate the same power. Think about it; the copper required for the wind turbines is a fixed one-off cost that lasts the lifetime of the turbine, and can be recycled. Nuclear reactors need a continual supply of uranium (about 27 tonnes per year for a 1GWe reactor: http://bit.ly/3voR0II).

Furthermore copper concentrations are typically around 100 times higher than uranium concentrations, which means you need far more uranium ore than copper ore to produce the same weight of metal. Copper has been extracted with relative ease for thousands of years.

And then of course, there's all the metals and concrete that are needed to build the nuclear power station.
Yeah I'm having a feeling we are gonna need to buckle up. It'll be a bumpy ride.
Yea, in an "enterprisey" organization you'll have auditors who will note that it doesn't have XYZ SoopEr SeCure Certification v3.141 and there isn't an Alpine LTS Enterprise Edition with White Glove Support.
yes, except for when it's fraud to hide illegal government trades.

https://www.wired.co.uk/article/venezuela-petro-cryptocurren...
Well, to be accurate, these vessels are usually not fully submersible / true submarines. That would require a level of engineering and cost that is probably not worth it for smugglers.

These are semi-submersed "snorkeling" vessels that breath surface air and ride just under the water, which makes it much simpler to design/build + operate.

The real goal is to get most of the ship off the surface where it can be easily detected. Semi-submersible is good enough for that purpose.

I'm guessing various countries' navies (underwater sound detection) probably can detect these vessels with some accuracy if they wanted to, they just don't have the resources/time to go after them as their top priority.
The rule of 3 doesn't apply to C++ native polymorphic types and your statement is so far out of left field I'm guessing you don't do much C++ development.

To humor you... if I have a base class of type Animal and a derived class of type Cat, then making a copy of a Cat through a pointer or reference to an Animal results in object slicing which is not what you expect when you make a copy of a polymorphic object. Basically you only end up copying the Animal instead of the entire Cat.

https://en.wikipedia.org/wiki/Object_slicing

One of the motivating reasons to use type erasure is precisely to solve this issue, so that one can copy an Animal or assign Animals and treat an Animal as a value and copies work as expected.

When one copies a std::function or any of the type erased classes provided by the standard library, it just works as expected, without needing to consider lifetime issues, object slicing, C++'s complex rules about inheritance vs. virtual inheritance, and a host of other problems that don't mix well with other parts of the language.

The cost of type erasure is that it requires a lot more work on the part of the author. The libraries I linked to help alleviate most of the boilerplate, but as the examples demonstrate, there's still a lot of work that needs to be done to get it right.
Hey there - we'll be posting some videos soon - agree it is not a great experience to have to click or install something without understanding what will happen. Thanks for the feedback.
> Multigenerational LRU: better, more versatile, more straightforward than Linux's

> Multigenerational LRU: more versatile, straightforward than Linux's

Neither of these have as much information as the original headline. The version I came up with that's actually equivalent to the original without using the word "performant" has to use a word that means the same thing.

> Multigenerational LRU: faster, more versatile, more straightforward than Linux's

And that still means I don't get to use the "parallel more" construct.
> BugQuery

Is this a typo or some kind of joke about BigQuery being buggy?

Anyway, agreed on this being needlessly complex and I stopped reading pretty much immediately when I saw the article continue to talk about postgres when it came to the "data lake". If you already have a postgres database backing every service and already have views defined for the data then just set up exports of those views to BigQuery/Snowflake/Redshift/etc. All of them have out of the box templates for doing exactly that.
The problem is stores need to open at some specific time, and thus need employees to start work at that specific time. Adjusting either of those based on the sunrise every day wouldn't be very practical.
Take your gig economy elsewhere bro
Even if it doesn't make the comments better, it's at least the paper's paying audience, so at the very least it's "authentic." If their subscriber base is all racists, well, I guess that's enlightening.
This is how the NYT moderation works. They even have "Editor's Choice"-type badges to signify high quality comments
Ursula LeGuins intellectual property. She was strident and strong in rejecting bad IPR deals with publishers, don't traduce her memory by pirating her own words.
Thanks - a good opportunity to learn more about the HN principles.
This is sort of like the thing where

Biology is applied Chemistry

Chemistry is applied Physics

Physics is applied Mathematics

Not a perfect train of thought, but correct enough. If that is the hierarchy of the scientific world, I would argue that Philosophy is the "Mathematics" of art world. Every other art form is "applied Philosophy."
I don't understand what you're saying here...
This is the new norm. Men are stronger biologically so women must have an easier fitness test. Next move should be to make written tests easier for men since women are better at these than men, especially longer ones. We must all be the same and yet also be special snowflakes.
And as someone who hires contractors, 20 hours can be positive for your client.

Why? Lowers weekly management / feedback / “business decisions” needed to enable your work.
It's half-serious, I don't call it analysis; I think it's weak but genuine evidence. It was meant to be a Parthian shot; the rest of my comments don't hinge on it.
Oh yes, there are plenty of footguns in the administrator/operations/developer space. That's just one of the reasons that I refuse "oh you're in X team, here's unfettered everything access in case you need it" offers. Just give me the least privilege I need to complete the task at hand.
Yes this is true. Only the highly educated have anything useful to say. This is why HN is so brilliant and diverse. We have opinions from all over SV and from all walks of the tech world. We know the world so can give voice to the world. The common sorry of comments on a news articles are usually so ill informed as to be embarrassing, you can tell that because they are typically nothing someone from HN would consider. The moderators on HN and the highly evolved intramural voting do a great job ensuring that open sophisticated voice is rarely found elsewhere.
Where do most people in AZ live relative to their time zone? I wonder how apparent these issues are to people in DC; they're very apparent in places like Michigan, on the edge of their time zone; you drive for an hour outside of Chicago and it's weird how long the sun is suddenly up.
africanboy says "Nobody in Switzerland sleeps with their gun under the pillow ..."

And you know this how?
Video resumes will bias you towards attractive and well-spoken candidates. That makes more sense for sales than technical positions.
You don’t think you should be able to report being harassed or spammed?
Why do we have to be broadly in one of these categories?

“No provider or user of an interactive computer service shall be treated as the publisher or speaker of any information provided by another information content provider.”

This should only be true for platforms that don’t algorithmically curate the content that users see, or platforms that don’t editorialize. I don’t care about hypothetical censorship or bias toward conservatives. I want platforms to stop algorithmically curating content. I want platforms to stop editorializing.

These companies are choosing the content that users are seeing, and they are editorializing that content. They don’t deserve Section 230 protection, and they shouldn’t have it.
Are We Prepared for Killer Robo-Drivers?
There are countless brilliant comments on the internet.
When European history writes about discovery it naturally means discovery by a European. If somebody in China or India did it how would it matter to Europeans?

History is always written from a perspective. If native Americans discovered Europe then whomever did so would have been recorded in their history. They would not go “ah but the Europeans where already there so let’s forget about this feat”
Adding protein is just making things worse. If you want to control glycemic response then what you want is more fiber:

https://pubmed.ncbi.nlm.nih.gov/3001740/

Add some veggies to your meal.
Polling doesn't back up your opinion[1]. 40% preferred extra sunlight in the morning year-round, 31% preferred it in the evening year-round and 28% preferred switching.

[1] https://www.cnn.com/2021/03/14/politics/daylight-saving-time...
Quitting HN again, hopefully for the last time
I’m so sick of this piss community. Most of you are great in some way, but I cannot stand downvoting and group lack-of-think.

Bye.
I've got a couple dozen accounts registered between defunct bots that were tied to irc bots or blogs, and single-use numbered accounts registered for contests and giveaways that required twitter. None of them has ever required any proof or phone number for registration. My primary account, which I use just as infrequently? Of course they asked for my phone number. I'm just annoyed I can't do 2fa without the twitter client or sms.
Just read their FAQ[1] and was optimistic until reading that it runs on the Ethereum blockchain.

This is not a problem that requires blockchain to solve, and it makes me wonder what other issues are built into the project.

1. https://urbit.org/faq/
Are you suggesting we eliminate (go permanent standard time) and have people change their alarms 1 hour earlier in the summer? Does that mean you also go to bed 1 hour earlier in the summer? If you go to bed earlier, you have less evening time to enjoy.

Also adjusting your entire schedule (your alarm, your bedtime) twice a year would be very disruptive.
Just commenting to say that I work on this project. So let me know if anyone has any questions about it!
Well... you're kinda wrong, because now many retirement accounts and such have indirect exposure to cryptocurrencies (MSTR and TSLA's silly Bitcoin buys come to mind, and I know TSLA is part of the S&P500), whether we like it or not. So we do have a dog in this fight, and we'd prefer not to be a part of any of these shenanigans.

What two consenting adults do in the bedroom has zero affect on me. What a cabal of opportunists do with cryptocurrencies and then a possible epic black swan event could cause a domino effect that could even be considered catastrophic across the entire economy. Then a select few run off with their bags of real money while the rest of us take the hit.

That's no good, if you ask me.
Investing intelligently isn't a matter of luck. The ability to think very broadly and deeply helps a lot. Be curious! Read stuff! Don't blindly copy others.
We're between good people here, not like the uneducated masses who comment on online news.
The state pretty much spans the width of mountain time. It's pretty large geographically, almost 350 miles across.
Dissenter also got banned from the Mozilla and Google Chrome web stores[0]. I can't help wondering, though, if banning software for allowing people to access offensive web content might be a policy that browser makers wouldn't want selectively applied to their products in OS app stores.

[0] https://hub.packtpub.com/mozilla-and-google-chrome-refuse-to...
That works until the trolls' game is to shut down the channel of communication by crapflooding it.

Spewbots and humans who act like them are nothing new. See a topic of discussion you feel is dangerous or merely not aligned with your core values? Send in the trolls and/or bots to spew hateful nonsense all over it until nothing else remains. Ignoring those trolls is precisely what they want: Ignore them, ignore the topic, ignore everything all the non-trolls are saying, move along, nothing to see here. Nifty little censorship tool if you can weaponize it effectively enough.

DNFTT only works on pathological individual cases who care about what the community thinks of them.
And mustard?
I suspect there are a few factors:

* Motorcycles aren't very dangerous to bystanders.

* Approximately zero infants or toddlers are routinely transported via motorcycle.

* Motorcycles don't make up a large percentage of traffic in the U.S.

* Motorcycle deaths are more likely to leave donable organs intact, so it's a bit like the lottery, but for organs. Some people opt in to entertainment, and the rest of society benefits.
Unless you think that Niger will persist in poverty forever, or that people born in Niger never move to the US or Europe, then yes, it's still a worry.
We have similar problems in places here in New Zealand urchin barrens are taking over from kelp - here it's thought to be caused by over fishing taking out the larger/older fish that previously kept the urchins (kina) under control.

Kina are considered a delicacy here, but as mentioned here the kina in the barrens are underfed and not worth eating
Yeah... I've worked with some smart fabrics and I wouldn't touch them knowing the voltages this kind of stuff requires to work.

I'm sure it can be done safely, but those folks touching it were all wearing gloves. I agree!

And if a single wire in the fiber breaks the entire line is gone, though this is hardly perfect with stationary stuff it seems a lot easier to happen in a fabric...

But still extremely cool. I just hesitate to wear clothes that I have to plug into a wall outlet :-D
Are you logged in? I searched for that phrase 'rust vector drain' (without the quotes) and the entire page is filled with Rust documentation. Although the broader point stands, I have noticed Google search getting worse.
I don't know if that's the best method though. If some PAC decided it was going to pay for the subscriptions of its members as a campaign, then that subscription model isn't really a big barrier.
Noting an author's biases/motives, like agarttha did, is useful. It's not the same as asserting that a conclusion is logically false because of the biases of the person who argued it.
I am often interested in finding past sports information so if I search for something like +2003 "Team X" "football schedule" I will receive many pages of their 2020 or 2021 schedule and recent news about that team. I feel like the Google of the old days would deliver me exactly what I wanted within the first 5 results.
In my defense, when I did my googling a while back, it was specifically about data lakes, not the comparison. :)
I don't want to diminish that, from a brief skim of wikipedia this looks like a typical American light rail with vast suburban extensions, "park and ride" stations rather than dense development around station.

This sort of transit just allows for further sub-urbanization and car culture when the highways fill up. It doesn't promote cross-sector density (just larger central business districts), and it doesn't reduce the externalities of the American way of living.

To be fair, this is by no means a mistake exclusive to red states. The WMATA in DC, and LIRR and Metro North in NYC all commit the same sin.

https://upload.wikimedia.org/wikipedia/commons/b/bc/Salt_Lak... Guess the mountains hem it in one some sides; that gives me some hope. Maybe someday it will look more like https://c1.staticflickr.com/1/659/32455034626_dc15a3023b_o.j...
I hope that's not designed for the programming jobs -- because for those, it'll totally select for the wrong thing. I have been conducting interviews, and they often start with me asking, "please tell me a few words about yourself". Some people fumble, and some have great prepared speech. Except in the extreme cases, the quality of introduction is rarely correlated with either interview or job success.
I would prefer to not live in a timezone with a half hour offset from UTC (which do exist, in fact 15 minute offsets exist).
Time to market, maintainability, and ease of regulatory compliance.

The developer-friendly bit is just a marketing/sales tactic (make the developers swoon to force the hand of co's to implement it).
I believe that China also requires that people's comments online be connected with their physical identity, and I'm sure that's quite effective at stopping people from spreading any unacceptable ideas.
Europe vs. USA – toilet technology teardown
China has a similar system.
I'm glad I'm not in the military any more. Putting my life in the hands of someone who is here because he passed the tests OR because of her gender is out of the question.
Word of warning to anyone that might give Neon Genesis Evangelion a watch after seeing this - a lot of people include it in the "mecha" genre but if you're looking for a light-hearted, Saturday-morning, big-robots-punching-each-other kind of experience that's definitely not what Evangelion is.

It certainly includes big robots as a plot point, but that's really just a backdrop for the character drama and deeper (and pretty heavy at times) emotional themes of the story. Things get very avant-garde towards the end, and the studio producing the series basically ran out of money to animate the last few episodes so you'll have to jump between the movie adaptations if you want a complete experience. I'd still probably recommend at least giving it a try sometime, as it's personally one of my favorite anime series and a landmark work in the medium as a whole.
I think my point was not well constructed.

NZ locked down, had good isolation, and got a bit lucky.

The problem with COVID is that because there’s a large portion asymptomatic carriers, the success of contact tracing can vary a lot.

In Canada, it is politically expedient to point to (valid) US failings and throw them under the bus. I don’t doubt that this is something done by the BC health officer at the time. My math of single digit percentage is based on even having a few cases a day coming in contrasted with 10-20 cases underrepresented by a factor of ~5. It’s just guessing, but I doubt they have more than a few direct travel cases each day and therefore community transmission was significant. I would be curious if there was any data that suggests this guesstimate is wrong.

It’s possible to argue that all that community transmission was the result of border crossings, but the same is true everywhere and quickly becomes non-sensical. Would the virus have disappeared if not reseeded by travel cases? We do know that New Brunswick and Nova Scotia had the same essential travelers (i.e. baseline imports) but were able to effectively control and have had no deaths since August of last year (and very few cases).

I’m not saying that BC did a poor job — I’m not sure that BC could have done anything to contain the virus completely. But I also don’t think it’s reasonable to point the finger completely at travelers as the thing that prevented success.
> but they seldom mention this means an earlier sunset

I thought normal time meant a later sunset and later sunrise in the winter. That's why DST was enacted no? So that in the winter the sun rises earlier and sets earlier?

Anyways my preference would be for later sunrise and sunset, so that more of the day can be enjoyed around work. Which I think means staying on standard time the whole year.
The navigation demo has no arrow. How do you know to take the turn? But club tech... yes pls.
Adjusting your entire schedule (commute, job, child care, school, bedtime, alarm time, meal times) twice a year is much much more disruptive than changing your clocks twice a year.
The Irish are some of the best dart players in the world, so I think Stripe would end up in Dublin either way.
Yes, you can, you can pipe tar to the AWS CLI to upload a stream, like "tar -c ./myfiles | aws s3 cp - s3://my-bucket/myobject".

For very large uploads you must also specify a chunksize using "multipart_chunksize" such that the upload will require 10,000 chunks or fewer (the CLI can't do this for you because it doesn't know the size of your stream up front).
AZ and Hawaii experience ranges of [10-14 hours] and [11-13.5 hours] of daylight across the whole year, respectively. More southern latitudes can get away with not shifting their clocks because the daylight variance is much smaller. In AZ, sunrise varies from 5:15AM to 7:25AM. In Seattle, without DST, it would range from 4:11AM to 7:57AM. If we use "civil twilight" (bright enough for outdoor activities), Seattle would start experiencing daylight at 3:30AM in mid-summer.