skysight-inc/HackerNews huggingface dataset:
“Funny enough, but this reminds me almost exactly of what I was asked to do while working for a White husband and wife duo.”

“Funny enough, but this reminds me almost exactly of what I was asked to do while working for a Jewish husband and wife duo.”

I guess it does add more detail.
>you need to unload everything in the bed, which will be a huge pain in the ass on the side of the road.

Who says that’s even going to be possible? It sounds like a complete design flop to me.
There doesn't seem to be much information in the article. No actual numbers just:

> the market keeps expanding, but these two major companies never seem to get a much bigger piece of the pie

In my circles people only talk about AWS and Google Cloud. I know there is going to be a massive segment of the market that just defaults into Azure because Microsoft .... but it seems to me that beyond that the race is pretty much over. IBM, Oracle all the others are not going to succeed beyond niche applications.
> Learning SQL once will allow you to re-use it heavily across your career span without having to re-learn.

Like all good abstractions, SQL is the practical expression of a mathematical theory. In the case of SQL, you use Zermelo-Fränckel (ZF) set theory to reason about data sets.

While it is easy to come up with merely conjectural implementations for haphazardly doing things -- arbitrary trial and error, really -- it is notoriously hard to develop a systematic axiomatization such as ZF. Mathematics do not change and are hard to defeat. That is why math-based knowledge and skills are able to span an entire career without having to re-learn.

SQL got kicked off in all earnest when David Child's March 1968 paper, "Description of A Set-Theoretic Data Structure", explained that programmers can query data using set-theoretic expressions instead of navigating through fixed structures.
In August 1968, Childs published "Feasibility of a Set-Theoretic Data Structure. A General Structure Based on a Reconstituted Set-Theoretic Definition for Relations".

Data independence, by relying on set-theoretical constructs, was explicitly called out as one of the major objectives of the relational model by Ted Codd in 1970 in his famous paper "A Relational Model of Data for Large Shared Data Banks" (Communications of the ACM 13, No. 6, June 1970).

Using Codd's work, Donald Chamberlin and Raymond Boyce at IBM, developed in the early 1970s what would later turn out to become SQL.
I wrote this interactive SQL tutorial (you can write SQL in the page, and it tells you if you're right or not) last year! Always looking for feedback:

https://chartio.com/learn/sql/
Maybe the federal shutdown?

https://www.secureworldexpo.com/industry-news/nist-governmen...
whoops i assumed the 85k was already gzipped. fair enough
As I understood it, actual developers was the category least impacted by these layoffs at Activision.
Reading the thread so far, I see SQL and bash suggested as being valuable skills.

Can you suggest more skills and tools like these that are timeless and valuable?
The statistics Hinkel cites are fairly clear: the bulk of the reduction in poverty (which he disputes in overall effect but agrees has happened at some scale) has been from economies like China that operate with very different economic strategies than the neoliberalism Pinker and Gates advocate.

Read the article or listen to he podcast, they’re both good! :)

And: apologies if I’m not being clear about something, unlike the below commenter seems to think I’m happy to expand on what I’m saying.
So the original plan was to announce this earlier then?
Are you serious? The Pixel has gone 2 straight years without being hacked at pwn2own events while the iPhone has been hacked and brought to its knees Every Single Time.
That's a really interesting link, thanks for that. The parent comment made it sound as if this was their normal method of reading which is pretty fascinating. I wonder how common it is.
Even funnier, this reminds me when my white boss asked me if I could hack into his white wife’s email. I told him I couldn’t. I’m also white.
Knowing how to optimise SQL (and also database indexes) is a valuable skill.

Reducing a highly used query's execution time by several orders of magnitude can be quite gratifying.
Luggage Shipping
> BTW, we're preparing to move a postgres database that's a few TB from Heroku to AWS RDS. The catch is that we can't afford more than a few minutes of downtime.

Would it be ok to serve stale data for an extended amount of time? If so then you could modify your application to write to AWS RDS but to keep reading from Heroku. Then you start copying over the data from Heroku to AWS RDS, and once the copying is done then you point your application to read from AWS RDS.

Another thing: If your tables have foreign key constraints then you need to create the tables in the new DB without them first, since the writes coming to the new DB could be referencing data from the old DB which have not yet been copied over. Once you’ve completed copying the data over you add the FK constraints to the new DB. Depending on how your application was made this could be a problem or it could be ok.
The core concepts are the most important things to know. How do SQL queries and their various clauses work. Tables, data types, indices, and constraints are all very important. With that knowledge you can handle most SQL databases, and begin to learn and work around their quirks. Yes, there are a lot of database specific details. Procedure languages can be useful such as PL/pgSQL for PostgreSQL and T-SQL for SQL Server.
I really miss being able to make arbitrary where clauses to adjust to feature changes.
Something to be applauded, but I fear that this may be too little too late, especially considering Buzzfeed's heavy dependency on "community content" (read: unpaid work).
Fyre Festival Was a Huge Scam. Is Netflix’s Fyre Documentary a Scam, Too?
Stonehenge, other ancient megaliths may trace their origins to these monuments
I agree with this. I've found that for myself, reading is much more effective because everything has to go through my inner monologue first, whereas videos circumvent that.

My inner monologue is where I really begin to understand / remember / question concepts.

That's also why I like writing difficult concepts down, because then I will be forced to put it through my inner monologue once more.
The study showed that people showed a strong tendency to tap other options where payday operators weren't available and ended up financially better off overall.
Without emotional thinking there is no reason to have an opinion on the issue.
The reason SQL is great in my opinion is partially what the author highlights. In addition I think one of the reasons is that it is a very mature technology that baked over decades. I first was exposed to ANSI-92 SQL in school and that was already like the 2nd or 3rd revision of the standard. I used it in my first couple of jobs and the skill applied everywhere, Oracle, mySQL, SQL Server and there was even something called Access that understood it and Access was widely used amongst small businesses.

Knowing SQL to me was and even now is extremly helpful to understand data and how to tackle data problems. There weren't many other technologies that had such profound long term applicability, besides maybe knowing and understanding HTML and C. Many new things are just variations and improvements of those core technologies, and those can easily be understood and learned with good foundational knowledge.
Why JD is buying a hotel in Beijing for $400m
Communication. Particularly the ability to cross the boundary between technical talk and non-technical talk.

People like other people who are easy to talk with. Also you will be more likely to build what is actually needed, rather than what someone thought they needed.
Formal Proof of the Four Color Theorem in Coq
When you try to call the API, it will fail as it’s not there. The precise failure mode will depend on the application. One possibility would be to crash outright. Another would be to try the EdgeHTML control, then fall back to MSHTML. Yet another would be to try EdgeHTML, then complain in an alert, notifying the user of the requirement for the new version of Windows.
Yes, this (at the top level) was how they signed up fortune 1.
Then again, the Slack app segfaulted on launch for months because of a node.js incompatibility with newer glibc. So I guess what you've traded for is

- Nobody bothers to be testing against multiple operating systems in 2019.

- Everybody gets to wait for Slack to get around to it while the system webview gets the compatibility update almost immediately.

Great for the authors, shit for the users. On the bright side, it was the straw that broke the camel's back, and my org doesn't pay Slack any more.
> I'm not sure why you would discount an improvement in symptoms over 8 weeks though.

I'm not, but I don't think anyone is arguing that SSRIs can't be effective for some people with severe depression when used in the short term. The issue is that that only represents a small percentage of patients.
I haven't worked at the same place, but in the same industry since 2001, doing almost exactly the same work for each place I've been. Having so much domain knowledge is extremely useful. I'm not a great developer but it sets me apart, very far apart in my opinion.

The part that sucks is that very few people recognize it and the ones that do are rarely the ones that get to make the calls. The ones that do make the calls think any developer can do what I do. What I've seen happen several times, is the company decides to replace me with outsourced/cheaper development, and after an attempt to reason with them, I stay for a bit to help them move in that direction and then move on to another place. Invariably, they call a year or 2 later looking for help, not because I've planted some obscure code no one can understand but me, but because no other developers have the knowledge to form the necessary follow-up questions to the ever-changing specs handed down from the higher-ups before moving forward. They end up with systems full of incorrect assumptions that fail daily and tie up all the developer time being fixed. Now I can't help them because I'm working for a competitor. It's infuriating. Every company I've ever worked for I've wanted to make the best in the industry, but they've consistently been blinded by short-term goals, driven by unfounded hype to be "progressive", when all they needed to do was a few basic things better than the competition to take the majority of the market. Even when I get far enough to produce numbers to prove that point, they still want to do some wild shit no one is asking for, or they get bought out (because they start growing rapidly) by a venture capitalist company that just wants to do a quick flip.
My first job out of university was on an analytics team at a consulting firm (big enough that you know them) that used MS SQL Server for absolutely everything.

Data cleaning? SQL.
Feature engineering? SQL.

Pipelines of stored procedures, stored in other stored procedures. Some of these procedures were so convoluted that they outputted tables with over 700 features, and had queries that were hundreds of lines long.

Every input, stored procedure, and output timestamped, so a change to one script involved changing every procedure downstream of it. My cries to use git were unheeded (would have required upskilling everyone on the team).

It was probably the worst year of my life. By the end of it I built a framework in T-SQL that would generate T-SQL scripts. In the final week of a project (which had been consistent 60-70 hour weeks), the partner on the project came in, saw the procedures written in my framework and demanded that they all be converted back into raw SQL. I moved teams a few weeks later.

The only good bit looking at it, is that now I'm REALLY good with SQL. It's incredibly powerful stuff, and more devs should work on it.
I didn’t say markets are a bad way to value goods, man, I said china’s state planned and financed approach to the market has produced the gains Pinker is saying neoliberalism should get credit for. What we’re talking about here is the false idea that America’s approach to capitalism is responsible for very much of the global reduction in poverty, and whether we should consider other modes instead.
Jquery is dead (RIP). Moving away from it is a necessary act to keep a project alive, even if they copied 50% of it into Bootstrap (I’m guessing the real number is much lower) to do so. Over time the remnants will decay away as well.

Your argument is like saying Chevy never should have abandoned the carburetor because the effort was not worth the efficiency gain of first generation fuel injectors.
I'm not terribly happy at the VM startup latency, unreliability of actions (you have to double check if it really happened), and how things don't clean up nicely afterwards. Things may have changed, it's been a few months.
Oh yes, I totally forgot about that part for low-light reading. Blue light filters are awesome when properly done.
I agree with you on this, it is a moral dilemna I think about every day. Programming was one of the few professions where the practitioner owned/had access to their tools in their own spare time. Across history and professions this is a rare property, and I fear that we might lose this in the next 10-20 years.

Disclaimer: Views expressed are my own and do not reflect any positions held by my employer.
During the same period, we have put presidents in jail immediately after the end of their term, others have fled, another has committed suicide, and it's open knowledge that corruption is rampant. We had dictator presidents for decades. Park Chung Hee, widely credited with the miracle on the Han, was a dictatorial strongman with little grand plan except that knew protectionist policies would allow Korea to trade favorably, and trade up the industrial ladder from textiles to shipbuilding.
I like Marques a lot personally, but in my experience he is at his best only when it comes to gadget reviews.

His high profile interviews are shockingly shallow and his new car review show "Auto Focus" (ok, that's an amazingly clever name) is also about as in-depth as you'd expect a smartphone guy's car reviews to be.

But again, he's got a great personality and screen presence, I just wish he spends a bit more time on more meaningful thoughts and more in-depth research when it comes to other subjects.
Funny you say that, I was an English major for a brief while in college. I switched to a creative writing minor before the end of my first year.

For whatever it was my English professors had, it was my creative writing professors with real acclaim and ability.
Do people read BuzzFeed because it's something to talk about during breaks at work? Other than clickbait, does the site provide any kind of meaningful content? Does BuzzFeed operate on a 'vision' or 'goal-driven journalism' ?! I never saw the site for more than a junkyard selling bullcrap to make money.
It's called marketing and they're pretty good at it. They do provide some useful tools however if you want to use them and don't just blindly follow the docs (which are selling you on things you may/may not need).
this is my goto bash source https://www.tldp.org/LDP/abs/html/
current TC?
In the video interview, he prefaces the conversation when starting to talk by saying they framed it as surprises this year.
There is a big difference between "get's the correct data out of the database" and "get's the data efficiently"

A significant percentage of my time over the past few years has been spent optimizing queries that other people did in obvious, but non-ideal ways.
Sorry for the delay; you've been some kind of banned and I didn't see your reply.

I'm not going to watch a College Humor video at all, much less pretend it's research.

What I will say is that federal law establishes up-front salary limits for tipped waitstaff such that no waitstaff will ever be paid less than $2.15 an hour (a number I feel should be much higher and pinned to a percentage of minimum wage) and in the event waitstaff does not receive sufficient tips to equal minimum wage for time worked, the restaurant is obligated to supplement the difference.

This is known, up front, by both parties.

These drivers were promised a rate of pay and not told in advance that Instacart would be intercepting tips. That's a bad-faith operation.

In addition, the real instance of wage theft here is classification of these employees as minimum-wage-exempt 1099 workers instead of payrolled W2 employees -- and the cynic in me suspects they're classified this way expressly because Instacart knows they're exempted thereby from minimum wage.

So, I agree that reform is needed, but none of the things you posted (modulo some Youtube I'm never going to watch) have been accurate or even relevant.

Which brings me back to my initial questions: did you create an account to misrepresent federal law? Why?
Forced pricing is exactly why theaters sell 3 sizes of popcorn, with large "only being 25 cents more than medium. The goal isn't to get you to buy the large, it's to get you not to buy the small. There was a book I read years ago about this sort of psychology and food, but I can't recall the title.
> least efficient chat app ever

I dunno, Discord might be gunning for that prize.
>Nobody wants to be testing against multiple browser/rendering engines in 2019

Nobody does. CSS is pretty mature, a difference in rendering between modern engines is extremely rare
Well, the difference is that China has useful high speed rail and California does not.
Is me or the website shows that the in general jQuery codes are much smaller?

Like the $.getJSON jQuery code seems much compact compare to IE8+ to IE10+.
To be even fairer : it seems that the goal was to allow the
sizeable Android dev community to reuse some of the APIs they already know in the context of Android Things.

I am not saying that it makes a lot of sense .. I am an Android Engineer myself and the amount of boilerplate for that blinky sample makes me vomit but that's how it is.
Heroku Postgres doesn't support external replicas, which complicates migrations out considerably. If you can't tolerate more than a few min of downtime for writes, you pretty much have to build the replication at the app level.
It is indeed prudent to work on post-quantum cryptography now, but no, there's absolutely no quantum computer factoring on the horizon. Any viable path to it, by itself, would be a breakthrough.
None of that has anything to do with the topic of unionization.
I recommend you look at one of Markus Winand's presentations, such as this one : https://youtu.be/xEDZQtAHpX8
I felt it summarized well the modern foundation of SQL databases.
Alternative interpretation: Google's Cloud is ridiculously large, but they occupy 99% of it with their own product.
During the same period, we have put presidents in jail immediately after the end of their term, others have fled with billions, another has committed suicide, and it's open knowledge that corruption is rampant and a handful of conglomerates own the country. Our very last president was impeached and thrown directly in jail due to a popular uprising. We had dictator presidents for decades. Park Chung Hee, widely credited with the Miracle on the Han, was a dictatorial strongman with little grand plan except that knew protectionist policies would allow Korea to trade favorably, and trade up the industrial ladder from textiles to shipbuilding.

Gates and Pinker are giving ground on marginal issues like healthcare, but pushing the core agenda of "free markets make everyone's lives better".
Silicon Photonics: Mapping the Impact of Heat on Light
https://azul.rs/
They do some serious journalism: https://www.pulitzer.org/finalists/staff-buzzfeed-news
> So in other words, Apple is providing a valuable service and the 30% is a customer acquisition cost?

According to what Rebelgecko said, it sounds like the only reason Apple's service has any value at all is that they artificially restrict any possible competing payment methods on their devices.
>Collective bargaining wouldn't have prevented a company like Activision Blizzard from making a strategic decision to move in a different direction

Maybe not in those terms, but I wouldn’t rule it out. Unions work through adaptive contracts and agreements, which can involve all sorts of arrangements.

Either way, the workers would have been in much better shape for the loss had they been unionized.
And more recently, we see SQL abstractions overlaid on top of things like Kafka streams with messages encoded in Avro thanks to technologies like Spark structured streaming.

SQL is not only relevant to traditional databases. I never got into C#, but LINQ looks really interesting.
SQL is the most powerful query language ever invented and widely implemented over relation databases IMO (qualified heavily for lurking RDF zealots). Every time you see someone start to invent their own query language, I almost always mark is as folly (similar to when people invent their own configuration languages). Prometheus and GraphQL stand out as recent examples.

DBs like Kafka who recognize this and instead offer SQL on top of their things take the right approach IMO KSQL.
Though I believe the antidepressant use of ketamine consists of one or two directly administered doses, so injection wouldn’t necessarily be a show-stopper.
Interesting - we're currently only detect credit card fraud for the segment of customers transacting with more typical credit cards (the largest chunk of the market) but this is good to know.
You can be a good developer and not know bash. Bash is, in some ways, programming horror. But SQL is pretty fundamental. It's a thing onto itself. There are plenty of shells and shell-like languages but there is really only one SQL.
Data modelling/design (closely related to SQL of course).

i.e. distilling business problems down into tables and columns.

Skills acquired decades ago are still extremely useful.
wait to you have a performance issue in prime time and you need to refactor your query in a hurry
I’ve been a career analyst for about 12 years so I write SQL every day. I know it very well. I’ve developed a very strong love / hate relationship with it over the years.

On one hand, you write what you want to find in fairly common language and you almost always get back what you want if you do it correctly. In many ways, it’s like a precursor to Alexa but in written form. It’s super easy to pick up for non technical people.

On the other hand, it’s extremely difficult to code review, and on a very complicated piece of business logic, errors could mean the difference between hiring 10 more people or laying off 100. So almost always it’s just easier to re-write.

Imagine if engineers couldn’t understand each other’s work, and had to rewrite code every time someone leaves the team. It’s insane to me that this is standard practice.
As a dev, I have to use a query builder. It's frustrating because it's ten times more complicated than SQL and slower to execute, with basically zero advantages.
Unions are leaches of value. Everyone loses.
Last I checked, differential programming involved exploding matrix sizes at 2^n in the number of memory bytes that the differentiable program could access. Is the situation any better now? If not it seems kind of like training a function approximator map the present cycle's memory and register state to the i+1th state.
Slack migrating to Electron was by far the worst decision they’ve ever made for UX. That one migration introduced a ton of bugs and platform inconsistencies, most of which are still around.

One I just complained about the other day is Electron apparently doesn’t handle font fallback properly, so if I type an emoji that Slack doesn’t support, such as [frozen face], it just renders as a placeholder square in desktop Slack even though it renders as the emoji on both the website and in the iOS app.

Edit: Apparently HN strips the emoji from the comment [facepalm]
Http.
Wait. AWS only has 32% market share? That is way less than I would have guessed.