skysight-inc/HackerNews huggingface dataset:
Glad you like the LEFT JOIN idea. Thank you for being open to new ideas.

Regarding table aliases, I understand the reluctance to overload your students with too much information, but in my experience they really do make writing SQL a lot easier (when coupled with an IntelliSense-capable environment such as SSMS).

Every time a student wants to reference a specific field they type one or two letters (ideally a name that is easy to remember, so if there was an ObjectType table a good alias would be OT, for example), a full stop, then all the available fields from that table are shown in a list. Nothing else is in that list, which makes the decision simpler to make. In SSMS, the IntelliSense usually displays automatically. Sometimes you experience a brief delay from building the cache, but manually toggling IntelliSense usually gets around this (it can be toggled manually with Ctrl + Space, which is an easy shortcut to remember).

On a side note, I tend to use the AS keyword when creating table aliases as I like making them explicit, perhaps that habit will also be beneficial to your students as it's the same keyword used for renaming fields in the SELECT clause also, so in a student's head they can think of AS as rename.
Don't be silly! Evil corporations don't have farside moon bases!

No, this proves that there aren't any space nazis on the far side of the moon.
My guess would be electric might be simpler and easier to maintain and with electric you can charge at home.
Agreed. You don't realize how invasive radio and TV advertising is until you don't have it.
Spanish people typically don't have eggs and bacon for breakfast (a pity, I'm from Spain and I love that kind of breakfast).

You probably had breakfast at a hotel or some other place that caters to foreigners.
This is a way to introduce space leak detection in your tests http://neilmitchell.blogspot.ro/2015/09/detecting-space-leak... so that you can sleep well and not be afraid of using Haskell in big projects :)
Finding and Fixing Productivity Bottlenecks
If you can show me even a contrived example of a React app where the presence or absence of three kilobytes of debug messages makes a measurable difference to performance, I will be very impressed (and humbled).
Indulge in the Fancy Party Dresses for Women
As you might have read two months ago, breakfast only became "the most important meal of the day" in 1944 when General Mills launched an advertising campaign to that effect: http://priceonomics.com/how-breakfast-became-a-thing/
Hi I'm one of the founders. Many people think this upon hearing about the service but the logic is flawed because:

A) It does not consider that we are building more cost effective alternative fuel delivery infrastructure that can help accelerate the adoption of alternative fuel vehicles other than electric such as the Toyota Mirai and Honda FCX Clarity.

B) Does not consider that efficient gasoline delivery can reduce carbon emissions and the number of polluting underground gas station tanks.
kind of a scam, just a bad wording from google "full access" and old oauth workflow - but no real security threat

TLDR: Pokemon Go can't read your gmail - he checked

https://gist.github.com/arirubinstein/fd5453537436a8757266f9...
Amazing project and very inspiring!
I'm curious about how do you scale to start getting revenue. For example, at remoteok.io companies have to pay to post a job. Was it for free at the beginning? How did you do the transition from free/low-fee to 200$?
Thanks and keep up the good work!
VKC CodeBuilder- an Online HTML5 and JavaScript IDE for Learners on the Go
Pretty common in Germany. People eat at home with family, then leave for work or school, and have a small breakfast with co-workers later in the morning or during recess.
Unfortunately they don't let you "buy" anymore. It's a yearly fee a la adobe creative cloud and as soon as you stop paying they "de-update" you a year.
Well mine does.
LOL. Technically some heavy trucks and engines, are powered by electric motor with generator. Some of the biggest trucks and tanks were electric ;-)

https://en.wikipedia.org/wiki/Diesel-electric_transmission
There is one thing I often think about when I see certain comments downvoted: downvoting a comment should cost one karma.

After all, this score system is called karma. And hurting someone else's Karma - even for valid reasons - is bad karma by definition :)
The "comma join" disconnects the join from the condition. It is hard to find the actual join condition between all the "where" conditions.
By using JOIN ... ON .., you explicitly link tables with their join condition and also separate join conditions from other filter conditions on the "where".
Duly noted, will fix bolding issue in the next posts.
The most effective way I've found to disable autoplay is to simply block the video content networks which provide these. At my last update, it was a rather small set.

0.0.0.0 player.theplatform.com # Autoplay video
0.0.0.0 link.theplatform.com # Autoplay video
0.0.0.0 ci-2862d2c8d6-68f418d2.http.atlas.cdn.yimg.com # Autoplay video
0.0.0.0 big.assets.huffingtonpost.com # Autoplay video
0.0.0.0 ht1.cdn.turner.com # Autoplay video
0.0.0.0 ht2.cdn.turner.com # Autoplay video
0.0.0.0 ht3.cdn.turner.com # Autoplay video
0.0.0.0 ht4.cdn.turner.com # Autoplay video
0.0.0.0 ht5.cdn.turner.com # Autoplay video
0.0.0.0 ht6.cdn.turner.com # Autoplay video
0.0.0.0 ht7.cdn.turner.com # Autoplay video
0.0.0.0 ht8.cdn.turner.com # Autoplay video
0.0.0.0 ht9.cdn.turner.com # Autoplay video

Alternatively, uMatrix should allow you to globally blacklist, then optionally whitelist same.
How do I make autocomplete work? I installed the plugin, let it download and install rust sources from zip, but no autocomplete suggestions work, even after ctrl+space. Should it work out of box?
Next time go to Poundworld/land if you want a radio! ;)
https://www.taskrabbit.com/platform
> signals not being queueable

real-time signals are queueable.
Metacomment: a few years ago anything by RMS would have been jumped on within minutes of posting with lots of comments against him and his principles. Is he now being looked at in a different light by the wider software development community?
For my last job interview, I encrypted the plaintext "DO IT" (as in, hire me!) with solitaire. I still remember sitting in the train on my way to the job interview, frantically shuffling cards to generate the ciphertext.

My interviewer thought it was a fun gesture and it definitely helped in me landing the job. Had they known about these vulnerabilities in the cypher beforehand, I'm not so sure I would've gotten it. :p
African Industries Hold the Key to Development and Job Creation on the Continent
As far as I know, you are probably looking for Jeffrey D. Ullman [1]? I think my lecturer at my local university basically stole [2] when he taught our course :)

Just be aware that he is an academic, so I might compare him more to A.S.Tanenbaum than K&R :-)

[1] http://infolab.stanford.edu/~ullman/
[2] http://infolab.stanford.edu/~ullman/dscb.html#slides
Doing a quick search has surfaced an item on this issue from a year ago. That article had this:

But Jot Carpenter, vice president of government
affairs for CTIA-The Wireless Association, resists
the move to turn on the FM chip.

At a NAB convention in Las Vegas this week,
Carpenter said there would have to be demand
by smartphone consumers for mobile carriers to
consider switching on the FM chip.

"What Americans really want is the ability to
stream, download and customize music playlists
to meet their personal preferences," Carpenter
said, according to the Las Vegas Review-Journal,
"and that's not what the traditional FM radio
offers."

There were 100 comments on this submission:

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

And a further 6 comments on this one:

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

It would be interesting to compare this thread with those threads from 450 days ago to see if anything has changed in the HN community mind.
Not sure what timezone you're in but it's about 4AM US Eastern time.
It might be useful to distinguish between intentional exercise and incidental exercise.

By intentional exercise I mean exercise that you consciously set out to do in order to help lose weight or improve your fitness.

By incidental exercise I mean exercise that happens incidentally to doing other things.

I've lost a fair amount of weight over the last 10 months (110 pounds, or 50 kg). I haven't really done much intentional exercise but because as I've lost weight my energy level and stamina have improved, I've ended up doing more things that provide incidental exercise.

For instance, I used to put off mowing the lawn because it was physically taxing. Now it is no big deal and so I mow about 4 times as often, and I mow places that previously I was content to leave overgrown. So I now get a lot of incidental exercise from mowing the lawn. I've also done a bunch of other garden work that I would not have done 110 pounds earlier, and have plans for a bunch more.

I used to prefer to shop at a smaller supermarket, because I got tired walking around a big store. Now I regularly shop at a large market that has lots of locally grown food, and also at a Walmart superstore. So now I get a lot of exercise incidental to shopping.

I'll probably be doing a few more home projects if it ever decides to actually start being summer here (Pacific Northwest), which will give me more incidental exercise both from doing the actual work and from shopping trips to Home Depot.

I used to enjoy bicycling, not specifically to exercise but just as an enjoyable form of transport. I was a regular bike commuter when I lived in Cupertino in the early 1990s, but when I moved to Seattle in 1992 that stopped. I took one ride around the block my first day in Seattle, and learned that fat cyclists and hills do not get along, and have not been on my bike since. But I still have my bike (1990 Miyata Triple Cross). I just pulled it out of its corner in the garage, and checked it out. Most things still work on it (although it needs a good cleaning and lubrication, a new front tire, some adjustments on the brakes and front derailleur, and maybe some new cables). A year ago, fixing it up would be too much work, but now it will be no problem, and once I do that I might take up bike commuting again. (I'm still in the Puget Sound area, but in an area that is much less hilly than Seattle). So that will be a bunch more incidental exercise.

I did try some intentional exercise, such as using a treadmill, but I found it kind of depressing. I'd finish a session and feel like I'd had a good workout, and then look at the estimate of calories burned and see that I'd burned off the equivalent of a few Tic Tacs.
I said a combination of that and tax/administration stuff.
Electric airplanes already exist. Obviously they're not replacing long haul airliners this year... but not every plane is meant for that sort of use.
what's more, it's remarkably annoying, being subjected to adverts on someone else’s TV is absolutely infuriating.
Tablets sold in US also do not have voice capabilities. 8" table is an excellent phone for daily use.

In some European countries you have to pay license for radio receiver. For phone with FN radio you would pay $25/year, that is lot of money with national average salary $8000.
If you care, dont support Sony. I have stopped buying consoles because of DRM abuse.
That's not quite true. What all your sources say, is that it is influenced by chicken feed. Specifically "the amount and type of carotenoids the chicken consumes."

You can argue that it doesn't matter what chickens eat, and you could win. But I'd wager that to a great many people the quality of food does matter.

There is the spurious matter of the nutritional quality of the eggs as discussed here http://www.thekitchn.com/what-does-egg-yolk-color-actually-m...

"Some studies have shown, however, that eggs from pasture-raised hens can have more omega-3s and vitamins but less cholesterol due to healthier, more natural feed."
suggest renaming this as "someone" has already snagged GXT https://www.sencha.com/products/gxt/
Did they give you that as a preparation task or how did that come up in your interview?!
Viennese breakfast: 1 bread with butter, 1 egg, 1 orange juice + 1 coffee.
Comey also admitted under questioning that the emails with "classified markings" were not marked classified as specified in the manual (with headers etc), and given that, it would be a reasonable for someone to not consider them marked classified.
How Not to Hire an Entirely Remote Workforce
Top Ideas to Create a Passionate Work Culture – SaaS Labs Culture
It's all about the batteries. That's what's holding us back
Original source at NASA (which, as usual, phys.org does not link to, they even ripped the short movie from youtube)

http://www.nasa.gov/feature/goddard/2016/nasa-camera-shows-m...
If you serve to mobile phones in third world countries every KB counts. For some of us this is a reality.
The Superbook $99 laptop shell for Android phone – APPlite
>Manufacturers can activate the chip, but the decision to do so typically rests with carriers.

Um... carriers in US have any authority over hardware functions of people's devices? Why? What the hell?
This is an HTML5 & JavaScript based IDE for learners as well as professional to make website and learn on the go. It can develop a webpage in real time on the go as soon as code is typed and has an autosave function which saves all your data as soon as you leave the IDE or any type of system crash occurs. You can leave and continue working anytime. It's fast and reliable and doesn't depends on server. Also it has an smart IDE editor which autocompletes and senses bug and error. With any updated HTML5 browser, it works at its best.

How much you rate it out of 10? What's your feedback about this & what more we can do more? Please let us know. Its online here https://vkccodebuilder.neocities.org

Thanks
complete garbage.
Uniblue Registry Booster 2016 Crack and Serial Key Free
Also you might be able to get weatherfax from satelite.
Hope for Tax Break on Private Tech Options
Emulation is far from perfect even for older systems. Amiga emulation is still being worked on. Less popular systems have poor standars of emulation too.
All those studies are as shady as the studies that used to promote cigarettes as healthy. There is enough evidence out there to the contrary, including recent studies :
http://www.atherosclerosis-journal.com/article/S0021-9150(12...

http://www.thelancet.com/journals/lancet/article/PIIS0140-67...

http://ajcn.nutrition.org/content/25/6/589.abstract

http://www.nejm.org/doi/full/10.1056/NEJM199112123252405#t=a...

The current rehabilitation of cholesterol is about politics :
http://www.foodpolitics.com/wp-content/uploads/2015-08-24-Ho...
http://ajcn.nutrition.org/content/102/2/235.extract

http://time.com/4225819/eggs-nutrition-egg-yolk/ ( 2016 )
Chris is quite big on saying that he chose Brunch because it is working quite well and avoid him to even touch the frontend.

I bet Phoenix will not make a so heavy choice on frontend and keep the default to vanilla js.
God, the double slit experiment drives me absolutely crazy
Hmm, I asked since my mental model of the 'programming community' that I osmosify by reading comments on these kind of websites detects a slight shift on the RMS popularity front over the last year or so. I feel he's coming in from the cold a bit.

I am mostly browsing HN during my european daytime. Lots of people seem to comment on stories during my daytime. Do you mean his detractors are predominantly American? Do you think they have a particular political allegiance too?
Snippets.today: a new social network for independent microblogs
To add to this, there's a professional penetration testing industry & similarly their methods could be employed in a malicious nature
My girlfriend's new Escape doesn't have a lock on the gap at all. Kinda weird.
The point is, Apple has a vested interest in making sure you're using TCP/IP to do that streaming, instead of just tuning into a radio signal from space.

The investment in the network of users is so high, and such a massive profit factor, that there is no incentive to flip the FM bit, for the users. Since it will mean less streaming will occur (you're not using TCP/IP when you're listening to FM radio..)

Its Apple, jealously guarding its piece of the OSI-model pie, and us users getting screwed in the process. I, for one, would very much enjoy being able to use my phone for FM radio .. heck, I'd like to use it for local peer-to-peer communications too, but we know how hard-bound the radio is for that purpose ..
I have uBlock Origin, no custom filters / extra plugins. No nagging. I'm from Europe, maybe it has something to do with the types of ads displayed to the US users? (Like some providers requiring anti-adblock measures)
I assume this works fine with intellij community edition, which is free and apache licenced OSS.
What. No, there was never a security breach. We uploaded the logs because people asked for them.

Lots of people asked for the chat logs (of public channels only) to be public and searchable. Like the forum. So I made them. Then lots of people didn't like that and wanted them to be private. It was never a security leak, I uploaded the logs myself. That was the whole point. I've never had any security breaches.

It was never a private chat, it's always been publicly accessible by anyone who paid the entrance fee and then scraped it. And they could (and probably) have already done that since the beginning.
It still means I'm sending potentially sensitive data (idk, passwords) to a server I don't own. There is no way I can trust github on this. Would there be a less-than-hacky way then regexing the URL? a way to let it redirect to a self-hosted version of the github page for example? Shouldn't be too hard to add and would solve OPs concerns.
As a fellow Brit, I've never seen a smartphone that does FM - though my feature phone does.
Would love one of these for Minnesota winters.
If a programmer is struggling with SQL in the way you describe, I'd suggest they learn how to perform MapReduce in the programming language of their choice. That should help give them a better understanding of how to approach SQL. If their language doesn't have good support for the MapReduce approach, a quick introduction in any functional language should help.
Bootstrapping compilers: solving the chicken and egg problem
Yeah, what is the secret sauce that lets them be profitable on only 3bp and provide a fund expense of only 10bp? All the roboadvisors are a 15-25bp wrap and ~16bp funds fees. A 401k provider is naturally more costly since there are compliance issues.
If you buy a Starbucks coffee every time at the gas station, doesn't that also add up to $15/month?
Nutritionist Adelle Davis warned about excessively sugary breakfasts in her popular book "Let's Eat Right to Keep Fit" (1954). Chapter 2 described the effects of various types of breakfasts, taken from the results of clinical studies. Some excerpts:

"The sources of sugar and starch in our American diet are cheap and overabundant; proteins are expensive and scarce. Typical American breakfasts, therefore, consist of fruit or juice supplying natural sugar; cereals, hotcakes, waffles, coffee cake, toast, or other starch quickly changed into sugar during digestion; usually refined sugar is added to cereal and coffee; jam or jelly may be eaten; quantities of sugar pour rapidly into the blood. In a matter of minutes the blood sugar may increase from 80 to 155 milligrams... As the digestion of a high-carbohydrate meal continues, however, sugar keeps pouring into the blood. In effect, it calls to the pancreas, “Send more insulin! More! More!”... The more carbohydrate eaten, the greater the insulin oversupply. For example, in the studies mentioned, the largest amount of sugar was freed during the digestion of the breakfast containing oatmeal."

"If we now consider typical American meals with a critical eye, we see innocent stupidity elevated to an art..."

"You may say you are not hungry in the morning; this remark means, “I overate last night.” Hunger sets in only when the blood sugar drops to about 70 milligrams; 12 hours after a typical American dinner the blood sugar is usually 95 milligrams or even higher. To launch a campaign of efficiency, the best technique is to have a mid-meal in the late afternoon. Dinner should be simple and graciously served: a soup or salad so delicious that everyone wants a second helping, meat or meat substitute, perhaps a low starch vegetable, milk, buttermilk or yogurt, and fruit. Appetites can be satisfied and the meal enjoyed without potatoes; gravy, and dessert, provided the afternoon snack is sufficient. Such a meal is easy to prepare, creates less havoc in the, kitchen, and allows you eagerness for breakfast the next morning."

When it comes to food and nutrition, many people suddenly become 'armchair' experts. But these observations and conclusions were backed up by clinical studies. Note, too, that this was published over 60 years ago. Ms Davis was a household name in the US throughout the 60s and 70s; she was to nutrition what Rachel Carson was to environmentalism.
Plain HTML, JS and PHP
https://github.com/rreusser/the-old-github-font
I think people are just tired of criticising him. I personally am against him, but it bores me to discuss the same stuff all over again, especially when it's "meta" as you say and can be deemed off topic.

(Not from the US)
I'd love to be debunked :)
Bitchcoin
Huh? I remember this being the case in the 1990s. In UK at least
Our favourite Cucumber anti-patterns
I believe Sega also had some institutional issues. There was a documentary a while back, can't quite remember the name. Something about the corporate structure a lot of the business was based in the US while the technical knowledge was based in Japan and thru some skulduggery they ended up torpedoing themselves ...
I've never given it much thought but the first thing that hit me is that the moon really is just a big 'ol rock up in the sky. These images have changed the way I view the moon. Pretty neat.
I don't get it, why do manufacturers bother adding an FM chip if they never activate it?
I don’t have any stats to back this up, but my impression is that most software developers doesn’t care that much about the FSF and RMS. Lots of people use free/libre software, of course. It’s kinda hard to avoid these days :)
Consumer Protection Filed a Complaint Against Apple Pay in Switzerland
> "For searching for items with '%foo%' in all tables and columns"

To do this you could perform two queries of the information_schema (one query for '%foo%' in tables, one query for '%foo%' in columns) and join them together with a UNION statement (or if you didn't mind duplicates you could use UNION ALL in this case as it's faster and the results from both queries can have the same fields).
I really appreciate what RMS has done as far as start a movement that I think has contributed greatly to the human existence but when he says things like "The basic point of the free software movement is that nonfree software is unjust and should not exist." I can't but seriously question his judgment. It's one thing to personally want to use free software, it's another to claim that nonfree software "should not exist". If one person writes nonfree software and another person voluntarily uses it, I don't think anything "wrong" has transpired. People should be free to offer software under whatever terms they desire likewise people should be able to consume software under whatever terms they are willing to agree to.
Is there a compiled binary for Windows yet??
the 2K Sports series negated the need for EA and sold so well that EA sought out an exclusivity contract with the NFL so that 2K would be killed?

The DVD drive after the ps2 was released probably would be a huge factor though, if the dreamcast wasn't in fact already dead which it was.

I'm sure some business school guys have written papers on this, I should find them. Would be interesting to read all the opinions on Sega's near death and exiting the hardware business.