skysight-inc/HackerNews huggingface dataset:
In the 'Select specific columns' lesson, FROM isn't capitalized. Not an error but could cause confusion. Same with AND in its lesson. It might also be nice in the first lesson to explain that the caps aren't necessary, but make it more understandable.

In the first lesson, after the paragraph "Imagine we have a table...", it might help to display an actual table there. I was a bit confused, reading through the whole page and not visually seeing any table. Only after I started writing the command did I realize I had a table underneath the input box.

Overall, looks really good! Not a bad place to start for developers who haven't used SQL before but want to get a simple working knowledge of it.
If you want new features, you cannot expect old browsers to be supported, that's just the way it works.
Learn the one you prefer but don't choose for this reason : Haskell is also very present at Facebook.
Great job! By the way, pet peeve: It's Lua, not LUA.
How do you cope with demands for 100% uptime? This new eBook tells you how
Once I see the demo I had exactly same feeling!

So I made this: http://demos-sxx.rhcloud.com/apparently-transparent/
And if you just want a flexible ORM without models, knex (http://knexjs.org/), which bookshelf uses.

I found knex + Postgres to be a great combination.
Even if his snobbery is with the car, the Camry design works at some level. Toyota sells tons of those. I had one about 10 years ago, and it was functional and does the job. For me, if I am going to spend 20K on an item, I would want it to be functional.
It's selective enforcement based on who he is and his associations. That is, they were being opportunistic. Whether that was to send a message or otherwise. It's also possible they were tracking his activity and they chose to pursue it because from early on they wanted to convert him to do work for them.
> Theoretically, you can compile any compiled language to asm.js, so you'll have a lot more choice for the language you want to use to create your webapps.

Asm.js is meant for low level code, i.e. the kind of code that doesn't do garbage collection. High-level languages are better off compiling straight into Javascript.

Solid examples that I know about:

- http://www.scala-js.org/ (we are actually using this one)

- https://github.com/clojure/clojurescript

- http://funscript.info/

And there are other implementations as well.
This is a self-plug, but you might find http://pgexercises.com useful as well.
"the concept of arcology, which combines architecture and ecology"

The first things that comes out at word deconstruction are "arc" (bow, curve) and "logos" (science), which suggests some kind of discipline on curves. Very far from "ecology and architecture combined".
Interesting and funny. Good to see I'm not the only one in a similar situation.

You're not sick, you're just a human being in a very competitive world which changes very fast. You're bombarded by an unlimited amount of information, entertainment, advertisement, scary news and adrenaline.

No wonder we all have ADHD and OCD and whatnot.

Some tips:

You need to force a little discipline upon yourself, limit your addictions, eat healthy and excersise.
Socialize.

Make an imperfect thing, just a prototype, no database, no beautiful graphics, messy code.

Show it to the world and see what the world thinks of it. If they get as excited as you are, then find some money and focus on doing it right: TDD the shit out of it.

It's the only way, just do it badly and see how it feels. It might not be as cool as you thought or it might actually be your Thing!

I'd write a longer comment, but I feel like I'm taking time away from my next insane project that's going to change the world - and I need to write some code.
Good luck.
> For example, realising that other people find listening to trance music also helps them code.

I'm starting to find that listening to repetitive music helps with coding as opposed to lyric based music such as hip-hop.

It would be really interesting to see how many others feel this way and what else helps them focus.
I witnessed a similar project unfold. Eventually, I believe, most of them were kicked off the project and it was brought back under control of the company I was working for.
Likely also better performance with just using Knex.
Any ORM likely adds overhead, Sequelize definitely does, although we keep working on reducing that overhead - But inevitably features === overhead.
Is there a reason you don't bother transferring your number to the new provider when you switch (to another provider in the same country)?
It's about programming languages! :D

Although, I think, if someone reads it who's not familiar with programming languages, the reactions, when you tell them what Haskell and Python are, might range from hilarious to WTF.
Neither Sequelize nor Bookshelf has persistence ignorance as far as i know.
It's kinda similar to the post I've submitted yesterday. Shows how us government is playing. It's kinda disturbing: https://news.ycombinator.com/item?id=9071148
Not when using tools that are unfamiliar. It's really really hard to fight the urge to Google "how do I XXX in YYY". Even though I have an online documentation browser (Dash), I still Google first; it's much faster.
Boss of Motorola Criticised by Apple's Jony Ive – Code Jar
Actually, on your point #3, it will most likely run faster than regular JS on those non-asm.js optimizing browsers, as most browsers have JS engines that perform some kind of optimization, optimizations that serendipitously work quite well on asm.js code.

Slower than an asm.js-optimizing browser, faster than idiomatic JS.
Pawn shops aren't exclusive to the states.

I guess there's more of a distinction since the types of collateral the other institutions take are more specialized.

The other distinction is i'm guessing these specialized institutions are going to use your credit rating against you when you don't pay up.

I don't think they sell hocked these items on their desks either.
People, please. This presents a problem poignantly and provides a pleasant programmatic solution - the precise point of "hacker news". Be not so butt-bothered about non-apparent algorithm applications.
2015 Analysis and Predictions for Facebook, AWS, Google and Apple
Aren't you imputing motives without proof ?

While I respect your sensibility, I would have made the same kind of remarks without thinking it would hurt someone. I understand it could, but it wouldn't have been my intent. Also remember that your position is very very US-centric. But I am all for communication : explain your point to the author and propose something else that is as funny as the current text.

But saying the author chose not to is simply dishonest.
Myself and other technie friends (some who have had zero interest in meditation) have found success with Headspace [1] It's approachable and encourages consistency which is the pathway to success in this area from what I have been told :) Good luck!

[1] http://headspace.com/
I had the same message on my Windows Phone 8.

It actually doesn't show too bad. So I would anyway rewrite this message.

- First, why absolutely say Chrome ? Especially if it actually works in Firefox.

- Second, well, even if I wanted, I can't download Chrome on Windows Phone, so I would say that you should detect when it's a smartphone and show a different message then.

- Third, I can understand that it's a lot of work to support all of those platforms, so I don't necessarily expect that you fix the issues with Windows Phone, but that really irritates me when people always advise to download Chrome. This is not IE 6 times anymore, we should all learn from it :)
If you are running a business and your team handles email marketing for your business, having a simple export button in the email marketing application is not a good idea.

Better option in my opinion is to have a simple export request form and send the export directly to the admin email address.
This has literally – literally — no relevance. No car would ever run a Darwin stack, except perhaps on some kind of user interface, where the demands are totally different.
PoCh - Proof-of-Cheese ?
Ha and to not be totally negative, because I like it a lot, is the code open source somewhere ?
> to be driven by or driving

I prefer to think of it as simply "to be"
No, this is an example of the Lenovo sales / marketing people making distribution deals with dodgy third-party companies. The people who design the machines don't make the decision to ship MITM proxies on them.

I honestly don't know why Lenovo (and others) still make these third party deals. Just ship the machine with a blank OS, or install a vetted selection of open-source software (7zip, VLC, LibreOffice if they want). Just don't install crapware for the mediocre kickback it generates!
You appear to have lost respect for because a journalist used the term 'disgust' to describe their feelings, without it being a quote. It is a ridiculous thing to lose respect for someone because of a third party's interpretation of something they said in this manner.
Oh for sure – instrumental-only for me. Lyrics are too distracting. I like ambient, downbeat, chillout-type stuff. Groove Salad on SomaFM is great: http://somafm.com
BaseX – An XML Database and XQuery 3.1 Processor
I have one of the Ubuntu XPS 13s. It is a nice machine but battery is woeful after < 2 years of use.
Please, shut up and take my money – or how I am unable to pay Microsoft
I ended up on the wikipedia page by some random navigation, felt interesting.

Seems like a pretty interesting concept of "city", so I thought the HN crowd might appreciate :)
Darja Isaksson – Startup Iceland 2015 – Speaker Profile
You Could Have Invented Monads is what really made monads "click" for me. There are better tutorials for how to use monads in the real world, but I've never read a better description of why you would want to, if you don't know what they are.
Getting solid at Git merge vs. rebase
Git won't let you push a modified history without a force anyway, and you can set up the remote to refuse these pushes if you want.
Watch out, batter life is pretty crap! (About 2 hrs on my < 2yr old one)
What’s new since Git 1.7
It's not clear to me. Just a few minutes ago (and after your post) this appeared on mozilla discussion forum given by [1] above (will come back to credit this- didn't copy and don't remember (and can't see!)).

https://bugzilla.mozilla.org/show_bug.cgi?id=1134506

Down around 0200 PST 2015-02-19

EDIT: credit

[1] cpeterso https://news.ycombinator.com/item?id=9072642
Financing of these types of thing has been going on for centuries, the article mentioned that the cheese loans had been going on since the Medici era. Most of this type of business has been credit funded for centuries too.
"Cupertino has the cash, the momentum, the expertise, the retail network, and the global experience to position itself as a car company"

I'm seeing essentially the same arguments over and over again for why Apple should obviously get into the car business. They all try to make the case that it's complimentary to what Apple already does, or that Apple has natural expertise to build a luxury car brand, and so on.

Well here's why Apple shouldn't do it: the margins suck.

Apple may do something like $60 billion in profit the next four quarters. In a good year, BMW can generate $5 or $6 billion in profit; Toyota, the world's largest automaker, just managed $17.7b in profit on $249b in sales.

If Apple does everything right, in 15 years they might be able to match BMW's profit and scale.

Why should Apple want to enter a low margin, capital intensive business, when they own one of the greatest high margin businesses in history?

Put another way, through extreme effort and investment, if they're really fortunate, one day they might get a $5 or $6 billion profit business out of it. Approximately equal to boosting their iPhone business by 10%-12% today.
For old technologies falling in disuse, like fax, there's an opportunity in the trailing edge to providing it as a service thru the internet.

You can have a fax number, and any fax sent to that number will be forwarded to you as an attachment in an email.

Similarly, there are services providing you with a phone number to receive SMS messages and forward them by email:

https://www.raymond.cc/blog/top-10-sites-receive-sms-online-...
Who will Facebook buy next?
The one non-subjective aspect of design (other than cost, obviously) is functionality, and the Camry is one of the more functional cars on the road.

Every other aspect of design is subjective. One person's Porsche is another's Ferrari. One's BMW is another's Merc.

Also, the article (although possibly misquoting), states that Ive's disgust is with the exec driving the Camry, not the Camry itself.
I can attest that thinkpad quality is on the decline, linux support too (not mentioning the stupidity of experimenting with new ways of doing keyboards[1]) but it's not that bad yet.

Hardware is good, in case of trouble on-site warranty works well (once you've learned your way through the ibm website). Be informed about what you buy, skip the comically broken models (see adaptive keyboard) use common sense and your thinkpad will be good. Nothing out of the usual when buying tech stuff.

Though in a not so distant future if lenovo declines continue, it may be wise to stay away from their brand altogether.

[1]: http://arstechnica.com/staff/2014/01/stop-trying-to-innovate...
What You Need to Know About Superfish
If it wasn't intercepted from the cPanel then it may have been intercepted from the HTML file download from JSbin (which I copied into cPanel).

Either way, this was a downloaded HTML file which was then copied into cPanel. I never viewed or edited the file between its download from JSbin & pasting into cPanel.

The Malware was affecting files & not just pages viewed in browser. Nasty stuff.
Why I can’t make good decisions when I am hungry
Perhaps not

https://bugzilla.mozilla.org/show_bug.cgi?id=1134506#c19
completed the course thanks for the tutorials.
And if you don't have a 3D printer you could perhaps use on nearby you via 3D Hubs, https://www.3dhubs.com/
You're right. We'll change the message as soon as I come back to my desk. To be honest, the fact is that for the specific widgets and animations we're using, Chrome gets the best performance (at least on my MacBook Air). Firefox also has troubles with the dotted attribute for border css that we use for the lux widget. But Safari works ok, just as any WebKit browser! And for the record I use safari as my primary browser :)
Looks like the certificate and encrypted private key has been found in "Visual Discovery.exe" - http://pastebin.com/N42Qfm5p (credit to @paul_pearce)

More context at https://twitter.com/supersat
Flexbox, or display: table-cell.

These have been supported for a while now – you're not going to get old browser support, but they're not going to support 3D features either, so your complaint is either flame bait or ignorance.
I agree. I think it's much more educational to watch two people pair program. Pairs have to explain their ideas and concerns to each other, so viewers are more likely to understand the problem, potential solutions, and general problem-solving approaches.

It can also help if the solo programmer is "rubber ducky" programming[1], but people typically assume more shared knowledge than actually exists. It takes another human to counteract this by asking for clarification.

1. https://en.wikipedia.org/wiki/Rubber_duck_debugging
How stupid are the FBI?

Do they really want to bring someone "in the fold" in a coercive manner like this? Someone who's entire ###existence### is about cracking systems and spreading information on what they find? They want to invite him into their own living room, knowing that he hates them and feels they screwed him?

The arrogance of these people to think they could actually manage and control someone like him, and not get burned.
Yep. https://github.com/SidLeeParis/sidLeeAgenceConnectee
It's considered poaching to hire engineers from a company that's been bankrupt for two years?
I do commercial closed-source development; there is no public branch to the
whole world. OTOH, all feature branches are public to the team; only trivial
features involve a single developer. So your assertion doesn't seem well-formed
to me.

Actually you can still rebase, but you would benefit from having a separate shared repository for developing that feature, so that you can share rebases without rewriting history on the release remote.

This makes it easier to manage public rebases, because you only affect those devs working on the feature, but more importantly it means that you still get the security because your release repository always maintains the integrity of its history.
Although the computer-generated art was done in the UK, at Atlas Labs (now part of Rutherford Appleton).
http://www.chilton-computing.org.uk/acl/applications/animati...

(Not that I think there's any realistic chance Saville saw the art before release.)
Yes it is, you can even buy laptops with no OS pre-installed or a gnu/linux distro.

Chromebooks are the worst possible thing, I tell everyone to stay away from these crippled google branded piece of slavery.

I advise either a second hand quality laptop or a brand new one while budgeting a little extra for cleaning the crap that manufacturers preload inside to allow for such a low selling price.
Gian-Carlo Rota on Alonzo Church (2008)
I expected a woman in black. This could be made quite scary. Great demo.
Can you guys seriously redefine what startup means ? Eg. Flipkart started ~8 years ago, employs 15,000+ employees. What/How can it be called a startup ? If acquisition of funds is the only definition of startup then all companies are startups as at some point they all needed to raise funds.
The actual quote from the New Yorker article is:

>Jeff Williams, Apple’s senior vice-president of operations, drives an old Toyota Camry. Ive’s verdict, according to Williams, is “Oh, God.”

This should, as you say, be taken as just the words "Oh, God". This may not be disgust, it may be amusement, resignment, anger etc.

You're right. I shouldn't draw conclusions from misquotes.

Some respect regained, but I still think he's playing the "design superiority" card incorrectly with comparisons to Camrys... Unless you count those 2009-2011 models.
For low-end machines these bundling deals likely form a sizeable chunk of the profit margin. (I've heard eyebrow-raising numbers for e.g. the default browser spot.)
I quite like my new Lenovo M73 "Tiny" desktop [1]. It's fast and silent and really is tiny.

But as far as adware/malware is concerned, that's a non-issue for me as the first thing I did when I got the machine was to replace the Windows drive with an Ubuntu SSD.

[1] http://shopap.lenovo.com/au/en/desktops/thinkcentre/tinys/m7...
How much do __builtin_expect(), likely(), and unlikely() improve performance?
I fly a Cirrus and it is not inherently more difficult or dangerous to fly then any other aircraft. What Cirrus has done is make an aircraft which brings new pilots into flying with the concept of using an aircraft like you would a car. The debate comes when the addition of technology (e.g parachute) is added and its ability to increase safety by not allowing pilots to make mistakes or always saving them.

The accident statistics are also interesting as actually the average experience of pilots involved in accidents are very high and you are more likely to be involved in an accident when flying with an instructor. There is no doubt though that more training in an aircraft type and currency are the two biggest ways to decrease accident rates. [1]

It is also funny that Cirrus' latest aircraft is a V-tail jet aimed at owner pilots! [2]

1. https://www.cirruspilots.org/copa/safety_programs/w/safety_p...

2. http://cirrusaircraft.com/vision/
Mentioning that Jobs's father was auto mechanic is very cheesy argument.
Asking if you should trust software X is like asking the internet if it'd be healthy for you to start running a marathon.

For starters, how would we know? The software in question is closed-source and has spotty docs as best - and more importantly: your trust in a software is something that only you can establish for yourself, irregardless if whatever number of people on the internet claim the product trustworthy.

Appelbaum on FileVault(1) in 2006:
http://events.ccc.de/congress/2006/Fahrplan/attachments/1244...
I honestly don't get this article. From the first looks, it seems like some CSS framework has its own build system now. Fine. (BTW, I thought SASS was a language, not a build tool).

But the second half of the story is a complete mystery to me. I read stuff like

> Enter the absolute url containing your style within “external assets”.

So ... are you hosting my code on your site? Why would I ever want to trust some external site to host my CSS? Or am I supposed to use the picnicss build logic to create my own concatenated CSS files? If I am supposed to do it locally, what's the advantage over using grunt/gulp and simply include the (previously downloaded) picnicss files?

> 5. [optional] Set the option “fresh” if you are developing it, to keep updating the style on each call.

How? When I develop, my code runs on somesite.local, so you can't possibly fetch the code from my localhost. And even if I used it on some public-facing development site, this roundtrip would dramatically slow me down.

Changing the build logic to provide a single CSS file containing Picnicss is a fine thing to do, but I don't get all the future plans and stuff. And I haven't learned a single bit about why doing the CSS magic on demand via Express is a good thing, what challenges you had to overcome and what to take home from this.
I agree. The pro bono lawyer is the real good guy, here.
Is the theory that Apple is going to be selling $100,000 to $150,000 sports cars? $90,000 SUVs?

Out of the last 30 years, Porsche also spent about half of that trying to just stay alive as a company.

And Porsche is an amazing outcome example, that's a world-class automaker with an extraordinary car brand and buyer loyalty built up over decades.

Apple is going to go through all of this trouble to hopefully one day in 20 years earn $4 billion in annual profit? Or the theory must be they're going to demolish other car companies, perhaps killing off Porsche and BMW, and maybe they can then earn $8 billion annually if they do that? (versus their $45-$50b iPhone profit business they have today).

It really seems to make no sense.
Google Compute Engine: Preissturz Zieht Cloud-Spezialisten An
Screen rotation is borked on the Yoga, apparently.
Post says "buy the laptop with the cheapest drive; then replace that cheapest drive with an SSD".

You said "the cheapest drive is not an SSD".

The point is to minimise the money spent on the drive supplied with the machine because you're not going to use that drive, you're going to throw it away.
Google cloud suffers two-hour global outage
I have always been a fan of skinning, even since the days of Litestep and other PC OS skinning systems.

These are nice.
Ok, after a lookup, "persistence ignorance" is the ability to have implicit save of the models when things change.

Bookshelf has events, which make very easy to wire some kind of persistence ignorance (we implement it in our base Model class).
[ wu: riddles(hard) ]
I think most people don't "get over" depression, so much as learn to live with themselves and the world and their new outlook. It's how I feel about it at least, and it's not hard to recognise it in others.

The process can take many years. There's still joy in the world, but I find I have more conscious awareness of it.

I'd be really interested to see studies of people who "recovered" from depression. Maybe there are two cohorts; those who get their rose-coloured glasses back, and those who have to learn to cope with what they feel. [That sounds worse than I intend it to, but I can't think of a better way to express it].