skysight-inc/HackerNews huggingface dataset:
the problem with ON DELETE CASCADE isn't the CASCADE, it's the DELETE. Almost always, you want to to mark an entity disbled, not really DELETE it. If you want to DELETE it (for GDPR?) you should have something in place to fail your delete unless you've properly defined how to clean up danglig keys. (Perhaps what you need to do is delete the non-primary-key fields containing user data, but keep the row for relational integrity)

ON CASCADE DELETE is used for deleting logical sub-components (a row owned by another row) in a well normalized database -- it's for deleting your dadress book when you delete your account. It's not for deleting all your friends when your account is deleted.
You do not have to be a monopoly to be in violation of anti-competitive business practice regulations.
Sorry, I mean polling for the ready register, not interrupt.
if you don’t mind sharing, I’m curious to learn more what was the main challenge was applying Calvin.

Thanks!
Don't get me wrong, I like Elm a lot, but the drop in expressiveness/ability to build abstractions from Haskell is substantial. Especially when you're looking at modularity, there are a bunch of things that Elm can't abstract out that both Rust and Haskell can manage just fine.

I haven't used Rust heavily enough to comment on how it compares in great detail, but comparing to Elm as a proxy for Haskell doesn't really work.

Frankly, paradigms are a really lousy way to think about languages. I wrote a series of blog posts about this[1], but this opening lecture from one of Brown's PL courses I think does a better job of making the point:

https://www.youtube.com/watch?v=3N__tvmZrzc

It's useful to talk about what say, GC, laziness, lifetimes, ownership, typeclasses/traits, higher-kinded types, higher rank types, variants, elm-style records, etc. do to a language, and how they compose, but I think you can't go very far talking about how "paradigms" compare.

[1]: https://zenhack.net/2018/07/14/three-funerals-in-the-name-of...
Enable FKs for test and development, disable them in production, for tables that see billions of rows.

FKs have other downsides. They add locks on the referenced rows, to ensure they don't disappear before the transaction commits. If you start out with 32-bit primary keys, you have a major pain when you go over 2 billion records - incrementally upgrading all your FKs before your PK breaks your referential integrity, since FKs generally need to have the same type on each side.
Suffering matters. Because we all are capable of experiencing it. And it should be the basis for systems of morality, and therefore help guide our decisions.
TCP over BlockChain over SMS
Sounds like someone discovered Nihilism?
It’s not strictly necessary like breathing and eating, but it can be an extremely powerful time to spend time together as a functional or leadership team and really hammer things out. We do it 3 or 4 times per year for 3-4 days at a stretch. I see it as part of the job and honestly look forward to them, even though they can be grueling.
there are many formats. in some the field is as level as possible, in some it takes years to understand all the mechanics and interactions.

the cost to enjoy it is minimal if you’re not playing competitively and even if you are paying attention to the meta matters more than investing thousands of dollars in the game
That's the paradox of tolerance in a nutshell, yeah.

As stated, I don't think public conferences are an appropriate forum for this kind of polarized argument, but it's not wrong either. Wearing a MAGA hat is declaring your alignment with a political platform that pervasively equates mexicans with dirty criminals, muslims with terrorists, gay and trans people with the mentally ill, and anyone who isn't a white rural christian with "not a real american".

That's intolerance, straight up. And that's what you're telling me if you wear that thing. And if it's my environment your standing in I don't have to put up with it. Refusing to tolerate intolerance is the paradox, and the solution is to get out of my face with that hat.
Although we cannot preclude the GP's experience, as a former developer and verifier of safety-critical systems, my experience (from the 2000s) agrees with the parent post.

Safety-critical systems (at the time: DO-178B design assurance level A in airborne systems) were about custom processor boards based on mature technologies (PowerPC was popular; caches often disabled for maximally predictable peformance), quadruplex redundancy, software with 100% MC/DC test coverage, verification of traceability between source code and object code, zero-runtimes, no dynamic memory allocation, extensive time budgeting analysis for control loops, worst-case stack utilization analyses, hardware watchdogs, extensive built-in-test and multiple independence objectives (verification team had to be independent of implementation team etc) as well as formal methods like data and information flow analysis.

These systems are virtually nothing like conventional "information technology" systems.
Cogeneration happens at the gas-to-power side of things. Doesn't help you with electricity generation, but that's ok as the goal is reduction of emissions across all sectors.
Huh? If you have a tree with parent pointing to children, how do you get a child's parent? You need an index. Same as with a DB.
> You can't deploy an app to a phone that you own unless you also own a Mac workstation running OS X and pay Apple $100/year for the privilege of using the very expensive hardware you bought from them.

This hasn’t been true for a while now.
Thanks everybody, pretty much all great and valid points. This is all usually very much glanced over and oversimplified in most online docs and tuts in the "web development" area which is unfortunate since it's usually all mostly about keeping and maintaining said data.

I frequently get the self-awareness that there is a lot of sql functionality that I'm probably missing, misusing or completely ignorant of.

Particularly, the fk example just stood out because even though it's usually an integral part of database design i don't think enough importance is given to them "overall".

As @mpartel stated, as most orm's have similar functionality built in, their usage is just basically ignored. Also good example about the transactions stuff, I rarely see the use of foreign keys encouraged (and on your example pretty much almost required) in online tutorials and docs when discussing transactions.

More of a rant really, thanks again for the input guys! +1
Transparent Programming
2b) And keep your schema changes as incremental and backwards-compatible as possible. Add new tables, add columns to tables, but don't drop or rename anything. If you need a flag day, in PG terms just setup a new schema, use triggers to sync the two, and migrate your apps to use the new schema -- when they're all migrated, drop the sync triggers and the old schema.
Which Apple may keep private for any number of reasons, none of which have to do with hobbling competitors, nor is it proven that Safari uses these particular APIs to gain a performance advantage for itself in any way whatsoever.

So you’re basically just talking out your ass, saying that Apple should open up APIs that have always been private for the sole purpose of helping a competitor who knowingly adopted them in violation of platform rules.

“Yes, officer, I broke the law. But I think, now that I’ve broken it, you should just abolish the particular laws that I broke because some people think I’m a big deal.”
You can implement FKs with the same cost as FKs. Look up the referenced rows and add read locks. It's not cheap. FKs are by no means free.
The Story of the Huge Chunk of Cheese That Sat in the White House for a Year
> Nothing we ever do will ever be remembered or matter.

I am not so sure about this. Our data based society pretty much guarantees that a lot of information about what any one of us did will make it into the future as long as the species (and tech level) survives.

Even more so if we get off-planet. But yeah, ultimately that doesn’t really matter to the main point of the article.
>> So, in Magic, the rare cards are often the more interesting cards, but the most powerful cards are meant to be common so that everybody can have a chance.

It's funny but just today I was playing a match in M:tG Arena and I noticed that I used a card's rarity to make a decision. The card was Worthy Knight, a 2/2 creature and I was trying to decide whether to attack into it with my own creature, a Pelt Collector (at the time also a 2/2, with a +1/+1 counter). Normally, in that situation, I wouldn't attack with Pelt Collector - I'd wait for it to grow a bit and then attack so it wouldn't just trade.

However, I wasn't sure what Worthy Knight was doing in the opponent's deck, but I noticed it was a rare (I didn't know the card, it's from the new set, Sword of Eldraine).

Now, normally that would make no difference, but there is no trading in M:tG Arena, as there is in the physical game, so rare cards are harder to come by in Arena than they are in the physical game. Given that Arena booster packs only have eight cards, when physical booster packs have 15 cards, a full set of four of any rare represents a more significant investment (of money, or time) on the part of its owner.

Based on this I figured that, if the opponent was running Worthy Knight (and likely a set of four given I'd seen it in the first turn), then it must be somehow important to their strategy. So I attacked with Pelt Collector and we traded (i.e. the two creatures killed each other in combat).
+1 million times this. Seems like everywhere I work with are concerned about google size data problems when the apps I'm working on are at best 1000 concurrent users...
To be fair, that text was added after the above comment was posted.

https://github.com/lovasoa/bad_json_parsers/commit/16f6ed75b...
All you need to know is WITH RECURSIVE CTEs.
Domestically, yes. Internationally, no. The US has a long history, comparable to if not more extensive than either China or Russia, of supporting totalitarian regimes in other countries.

When accessing the potential danger of a new technology, for a large number of ordinary people in a lot of places around the world the chances of it being misused by the US against them is as likely as it being misused by Russia or China against them, and so lumping those three together is not unreasonable.
Agreed, so we might as well do something interesting. We inject meaning. Or we don't and suffer. Totally up to us.

Wild.
Are you talking about systemd-networkd or Network Manager? Those are separate projects, and I agree that Network Manager is garbage. Still, you don't have to take systemd wholesale. You can still use ifupdown if that is your jam.

In your specific case, if you were using systemd-networkd you could specify MACAddressPolicy=random in your link file to achieve what you wanted.
TBL might not have used SGML tools, but surely wanted to make HTML extend to SGML proper and appeals to SGML concepts at several places in the linked document:

> Currently HTML documents are transmitted without the normal SGML framing tags, but if these are included parsers will ignore them.

> In SGML terms, paragraph elements are transmitted in minimised form

> These tags are kept as defined in the CERN SGML guide. Their definition is completely historical, deriving from the AAP tag set.

> (not good SGML)
Researchers didn't think humans attacked woolly mammoths until uncovered a trap
You are right; I've fixed the typo.
yeah. the guy who invented it does not know.

-5/-5 for you + you must suffle all of your library into your graveyard
Hmmm, so exactly the thing that so many people said would happen has happened? Surely not!

CoCs are not laws. The purpose of laws is to define what is allowed by what is explicitly prohibited and by these being all that is prohibited. CoCs on the other hand are an ill-defined subset of what is prohibited that is selectively enforced for political goals. They do not bring any of the benefits of codified laws. They do not clarify what is and isn't allowed since they are so general that none of those who wouldn't grasp these rules intuitively would grasp them after reading a CoC. I see no value added by CoCs, only potential for abuse.
On a somewhat related topic, I noticed massive amounts of gifs that I would typically discover through Android's keyboard option (hooked up to Giphy I believe) were deleted sometime last year (tons of content, even obscure stuff, related to pop culture and movies, even DBZ abridged stuff). I was not sure if this was done by the website hosting these gifs or the users themselves but it was such a large number across so many genres that I suspected the website scrubbed them for whatever reason (also cannot be found through the main website itself).

Additionally, I've been looking for gif hosting websites and Google does not make one mention of Gfycat anywhere in their search results for keyword "gif websites", and this is after going through the first 5 pages of results, which seems a bit odd to me.

edit: I found Gfycat on the 7th page of Google search results, interesting...
No. Just use an RDBMS that doesn't suck -- one that supports WITH RECURSIVE CTEs.
One of the greatest lies perpetuated in America is that people's objection to things like a wealth tax is based on a belief they could one day be billionaire's. It isn't. See Davidu's comment.

There are better ways to do what the wealth tax candidates want but they aren't imaginative enough for that task.
To be fair, the article was updated to address those complaints after the comment you're responding to was made.

https://github.com/lovasoa/bad_json_parsers/commit/16f6ed75b...
Not exactly. First, the corporate shield is not absolute: https://en.wikipedia.org/wiki/Piercing_the_corporate_veil

Second, for this issue, I don't think it even applies - their complaint isn't about WeWork, but specifically about Adam.
Do you blame individual engineers for the business decisions that their companies make?
If we learned anything it's that american financial institution are excellent at developing novel financial tools to resolve these issues.

You're right, an owner of $160M paper money might not have 2m/year liquid, but I am sure there will be many banks willing to provide equity secured debt (perhaps no payment needed until exit!) to pay for the taxes. Also, if this pushes startups to profitability/IPO earlier, I think that's probably a good thing.
You have misunderstood this movement. It's not about fairness or stopping discriminatory behavior. It's about banning all opinions except the sanctioned one.

"Do not speak unless you are one of us, do not think unless you have been told how to, do not hold us to the same standards as we hold others."

Those should be the mottos of these idiots.
Public Investors Signal It’s a Buyer’s Market for Money-Losing Startups
You don't need a service as big as GitHub; you just need billions of rows.

I think you should enable FKs for test and dev, and possibly QA, but disable them in production.

Depending on your database, you'll get surprising interference in concurrent operations via other means than FKs, but FKs don't help.
A good question to ask does the answer to any of these nebulous ill defined questions have any non socio-politcial consequences? If the answer is no, be very very dubious.
Populism vs. Populism: The Choice in the UK
Free Ecommerce Tools to Increase Online Sales
On Solid, or specifically the ACLs proposal? There's a lot of ongoing work on Solid in the Gitter rooms, forums, and the working groups for the differest standards. There's also a growing set of (MVP) apps for Solid right now.
Configuring DNS-over-HTTPS on Pi-Hole
McKinsey Faces Criminal Inquiry over Bankruptcy Case Conduct
I'd go one step further and say that allowing you to type faster just makes your programs worse.

>Why should I spend time implementing this logic as a function when I can just use macros to type it 5 times with 5 key strokes?
just buy a duel deck and play that w/ a friend.

the barrier to entry is super low. i can teach you how to play in the time it takes to drink 2 coffees. it’s trivial. to actually see beyond immediate things? well... it’s gonna take a while
Robinhood users are gravitating towards loss-making companies
> First let me say that I find it highly problematic that the complaint and the decision were public. Indeed I am surprised that LF would accept a publicly submitted code of conduct complaint. I am much more than surprised that LF would ever consider publicly responding to such a complaint.

Transparency is good though.
It seems to me all these companies would benefit by pooling resources into an industry wide organization for defending against this sort of thing.

If case law is set by the little guy losing, it doesn't matter how much money 23 and me is throwing at their cases.
I write 'colour' most of the time. But when I comment on US websites, I use 'color'.

I suppose that's a case of 'When in Rome ....'.

Still, there are some words whose meaning changes completely whether you use US or British spelling. In British English, the US-spelling 'pedophile' becomes British-spelling 'paedophile'. But British-word 'pedophile' means 'somebody who loves feet' (a foot-fetishist), from the same Greek root as 'pedal','pedestrian','centipede', etc.
Visual6502 Remix
The comments here are missing the real issue - its the inconsistent application of the private API rule by the app store teams that is arguably the worst part of this. Apple have a terrible track record in consistent application of App Store rules. I'd argue there's enough evidence now to support a theory that some apps are considered just too important to reject.

When will they pull big Electron apps like Slack et al? I'm guessing never. It's often the little guys whose business gets stomped on by the unfair application of these rules.
The point is, people lives are often in the hands of fragile software that doesn’t meet the standard of a safety critical system.
> fix a problem that didn't exist

Didn't exist for you, maybe.

Are you by any chance a white male? I myself am I white male, and while I don't personally have problems at conferences, I wouldn't pretend that problems don't exist.

> What privilege

Indeed.
What is ageist about a workweek-long company trip? I went on them in my 20s, my 30s and now in my 40s. I’ll do them in my 50s as well. I went on them when I was single, in a relationship, and married. I went on them before kids, with infants, toddlers, and now with elementary school age kids.

My fellow attendees at these events are in their 30s through 50s (and for all I know, some might be in their 60s or 20s).

I don’t see ageist discrimination around business trips to be honest. If business travel isn’t for you for whatever reason, there are an enormous number of jobs that don’t require or even offer business travel.
There's hope though.

Drivers practically only develop enough margin if their cost per mile decreases - and the best ways to do that are for it to be a trip they are already making, it to be a pool, or to be delivering food at the same time - or shorter rides with fixed pickup costs.

And as prices rise as profitably is sought, passengers will look for ways to reduce their trip needs, incorporating public transit again.

Unfortunately, neither of these models supports the number of drivers currently in the system.
I think many young people, including those referred to as "snowflakes" are hardly being cautious with their online behavior, or what they say to people.
Technically, this makes the duck curve worse, because the actual "problem" the duck curve presents is solar ramplong down in the evening faster than gas can ramp up. But trackers (or west facing panels) make that more like a square wave so it lasts longer but then falls faster than a static south facing panel.

But, the duck curve isn't a real problem anyway. Worst case scenario, some solar gets curtailed , creating an opportunity for storage solutions.
this is literally how not to handle errors, so why are you doing it?
Will result in corruption. Yes.

Will result in more fault tolerant software, also yes.

It's a trade off and one I make willingly at every scale.

I stopped using foreign keys after university and have never wanted them since.

Non nullable database fields are far more useful than worrying about fks.
They might be shooting themselves in foot here. Part of the reason why Microsoft is so big and why there is a PC n every home is because many of us could pirate Windows and Office in early days. That reduced barrier to entry and enabled poor folks in India and elsewhere use computers and be familiar with all other MS technologies.
I'd turn it around. Has there ever been an instance of a CoC being used in an unreasonable way against an actually reasonable person? There's been a few cases that blew up because the behavior fell into an arguably ambiguous zone, but I can't think of anyone who suffered real consequences and didn't have it coming. Just a little more tact and thoughtfulness on the offender's part would have saved a world of trouble.

Now I'm of two minds on this. I do sometimes miss the more freewheeling culture of the '00s, and feel like the need for constant compliance has drained the tech scene of some life... but honestly it's a small price to pay if the only alternative is tolerating fascists in your midst.
FKs add read locks to referenced rows. It limits concurrency and it is observable. FKs constrain your ability to incrementally widen 32-bit FKs once you go over 2 billion rows, if you start out with 32-bit PKs. Two concrete reasons to avoid FKs in production, or at least disable them for longer running transactions.

I think this perspective is something you only get once you've run bigger databases in production.
This is approximately what people used to say about EAL4+ certified products, until everyone realized you can just look at the list of EAL4+ products and the CVE database and compare.

Look, I don't doubt that there are avionics systems that are secure by design (largely because their inputs and their functionality are extremely constrained). But that's a question-begging definition of "safety critical", because --- my expertise isn't in avionics but I've done a fair bit of utilities and medical work, for example --- those "safety critical" systems tend to be embedded in larger distributed compute systems that are riddled with vulnerabilities, with an ultimate systemic security result of "some doofus on the Internet can blow up a transformer".

So if the argument is "you can in fact built safety-critical systems by massively expanding the cost in money and time to built drastically simplified and less useful components", sure, you win. But if your argument is "the safety critical industries all know how to field software-based infrastructure that is safe from attack", then, based simply on personal experience, I'm going to call "shenanigans", because no, they cannot.
Ubuntu 14 doesn't use systemd. It was the last LTS prior to the systemd switch.
Entrenched ideas resist change. Some of the worst ideas in human history have been the ones that have stuck around the longest. It took over a century to adopt the heliocentric model which was centuries after Aristarchus of Samos first proposed the idea.
Some other recent Skype features:

Calls not connecting despite both users being online

Calls dropping suddenly

Calls seeming to connect but neither user can see or hear the other

Video freezing for one user while fine for the other

User showing up as online when not

User showing up as not online when actually online

I wonder if their case studies showed these would cause users to flock to this "walking dead" app. But hey, a UX lead got to put "re-designed Skype" on their resume, and their logo animates differently while connecting, so they have that going for them.
I tell you, we are here on Earth to fart around, and
don't let anybody tell you different.
Kurt Vonnegut

Yup. Gotta keep some perspective.