skysight-inc/HackerNews huggingface dataset:
> just moving sorting to the frontend took a 3 second query down to 10ms

I've seen this too, but the problem can often be optimized in SQL as well. For instance, if you expect that only one User will match a specific username, then adding LIMIT 1 to the query will instruct the DB to return after finding a single hit, which can significantly shorten query time. But then adding an ORDER BY clause will cause (at least MySQL) to parse the entire table anyway, even though you've got the LIMIT clause. This is just an example, one really needs to know their database and their application to make these types of decisions.

But the premature optimization applies to SQL as well, if the results can be sorted/filtered/transformed in application memory better than in the database so be it.
Russian Military Spy Software Is on Hundreds of Thousands of Home Routers
Most users are outside of the US for these companies.
That means you can't be discriminated against on the basis of your religion, not that you can discriminate against other people because of your religion though, right? Just like eg. being gay does not allow you to discriminate against black people.

I know it's more complicated in practice because the problem is political and other factors come into play.
Crypto prices are falling, but not everyone is losing money
>If you are imagining something that doesn't hurt, you are not imagining pain, by definition.

By the same logic, I can feel happy just by imagining myself feeling happy?
Isn't that the point though? Europe has experienced first hand not only "national socialism" (nazism), but also another type of socialism — communism. Still legal though, and going strong in Europe.

It's a grim comparison, but communism has actually produced a higher body count that nazism and fascism combined.

That US had traditionally granted free speech to all kinds of extremists, no matter the -ism, was truly remarkable and unique. Definitely a cause for wonder (even jealousy like OP says).

And the way they found to circumvent that pesky constitutional constraint by having mega-corp-in-bed-with-gvt monopolies do the dirty work, without breaking the letter of the law, is remarkable again. An elegant "hack".
I'm all for freedom of speech even if that speech includes ideas I vehemently disagree with (even hate speech). However, when speech incites physical violence and can be viewed as a legitimate threat, then it needs to be shut down.

Parents of children who were lost during Sandy Hook received physical threats and death threats because of Jones' comments. That's the line where free speech should be censored.
This seems to be a common misconception outside of the United States. The First Amendment applies to the government, not to private entities.
Before jumping in with your thoughts on how managers should or should not be involved in code review, note that this is about code review review. Reviewing the code review process, and reviewing the code reviews.
Yes, initial benchmark results: https://github.com/M4GNV5/GSoC2018
Abundance of cells. This is a properly formed English sentence.
The majority of people only access these distribution platforms.
The "they still have a website" argument equals to "in a dictatorship, you still have a home and you can say anything between its walls, people can come to you and listen". The internet is / should be much more than that.

I always found "disapproval by removal/banning" to be absurd. The true way of them not gaining ground is by educating people. Yes, it's a much, much harder way. Yet it's infinitely more fair, and probably the only way to a healthy society.
What I believe should be legal and what I believe should be done (by decent people) are different questions.
But a pragmatist in many people would say: “why then that person does not take any antidepressants/codeine?”, if that pain is so painful?

So it may be quite a bullshit statement, depending on how you take it.
There are well posed version of these questions that have existed for quite a while. It’s one thing to wonder about arbitrary fluffy hand wavy way and it’s quite another thing to crystallize your thoughts and cast a precise statement of what you are looking for.
Intel reveals more major chip security flaws
Freedom of expression isn't at stake here. Your right to free speech - even the "disagree with what you say but fight for your right to say it" kind - doesn't entitle you to get broadcast or listened to.

https://xkcd.com/1357/
You are completely misunderstanding his point.

He is saying why is it OK for a small business to be forced to accommodate something that may be against their belief system. But the biggest corporations, who are also managing our online discourse, can pick and choose what they like.
Don’t fear the TSA cutting airport security. Be glad they’re talking about it
Ah yes, the superior thinking of top minds that frequent news.ycombinator.com
Twitter put up a ban for 7 days because the account tweeted a video calling for violence against media. People commenting here either have not read the article or are deliberately bringing in false parity between call for violence and request for cake for a wedding. It would be outrageous if any media did not ban call for violence, especially by somebody with considerable following in the public.
Yeah, I keep using it in the hope that I will slowly memorize it, and one day I will be able to use it effectively without constantly reading docs. This approach worked for LaTeX itself, and vim...
Its fine to say that something else is going on, as long as you don't ask what.
I guess this means that many "IT professionals" don't even reflect enough to clearly detect rubbish even after a fad is over.

OOP (as the solution to every programming problem), Java everywhere (performance is great and/or doesn't matter - really!!), P2P everything (because Napster), semantic web, XML, SOAP, agile(washing), cloud (whether it makes sense or not), server-side JS (overused), client-side JS whether you need it or not, IoT (aka please pay us monthly), blockchain. You see a lot of bullshit in a career.
Freedom of speech does not apply to privately controlled products from private companies. Any one of these companies could create any arbitrary rule to regulate their platform and it's not a violation of free speech. The thought is that they operate in a capitalist system where they are optimizing for profits which means they need the most amount of customers so they are trying to accommodate everyone.

The same way all of these companies actively block spam on their platforms to improve user experiences. This is probably a result of analytics in inside Twitter where they realize that it's costing them subscribers and revenue.
30 Ways How AI Will Change Your Business
I classified them into "falsifiable" and "not even wrong".
The point is you don't have to leave it up to Amazon whether or not you own something.
By monetary measure.
Nominal GDP is used to measure country market sizes, sorry.
Yes you can. In fact, considering happiness is a feeling, it’s a reasonable question whether there is even a difference between feeling happy and “being” happy.
>Is there a reason you have brought up the inferiority of third-world countries in your last several comments?

Is there a reason you have been "stalking" my last several comments across different threads? Checking what this or that commenter wrote in different threads to call them on it is kind of abusive.

For my part, the reason is quite simple: I first wrote about such countries in a thread, and so had the situation there fresh in mind when I encountered a couple of other threads with similar issues. I've also travelled and worked in those places for periods of time, so I also have them in mind.

Also, note that I didn't bring up the "inferiority of third-world countries" (those are your words).

I mentioned how they drive in some of them - which I don't find inferior. If anything it's more lively and less obsessed with cushioning the individual, which I appreciate).

In another comment I mentioned how countries near the tropics where billions live have lots of mosquitos and lots of heat -- and that was again in a positive spin, to contrast someone complaining about how Houston was unlivable before air-conditioning because of such things.

And that's it, a grand total of 3 comments, 2 about traffic patterns and driving, and one about heat/mosquitos.

Not all places I mentioned are "third world" either. I explicitly included e.g. China which is the 1-2 biggest economies in the world. Do you consider all of those places "third world"?

>Blind comparisons (to put things into perspective) aren't useful.

"Blind" is a weasel word without which there's no argument above.

Those are not "blind comparisons", they are simply "comparisons". Putting things into perspective is extremely useful alone.

In fact you first need to put things into perspective (survey what's going on across countries/domains/etc) and only _then_ form your "point". Else it's just a priori dogma.
4 Precautions You Need to Take for Safer Events – NVOLV
This is great for Alex Jones, he gets global notoriety, free publicity and gets to be the martyr.

Given Alex Jones weakness for theatrics he is going to play up this 'conspiracy' against him to prove every other conspiracy theory he nurtures for the next 10 years.

The 'co-ordination' however is blatant and raises questions about whether they are trying to silence him or martyr him.
Is this really necessary, why is it co-ordinated and so heavy handed?

The only logical explanation for it being so brazen is they are doing this against him as cover to silence more 'problematic' figures which would raise more serious concerns about dissent and free speech. But that's a conspiracy theory.
That one clearly describes LISP.

Lisp has an abstract beauty in that it is a homoiconic language thought up as an intellectual exercise from a small number of basic rules and simple syntax.

The hidden meaning, which surprised even its creator at the time that he wrote "RECURSIVE FUNCTIONS OF SYMBOLIC EXPRESSIONS AND THEIR COMPUTATION BY MACHINE", that a mathematical syntax should also be a fully implementable language to get a working interpreter, transforms the original paper into something even more beautiful and amazing than the original abstract beauty of the idea.

"The hidden meaning transforms the abstract beauty".

Edit: indeed, i think that one can apply to many instances of people who find programming languages and math aesthetically beautiful but also practical :P
Ok -- we must have such different internal lives that I'm willing to believe that your imagined pains actually hurt you.

Responding to your edit:

>whether there is even a difference between feeling happy and “being” happy.

That's not the question. The question is whether there's a difference between feeling happy and imagining yourself feeling happy.
I don't know if they mention it in the article, but those BS quotes are eerily similar to those generated by http://wisdomofchopra.com/ and I think that might have been what they used.
More and more Europeans have some form of AC, even if it's just at work. Even in homes portable units are becoming much more common. --In much of southern Norway stores haven't even been able to keep them in stock due to the heat wave we experienced that started in May and only recently ended.
JavaScript Limitations in Algorithmic Competitive Programming
Sure, within a few days he was banned from Facebook, Twitter, Youtube and LinkedIn - which covers almost all Internet traffic.

It was just 4 companies that banned him, not the government. He can just go to the alternate versions of those platforms...
IMO it is only Art if you feel something immediately. If you have to read some description to get the meaning, it is only pretentious and not Art for me.
BDS: how a controversial nonviolent movement transformed Israel-Palestian debate
> For sure, it's important to keep an eye on the code review culture, though. It's easy for code review to degenerate into nitpicking small things like whitespace, naming, coding conventions - these should be handled by tools instead.

I agree with this, but think there needs to be some balance. My experience has been that people generally add rules over time while rarely removing them - usually to quell disagreements without regards to the benefit of standardising the answer versus the cost of more rules.
11 does make sense even if it is false. As I see it, the distinction is on make sense/doesn't make sense axis.
We're just talking about cases where people suffer pain because of false beliefs, which can easily happen to people who have no mental health issues. If you heard that a loved one died, you'd be in a lot of pain, regardless of whether or not that report was true (so long as you believed it).
What, I'm not sophisticated and articulate at 3 AM? ;)
> "its power but it's persistence"

Can I call BS on getting the first its right and the 2nd one wrong?

On that subject, I would have classified 5 differently but it seems to be the highest score of the BS sentences so I guess it's debatable
It's supposed to be a distinction between bullshit statements and profound statements, which isn't the same thing at all.
Avoiding Concurrency Boilerplate with golang.org/x/sync
Yes, this is the value of optionality, as N.N.Taleb would say.

I had exactly the same thought about crossing streets when reading one of his books. Always choose a route where you have the choice to keep walking in some direction towards your destination, with a delayed jaywalk to cross to the side you want during a gap in traffic, rather than wait on a corner when a crossing is blocked. The reason for blockage can be a crosswalk light (if you obey them) or traffic itself - the rule applies even without any signal-controlled junctions.
BackPackerLampung
They've just had a hell of a long time to polish their excuses :)
I thought it was true, because of this: https://en.wikipedia.org/wiki/Phantom_limb

I guess you could debate whether that is "imagined".
How is graphic acceleration support these days? Does PCI passthrough work?
Abstract beauty can be beautiful without having a hidden meaning (or at least each one will see "the beauty they can see")

Show white noise to an Imagenet CNN and it will give you a score for something.
How different are tcl and node from select, poll, and epoll?

I know tcl and node are runtimes - but what do you get extra in their event loops compared to standard event loops that Linux offers?
Many very creative musicians lived very unhealthy lives. Most of them even grew old, some were not so lucky eg Cobain, Hendrix etc
> Clearchannel, which controlled most FM channels, infamously stopped playing John Lennon's "Imagine" after Sep 11 2001

This snopes article provides some background about what happened there:

https://www.snopes.com/fact-check/radio-radio/
Just the obvious: all the social media feeds you see are heavily moderated and shaped to ignite actions that are beneficial to advertisers/the platform. Comments, posts are removed without notice (except maybe the poster). Major search engines filter according to police warrants, media corp inquiries, "privacy rights" (eg. EU's "right to disappear" law).

As separated cases they don't seem like much - but knowing how few major platforms there are (covering like 90% of what most internet users see) this is catastrophic. What someone should see shouldn't be decided in some Middle-European FB contractor's moderator sweatshop.
Since the builtins are embedded directly into a read-only section in the executable, the OS will automatically share them between all processes using that executable; no need for node.js to do anything special.
It was never sound.

Black-body radiation describes the distribution of power emitted at given wavelengths or frequencies emitted by an ideal black body.

1. Distributions don't have one wavelength. There is a "peak" wavelength at which most power-per-wavelength is emitted, but there is still power emitted at all wavelengths no matter what temperature something is.

2. There is not sufficient reason to believe that the Planck length is a limit on the wavelength of light. This would break Lorentz symmetry.

3. Most things aren't ideal black bodies, but still have temperatures. Even if very hot objects couldn't emit light of Planck length, they can still couple to the environment and emit heat in other ways.
> ompare the amount of violence and harassment right-wing events and meetings get (from Antifa, and other such orgs), vs. how relatively undisturbed gay pride events are

.. you find that you know nothing about why Pride exists and what it's for? Homophobic attacks on Pride marches themselves are relatively rare in the West these days, but individual random street attacks, abuse and discrimination against gay people are not.

(also, you seem to have forgotten that the US president and both houses are currently in power, or does that not count?)
> infowars is still available at infowars.com ...

Until the CloudFlare CEO decides that he wants to virtue signal too (like he already did with Stormfront).

Or until Microsoft decides to boot them from Azure (like they already did when Gab.ai had a post they didn't like).

Or until the DNS is revoked... which has already been done by government agencies.
Yeah, I see more projects with bad code review culture than good. There are many things that managers can do about it.

* Assign enough time for code reviews - otherwise developers will just care about their own code submissions and let reviews rot.

* Establish productive code review rules. E.g. always go from big picture to details, otherwise you'll waste time on details that you end up throwing away.

* Make reviewers co-responsible for the quality of code reviewed, otherwise instant acceptance for everything becomes attractive.
But he's insinuating that people like Alex Jones should be protected by freedom of speech as if their fucked up ideads are some sort of alternative view that's just not for everyone.

This is a form of gaslighting that tries to establish credibility for extremists that they don't have.
DNA-based chemical compiler
Conterargument is that unhappy creative people exist and are not rare. So does bigoted closed minded creative people.

Unhealthy people can also be both creative and non-creative, both cling to one set of ideas or change their minds constantly. Pain makes you more nervous, frustrated, snappy etc, but you can still be creative.

Conversely, you can be tolerant and healthy, but still completely non-creative, whether it means generating new ideas or creating things. You can be tolerant, healthy and completely passive.
http://uk.businessinsider.com/alex-jones-infowars-employees-... ?
> There is nothing stopping you from doing it yourself.

Good database migration tools (e.g. Alembic) do this automatically.
CounterSocial
How much does it cost  to build an app?
Those are all really good points.

I have a recollection of seeing a study once that found the best balance point of review time vs dev time but haven't found it again. I recall it being somewhere around 20-30% but now that I can't find it I'm questioning my recall.
Stranger Strings
I will let you in with a little secret that 99% of the public is not aware of or refuse to believe. Every guest room in every hotel is equipped with extremely sophisticated surveillance equipment. Yes, every single room!

It is okay if you refuse to believe this because I know it's very difficult to accept. I didn't believe it myself until I saw everything in front of my own eyes. Just keep this thought in the back of your head as a possibility, one day you'll see the truth comes out.
> this comment is being downvoted without any explanation

https://news.ycombinator.com/newsguidelines.html

"Please don't comment about the voting on comments. It never does any good, and it makes boring reading."
Extreme nihilism seems to be as naive as buying any falsely profound phrase.
so then those people should be banned. A public individual cannot be held responsible for the actions of their followers unless they called for those actions to be taken.
yeah, quite similar situation in my experience too. Usually you need to implement features ASAP, so rarely you have time to do it properly, so you cut corners , implement it , and move on to another burning task just to meet deadlines for next investment round or something like that.
1) It doesn't make sense to call that "imaginary pain". The pain is real -- that's why it's a problem.

2) Do we know that phantom limb pain does not hurt less than the corresponding non-phantom pains? It seems entirely possible that while phantom limb pain is very acute, it's not as actually as bad as the pain associated with losing the limb in the first place.

3) Even waiving 1 and 2, that would be one rather obscure instance of an imaginary pain and a real pain having the same intensity, which would in no way establish the truth of the general statement.
The speed limit signs are the things that should be slowing down drivers.

The purpose of the camera is to enforce the law. By painting them yellow we're allowing drivers to evade the law: slow down for this bit, keep driving at our usual unlawful too fast speed everywhere else.
SQLite has had FDW since forever. https://sqlite.org/vtab.html

SQLite has had user-defined functions since forever. https://sqlite.org/c3ref/create_function.html

Another underappreciated feature (while we're at it) would be WAL instead of undo-journaling (https://www.sqlite.org/wal.html), which enables concurrent reading and writing of SQLite databases. Has been available for some ten years or so, but is off by default.

Functions are available through the Python bindings (which are not maintained by the SQLite project), virtual tables I think, aren't. Alternate bindings (https://rogerbinns.github.io/apsw/) claim to achieve "Everything you can do from the SQLite C API" interop, which would include virtual tables.
A part of me misses blue collar work. I'm a software engineer now and love my job but I'm often mentally exhausted, have less time to think, and find it much harder to stay in good physical condition. Besides, in a lot of meaningful ways, it isn't so different. I work for a great company but that doesn't change the fact that I'm giving up a certain amount of practical free will and allowing others to profit off of my work. It's not slavery but it doesn't always feel so great. I've never understood the mentality you're exhibiting. Someone else has it worse so nobody should complain? That's nonsense. Everyone should strive for better. Whether they're at the bottom or the top. That has always been the way of humanity.
>Upon saying that, the road injury and fatality statistics for the countries you mentioned are shocking. Vietnam is 2.5x higher than the USA for road fatalities per 100,000 per year

Just 2.5x doesn't sound shocking to me -- and probably the most of the difference is not even caused by driving patterns.

E.g. the road conditions in Vietnam vs the US, and the vehicle conditions there (breaks, mechanical faults, age, etc.) compared to the US...
Can Talk Therapy Help People Who Are Unable to Experience Joy?