skysight-inc/HackerNews huggingface dataset:
> Foreign key violations are 100% data corruption

Sure, yes, of course, who cares?

These are self-imposed rules, so breaking them is wholly up to yourself. And there are trade-offs involved that may often make it acceptable relax them.

You seem to be rather invested in one set of arbitrary definitions. If people do fine even in situations where they "by definition" shouldn't, it's the definitions that have been found lacking, not the people.
If anyone is looking for a really eye-opening video take a look at that this. "Domain Modeling Made Functional"

It's applying Functional Programming to plain old Enterprise line of business apps in F#. The author argues why it's so much simpler, and simply walks through an example with cases. It's hard not to be persuaded. It leaves behind all of the lofty crazy maths you see in a lot of presentations of FP, and just shows how it's a simpler technique to solve real world problems.

Domain Modeling Made Functional -
https://www.youtube.com/watch?v=Up7LcbGZFuo&feature=youtu.be... (Watch on 1.25x speed)

It's really impressive, and also surprising why more people promoting FP don't show it's tangible benefits and simplicity vs. the theoretical/abstract way it's usually presented.

It's also a great introduction to 'Domain Driven Design' and data modeling regardless of the language you use.
Nice video indeed (I only wish the guy pointed the camera more to the objects of interest rather than his own face), but what is shown is clearly a magnetostrictive delay line (rather than an acoustic one) which is similar to one shown here: http://www.vintagecalculators.com/html/calculator_memory_tec....
What's shocking about this post is there is no mention of what private API(s) are being used by Electron. The link to the Mozilla blog post has nothing to do with Electron.

Edit: Google to the rescue:

https://mjtsai.com/blog/2019/11/04/electron-apps-rejected-fr...
Could you elaborate? That's horrifying. I'm guessing this was a camping trip then?
Sounds like the rule of demos to me. Don't worry too much about it, do better next time.
"The medium is the message" McLuhan was right and is still right
Going by that logic, if I watch a movie twice or more, I should be charged more? What is the difference, “electricity” and “bandwidth” wise if I watch twice, or me and my coworker watch once?
> I’m not thinking of how long it takes to read a book but of how long its effects can be felt, and of the strange phenomenon that even literature written in other times, on the basis of assumptions radically different to our own and, occasionally, hugely alien to us, can continue to speak to us—and, not only that, but can tell us something about who we are, something that we would not have seen otherwise, or would have seen differently.

I think other works such as the Bible, The Epic of Gilgamesh, Bhagavad Gita, and the Koran would have made the authors point much better about how books written a long time ago and in very different circumstances still can tell us who we are.

Surely, these books have far more influence on our world than Lucretius's poems or Faust.
The paper does look at the outflow. In fact, in the same paragraph as the "money quote" I copied it says, "uranium has a residence time of approximately 500,000 years". It's not clear to me that the 9000 tonnes is net or gross, but either way your original point still stands: ocean uranium is nowhere near a limitless resource, and could likely be made economically unviable[1] in a rather short timespan, perhaps even in a single human lifespan if we switched overnight to 100% energy generation from dissolved uranium.

What's more surprising, actually, is how much uranium we consume currently. And AFAIU, we do so very inefficiently. Seems to me we'd get a much better RoI by using uranium more efficiently than by turning to seawater for more uranium to waste.

[1] Assuming it becomes viable in the first place. It certainly doesn't seem economically viable, today.
Free will exists, but as spiritual masters going back at least to Jesus have observed, the free will can become enslaved.
Chrome has 1.5% marketshare on iOS but 70% on desktop. So "Mobile Safari sucks" doesn't seem like a good theory.
Supreme Court statistics: Interactive visualizations
I can speak to this problem as I develop an Electron app that targets MacOS, Windows, and Linux (as well as the web).

https://getpolarized.io

I'm just a humble independent software developer so I can't really target every platform 100% so having cross-platform code is really nice.

Unfortunately, every platform seems to want to screw you over somehow. I've written about this on our blog before:

https://getpolarized.io/2019/02/28/dear-app-stores-dont-bloc...

https://getpolarized.io/2019/04/05/Google-Will-Kill-Chrome-E...

Even CREATING the MacOS build for MAS is such a pain that I gave up. I tried going to the Microsoft Store but that also was a nightmare.

Every platform has hurdles and roadblocks designed to screw over developers and bring more money to Apple, Google, Microsoft, etc.

With Microsoft, for example, you HAVE to use their monetization platform. You can't use stripe.

With Google, they seem mostly just incompetent and not directly malicious.

The discussions on /r/androiddev are enough to scare you to NEVER build an Android app.

Have a business making 7 figures on the app store for the last 5 years? 10k revies? 5 stars? Not anymore. They just killed it and they won't tell you why.

Or someone files a trademark in a 3rd party jurisdiction and you lose your app entirely.

Then there are the big boys like Uber that just flat out ignore the rules because they know Apple won't remove them.

OR.. I could just bypass the app stores entirely right? Just distribute my app on my own site. Don't play these games.

However, now I've basically abandoned a massive source of users.

If you've never built an app and experienced how hard it is do to customer acquisition you're NOT going to appreciate how much of a challenge this issue is for ISVs.

Some apps simply would not exist without the app store distribution.

Getting featured by Apple could make or break a company. Just getting featured ONCE could mean the difference between your startup succeeding or failing.

... but they won't feature you if you're not in the app store. They also won't feature you unless you really do EVERYTHING they say including completely tailoring the app for their platform.
Apple will probably have to.

* I understand the prviate API was about reducing power-consumption.

* Apple sells itself on superior battery-life compared to Windows laptops.

* Unfortunately, the Electron ecosystem is too big to dismiss - there's a lot of software using it that could potentially pull customers away from Apple's App Store if they weren't allowed back-in.

* Despite the fact most of those apps are nominally free (Slack, Skype, etc), if they weren't available in the Mac App Store it would mean users would stop seeing the Mac App Store as the place to go for Mac software - thus damaging the brand.

In short: if Apple doesn't document this power-management API and make it public then significantly fewer _important_ apps will be available in their Store which is bad for Apple's current long-term vision. If these apps do modify themseles to not use the battery-life API then they'll reduce the computer's battery life which then makes Apple look bad.
Behold the party of self described “tolerance understanding and diversity” folks.
googling around i cannot find any info on this single-use tape story. do you have a link?

I did find the dvd one: https://en.wikipedia.org/wiki/Flexplay
Kinda weird how many people seem to think that Electron is a web technology.
No you can’t actually customize the networking anymore. On iOS Apple controls the whole web stack. Content, networking, JavaScript.
How do feel about ChromeOS? You can't really bring a fully independent browser there either - you have the Android APIs but they make for a pretty crappy desktop browser experience.
1. Google knows what they are doing. How many zero days does Chrome have this month?

2. Yeah, monads and applicatives aren't too hard, but really understanding monad transformers well is challenging.

3. I mean, yes, there are a lot of junior-ish devs who see the potential about FP and then spout how much better it is, but isn't that just like complaining about how annoying people are on twitter? I'm unsure its meaningful to make this criticism, or at least I'd like an example.
Safari on iOS is faster than Chrome on Android and given how crappy Google apps on iOS are I have no reason to believe they could do a better job than Apple.
Sorry. I have just seen way to many systems fail in way too many mysterious ways because "foreign keys are bad" and "the application code can do the validation". In fact, I wager that 100% of all databases that don't have FK's have some kind of data corruption that is causing at least some kind of user-visible issues.

It is frustrating to me because even the most green behind the error developer would cringe at somebody saying "we don't need the backend to validate user input because the front-end javascript does it for us". This is the same thing.

Never trust your inputs. Your application code calling the database server is exactly like some javascript client calling your backend system. Your database has tools to keep it from being fed bullshit input. For some extremely frustrating reason, people think it is perfectly okay to have the database trust its user input.

The result is in almost every single instance where those tools aren't used, the inevitable corrupt data will cause some kind of hard to reproduce user-impacting issue. I've seen it so many times it makes my head hurt.
I got, sent out a tweet looking for work and got an interview the next day in my city. ended up working there for a while.
It's not even a copyright violation it's at best a violation of tos.
No, I literally can't. I keep track of all the movies I'm interesting in watching in a list on IMDB. Checking right now (IMDB has this feature built in), it seems only about ~5% of them are on Amazon Prime. Assume I'm lucky enough that there's no overlap in the catalogues and subscribing to Netflix will get me another 5%, Disney+ another 5%, and let's say subscribing to the other services will get me 10% on top of that (they're smaller, but there are more of them ... this is just a guess). That means ... 75% of the movies I might want to watch any given night are simply not available through my streaming subscriptions. That's pretty bad, given how much money I'd be spending on all these.

You might claim I could still do this legally, by renting the other films I want to watch at $3-4 a pop on the same apps (e.g. Amazon video). But no, that won't work either. IMDB tells me that less than half of the movies I want to watch are available to rent from Amazon at all, even if I could afford the thousands of dollars it would cost to rent them all. And since catalogue overlap for rentals is nearly 100%, I have little hope that I'll be able to find any significant portion of the remainder somewhere else.

Even if e.g. Netflix somehow magically had every film I want to watch, it would still be a miserable experience, because since they don't like my browser / OS / hardware combination, I'm limited to 720p streams at 3000 kbps. That's noticeably bad compared to a Bluray.

Not everyone's film interests can be satisfied with the top five Disney films from each of the last 10 years. What piracy means is the ability to watch anything you want near-instantly for free in the highest quality it was ever released in, if not higher (pirates not-infrequently correct mistakes made on commercially mastered Blurays). And even some popular stuff (like the original non-special-edition Star Wars trilogy) isn't available at all, you'd have to pirate it.
> MySQL

What other database has been used at such a giant scale at so many companies, than MySQL? I'm sure Oracle and SQL Server are used at big companies, but nowhere near Facebook scale.
I'd argue that any decent application programming language can express these constraints better than SQL can.
Here we go with the nuclear debate again. Frankly, I'm against how the US/UK handle nuclear as a decentralized, privatized business. If we could have the French model for nuclear (and I know it's not perfect either), I'd be much more in favor. Also French high speed rail, let them take over and give us TGVs.

Of course this doesn't work for the US, because French nuclear (and HSR) depend on their dirigiste government--which has totally different assumptions about distribution of political power.

Edited to add: https://en.wikipedia.org/wiki/Dirigisme

with the following quote: "...marked by volontarisme, the belief that difficulties (e.g. postwar devastation, lack of natural resources) could be overcome through willpower and ingenuity. For instance, following the 1973 energy crisis, the saying "In France we don't have oil, but we have ideas" was coined. Volontarisme emphasized modernization, resulting in a variety of ambitious state plans. Examples of this trend include the extensive use of nuclear energy (close to 80% of French electrical consumption), the Minitel, an early online system for the masses, and the TGV, a high-speed rail network."
> Apple outright banning Electron-powered crap is the best reason I've heard yet for buying my new iPhone.

Why not let the consumer decide of they want the app on the phone they bought vs letting Apple decide?
In a non-relational model, you'd generally copy the items/products and their quantity into the shopping cart.

That's a huge change from the relational model, and takes much more space than a normalized approach, but it also comes with some advantages. For example, it makes sure that the price of the items in the cart remain constant, even when you change product prices. That way, you don't have to inform the user "oh, your cart just got 8% more expensive" before checkout.
Unique constraint is a good example, because it reminds us about race conditions.

The app can check that it won't violate a unique constraint before doing an insert/update, but in between that check and actually doing the insert/update, some other process may have changed data, such that unique constraint can be violated.

So when the rdbms catches this, it'snot just a "fuck you for giving me bad data" condition if the implication there is that it was a bug in app code, and it's a failsafe. It isn't necessarily a bug at all -- unless you intended it to be the app's responsibility to use db-level locks and/or transactions to guarantee this can't happen without the uniqueness constraint -- but then why not just use a uniqueness constraint, the tool the db is actually giving you for this?

Mature rdbms's sometimes don't get the recognition they deserve for being amazing at enforcing data consistency and integrity under concurrency, with pretty reasonable performance for a wide variety of usage patterns.

Foreign key constraint can be similar; you can do all the checking you want, but some other process can delete the object with the pk right before you set the fk to it.

If you have app usage patterns such that you really can't afford database data integrity enforcement (what level of use that is of course depends on your rdbms)... you are forced to give up a lot of things the rdbms is really good at, and reinvent them (in a way that is more performant than the db??) or figure out how to make sure all code written never actually assumes consistent data.
All white men
You can write them, you just can't write them generically.
More accurately, "In 1982, Stroustrup started to develop a successor to C with Classes, which he named C++". (Source - Wikipedia.)

As far as Go's popularity, see e.g. https://fossbytes.com/most-popular-programming-languages/.
Powerful, absolutely yes. Beautiful? Absolutely not. This is of course subjective, but come on. Insofar as you can be objective about beautiful code, SQL stands over in the corner wishing it had remembered to shower while all the other kids are elegantly rotating on the dance floor.

Except PHP. It's hiding in the bathroom.
What you say is true.

I would point out that the vast bulk of software in the entire world is vertical market business software. Vertical market meaning for a limited kind of user, versus horizontal software such as Word or Excel that everyone might use. Vertical market software is literally everywhere and largely invisible. Your public library has custom software. Your hospital. Ever go to get a blood draw and notice the operator is using specialized software. The place that changes the oil in your car. A lawyer's office. Cabinetry makers have custom specialized software. Cities using utility billing software. Keeps track of what gas meters (models, serial numbers) and whether and where installed, tracks the meter usage and generates bills. Rental car companies and airlines have custom software. Hotels have custom software. Restaurants software may have a map of the tables and what "state" they are in, with a list of customers in line. Some of these categories like City, Healthcare, School Districts, and other specialized software are entire industries unto themselves with huge software companies that build software just for these specific industries.

Much of this software is now web based. Because web based is centrally controlled. Zero install at the workstation and zero maintenance at all the workstations. All you need is an OS and a browser. (hint: chromebooks in some cases, and iPads, etc)

Is it any surprise that languages like Java have been the top languages year after year? It's where the jobs are.

It's not the same thing as microcontrollers. And microcontrollers are in lots of things around us. But they get built once, and replicated millions of times. The vertical market business software has thousands of specialized categories, all different, and with ever changing regulatory requirements (federal and state) and reporting requirements, etc. An accounting system with a large complex payroll module probably pays your paycheck. And is integrated with a human resources system. And benefits system.

All this software is written thinking at a higher level of abstraction some distance from the hardware. Transactions. Currency amounts and conversion. Databases. Yes, it may sound boring, but it's what makes the world go around and is mostly invisible.

It's also very stable. Like decades of employment stable.
I disagree with your conclusion. I would instead say that the combination of using the stack to parse JSON and allowing unlimited depth is the problem. In practice, almost no one ever deals with JSON structures even a hundred levels deep (I’d quite seriously guess it to be less than one in a million applications that desire it), so if you artificially cap it to protect against stack overflow you can then safely use the stack, thereby getting better performance by reducing the required allocations, while also protecting against one DoS attack vector.
I'm not at all convinced that "regulation" is the cause of high nuclear power costs. I'll note that, per someone else's attempt to rebut me, I learned that nuclear power is cheaper in the US than it is in supposedly enlightened France.

Of course, I completely concur that we should eliminate all fossil fuels from the electric grid, as much as possible from transport, and at whatever pace we can manage from building heating. But I want market forces working with us, not against us.

You mention "currently viable", but then we need R&D to make it currently viable? For how long? Ten years? Twenty? Wind and solar are viable now. Energy storage is viable now.
People should learn a functional language, even if they do not intend to ever use it professionally. Languages are tools for thought and if you only know imperative programming, it will limit your thinking (for example, one well-respected OOP programmer on stackoverflow seriously suggested modelling a bank account with a mutable number). Functional programming ideas are gaining traction and have made big contributions to distributed computation, filesystems and databases recently. Don't get left behind by dismissing it all as niche. You'll also get a preview of the upcoming Java and C# features.
Right–Apple will make an update that breaks Chrome accidentally, and no one at Apple will notice that it happened.
You seem to be saying people were idiots for relying on the results of one experiment -- how could they be so stupid? Yet here you are, completely buying into the results of one recent paper as it agrees with your own model of the world (apparently).

As for being edgy, you are taking a condescending position using broad and vague claims that are impossible to refute ("looking at you game theory").

I agree that by itself "free will" is meaningless to talk about unless the term is defined. I'm sure most if not all authors on the subject do define what they mean by free will, eg, Dennett and Harris, but I'm sure there are many others who do.
Here’s the logical continuation of your analogy:

If the movie is showing in the park for free, you can stick around and stand to watch it, but if there was a better service at a reasonable cost, you could go home and watch it there more comfortably.
Cool, here's my take: people who insist on a language supporting generics are lazy and uncreative.
MySQL 8 DDL is atomic at the statement level, but cannot be combined with other SQL DDL or DML statements in transactions yet.
The validator existed, sure, but finding a page that validated was like finding a unicorn.
I've worked on projects where adding foreign keys increased performance tremendously. A good relational database can take advantage of them in all sorts of ways in execution planning. Even scenarios such as some types of sharding, a relational database sometimes can use foreign keys for useful data proximity information, to better co-locate "families" of records together.

You need to know your database engine, how normalized you are or are not, how appropriate your data is for its relational model. It's not always your FK constraints that are the bottleneck you might think they are. Sometimes their "slowness" is hiding a problem elsewhere in your schema, a bad shard or an index that could be better or a key-value pool with soft version controlled enums pretending to relational data.

Sometimes "optimal" isn't a simple spectrum but a checklist of trade-offs and no "right" answer.
The fears of peak lithium are greatly overblown. New mines are coming online now that the element is in higher demand and the price is going down.

But that's only one of many energy storage technologies that can be used for batteries. It's popular for mobile/portable uses because it has high energy density, but that's not really necessary for grid-scale energy storage; whatever's cheapest will do (which may well be pumping water uphill).
WeWork's Adam Neumann sued over $1.7bn package
HN has novelty accounts now eh?
It's been a while, but IIRC at the time Rails got started MySQL actually did not even support foreign key constraints. Since that was the DBMS of choice, it wasn't much of choice.
Green Card Backlog Unlikely to Get Senate Hearing, Durbin Says
This is one of the reason why the Apple iOS messaging app is so popular. IIUC, when sending messages among users who have iPhones, SMS is not used.
Because they are not a monopoly so those laws don't apply to them.