skysight-inc/HackerNews huggingface dataset:
> ...why these design trade-offs were made.

While your line of reasoning is sound in most scenarios, in this case, the why is pretty obviously written on the wall. The overriding reason why this hacky-hack software solution was slapped into the airframe was to keep from having to reclass the plane following the addition of too-large engines. Your reasons listed played into the design decisions that became MCAS, but the underlying reason as to why any of this nonsense was needed in the first place is because non-engineers forced a shitty situation on the people who actually implement these airframes.

Hacker News is frequented by engineers from multiple disciplines, including software engineering, and many of those engineers know the kinds of terrible design decisions forced by management that come about to make a quick buck. People are pissed about it due to this fact, and rightly so.
Not to step on anybody’s toes, but… I often suspect that there are lots of people who tried, and failed, to learn relational database techniques and gravitate toward schemaless solutions like Mongo just because they’re easier to understand. Maybe not everybody, but more than a few that I’ve interacted with.
Rails + Postgres + Heroku. I may be living a decade in the past, but all the bugs are worked out and the development speed is extremely good.
I should add that the SRCF offers services to pretty much anyone at the University (or its colleges), including staff and of course the students you mentioned.

I am involved in running the SRCF nowadays. It's always encouraging to hear that it's been beneficial as an educational aid, as well as through pure utility!

Some people migrated their work pages to our web hosting from the University's equivalent service, which was abruptly shut down recently [0]. This follows an incident that got some attention on HN [1] -- chronologically at least, if not causally as well.

[0]: http://people.ds.cam.ac.uk/
[1]: https://news.ycombinator.com/item?id=20283922
What science in regards to climate change is settled?
Even if they don’t last as long as li-ion batteries the environmental/health friendly aspects of this technology might be useful.

But yeah, curious to see how it shakes out in practical application.
Either. The alarm must be an OR.
The only way someone can be Protestant is to be ignorant of history. If you look at the writings of the saints for the past 1900-2000 years, they all believed the doctrines of the Catholic Church, and they were saints because they lived those teachings and received her Sacraments which are only present in the Catholic Church. All forms of Protestants started off in the 1500s by simply guessing and assuming that the Catholic Church had strayed from the truth, and then guessing what that truth might be. There is no credible basis for any of their teachings at all. They started off on the logical fallacy that because there are evildoers in the church and because the church seems to condone their behavior, the church must have fallen from grace and erred in her doctrine. No, the Church’s members were corrupt but her teachings and Sacraments remained intact. And she was healed of her gangrene and errors by saints like Frances de Sales and Ignatius of Loyola, who explained the truth and converted hundreds of thousands of Protestants back to Catholicism even during their lifetimes, let alone afterward.
I used to live in Tokyo and Singapore before moving to a crumbling city which aspires to developing world levels of corruption, blight, and bureaucratic ineptitude called “San Francisco”. Completely agree with how amazing well run transportation systems are. Also amazes me how consistently SF can fail miserably at even the most basic transportation projects. (SFO is a notable exception. No idea how that happened but we are so lucky to have it)
There Is a Horse in the Apple Store
I mean, we're all programmers here, and we've all dealt with the growing pains of changing requirements.

But has an RDBMS ever been a major source of that pain? I can't say I've ever encountered a time when it has. If you need to change the structure, just write a script.

I'm not saying it's completely painless, but nothing is.
I do the same, because for some reason only microsoft knows those tiles display the latest news and try to get me to launch candy crush instead of helping me to launch programs.

So I only use the search feature which works ok most of the time. Some days ago I fixed the printer on my wife's laptop which involved a restart as usual. Right after the restart I typed "printer" in the search field and all I got was web -search. So right after a restart windows "forgets" that it has a native setting for configuring printers (and basicly everthing else).
well yes, but that's rather the point: I know that it's normal to feel inadequate, but that doesn't make it feel any less terrible.
That is very interesting! how do they know that a difference in a satellite measurement is not due to slippage in its orbit?
DB Weekly Issue 279: November 8, 2019
How many people actually agree? Yes, if you ask them, the social costs and gains of each answer being given means most will disagree. But is that actually what we value more when their isn't a social cost to being honest with the 'wrong' answer? Is that what our actions speak too? I think we live in a world that puts a value on the plane crash and sees a certain level of cost from plane crashes as acceptable in the payoff is high enough. And this isn't unique to just plane crashes, look at what movie and music stars are allowed to get away with that would quickly get you or I a 20 year prison sentence.
Strange numbers found in particle collisions (2016)
Also, the actual questions are not just "Has Earth's average surface temperature increased 0.8 degree Celsius since 1880?" but:

* What is humanity's effect on global warming?

* What meteorological and ecological effects does global warming have?

* What is the magnitude of impact of hypothetical changes to human behavior?
Single family zoning in particular skews the market and prevents more affordable options. Also, the tendency to for new construction to be bigger houses than people used to build with the same price/sq foot means a more expensive house to start with.
It sounds like you're calculating a running average. Have you looked into window functions? I think they do exactly what you need. Something roughly like:

SELECT AVG(stats.val)
OVER(ORDER BY stats.date ROWS BETWEEN 5 PRECEDING AND CURRENT ROW) AS avg_val
FROM stats

Regarding this point:

What I've learned from this project I'm doing is that sql is very, very powerful in what it does. I've shifted more to using it for actions than I would have in the past, and pretty much all thinking I do is making as little code as possible.

It's an interesting tradeoff. I've been on the other side, in an environment that was super SQL heavy (also Oracle PL/SQL) where we had to deal with these huge complex queries, and it was incredibly painful, for various reasons. One, SQL by itself isn't that composable in the way code is[1], so there tends to be a lot of copy/paste/duplication. Two, giant queries can be hard to understand/debug. Three, SQL can be hard to test. I mean, you can set up integration tests against a database (which can be time consuming), but how do you unit test a query?

On the other extreme, I've seen cases where something separately queries two tables and does a join operation in code, which would be much easier/safer just by doing a sql join. So there's a tradeoff. There's a hard to define sweet spot somewhere in the middle, IMHO, where you take advantage of relational semantics/joins, and utilize various sql features like group bys and whatnot, but where you haven't shoved all of your logic into the database layer.

[1] You can create CTEs (with foo as....) in postgres, but they may have downsides wrt performance (at least, last time I'd read up on it they posed an optimization boundary). You can also create views, but similar issues may arise.
https://en.wikipedia.org/wiki/First_they_came_...

https://tvtropes.org/pmwiki/pmwiki.php/Main/ItsAllMyFault

https://tvtropes.org/pmwiki/pmwiki.php/Main/YouAreBetterThan...

https://tvtropes.org/pmwiki/pmwiki.php/Main/BetterThanNew

https://tvtropes.org/pmwiki/pmwiki.php/Main/ResponsibilityTr...
Regional California agency pushes for more housing in coastal over inland areas
I'm a huge MAX skeptic, but this article just has to be wrong. Someone who had dropped out of a CS degree would know not to do what the article says they're doing.
We have a few promising ones IMO. Lithium will probably win out due to cost, but liquid metal storage is what I wish would win. It is more expensive, yet it also has basically infinite cycles (it doesn't wear out). That seems like an ideal characteristic for grid storage.
>It's hard when so much of commerce is conspiring against us.

It's true. I'm no health nut but I can't even consider a sugar-free lifestyle without going very much out of my way since everything has some sort of added sugar or sweetener.
It depends.

Tinnitus is believed to be, in many cases, due to the maladaptive plasticity that happens in response to hearing loss.

The brain doesn't hear some frequencies so it "reconfigures itself" to amp up the volume on those frequencies. Not unlike our own HiFi amps, if you increase the volume on a line that doesn't carry a signal, you get all kinds of bad noise.
Personally, I suspect that when a crash happens, it will come with higher interest rates. A 2% increase will result in an 18% higher mortgage payment, which could actually be higher than the dip in home values.

That's why I'm buying right now. I too expect a dip in values within the next couple years, but we've got cheap money right now, and I don't plan on moving again for long while, if ever.
If the ground is sinking rather than the sea rising, the impact will be pretty similar!
> In effect you are stating that you understand better than the hundreds of engineers involved with this project why these design trade-offs were made.

We don't know that any engineers approved this design. It could have been completely compartmentalized and approved by management only. We'll never know what the engineers said until there's a complete investigation and the engineers are subpoenaed.

Here's what we know so far about the 'engineers':
1) The MCAS software was outsourced.
2) MCAS as originally designed and submitted to the FAA didn't have enough authority to affect the plane in the needed amount, so Boeing increased it's authority and never told the FAA.

Point to speaks to a failure in basic engineering or a deliberate deception of the FAA. A competent engineering team should have been able to calculate exactly how much effect was needed before the plane left the ground. Sounds like they were winging it on this one.
Coming from the boring enterprise world, where we didn't really get swept along in the NoSQL hype, this doesn't seem like it should remotely be a surprise to anyone.

"Hey, turns out there's lots of great ways to use SQL!" Yeah, we know, they've been at the core of our business for the last 20 years at least.

Lots of enterprise shops started out as SQL databases to keep track of all the data, and web apps grew up organically around them.
Coal plants are dying as gas became cheap due to all the fracking and shale gas in the usa.
Germany is about to start a brand new coal plant in 2020 https://www.power-technology.com/projects/datteln-4-coal-fir...
They need the coal plants to compensate lack of nuclear and alleviate the intermittent issue of the renewable.
This. Without getting into too much detail, based on what you've written, it seems like you've spent time building a solution and are now looking for a problem (with business value) to match that solution with. Ideally, you start with that problem and go from there, but, in this case I would switch gears immediately away from development and towards validation (which is an earlier stage than sales).
1. Lots
2. Very
3. Extensive

I know this is flippant, but the answers are all generally pretty well-known
Yakovlevian Torque
Indeed, I have 300 games on Steam, and I've only booted up 60 of them at all.
How do you create new pumped hydro capacity?
I disagree with the notion that we should give additional advantages to people who are bad at things, at least genetically. Math is not a vital part of life, so I wouldn't equate it with accessibility measures like ramps or braille, etc.

In the case of economic or societal disadvantages the argument is that if the environment changed, both the rich and the poor, the white and the black, would perform equally, justifying "leveling the playing field". Genetically, all "leveling the playing field" does is provide an artificial equity which will go away once the advantages are taken away.

This seems similar to the argument that women should have different physical fitness standards in the special forces. Nobody should care about gender proportions in the special forces, they should care about the effectiveness of the teams, same with other non-trivial pursuits. (This is provided that the differences between groups are indeed genetic).
Look, the "gender paradox" results aren't super new, going back to something like 2012, don't blame a npr pice about a new study for you not knowing older news. Additionally, the gender paradix results don't have any clear interpretation, they robustly indicate a lack of understanding but little else: https://arstechnica.com/science/2018/10/gender-differences-i...

Finally, discounting a MRI study that does high resolution studies of brain activity as garbage based on critera apropriate for surveys isn't apropriate. Samples of around 50 participants are actually well motivated for fMRI studies: https://www.ncbi.nlm.nih.gov/pmc/articles/PMC3427872/#!po=1....
An extensive rewrite in only a few months (they expect a return to service by the end of the year), involving a whole new paradigm of 2 computers monitoring each other vs the old failover mechanism. I'm sure the aviation industry has extremely stringent coding standards, but that's just not realistic and asking for bugs (aka risks to the safety of passengers and crew).
The greenhouse effect, for one. It's essentially the blackbody effect along with spectral properties of constituent atmospheric gases.
Gloves that can translate sign language
IMO if your data model's still so nebulous that you're changing it so often that SQL migrations are a serious impediment to progress, you probably don't need any real datastore yet. You can usually figure out WTF you're going to do, broadly speaking, before persisting anything to a remote database. And if you can, you very much should.

Yes, yes, there are sometimes exceptions, one must repeat explicitly despite having already said it (see: "probably") because this is HN.
You can make what are virtually zero-cost copies from what you call a "big stack" to a resizable stack with virtual memory tricks. You don't even need to copy the entire stack, but cleverly rewrite the return address stored on the stack to do this kind of "code-switching". But it does mean doing backend manipulations in a platform-dependent way. There are several good ways to do this, none of them particularly easy. What is perhaps impossible is allowing FFI code to block the lightweight thread, but async/await doesn't solve this, either.
Cloud Firestore Now Supports IN Queries
Cherre | New York, NYC| Cherre.com
We provide an end to end data cleaning and connection solution for real estate industry leaders.

Cherre just closed a 15 million series A with Intel and other key players in the real estate industry and we are looking to continue our explosive growth by hiring onsite senior level engineers for three core positions: Data Engineering, DevOps, and Fullstack.

Core Experience We Look For
DevOps: Docker/Kubernetes infrastructure on GCP (AWS is ok too). Believe in CI/CD.
Fullstack: React/Redux and Node.js with API experience. Has built for data platforms. Maps are a plus.
Data Engineer: Strong Python and SQL knowledge and experience running ETL process on complex data.

Our full job descriptions are here:

https://jobs.lever.co/cherre

We have a strong culture that focuses on Ownership, Humility, and Knowing the Data. We provide a great range of benefits including flexible work hours, unlimited paid vacation, educational credits, mentorship, in office meals, commuter discount, and much more.

You can contact me at james@cherre.com
Leininger would like a word with you.
Depends on how much they enjoy their work.
I find exercise is the best solution along similar lines for me, and has the added side effect of actually making you stronger and healthier. The difference is night and day:

If I don't regularly exercise, I'll get burned out very quickly on some task I would have normally found fun previously. E.g. some highly-intense game like a competitive multiplayer shooter, or even a difficult programming challenge. Even interacting with other people can suck in this mode.

If I am regularly exercising (I.e. 30 minutes of cardio every day or better), I can carry through marathon sessions of gaming or coding with a smile on my face the entire time. My social tolerance levels are infinitely higher than without.

I still don't fully understand all of the biology behind this, but it seems that regular exercise is a great way to pay-forward the debt that is incurred when you stimulate your dopamine receptors. Maybe there is some relationship between exercise/sleep/dopamine/serotonin, because I find that regular exercise yields substantially deeper sleep, and when I wake up from this I feel like I want to engage in challenging tasks.
>Landing contracts for key systems on the Max cemented a relationship with Boeing that Collins had long cultivated, in part by creating what its chief executive in 2002 called an “enormous sea change in a very long legacy business." For years, the company had been “a technology leader, an innovator,” Clayton Jones, then the chief executive, told Fortune magazine. “Unfortunately, along the way they forgot to hone their financial skills.” In 1998, Boeing executives summoned Mr. Jones to Seattle, he later recalled in a speech, and made clear that, to get more of Boeing’s business, Collins would have to cut prices dramatically. In response, Collins introduced what it called “lean electronics,” its take on a belt-tightening philosophy popularized by Toyota.

>Collins reorganized business units and retrained managers, with an eye toward efficiency and speed. It pushed its suppliers to do the same, and established partnerships with companies such as HCL Technologies, which provides outsourced, lower-cost engineering services from India.

>Along the way, Collins unseated Honeywell as the provider of flight control computers on a predecessor of the Max, the 737 NG, and supplied numerous systems for the Boeing 787, which went into operation in 2011.

>When Collins secured the contract for the Max displays in 2012, it credited the belt-tightening. “There were a lot of cost-saving measures — a lot of tough decisions — that had to be made,” one manager said at the time in a company publication.

https://www.nytimes.com/2019/11/07/business/boeing-737-max-c...

If there was a problem with the master-slave operation on the MAX, not necessarily connected with MCAS, might not the same problem exist on the 737 NGs?
God forbid you do some difficult volunteer work instead of this "putting people down and mocking them" internet commenting.

Incidentally, why is it that so many people argue that wealth comes from doing things people value, but then support volunteer work? If it's the case that helping people makes money, all the people needing help should have entrepreneurs all over them, rather than hoping for unpaid volunteers. And why would people tend to become volunteers if continually told that virtue comes from measurably productive money making?
This is not a discussion about nutrition, or psychology, or anthropology. It's a discussion about two very concrete questions:

1. Is global warming happening right now?

2. Are humans responsible for it?

The answer to those two questions is absolutely unreservedly settled: it's "yes". It's as settled as any question in science can be, it's as settled as the fact that electrons exist.
Maybe I need to double check the math on this, but due to amortized interest, I'll be paying 2 million dollars for my half million dollar home.

I don't understand why we are pushed to go into debt on housing. I don't plan to sell, and my apartment was 1/6 the price.

Looking back, I would have saved up money for 6 years and buy the same house with Cash.

The only way I see this as a good investment, is if we experience near hyper inflation in the next 15 years.
> how badly SQL parrots relational algebra

I’m continually amazed that we’re STILL primarily interacting with databases, programmatically, by passing SQL statements as strings into them, rather than, say, passing in a list of column names as an array, and a list of conditions as tuples, etc. ORM’s try to bridge this gap, but they do a pretty bad job of it; they end up oversimplifying so much that the result is unreasonably inefficient.
What Is Behind the CLI Making a Comeback?
I Tracked Everything My Baby Did Until Nothing Made Sense Anymore
I remember playing this game for hours and hours as a little kid, on an old DOS computer. A fun meta-game is to try and just keep the game going as long as possible, which means trying to find the right balance of keeping at least one competitor strong enough to survive but too weak to go to war with you or someone else. And hope you don't die in a nuclear holocaust caused by some non-neighboring nations like Iran and Iraq.
Thanks for sharing! Impressive resume by the way.
It does not really matter whether nuclear requires government backing, it's the role of the state to back things that may not be viable otherwise. Actually, currently renewables receive massive amounts of subsidies.

Nuclear works.

The important points for our current problems is that it is low emission and that it can guarantee vast amounts of electricity 24/7.

In order to drastically reduce emissions while meeting demand, not least the upcoming demand from electric vehicles, there is simply no alternative.

This does not mean that renewables should not be pushed as much as possible as well.
If you have an a/c, you can just opt out from using new under https://www.reddit.com/prefs/
Free Webinar: All Things CTF
And Boeing will make that disagree alarm an optional extra?
I'll check it out, looks good :)
Scientists discover 'holy grail' approach to renewable energy
To be fair -- the docs for ZFS via the manpage are great but I found a lot of help also from forums of likeminded folks -- ServeTheHome (https://servethehome.com) is where I got hooked.

And then there are countless GitHub projects where the README.md file, which is usually first thing I read, that is super well documented and written for the noob (imo). The best example of that so far, especially for someone like me just getting started with the framework, is the gin Golang http framework: (https://github.com/gin-gonic/gin) -- that readme is full of useful examples.
I am sure there are good use cases for triggers but I have seen quite a few databases that used triggers a lot and it almost always felt like the equivalent of spaghetti code. Things are happening and it takes forever to figure out why they are happening.