skysight-inc/HackerNews huggingface dataset:
Knew most/all of these tricks already, but it's a good summary of some useful tricks.

Just one thing...

"Common Table Expressions (also: CTE, also referred to as subquery factoring, e.g. in Oracle) are the only way to declare variables in SQL (apart from the obscure WINDOW clause that only PostgreSQL and Sybase SQL Anywhere know)."

Can't say anything about other vendors, but in T-SQL (a.k.a. MS SQL) creating variables is easily done via the DECLARE keyword, e.g. DECLARE @x INT = 4; . You can create a number of structures this way, including temporary tables (there are few different types of temporary tables, but the ones specified with DECLARE are specific to the scope in which they were defined in).

Does the DECLARE keyword (or something similar) not exist within any of the SQL standards?
I suspect your disclosure (2300 feeds!) overly negated what would have been valid criticism of the tool...
I find this very hard to believe. One would expect Google to adopt Go, or perhaps Dart, since they were developed by Google.
Collision(New Orleans) live stream
The only facet that matters, then? Or, combined with gender the only facets that matter or let you be a part of the discussion?

I've been told off + blocked on twitter for chiming in about something I have intimate personal experience with, because white male.

Or the semi-famous video "you're a WHITE MALE!" (language warning) https://www.youtube.com/watch?v=0diJNybk0Mw
> Like now, during those times there were people arguing that the Jews are taking all the jobs

Are you really comparing Internet essays about 'white privilege' to the Nazi movement?
Curious on what advantages you see vs. using IPv6
Edit: IPv4
The rich want that.
This is great... I am kind of tempted to see if works firewall will not like the URL's
Leprechaun In the Hood is generally considered to be the high point of the series and isn't included.
It's rubbish, but the IntelliJ plugin is improving at a rate of knots:

https://github.com/KronicDeth/intellij-elixir
I am against torture. However, it behooves us to be honest to avoid counter arguments. There is a time when torture clearly does work - when you have a way to quickly verify information. I.E. if there is a safe in the room, or a phone number you can call, or something like that. However, most of the time torture is not used for that purpose.
I just think when we are talking about two technologies like this, something like "via" or "through" is a bit clearer.
Show HN: SaaS DNA Project – Community Driven SaaS Research
Are you perhaps looking for /etc/profile.
And that prejudice will amplify if you continue treating people of color differently.

Recognizing unjust treatment and inequality is not "treating people differently."

Equality is the goal; recognizing inequality is part of how we get there.
You really want to try Spacemacs (emacs with layers) with Alchemist
Thanks for the snarky link to your sources. That was uncalled for and entirely unhelpful. Most of the links I encountered cited that women left because it's a demanding work environment without a clear career path.

I have been in a position where I was overtly discriminated against because of my race and gender. It was in the early 90s and I was denied admission to a magnet elementary school that my older sister attended. The year I applied they took 50 out of 200. I scored 37th, but I wasn't chosen because diversity. There were lawsuits, and the practice was stopped. Now admissions are blind to race and gender. My younger brother also ended up attending that magnet program. It made a significant impact on the trajectory of my life, and it didn't feel any less terrible to be discriminated against because I am a white male.

A fairer chance based on merit isn't going to solve the gender / racial imbalance in tech. Tech is a meritocracy. Either your program works or it doesn't. The computer doesn't care at all whether or not you have "privilege."
They'll end up in phones and watches eventually, running CNNs for speech recognition and other useful things.
All this talk of 'intelligence' gets confusing - it seems like the core distinction people are talking about most of the time with 'general' or 'strong' AI is really something more like Artificial Consciousness.

This has issues too - if consciousness is an emergent property of a neural net with the right feedback mechanisms and training material then even if you have the right feedback mechanisms you could still create an artificial consciousness that's stupid.

You see this problems in humans - depending on a lifetime of 'test data' exposure (parents, peers, environment) and the underlying brain neural net 'hardware' you can get people that believe a lot of stupid things.

Maybe consciousness doesn't have to work that way and we're just dealing with a local maxima of evolution (or some reproduction/sex drive constraint), but we might end up stumbling on the ability to create a neural net with the ability to emerge a consciousness before we can craft the type of consciousness we'd want.

Actually understanding how the system works is harder.
> I'm wondering what the use cases for this were, and if they couldn't be achieved in another way.

I suggest you click on the link and read the words written on that page.
There's Sam Altman's Startup Playbook. That would be my recommended starting point.

https://news.ycombinator.com/item?id=10514729

On the other hand, worrying about what happens at IPO is premature optimization until well down the road from raising money. That said, selecting good investors is a good idea. By "good investors" I specifically mean investors with a good track record investing in Silicon Valley style startups. This implies that "startup" carries the specific meaning it has in Silicon Valley and not the every-new-business-is-a-startup meaning that it carries among entrepreneurs and investors just about everywhere else.

Lastly, there's also Graham's Before the Startup. I'd recommend that based on the implications of "Startup's for Dummy's" in regard to "playing house."

Good luck.
Depends on what you're used to. Certainly you get the normal bits that editors all support: text coloring, autocomplete + basic code complete stuff + whatever linter people have created. Not resharper or heavyweight sorts of IDE things yet.

I never had any issues here with sublime
The pendulum has already swung back somewhat: Since the '00s, the ruling party has been quietly ramping up the social safety net (various subsidy programs for the low-income), implemented universal healthcare to an extent (keeping health insurance costs low), and focused a lot on aiding older unemployed citizens (wage subsidies, retraining, upgrading). Government departments focus more on "customer service" and have a "no wrong door" policy.

It's been a gradual moderation since the '90s and before, when things were more uptight and anti-welfare-state. I remember the "OB markers", stuff that was out-of-bounds for public discussion - much of those have been eroded by blogs, forums & social media. So, not Marxism, just a shift away from pure capitalism and authoritarianism.
Honestly, Softpedia decided to write a review about it. We didn't even reach out to them.

The project is currently unmaintained, and we may open-source part of it.
Well it may take time, but they will work their way up. I really hope they eventually allow you to "buy" movies. The convenience of Steam for me has always been that I can download things I own and not take up a ton of space with CD's that will eventually be scratched and possibly break.
New Study Shows Fructose Alters Brain Genes, Which Can Lead to Disease
How did we ever get to HOV lanes?
Alchemist for Emacs is truly wonderful.
Smartphone saturation - the whole market is slowing, though particularly in the US and China where iPhone marketshare or growth is strong.

http://www.pcworld.com/article/3027008/smartphone-growth-at-...

http://www.usatoday.com/story/tech/2015/10/29/smartphones-sa...

http://www.telegraph.co.uk/technology/mobile-phones/11812322...

While the iPad seems to have stalled on its own significantly, this doesn't seem to be an iPhone-specific trend (yet)
>Yeah, no. Having an unelected, compulsory board governing the area is not freedom.

Whether the officers are elected or not (or whether there are officers at all) would be determined by the founding documents of the HOA. But it is definitely not compulsory.

>Often times not, as one cannot buy houses in an area without being a member of the HOA.

That doesn't make it compulsory. If you buy a house in an established HOA you chose to be subject to it. If you don't want to be subject to it, you don't buy the house. Saying you should have the right to buy a house in an HOA area and not be subject to it is saying you believe contracts should be non-binding, that is, worthless.

>I get to vote on members of my local government. I don't get to vote on members of the HOA.

As pointed out above, an HOA can have whatever structure the founders want it to have, or whatever the current decision makers amend it to be. As a tangent note, democracy does not define freedom.
Yeah, I use camera sync to backup my phone's pictures but it's too much for my small SSD in my laptop. I have to periodically move files from "Camera Uploads" to "Camera Uploads Archive" (which is setup to not sync to my laptop) but to do that I have to be on a machine that can hold all of that (which luckily I have one but still it's a huge PITA. I've ALWAYS wanted dropbox to work the way outlined in Project Infinite and I'll be really disappointed if it doesn't come to personal as well. Seems like it would be pretty stupid not to as it's just a client change and it's not like it really costs them anymore AFAICT.
As opposed to having your non-predictive model be in conflict, because your connection decided to space out for a minute so you don't see any results from any of your typing?
People actually wanted QUEL? There is nothing of value there. Maybe this is a hindsight bias, but it was less powerful than SQL in pretty much every way possible. The only thing SQL got irrevocably wrong from the start was null handling which forced us into non-intuitive ternary logic that couldn't be deprecated because of backwards compatibility.
The Brian Hayes articles were always awesome - sadly he has gone.
Nokia exited the consumer market, so they fell off most people's radars. They've continued as a multinational network equipment company with over 100,000 employees, so they do still exist.

As far as I know, this is their first reentry into consumer products since getting out of the mobile phone business.
Multiplying 3842 by 543 is very hard for humans. They're slow and inaccurate. Computers do it perfectly at incredible speeds.

Inventing multiplication is something no computer (as we currently understand them) would ever be able to do.

For another analogy, moving ten tons of rock a thousand feet is something humans can do, and have done for millennia. It's very slow and difficult. A bulldozer can do the same thing in minutes. But a bulldozer would never, ever have a reason to move ten tons of rock.
be careful with that.

as far as I can tell from my own investigations into it, Murray Gell-Mann did not coin this term or have much of anything to do with it. Murray Gell-Mann himself was a quantum physicist and I don't think he spent a lot of time worrying about the news media.

I believe the "Gell-Mann Amnesia Effect" is something created by the fiction author Michael Crichton as a plot device. It may be an interesting idea but as far as I know it is not a real researched effect in media studies or psychology.
Researchers have accidentally made batteries that could last 400 times longer
Atom has recently gained a significantly better support with the atom-elixir package. Adding language-elixir and linter-elixir packages creates a moderately enjoyable experience.
They'll likely put a lot of emphasis on their services number(s), which is growing substantially.
That's a great novel. Vampires!
I don't entirely agree with either side, but I will say that:

> First, you say "If given the opportunity, they would kill every single one of us". That's not true. Those terrorist acts have politic goals.

Certain segments of the western Political scene very much want to believe this, but I'm skeptical. They said that Hitler wasn't serious about his rhetoric either, that it was all politics. In fact, he meant it all, and indeed went on to start the biggest war in history and slaughter millions.

They downplayed the extremism of the ISIS types, and look what we have there. Just what we've seen so far is quite bad enough, and we haven't even gotten a full look at the situation.

Do we not at least owe the enemy the respect of believing they really intend to do exactly what they say they want to do? And they most certainly are the enemy of everything that we in the West hold dear.
It's awesome how the old monopolistic companies like Intel and Microsoft are really trying to get developers back to their platforms in any way possible, like trying to behave nice and create migration/adaptation layers and offer some kind of "port theory" tools.

It's interesting to see how far they are willing to go...
I literally cannot imagine amazing sex that doesn't easily pass the threshold of "affirmative consent".

As I quoted elsewhere in the thread, the definition that pops up on Google reads, "Affirmative consent is a knowing, voluntary, and mutual decision among all participants to engage in sexual activity. Consent can be given by words or actions, as long as those words or actions create clear permission regarding willingness to engage in the sexual activity." [http://system.suny.edu/sexual-violence-prevention-workgroup/...]

Any attempt I make to imagine "amazing sex" involves my partner being every bit as excited about what's going on as I am, at every step along the way. That means that when I'd signal interest in doing something new, she'd be expressing delight about it in one way or another (and vice versa). Anything of the sort would satisfy this definition with flying colors.
In a real democracy, 60% is not dismal; it is a landslide victory.
I've had people come out to my house and quote me on a project. I've then called them back and told them that it was out of my budget, to which they've then quoted me a cheaper price, hoping that it's within my budget. I've then told them that they should have given me their best price from the start, and I can no longer trust them, because they've already lied to me once.

This happens more often than not, and I usually eventually find someone to quote me a price within my budget on the first visit. I understand that that is typically how business is done, or more specifically haggling, but I don't want to haggle. Even if it is outside of my budget, I'll postpone the project until I get the money, and then call back whichever vendor didn't budge on price the first time (and had the lowest price, of course).
SQL also gets a bad reputation from programmers that have a SET based approach to data too, because it's horribly uncomposable.

When I try and solve a problem with SQL, it's generally trivial to produce a solution in relational algebra pseudocode , and convert that in turn into a deeeeeeeply nested, horribly nonperformant almost SQL query. Then I have to go through to try and unnest it, fix all the little "gotchas" involving "GROUP BY" and "HAVING" and implicit aliasing, and somehow make it performant (Admittedly, that last one is usually the DB optimizer's fault.)

Relational algebra is a beautiful way to answer many questions. The issue is SQL isn't a very good way of writing it.
sure, but for many people having a savings account that is out of sight out of mind helps prevent dipping into it when you don't need to
Did you get the irony of a platform for personal expression and sometimes dissent moving into a country that suppresses dissent and narrows personal expression? Unreal. They've clearly bought into the propaganda with the list they posted. It's half right but counterexamples show transparency and corruption should be off it entirely with trust in politicians and education having qualifiers.

It is a good place to do business with people capable of it, low risks, and so on. In general. Yet, I wouldn't bring in anything that's about personal expression or privacy. That's just incredibly stupid given long-term risks.
Maybe try bazqux. Super fast, written in haskell https://bazqux.com/faq
He makes a flawed argument that computers are smarter than humans: but the flaw is obvious in that a computer couldn't even make that argument. It takes a human.
My solution to that is to run mosh on top of screen. tmux would also work.
You aren't wrong. I believe in economic acceleration but there is a limit to how far you can take it, which we are now testing with ZIRP. In this case the central banks kept their feet on the gas pedals too long out of political fears of a global depression. Global depressions suck but they are also very useful in that they create healthy periods of intense asset reallocation to prevent malinvestment. Did (largely successful) Japanese attempts to prop up their economy in the 90s and 00s prevent more acute pain but also kill an entire generation of Japanese entrepreneurs who would have cut their teeth with blood in the streets? Instead of healthy reallocation, we have far less targeted broad asset inflation in an attempt to keep economic acceleration going when we are already near the point where GDP growth equals debt service requirements and I don't think it ends well. It's also interesting that ZIRP screams ''maximize your human capital'' at the same time that automation threatens opportunities for the bottom rungs of the work force, and it's not clear how that dilemma will be resolved.
If you enjoyed this article, I highly recommend the book "The Supermen: The story of Seymour Cray and the technical wizards behind the supercomputer". It goes into a lot of detail regarding ERA before Cray, the creation of CDC (which is a fantastic start up story regarding how they got funded) along with a lot of specifics on Seymour and his thinking and development style. Seymour is my all time hero, and learning extensively about him and his architectures was what gave me my love of computer architecture and design, with this book being a fantastic information source.
There is a lot of free, open and convenient software that respects my privacy.

Do you think money or privacy violations must be part of the equation to make good software?

That is like the old argument against free/open software that I heard from a lot of people, back in the 90's. I thought we were past that.
Goldman launching online bank.  Was Goldman better off as private firm?
Another reason to offer this money back guarantee when selling products online: you're already doing this whether you want to or not. Your customer's credit card company will usually offer a chargeback within 90 days, and then you'll cop the penalty fee for the chargeback. You may as well offer the same guarantee as the cards do, but encourage the customer to come to you instead. You'll avoid the fee and potentially get intel on what problems customers are having with your product.
I would say they're mostly orthogonal. I use mosh and screen.
I'm currently using Atom with this package: https://github.com/msaraiva/atom-elixir
Any details on what you were using it for? What did you like about it vs something like Racket?
I have mostly gone back to plain ssh. mosh was fantastic for keeping a connection running across network changes and when accessing a plain command line it does feel a bit snappier on slow connections.

But screen or tmux give me persistence and re-establishing an ssh connection isn't very time consuming. A terminal multiplexer has a lot of advantages that mosh does not provide.

mosh adds another layer of terminal emulation and while the extra latency might not be a killer the terminal emulation can be as it is opaque to some features.
No, no, no....you are doing it all wrong. You find the shortest verb describing what you do and add 'ly' after it.
"Hey kid, nice treehouse, but what about burglars?"

Also building code, fire code, ADA accessibility requirements and permits and sign off.
Show HN: HackerWeb, now available on Android (also on Web and iOS)
I thought driverless trucks were already a thing.

From [1]:

>Driverless trucks aren’t new to the resource industry. Mining giants Rio Tinto Group and BHP Billiton Ltd. use them at many of their operations and oilsands producers see driverless trucks as an obvious way to boost productivity.

I can definitely see it expanding, as automation has a tendency to do, and the idea that no technology will automate away more jobs is certainly interesting.

[1] http://business.financialpost.com/news/energy/how-canadas-oi...
It's been working out well enough that we're alive? That's a pretty low standard for whether we should discuss the intersection of social/political issues and the tech industry. Surely in that case, we shouldn't be discussing any regulations or taxation of the tech industry either?
>>Privilege is multifactorial. There are such things as white privilege, and male privilege; but those are not the only (nor arguably, the most significant) privileges there are.<<

Well, that's exactly the problem with the "white male privilege" verbage: it's just one single angle of the global problem regarding social / ethnic class issues.

Even from an Euro-American perspective... When it comes down to it, who has more "privilege" or social status? A college educated Asian-American woman from an urban, wealthy family? Or a poor, rural uneducated white male from, say, Appalachia or the Deep South?

Yes, there are obviously people with lower "social standing" than the poor, rural, uneducated white male -- and color or sex does play a part. But the point is, sex and race are not the only factors that make up social status, even from a Euro-American angle.

If you factor class issues in the entire world, it gets even more complicated. Each area has their own quirks and social structure.

Unfortunately I find that many people who advance the "check your privilege" arguments are not very nuanced. Social status is complicated. So I think it does a disservice in the end. Again, let's take that a poor, rural, uneducated white male in Appalachia, no job since the coal mines shut down, on benefits, etc. They come across an article written by a college educated woman, in an urban area, probably making quite a bit more than he is. And this person is telling all white males to "check their white male privilege".

What do you think this person is going to think?
To be honest, if I'm 55+, I'm probably not too worried that self driving trucks without attendant drivers might be permitted on some major trunk routes a few years after my retirement
key based, or saved credentials, and tmux on the host.
Termux[0], the best Android terminal emulator (in my humble opinion), recently had mosh added to its' package repository.

I currently use it and it's very nice. It makes me long for a better handheld though (my 4" Moto G screen is difficult to type on, even with Hacker's Keyboard).

I can have tmux sessions running on servers with say, an irc client running, mosh in, chat away for a bit, turn it off, the irc client continues running. Perfect. Same for e-mail using mutt, notes that are backed up on the server automatically using vim, etc etc. Really nice workflow.

Give me a handheld device with ssh/mosh support and I'm happy. :)

[0] https://termux.com https://play.google.com/store/apps/details?id=com.termux
I probably muddled my own point by descending into a rant in the OP.

I just found the unsaid implication, that torture is fine if the person does possess information you want to know, worth examining. Perhaps consider it this way: imagine all of the assertions made by the Bush administration about the victim were correct; he really was the Al-Qaeda 2nd in command, he had smuggled high-ranked Al-Qaeda members out of Afghanistan etc.

Would there be a defensible justification to torture him, and what would that justification be?