skysight-inc/HackerNews huggingface dataset:
Well, I'm not going to take responsibility for reconciling the inconsistency here.

People said at the time that Robin Hood was offering a money market fund by another name, using short term investments to produce that 3%. The head of the SIPC took exception to the idea that the accounts would be covered, as I quoted. I can't say where the confusion lies.

https://www.bloomberg.com/opinion/articles/2018-12-13/robinh...
It's road design, speed limits and enforcement (or lack thereof on the US).
I totally believe that it gives the suggestions as you describe, what I'm saying is that in order for it do that, the completion must be making faulty assumptions about the way that scoping works in SQL.
> Perhaps fortunately, this model has only ever been used in one real prison in Cuba - slight aside, Fidel Castro and his brother Raul were actually imprisoned here for a period of time.

The Panopticon isn't necessary in modern jails since CCTVs are cheap and installable everywhere.
You made another claim that djrobstep was responding to:

> The difference would all go to landlords.
That might've been an ActiveX control.
Why terrifying? Sounds like he saw that the structure of much of what he was doing was boilerplate and created a bespoke code generator to save himself time. As long as the resulting queries are readable and effective I don't see a problem. Unless I'm missing something, understanding his code generator is not (necessarily) a pre-requisite for understanding the resulting code.
The foundation theory is the relational model of data, and the use of operators from relational algebra. So, we use relations to represent the data in the application domain, and use the operators of relational algebra to take relational inputs and produce relational outputs. It's an extensible and composable model.

When we solve problems using relations, we benefit by thinking in terms of relations.

We can ask: How well does SQL allow us to express an algorithm in relational terms? (Let's ignore that that SQL introduces some non-relational impurities that may have practical value - eg column order, row order, duplicate rows.)

When I examine an SQL expression, and then visualize the relational operators involved, I find a very poor correspondence between the SQL expression and the relational algebra. I need to basically read the entire statement to understand the parts. (Contast to the LINQ examples, or perhaps a shell pipline.) In a way, this is the substance of the original article.

This is one way in which I mean SQL is bad.
I don't know how Brex is different, that's pretty much the theme of my comments in this thread.
That's just in a few places with crazy house prices.

Generally, the situation isn't like that. For example, in my location the median house prices are less than 3x the median household income.
People are downvoting this? Is HN a capitalist safe space or something?
> 1kmph

Did you mean a thousand miles per hour? Dallas to Houston is under 300 miles so a thousand miles per hour would make the commute about eighteen minutes? But then, 1k miles per hour is 447.04 meters per second while speed of sound is about 343 meters per second so I don't know if that technology yet exists...

At a thousand kilometers per hour, even including about fifteen minutes of speeding up and slowing down time, a train from Dallas to Houston shouldn't take more than an hour. It would be awesome.

Speaking of dreaming, Google says Miami to Seattle is about 48 h (3,303.3 mi) driving via I-90 W. Lets round it up to 6000 kilometers to avoid sharp turns. A non-stop train at 1000 kmph would be a six hour train ride, down from a forty eight hour drive.

Imagine a train on this route, full of quiet cars on this route.
Leetcode premium -> do all the problems for the company you are targeting, sorted by most frequently seen in the last 6 months. Then, you will know what your weak points are (mine were minimax and disjoint set problems), and you can go through questions tagged with those topics. Aim to complete at least 60 problems, you should feel fairly comfortable with any Leetcode medium grades, and DFS implementation. Leetcode hard questions are good challenges which could expand the way you approach problems, but in my experience, did not show up much during onsite interviews.

Also, "completing" one problem in the context of the above does not mean being able to solve it the first time without checking the solution. It means possibly struggling with the problem for 20 minutes, checking the answer, and making sure you can do it the next day without looking at the answer. YMMV.
NASA Takes Delivery of First All-Electric Experimental Aircraft
This is a ridiculously clickbait and incorrect title. I would expect this from CNBC or CNN or the Daily Mail. Not HN.

The participants were literally examined using a single night's sleep pattern. This is dangerous "science".
And then do you factor in medical breakthroughs you might benefit from with a higher age at death?

I think if you could go into some kind of cryogenic stasis for twenty years without otherwise substantially shortening your waking hours, it would be a kind of no brainer.
It's nice to see what can happen with a free press. I wonder how surprised FB'ers were when Zuckerberg announced the QA would be open to the public, I honestly expected more grandstanding but was surprised by the candor. It'll be interesting to see what happens to the crowd who call journalists "clumps of cells" if they keep delivering this great reporting!
East Asian HTML and XML documents are typically smaller in utf8 than utf16 because the of the markup. (on mobile so u can't prove it right now. maybe when I get home tonight) utf16 is a bad default for almost everybody.

The actual reason utf16 is used is because it was easier to port to utf16 from ucs16. Much the way it's often acceptable to assume utf8 is ASCII it's often acceptable to assume utf16 is utf8. Even today, I imagine there are a lot of applications which assume utf16 is actually ucs16.
NYT great example. Note how they dont source the claim. The reader is not expected to even wonder if there is a source. It's worded as if the sentence itself is the source.

A curious reader would need to contact Kenneth Vogel directly. If history is a guide, the response it something about "backgound sources with information about the matter". Or start searching archives for Shokin. It's common to use hit pieces to attack people problems.

Again though, consider that claim in context with the first hand account from the person that got fired:

https://i.redd.it/wp66quhos4p31.jpg

Who is Joe Biden's son? Why would that company hire him?

And what is the NTY? IMO thinking of it as a newspaper is like thinking of Google as a search engine: https://i.imgur.com/VUdcIou.jpg https://gawker.com/here-are-some-top-n-y-times-editors-and-s...
Yes! Thank you for posting this
:shrug:, yeah the old fashioned way is possible too (I have to support both), systemd just gives a consistent pattern to make common tasks easy.
Love this tool. Use it every time I write or review crontab code.
Cold email plus a bit of luck, and then an informal interview in person. My best advice for anyone wanting to get connected is to not be shy. To get opportunities and connections, you have to put yourself out there. This comes with the risk of criticism.
Driverless Tesla Model 3 Pulled over by Police for Failure to Stop
I wouldn't have bought an HP calculator yesterday if I'd heard about this.
Great comment. I would add that back in the 30's everyone was swooning over Hitlers autobahns. It's incredible what can be accomplished when you don't have a pesky democracy getting in your way.
I'm not suggesting one is better than the other. But two potential sources is surely better than one when it comes to surveillance.
Are you retrofitting tens of millions of existing vehicles on the road? Be realistic.

Nobody ever thinks these kinds of statements through. It's just, oh we'll sign the regulation, and poof, everything instantly falls in compliance. No. No, the world just does not work that way.
The umbrella is for the AI. For drivers there’s always eye contact
> Tokyo to Kyoto one way is 13,080 yen ($120) for the cheapest ticket, for a distance of 226 miles. About the same distance as DC to New York.

> A lot of people think high speed rail would be cheaper to flying, in reality it's often the same or more than flying today.

It's a lot more comfortable, and you end up in a downtown location instead of an airport on the outskirts of the city.
That is not really inconsistent with the principle of implied consent for drivers. Driving is dangerous and destructive and not a natural right. Cars _should_ be under suspicion at all times, moving or parked.
Great post, though a few nits.

> There are companies that will pay near FANG levels (maybe 10-15% haircut) without subjecting yourself to onerous completion of hundreds of LeetCode problems.

Some even pay more. I wouldn't say FAANG companies even have the highest pay - a lot of the top-tier unicorns are in the same ballpark range.

> FANGs? You must prove yourself to gatekeepers before even knowing if there are teams with personalities you will agree with.

This is not universally true. From experience, while Google does this for their HQ, they don't for remote offices (where there's more risk you can't find the right personalities). Amazon's Principal Engineer interview loop is conducted by the targeted team. (I actually think this is true for other levels as well).

> Money is important, but for a small haircut you can have better WLB, less competitive peers

Might I ask what companies fit this profile? It seems like a rare find for any company to both pay a lot but not be competitive.
Thank you for such a detailed response.

Looking at the content it seems like I will have to basically jump through all the hoops that are required for a new grad interview.
America’s A.I. Landlord
You sign up for a product. No email is requested/provided.

You might later want:
- to submit a support request and receive a response via email.
- to get blog posts or product updates in your email.
- to receive a transaction receipt

Trust is earned over time. I would much rather grant granular scopes as a product builds trust.
Yeah, no need for a warrant when you can use a National Security Letter. They even come with built-in gag orders!
Why do you think you should be able to drive, in public, but anonymously?
“when some latte-sippin' macbook pro totin' millenial”

This is the most tired boomer shit, seriously come up with something new.
A tax credit, if it is refundable, is exactly the same as UBI, and even if nonrefundable isn't “negative progressive” in the sense that a deduction is.
Except I still haven’t started working on it :grimacing:

I’ve been meaning to update this for years but hard to find the time. Right now MicroConf and TinySeed are keeping me busy, but it continues to be on my long-term list.
I thought this was obvious? (Serious, not snark)

You start explaining what you need and work backwards, on the other end, they work in reverse, because that's how it's stored.

Conceptually, it's like piping in bash, "find | grep | cut". Start with finding the files(tables), grep for the row data (where), cut the fields you want returned (select).
Give yourself a few years at a contracting firm that fulfills projects in both your current specialty and the one you want to move into. Or any other growing company that uses both technologies.

Apply based on your ability to contribute to Java projects but communicate you’re intent: that you’re enthusiastic about Python and want to make the transition.

When it comes time for them to staff up on Python projects, you’ll be more of a known quantity than any outside applicant. That’s worth a lot.

There will be a risk that you’ll be stuck in Java work, but you just need to stay clear on what you want and be ready to move on again if they make a habit of ignoring that. You don’t want to stay somewhere that would ignore your career ambitions like that anyway.
Did you read the article? There are consequences, they just don’t involve fines accruing over time.

If your grift is to take a book from the library in the city you live in and never return it, I don’t think you are going get very far.

I live in a city that got rid of fines a couple years ago after they were collecting about seventy cents for ever dollar they spent trying to collect fines. For some reason people really want this to be a bad idea and I’m not sure why.
I suppose I could keep an RTLSDR in my car running rtl_433 at all times, and just filter out my own TPMS IDs...
Our kart had a live rear axle with power to both wheels and slicks on the rear. Top speeds was < 60 mph so standard Ackerman geometry was fine.

On a track or flat parking lot you could throw the wheel hard left or right even at max speed with no controllability problem other than the aforementioned slight "washing out" if the surface was slick. It would go into a very nice predictable controlled slide.

I miss it! It was great training for later driving a car. I never had the urge to do anything foolish in an automobile b/c the kart was always far, far more exciting. Driving a car was dull in comparison.
(Author here) Oh that's pretty clever and better than my approach. I was going to point out that subtraction would still need to be supported but realized we don't need to support negative numbers.
Luckily it's not French cheese and Italian wine...
Unfortunately, New York City was built at a time when people rode horses, and its streets reflect that. And you can't just widen a street, certainly not in a city like NYC. You would have to destroy every building on one side of a street, and build new buildings, all for a gain of a few feet.

Large megapolises like NYC need to start exploring the concept of 3D streets. Instead of having a single street level, on the ground, start building skyways between skyscrapers, where both cars and pedestrians can move. Take 45th Street. You could build a second street 20m above the ground, straddling the buildings on the eastern side of the street. You build ramps at both ends, and you build your aerial street through the buildings. This would require heavy modifications, if not outright reconstruction, of the buildings in question, but this is the way of the future for large, dense cities in this millenium. Our current approach to city design is primitive, and quite frankly medieval. We still build cities the way we built them in the Middle Ages: independent of one another, standing next to each other. But as NYC's traffic woes show, this is not enough anymore. If you want to reduce traffic in large cities, without restricting car ownership, then you need to make way for more cars.

Or you could go underground. But I don't know if that's a viable option in a city with a subway, and straddled by rivers. You would need to protect your underground highways from water infiltration. And you can't hollow the ground below your city too much, lest the millions of tons of steel and cement and glass above the ground start collapsing.

Tl;dr we need to start building Coruscant.
Quorum | Full-Stack Software Engineers | Washington, DC | Onsite, Full-time | https://grnh.se/4fea05fa1

Quorum is a fully bootstrapped 75-person startup based in Washington DC that builds software for public and government affairs. Thousands of public affairs professionals use Quorum for their work in Congress, all 50 state legislatures, major U.S. cities, and the European Union.

Called "The Moneyball Effect on K Street" by the Washington Post and "Google for Congress" by the Huffington Post, Quorum's software is used by four of the top 5 tech companies, major companies like Walmart, Coca-Cola, and Toyota, non-profits like the Sierra Club and the United Nation Foundation, and many other companies, trade associations, non-profits, and advocacy groups.

Our engineers work the full stack using tools like React/Redux, Django, PostgreSQL, React Native, and much more (though no experience with our exact stack is required and we're dedicated to investing in engineers early in their careers). We're rapidly scaling our engineering team and have multiple roles available. Apply at www.quorum.us/careers or directly at https://grnh.se/4fea05fa1
No, but people here want to feel like its always the cars fault.
Task-Relevant Adversarial Imitation Learning
Oh my god that would be amazing.

A couple of weeks ago I was driving along a steep valley with constant winding hairpin turns for over an hour, and I'd never been more aware of the fact that the pillars prevented me from seeing any oncoming traffic whatsoever when curving (extremely) left, even if I craned my neck as far as I could to the right. The pillar just blocks it all out.

It was really disturbing to drive knowing you just can't see if there's oncoming traffic or not, and if they're in their lane or drifting into yours. You just have to hope and pray everybody's staying in their (narrow) lane.

Absolutely sucks from a safety and awareness perspective. I consider myself a really responsible and careful driver, and I hated being put in such a literally blind situation.
The crypto was an experiment and we just gave it away to friends.

We are creating an eco village and community.
I feel like this sort of thing just proves that the problem with building high speed rail in the US is cultural[1] and political[2] not technical or economic.

[1] Americans have been carefully propagandized to believe that governments can't do anything right. And cars represent manhood and freedom.

[2] For instance Ubber and Lift are funding the same anti public transportation organizations the Koch brother(s) were.
Long story short, relying on HAVING to run after SELECT is not a standard SQL behavior it is dependent on the implementation and what the optimizer thinks is best (more discussion below: https://news.ycombinator.com/item?id=21153870).

The diagram in the OP is a pretty good general/semantic understanding of SQL execution order for writing queries.
Mastodon 3.0
How to File for Bankruptcy Chapter 7 for Free – Road to Success
Memory palace
If you use SQL server you can inspect the query plan, very useful.
If you have not yet done so, may I suggest you investigate 'Dessqview/X'. Lovely stunts there.
My limit was that after a decade of single-handedly spec'ing, programming, supporting and otherwise being in charge of all internal app development efforts for the $6 billion North-American arm of a $50 billion multinational corp... I still wasn't deemed worthy of the opportunity of a green card, or a salary commensurate with my responsibility and impact on the corp. The day I got my GC by other means and thus was no longer stuck working for them, I gave my 2 weeks, to everyone's surprise and disappointment! And that was with no jobs lined up after that.
If you want Lua under the hood, but a more industrial-strength language on top, you might have a look at Haxe. It can compile to Lua (among other languages/platforms).

https://haxe.org/manual/target-lua-getting-started.html
"Americans are already paying enough to fund a European-style welfare state."
Why do we tolerate this. Vote next time.
Discussion posted around the same time as this thread with 70 comments: https://news.ycombinator.com/item?id=21153063
Those pillars are full of de-facto mandatory extra air bags. Crash safety (probability of crash survival) is more easily measured than probability of crash occurrence.
Changes of note: an interface for the account migration activity that was added to the backend a few releases ago, built-in OCR for easier image captions, an option to disable live timeline updates, and custom emoji categories.
But it simply can be. There is no reasonable expectation of privacy walking down a public street. I can walk down the street taking high definition photos and video of everyone I encounter and they would have no recourse to stop me, nor should they in a free society.
Google will go to any lengths to save money
Yeah right, because colleges exist only as trade schools and don't give people who go there any other benefits.

And they are useless even as trade schools, no mater how complex the trade might be. That is why all the science and engineering * conferences are teeming with people whose education ended at high school.

* as in "making actual things" engineering
Bayes Theorem hardly requires any math notation at all. It would literally take you less than a minute to understand conditional probability.

Yikes.
Topics in Distributed Learning Technology
And 2.5million people are injured or disabled every year.
Why wouldn't you put your name on it?
I know you said you are good at system design, but I'd still recommend you read Designing Data Intensive Applications book and read through https://github.com/donnemartin/system-design-primer.

If you do those and cracking the coding interview you should be good to go.
>And the most happy one was the cat.

Yup :)
What about the people who dislike the freedom fighters but live in Xinjiang?
You can’t be serious. It’s not that hard.
FREE E-book - Learn Everything New in JavaScript from ES6 to ES2019
Hi Guys, i'm happy to share with you the second edition of my JavaSript book.
Whether you are completely new to JavaScript or you already know some, this book can help you get started and updated with all the latest features up to ES2019.

I've also included an introduction to TypeScript, which I believe is a must know for any JavaScript developer.

You can find the book on Amazon.com ( http://a-fwd.to/5gUojI8 ) in both ebook and paperback version. You can also get it on Leanpub if you prefer to get a pdf (https://leanpub.com/thecompleteguidetomodernjavascript2019).

Alternatively you can check out the free version on Github (https://github.com/AlbertoMontalesi/The-complete-guide-to-modern-JavaScript ) where it recently passed the 500 stars

The paid version includes an introduction to JavaScript and TypeScript, quizzes and it is available in pdf, epub, mobi and paperback.

Thanks a lot, I hope it can be useful to you
The connected car of the future could kill off the local auto repair shop
I think that’s unfair. Haskell is used in the real world to solve really hard issues, like anti-spam at Facebook.

I’m simply more impressed by array-oriented languages :)
here is a different idea: we don’t need [new] tools for though. Our entire history is made up of using tools to basically enhance our abilities - mental, communication, design you name it. Our native possibilities are quite limited (eg you cannot hold a list of more than 5-7 things in your head at once). We figured this out a long time ago and have tooling to augment these abilities. Writing, Language, Computers they are all tools that literally make us superhuman.
Oh yes, forgot about all those cars killed by pedestrians.
A pre-nup costs a few grand, just do that if you're concerned.
> plus a bit of luck

What was that luck?
> What I want is a semi-tangible expression tree that I can manipulate and "snapshot" (to show my work) into Latex.

It definitely seems like there's a gap in the computer-math ecosystem: you've got systems like LaTeX that are great for typesetting math you've already mostly figured out, and you've got systems like SymPy that are good if you want the computer to do the vast majority of the work, but I'm not aware of much in between.

It would be really cool if there was something like Photoshop for math, where you could work with expressions in a visual, semi-tangible way and the computer would give you "smart" tools to help you out.
Young adults are also more likely to have parents than spouses.

This doesn't seem so surprising. The chart shows in 1968, about 80% of 26 year olds lived with a spouse. Today, even if every married 26 year old lived with their spouse, we'd only hit about 32% of 26 year olds.

They don't group people living with their unmarried partner with people living with a spouse.

Based on their chart, 23 is the age at which most people no longer live with their parents.
One of the upsides for prototyping is that you don’t even need a JS build system: simply point your page to their CDN and you are ready to go!