skysight-inc/HackerNews huggingface dataset:
> It all came to a head when I naively asked an experienced SQL developer how to represent a tree in SQL and learned one way to do it was to have CHILD nodes with FK references to PARENT nodes. So any time you want to get all the CHILDREN of a PARENT you have to query all children to see if they have a FK to the appropriate PARENT.

One far-less-painful solution: use what's called a "closure table" to track the ancestor-descendant relationships not just at the parent-child level, but also grandparent-grandchild, greatgrandparent-greatgrandchild, etc.

For example (assuming Postgres, and eliding some NOT NULL constraints for readability):

CREATE TABLE node (
id INTEGER PRIMARY KEY,
parent_id INTEGER REFERENCES node
name TEXT
);

CREATE TABLE node_closure (
ancestor_id INTEGER REFERENCES node,
descendant_id INTEGER REFERENCES node,
depth INTEGER,
PRIMARY KEY (ancestor_id, descendant_id)
);

Then, whenever inserting a new node (assuming that Postgres allows specifying integer primary key values on insert, which I don't recall if it restricts by default):

-- First node
INSERT INTO node VALUES (0, NULL, "foo");
INSERT INTO node_closure VALUES
(0, 0, 0); -- self

-- Second node (child of first node)
INSERT INTO node VALUES (1, 0, "foobar");
INSERT INTO node_closure VALUES
(1, 1, 0), -- self
(1, 0, 1); -- parent

-- Third node (child of first node; sibling of second node)
INSERT INTO node VALUES (2, 0, "foobaz");
INSERT INTO node_closure VALUES
(2, 2, 0), -- self
(2, 0, 1); -- parent

-- Fourth node (child of second node, grandchild of first node)
INSERT INTO node VALUES (3, 1, "foobarbaz");
INSERT INTO node_closure VALUES
(3, 3, 0), -- self
(3, 1, 1), -- parent
(3, 0, 2); -- grandparent

The upside is that it's now trivial to query for a node and all its descendants:

SELECT descendant.name
FROM node AS descendant
JOIN node_closure ON descendant.id = node_closure.descendant_id
JOIN node AS ancestor ON ancestor.id = node_closure.ancestor_id
WHERE ancestor.name = 'foo';

Or more succinctly (if you already know the ID):

SELECT name FROM node JOIN node_closure ON node.id = node_closure.descendant_id
WHERE node_closure.ancestor_id = 0;

Either of which gives you:

----
name
----
foo
foobar
foobaz
foobarbaz

As part of this upside, since you're not having to loop through every level of ancestry, reads for deeply-nested descendants are much faster.

The downside is that you have to do extra inserts to an extra table. The inserts themselves can be automated by adding a trigger on node which automatically creates/updates/deletes node_closure rows as necessary (which is why you'd still want the parent_id in the main table: so that the trigger can grab that and build the closure rows, and so that if the closure table gets out-of-sync you can fall back on that and rebuild it), but that still leaves a performance impact on writes (pretty negligible for shallow descendants, but it gets worse for deeper ones).

Personally, I'd opt for a closure table if I know that reads are going to be more common than writes. If writes are more common than reads, then sure, some sort of crazy recursive query might be preferable.
I would recommend looking at seedboxes /servers where you run your torrent client/. You can then download the files from the server. 10-15 years ago, it was pretty cheap, so I can't imagine it hasn't gotten dirt cheap by now.
who wants to go to kubecon anyways? it's not like any of those fools know how to provision software on linux - it's just a bunch of social-mad js hipsters with memes like "service mesh" (translation: I know how to install a nginx reverse proxy)
>In lots of cases going for the very long term scalable solution will be an impediment to your growth, and I'd suggest dealing with those issues when the chance that you need them is on the horizon, rather than across the globe.

My attitude is:

"Man if this takes off and I have to make some changes on how we do this....I should celebrate!"
How is a wearing a MAGA hat a CoC violation? This is so blatantly political that it's ridiculous.
So 50% of the US (republicans) are in violation of the CoC. Echo chamber much ?
What kind of rendering issues?
A Wearable Wiretap: A new generation of ankle monitors raises thorny questions
It’s not necessary to use kiam - as I mentioned that multiple times - but you need something like that if you’re trying to maintain security coming from a good EC2/ECS deployment. Since it’s one of the more popular options, and Java is not uncommon, it seemed reasonable to consider this a likely pain point for many users.
Some of the ancient justifications for heliocentrism included "fire is awesomer than earth"
I am not completely familiar with these APIs but from what I gather they are primarily intended for low level rendering and to support them means supporting frameworks that bypass all of Apple’s native APIs.

Apple does not want to do this for business reasons. Microsoft does, but they have a different business model than Apple. Apple is in the business of selling their own hardware which means they want exclusive apps. If everything is cross platform then Macs become an overpriced commodity. Why even develop macOS at that point?
I'm thinking that the streets of 2029 will be covered by cameras and scanners with ubiquitous recognition and tracking capabilities, and financial transactions will be much easier for government officials to access and monitor. Can a person like Waymond get by in an urban area like Oakland? I'm not seeing it.

Maybe, like you say, living as a 1919 homesteader in the middle of nowhere is possible, but that's not an option for people who need access to employment, family members, etc.
I’m still struggling to find the context for this whole thing. Where did you find DDD mentioned?
> This issue transcends politics, and is more directly about ethics and human decency.

Yeah I mean, that's just, like, your opinion, human.
Even so, there is a halo-effect - and customers’ expectations to meet.
How do you know how much time I have spent in Quebec and why I am so passionate about it, mon ami? I really really wish those were from 30 years ago, this is what the current government is doing right now:

"Quebec kerfuffle over bilingual greeting Bonjour- Hi!"

https://www.rcinet.ca/en/2019/10/08/quebec-kerfuffle-over-bi...

The world is watching and condemning:

"Toronto council passes motion to condemn Quebec’s secularism bill"

https://globalnews.ca/news/6109225/toronto-council-motion-qu...

"Redditors Have Made Their Own Hilarious Quebec Values Test & It's All About Poutine"

https://www.narcity.com/news/ca/qc-en/quebecs-new-immigratio...

Those are from the past few weeks only, not from 30 years ago and we have to expose and share the stupidity to push the government to backtrack as much as possible.
I'm curious how you've been doing since then. I've been dabbling a little bit but I haven't found a really good guide or documentation.

I feel like most guides or tutorials are outdated or incomplete and it seems like documentation isn't very detailed. I think I understand the basics (create or select an SVG, add elements to it, apply attributes, etc) but lots of functions still leave me wondering what they do exactly and how I can change them to meet my needs. Curious what your experience has been and if you have any projects to show off.
GUH GUUH
A guideline is a rule, just a non-specific one. Sometimes it's more a suggestion, sometimes it is iron-clad. For example, HIPAA Privacy Guidelines will still land you into serious legal trouble if broken.

The fact that Apple are rejecting apps that break the guidelines (even if not consistently) is proof enough that guidelines can be iron-clad rules in certain cases. It depends entirely on the context and the authority setting them.
See @freels’ reply above.

I think it is fair to say that the Calvin paper is visibly incomplete and expresses some constraints in a way that makes them seem insurmountable when they are not; specifically, they are only constraints within the log, but do not constrain the database experience overall.

Applying Calvin to traditional RDBMS workloads was a very unlikely creative exercise because it required questioning these explicit constraints.

The Spanner paper also leaves a lot unexplained, but it is less obvious until you are too far down the path to turn back. After all, it worked for Google. Calvin did not have that real-world proof. Combine that with the pessimism of the paper itself and nobody was willing to pick it up.
Also, if you look at it as bottom as front, the description doesn't match. The left side is slightly forward to the right, contrary to the article.
Why the downvotes, this is exactly how it is, we have to talk about it openly, expose it and try to change it!
... Wouldn't the statute of limitations pass after 10 years?
I find it difficult to have any remorse, given that this industry is one of the most morally bankrupt and predatory. Sorry, agree to disagree.

> Sorry, I'm not

Indeed you are. Even US law disagrees with you, and that is some of the most ridiculous.
Congrats on having no debt of any kind. I have debt. I also strictly budget my income and expenses (also with a big ass spreadsheet). Healthcare costs me more than $300/mo. Daycare (1.8k/mo), housing (1.2k/mo), car ($600/mo all inclusive) and food ($550/mo for a family of 4), are my largest expenses. Don't tell me to get rid of the car; I don't live in a city or area with ANY public transportation. The car is literally, it. No I'm not moving to CA. I don't have luxuries to cut. I don't go out to eat, I don't have Netflix, Spotify, Amazon prime, or the latest phone (my phone is a One Plus 3). I use a service provider that costs me $60/mo for two lines (TOTAL - $60/mo) for cell phone. TV is friends Plex or free Roku apps.

I won't say how much I have in savings, but your 100k in five years (20k saved a year?! SERIOUSLY?! that's more than min wage full time job, PRE TAX!) is not at ALL realistic. No I don't work a Min Wage job, but I'm not SF/Bay/SV area salary wither.
Right, but that comes out of the exact same code with some minor feature flags.
You seem to have your facts confused. Wood wasn't publicly planning to wear a provocative hat to a conference or anything like that.
Some great answers here, but if you're doing anything that involves going out and about (e.g. buying phones / cards / starbucks etc) - Don't forget to leave your regular registered phone(s) at home or office, and never allow burner and registered phones to be active (powered on) near each other.
current gop behavior is pretty bad, i hesitate to associate with anyone still aligned that way if i don’t have to. it was not this way 10 years ago.
Or "stage right" and "stage left."
It's one thing to try and quantify the collective "cost" of a hypothetical increase in traffic. It's another to lay blame for that increase on one segment of traffic user, and assume troubles would disappear if that segment were suddenly gone.

Especially as more studies show that most regular cyclical heavy traffic is ultimately supply-side controlled, given any chance to reach equilibrium.

>Finally, given 60 percent of rideshare users who could have used public transportation otherwise

"Studies" like this are worse than misleading. Just because people could have done something doesn't mean they would have.

And public transport ends up paying the price for it eventually, because when arguments like this end up funneling money to public transit projects with inflated demand: 1) they steal money from more beneficial projects based on realistic modeling of life choices, 2) they end up underperforming vs expectations, which makes public transport look bad, 3) if they aren't self sufficient, end up being an operating budget drain in addition to a capital layout drain.
Interesting, thanks for sharing!

Do you think it would be viable using a pool of 'a few' residential connections (think fiber >500 Mbps upload) in each region, with some x86 server behind each to transcode / store?

The idea being to self-host the whole infra between users themselves, those willing to plug a desktop/server somewhere.

I figure you'd only need a basic load balancer in an actual cloud (always on) which redirects to whichever server is available enough.

Any thought about any of this?
This has "fragile" written all over it.
> I don't think it's too far fetched to imagine a future where camo facepaint becomes fashionable enough to be widespread

A lot of those masks people in China wear they refer to as privacy masks (though this seems more an auxiliary usage -- especially in HK -- where the primary use is for filtering air). So I'd say there is evidence of such styles already becoming fashionable.
It is ridiculous to say that Chrome/Firefox are only popular now because they use private APIs.

Your own article says that Firefox only recently started using them.
> Make it illegal to use facepaint.

How do you distinguish this from makeup?
We are living in Hideo Kojima's dystopian nightmare
Fast forward to someone maintaining your code full of empty method stubs and unused variables because "that's my style".
CALayerHost and CAContext were listed in the offending apis in this rejection of an electron app https://github.com/electron/electron/issues/20027
Note that your parent does not argue "only suffering matters", only that "suffering matters".
You are free to use the POSIX networking APIs in lieu of CFNetwork (or Network).
Doubtful - the 6502 had something like one poly and one metal routing layer. It was hand routed by a human; balancing the use of poly, metal and diffusion is pretty tricky and requires bending a few rules that would otherwise constrain an autorouter in order to get everything to fit.
I don't understand the moral indignation. Getting angry at netflix et al. for trying to improve their bottom line is like getting angry at water being wet.

If you want to pirate, fine, pirate. I just don't understand why people are so insistent on coming up with moral justifications for their actions. If it's moral or immoral fine, who cares? It's simply a sign of weak character when someone needs to come up with a justification for every little thing they do.
Ah, well, I grew up 60 miles from the closest town, and 10 miles away from the closest neighbor, and the house didn't have a phone until I left for school at 15, so I guess my standards for acceptable-levels-of-existence are not up to the modern urban standards. I mean, all we did was grow our own food, and sell some of the excess to pay for land taxes and energy/fuel. And, no, I am not a boomer.
Hiking. Lots of great hiking trails.
at first it wasn’t clear if younwere talking about uncle bob inserting himself or the linux foundation insert thenselves.
Non-AppStore Mac apps can use the contacts API, I'm not sure what you're referring to.

The ability to use an Apple ID for payment probably adds a bit of convenience for some people, but we have Apple Pay on the web, not to mention Stripe and Paypal. It really doesn't add all that much friction.
> He is still wrong about that claim

Do you have a source for this? I've yet to see a convincing debunking (https://en.wikipedia.org/wiki/Race_and_intelligence included), and https://en.wikipedia.org/wiki/Heritability_of_IQ claims IQ is between 57% and 86% heritable.

And no-one gets fired for claiming the opposite, which has way less evidence supporting it, and lots opposing it.
It Montreal, it will cost more... the corruption is more than 3% either...
It's a bit disingenuous to suggest that devaluing women, minorities, and foreigners is merely a difference in political views. It's an outright abandonment of human decency that is central to the professional ethics of western society and more.
Amazonia, 1952: Finding objects recovered from a Pan Am plane crash (2012)
Haha “you do you man” - hilarious! Read my “note:” in original comment. My whole point is a better human vs IDE I/O throughput. Can’t imagine this improvement can be any bad? Process stays the same, some aspects get significant improvement, that’s it

EDIT: also how many times in your career you had a problem where you had to make a significant and time consuming effort over that one line of code (other than hackathons, of course). With practically all high-level langs in modern collaborative environments readability is prioritized. “I should be able to read your code as a well written prose” - uncle Bob’s statement, is pretty much universal doctrine. Ability to type fast here is greatly underestimated
Cloud migrating production first in 12 hours or less
Cloud migrating production without a plan, and how it made me a better programmer ;)

We have a b2b webapp product in cloud_provider_a which started having trouble serving requests, timing out.

My team (supporting another product in cloud_provider_b) was tasked with setting up a duplicate of prod in cloud_provider_b. I can't even remember why mgmt thought that would help.

By the end of the day, by hook or by crook the call was made to switch PRODUCTION traffic into a newly made stack in a different cloud than where that application was currently hosted. Despite protest from the engineering and QA teams.

Its all a blur now. Things went horribly wrong for two days. On the third day my team (with no prior knowledge of how this product works) found that the docker containers running the app had an nginx config with a low worker_connections setting.

We changed that one line and the app is back up. But the cost has been high, our customers had a far higher level of disruption these 3 days. Our engineers feel burnt out and disrespected, and our QA teams are appalled.

AMA I guess
Radars don't go nowhere. Each one is read and triaged by the product managers.

The question is whether there is merit from Apple's perspective in making these APIs public.

Because often we find out at WWDC a year later why they didn't make it public and it's because of some foundational rearchitecture.
Meanwhile, AT&T and Comcast made it so difficult to sign-in and stay signed in let alone all the false positive "this is only available at your house" nitpicking that I rarely was able to use my TV service except when I was ass-in-seat in the living room.

I do not plan on ever getting cable again. If NetFlix wants to work with them to start being anal about how I use the service too I know who's on the chopping block next.
> The internet, to me, is the same

That's not the same scenario. The content was taken from a private place (bootleg, studio leak, paywall/subscription, etc) and put into a public place.
> I would have purchased if I could get DRM free movies.

I have a feeling this isn't true. I'm sure if they released DRM free movies you would simply balk at the cost and then use that as justification for not purchasing it.
Yet the Go standard library is one of the best around ...
It IS threatening to ME. That is my feeling. You can't take that feeling away from anyone. It isn't a different political view. It is human decency. Wearing that hat endorses every hateful thing Trump has ever said. It is a scorn on the human race.
Bye, Chrome: Why I’m switching to Firefox (2018)
It's possible to cache Plex encodes, I think.

But Plex is very limited in its encoding capabilities. H265 with HDR is just not supported properly. On top of that, there is just no way to encode H265 in real time (a high quality reencode of a Bluray can take days on top of the line Xeon CPUs). One would be better off downloading a few versions of the same movie; plex supports choosing which version to play.
Much more detailed comparison of JSON parsers:
http://seriot.ch/parsing_json.php
I'm assuming you're a web developer? I feel like users may have a different opinion.
I was quite confused by why someone was sharing a non sequitur about how fast a steganographer they met could type. Why is this relevant to the story?
> and then rejected it.

Or, it can be said, they went on to discover Optimistic Nihilism.
iMessage has had some interesting bugs:

* 2014 -- if you switch from an iOS device to an Android device, iPhone users who try to send you text messages that are channeled via iMessage will have their messages silently vanish ( https://www.cnet.com/how-to/how-to-fix-apples-imessage-bug/ ; IIRC after a lawsuit, they added a remarkable little support page, https://selfsolve.apple.com/deregister-imessage/ )

* 2016 -- Apple iPhone devices were being used to send text messages which were going to the wrong recipient ( https://wp.josh.com/2016/10/26/divorced-by-apple-in-californ... , discussed at e.g. https://news.ycombinator.com/item?id=12797249 )
I think you're giving the author too much credit. They recently chimed in on Twitter in a similar context- which I'm guessing is where the motivation for this blog post originates. And despite having a WebKit engineer publicly discuss design decisions and reasoning, they ignore them during that discussion and go on to write this article while making note of literally none of the context that was provided? https://twitter.com/johnwilander/status/1191185213012865025.

It's bad faith commentary, to say the least. Look at the level of accusation they're making "Apple Is Trying to Kill Web Technology" ... "It wants its Mac App Store to be filled with apps that you can’t find anywhere else." Leaving aside the fact that there's no way Apple makes enough from some imaginary exclusivity to justify trying to "kill web technology," none of their moves can even rise to that level. So they were slow to implement WebRTC? Service Workers? Both have massive privacy issues- and partitioning service workers out of process is the crux of how WebKit enforce's privacy- which they're pushing even harder these days. And according to said engineer they even added a compile flag so Google didn't have to use partitioning (I wonder why they wanted that...)- how very anti competitive of Apple. And suddenly mandatory WebKit on iOS is a "monopoly?" It's their platform- they define the security and privacy baselines. Apple has had a walled garden since before the "Web Technology" the author is referring to existed and this is a piece of that. It's another valid consumer selling point- their stores aren't cluttered with trash and I know what those apps can access. But, according to this person, every single point here is fake marketing speak because... checks notes... they want to force people to develop apps only for the Mac Store? Really?

We can be critical of Apple for a lot of web stuff, but it takes a delusional level of self-absorbance to think that Apple is bringing about the end of cross platform web tech because they put up a completely fair and valid barrier, that will probably be resolved shortly, as you said, on one's tech stack of choice.
Sure with respect to norms of Governance and policy style, not over whether a woman or a minority deserves to be treated with the same decency as any other human being.
Safari totally uses private APIs, just not for web rendering.
Exactly, this isn't some "political" difference, this is a fundamental fight about decency and human rights. It is THE core of open source in a way. Thanks for this, " This issue transcends politics, and is more directly about ethics and human decency."
Mark Twain invested in all sorts of crazy startups. If he was alive today, he'd probably be a billionaire, but he was way ahead of his time.

https://www.newyorker.com/books/page-turner/how-mark-twain-t...
Objective C is magic and you and get around the static checker with using Ducks and NSClassFromString. This is how all mac and iOS devs have done this is the past and will continue doing this forever. Apple will never close the Duck hole, because it doesn't want to, but it will always slap devs on the wrist for using private APIs in a non-duck compliant manner.
It doesn't exactly work like that — you can't just go into hiding to wait out the time. Since there was a warrant out for his arrest, and marshals were actively looking for him, I'm assuming the limit was suspended.

See: https://www.lawyers.com/legal-info/criminal/criminal-law-bas...
Why do you think this matters?