skysight-inc/HackerNews huggingface dataset:
Thanks. It appears I need to stop overusing coalesce. I was told that sql NULL means "A value that is not yet known", which nicely explains why 1+NULL, 1 < NULL, 1 > NULL, 1 = NULL is always NULL. Now I know that AVG(test_scores) produces the average of the known values automatically.

- - -

I just did a test, and it appears the COALESCE is needed in this case. Running an aggregate where all values are null, results in NULL (the empty department). You need to do something because the total salary of an empty department is known to be zero.
The idea is that you can combine columns of different sizes. If you want a column of 1/3 of the width and another of 2/3, then you just need to add pure-u-1-3 and pure-u-2-3. Maybe you're right and the "u" is unnecessary.
Propagation power really depends on the problem. For some problems, propagation is amazingly good, and for some it does not do much at all.

One can characterize propagation algorithms for the amount of propagation they do. A domain consistent propagation algorithm will make all deductions that are possible to make in a certain state, removing all values for variables that are not a part of any solution to that constraint. Loosely, a bounds consistent propagation algorithm will do the same, but only for the bounds of the variables.

The constraint used in Sudoku (called all_different or distinct) has really good propagation algorithms (both bounds and domain consistent), and is one of the cornerstones of constraint programming.
"just about everything."

Yeah tell me about it, I've been living it for about half a decade and its in almost everything heavily processed. In the "real food" aisles, other than raw soybeans and tofu and some soy "milks" (and soy milk is getting pretty far away from "real food") its pretty easy to avoid soy. If it comes in a box and/or maybe a bag its nearly impossible to avoid soy, wheat, or casein (milk).

Which leads to "hmm, sounds like we're about to live the Paleo diet" which at least on HN leads to ridiculous responses against it, about God intelligently designing us to evolve over the last couple decades to live exclusively on "hot pockets", candy bars, and high fructose corn syrup and cooking at home should be illegal and/or only for rich people and/or only for poor people or perhaps both at the same time but definitely not for us, therefore trying to avoid junk food is a religious sin and ethically immoral and anti-american and everyone should eat as much fake food as possible, err, and well lets ignore the allergy people they can just go curl up and die somewhere. Ah, paraphrasing a bit from a slightly biased perspective.

Lets just say my family eats a heck of a lot of salads with a side of a little roasted, baked, steamed, or grilled meat. Last night was big spinach salad with some kinda vinaigrette and (admittedly non-paleo) sliced seasoned baked potatoes (I think dill and rosemary?) and some overly spicy bbq flavored homemade baked chicken. Want to cut back on meat consumption? Spice the heck out of it till you can't stomach more than a couple oz. You can eat paleo pretty cheaply and healthily if you want, or you can use it as an "excuse" to eat nothing but 32 oz of grilled beef tenderloin each night and then complain.
nice project. very useful...
TBH, when I started the project, I choose Angular because I want to learn and use it. Now that I have been using it for a while, I can justify why I want to switch to Angular from Backbone. Backbone is small and only provide a "structure" to JS App. You need a lot boilerplate code. While Angular is "full-stack" and eliminate almost all boilerplate.
Notice these GCEL images have been deprecated since GCE's public preview launch at I/O; you should now use the images debian-6 or debian-7. (Or, if you prefer that flavor, centos-6.)
Are you sure? I have about one accident per year when using my bike a lot in an urban area (20km/d). Only luck prevented me from landing on my head - if I had, I am pretty sure the helm would have been pretty helpful. Plus, a good helm is available for as little as 15USD. Considering the cost of falling on my head, that appears to be a good deal.

btw: In my last accident in a urban setting, I came down 3-4m away from my bike. And it did not involve any car, just me poorly performing an emergency break at about 20-25 km/h
I believe Django would do this as a single query.
Ask HN : How do aptitude tests decided ones coding skills?
Most of the interviews test your aptitude with quantitative analysis, how on earth is that related to the your skills in coding?
Rights come from a metaphorical God?
Having spent 2 mins with it, aside from what has already been mentioned...

No mouse chording (distinct from gestures). Wikipedia even highlights Opera as a key implementation of mouse chording, and now its gone.
http://en.wikipedia.org/wiki/Mouse_chording

No closed tabs drop down. Its not uncommon for me to want to dig out a tab I may have closed 20 tabs ago. Reopening one-by-one is terrible.

No forward slash search (á la Vim, or indeed, Firefox)

If these things aren't tabled for Opera 15's release, then thats it, I'll be back to Firefox after 9 years on Opera. These sort of small features are Opera's bread and butter, things that have become second nature to me, and I suspect many. Certainly for me, its these little things that have kept me on Opera until now.

Where can we go to provide feedback? The OP provides no obvious link.

Trying to be positive, Stash looks like it might be useful.
Liberty Reserve sealed indictment from US DOJ Southern District [pdf]
> Seriously, what would be a valid reason to sort employees based on which specific editor they are habitually using?

It's not for filtering out really good candidates, it's for filtering out abysmally bad candidates. Show me the dumbest Vi user and the dumbest Eclipse user you can find and you might learn something.
If the school system asked him to do something, anything that is in conflict with his moral obligations to students - as you claim - then it DID ask him to perform something immoral.
And plans for doing this for other languages?
You can build your own prefixes and class names for Pure Grids here: http://yui.github.io/gridbuilder/

The default prefix is there for maintainability. It's a pain to grep for "grid", "row", or "g" when you need to change something. But if you don't like it, you can build your own.
There is a public hearing tomorrow night and I plan on attending.

That's awesome. This is what democracy looks like.

I got hooked attending some townhalls on my pet topic. I've learned so much about politics, policy, etc. these last 8 years.

#1 Show up.

#2 Keep showing up.

#3 Bring your friends.

It's ridiculous how few people shape policy. The upside is adding a few more people to the debate can significantly shape outcomes.

If you become credible (learn a topic well enough to speak to all points), and you pack council chambers with your supporters, you will change policy.

Everyone focuses on campaigns. The real action is in policy. Politics is a dirty, filthy business, but it's still worthwhile.

I strongly recommend Camp Wellstone. There's an "activist" track. Anyone aware of methodology or project management will grok their techniques immediately. The focus is policy vs products.

http://www.wellstone.org/programs/camp-wellstone
Just a quick heads up: Ghostery blocks Typekit which messes up your entire layout as the backup fonts aren't the same size.

As of 1500 GMT 28/05/13 it has 686,260 users on Chrome.
Oxymoron (ox·y·mo·ron) is a combination of contradictory
or incongruous words. For example:

Early in the morning when everyone is asleep

Between our friends and family I am aware of exactly one toddler that sleeps until 8 in the morning and she is widely regarded as a miracle child for just that reason.
Additionally, and to my mind most critically, the university degree signals that you play well (enough) with others. It says you have learned that sometimes power is capricious and when it is you can keep your head down long enough to survive.
Not to put down your considerable experience but Microsoft is the largest software company on the planet - if anyone can do it then it would be them.

OnLive, despite failing, was not dissimilar to "cloud rendered graphics" and it worked. Lots of things people thought impossible 10 years ago are now commonplace.
These are nice, but you need simpler questions.

Hear me out: Take away two questions (the first four are enough anyway) and add two to start out with that are much simpler. You will be shocked how many people will fall out at that level.

Years ago, when I first started hiring, a friend told me about this and I didn't believe him, but I tried it anyway. I was astounded how many people were completely bluffing. It helps expedite the whole process.
No, you're not overestimating it but it very much depends on the problem and constraints. It's good to do the d^n search space check to give you a feel for the starting size of the problem but if your problem is heavily constrained i.e. the constraints make finding a solution hard, then propagation is very powerful.

Consider variables a[1:1000] and b[1:10] and constraint a + b = 10. A good solver will use propagation to reduce that to a[1:9] and b[1:9] because there is no support for a >= 10 or b >= 10. Even reducing one extra value from a variable's domain is reducing the search space by a factor so propagation over tight constraints is extremely powerful.

Most arithmetic constraints like those used in your program will use bounds consistency (find support for the lower and upper bound values). Special constraints such as "all different" have their own propagation algorithms that efficiently remove potential values from the domains of multiple variables. These are known as Global Constraints.
Pitching Hack: It’s Not What You Said, It’s How You Made Them Feel
I moved my family to Vancouver Island from Calgary in 2011. We ended up at Shawnigan Lake which is truly beautiful and a great community to raise young kids. I've been hosting the ios hacker group in Victoria as a way to meet like minded tech people. I'd love to connect with anyone interested...I'd be thrilled to discover someone else in the area too!
Smartname.com closes my account, keeps my money
That's still taking the decision out of the hands of the user, though.

I'm not saying that I totally agree with kijin, but I don't think your answer addresses his point.
these debates have been going for years, some arguments and counter-arguments f.ex. here http://www.smh.com.au/lifestyle/diet-and-fitness/bicycle-hel... and here http://www.bikebiz.com/news/read/cycle-helmets-offer-little-... including the overall impact on cycling culture (notice how in the most bike-oriented countries in europe people don't give a crap).

if people buy the fact that helmets will help them a bit when a car hits them at 60km/h, why don't they wear it when crossing the street by foot.
5 reasons you should accept a new job, even if it terrifies you
> The solver itself is generally dumb. It will propagate some constraints sensibly but mostly it will just search over the entire space - equal to the size of the domain to the power of the number of variables

This is false. The cornerstone of solving interesting constraint programming problems is the ability to effectively propagate constraints. Naturally, since constraint programming models NP-complete problems, a large part of all problems will take exponential time. However, when propagation does not help and the solver effectively searches through all combinations, that is a failure mode. It is precisely the cases where propagation reduces the amount of combinations explored that are interesting.
Houston Is Unstoppable: Why Texas' Juggernaut Is America's #1 Job Creator
I think that is the case. As far as I see, it extends admin/index.html template, and calls some templatetags.
I wonder what will be their position on visualization, statistics and user contributed projects reusing their data.

Their data feed is available [1], but in the terms of use [2], page 1, point 4 it says:

4. Proprietary Rights in Website Content; Limited License to Access and
Use Website.

All content that is on the Website or that is available through the
Website or any of the Affiliated Websites, including all designs,
text, graphics, pictures, video, information, applications, software,
music, sound, and other files and their selection and arrangement
(collectively, "Website Content"), is the exclusive proprietary
property of Alta and its Related Parties, with all rights reserved by
Alta and its Related Parties. [...]

[1]: https://citibikenyc.com/stations/json

[2]: https://citibikenyc.com/assets/pdf/terms-of-use.pdf
I've had this and have answered something like:

"Compared to most other devs I work with, 7 or sometimes 8. Compared to people who do SQL for a living, possibly a 4, or a 5 if I'm feeling cocky. It all depends on what the '10' really represents - the best of the best, or the best of the people I'd be working with."

Well, something like that. That last bit - I've said it more tactfully in the past.
Like it! Starts with a sample iPhone app, but does it cover iPad specific development too?
Why wouldn't a forked distribution be considered a "clone"? If bio-clones start from the same DNA, distribution "clones" start from the same source code...

A reverse-engineered game might be better termed a "dopple-gamer", since if didn't start from identical source.
Spring is just an XML-based DSL that wires objects together and applies AOP aspects to them.

Your bad experience was with a Spring-branded Eclipse; the open-source IDE that's so slow and bloated Google preferred switching to a proprietary competitor (IntelliJ) for their latest version of the Android IDE.
See my talk at the Haskell Implementors Workshop this past Fall for a longer list of what we need in the platform.

http://www.haskell.org/haskellwiki/HaskellImplementorsWorksh...
Show HN: My first "weekend project" - Adding colors to Subtle Patterns
It crashed two times when I first tried to use it so I tried another file which didn't have subtitles. When I finally loaded a movie and downloaded my own subtitles that I imported it kept loading and didn't show any subtitles after which I've uninstalled.
Only really for the time being (and a considerable time to come, Quantum and Biological computing enhancements notwithstanding) but for a salt that big it makes far much more sense to use a key derivation function as you're effectively generating two keys otherwise (one user generated, the other - salt - via PRNG).
Want to Save the Environment? Build More Cities
I don't buy this. People don't realize how complicated real accidents are, so they say things like "helmets won't help if you're hit by a semi, so they're useless". Well, the first part is true. If you're hit by a semi, you're probably dead no matter what. On the other hand, if you swerve to avoid a semi and fall and tumble a bit, then hit your head on a curb, you'd rather have a helmet.

Real world traffic accidents don't usually happen because one thing goes wrong. They happen because several things go wrong at the same time.

Helmets aren't a perfect solution, but they compensate to some degree for the fragile (and unpredictably so) nature of the head.
It feels like you are implying Kay didn't work with Lennart. it's simply not true. The systemd mailling list was created in May 2010 and Kay was already registered and posting there. Check the archives. They were working on systemd from the start in a RedHat-Suse joint effort.

Also udev merge into systemd would have not happened without Kay's consent.

And I don't understand why people get downvoted just beacuse they correct you.

[Edit] Typos
5 Rules of Thumb for Startup Financial Projections
Even the worst developers I have worked with could figure out SQL queries like this in an afternoon. If they study before the test, congratulations, we just hired a dud.
Refuse to pay salary? Good way to end up with a terrible reputation and/or a broken nose.
Speaking of class-naming, has anybody come up with a good naming-scheme for classes used to add padding (or margins) to elements?

Sometimes I've create things like this: .pad_10_5_20_10 to avoid having to declare each one separately, but I'm sure there's a more-elegant way to do it. Of course, I can always define that padding directly in a more-generic class-name like .sidebar .... but there are cases where a pad class is more-desirable.
I have coded a python app in my spare time to auto-sync two subtitles streams (any langage) and maximize the time each dual-subtitle is displayed on screen. It just tries to merge two srt as smartly as possible.
I'm interested for feedbacks and test cases, my mail in my profile.

But sometimes, doubling amount text on screen is just not processable at a glance, fleex seems to have very appealing solutions to that : picking one of the langage based on difficulty, arrow key to get back in time and slow down playrate. Cant' wait to play with it!
Thanks! I'll add an issue for that.

Btw, the site is open-source too: http://github.com/yui/pure-site/
What's wrong with identity?
Jeff Atwood has written about a similar experience in "Why Can't Programmers.. Program?": http://www.codinghorror.com/blog/2007/02/why-cant-programmer...
I've just spent the last week building a simple bookmark app (front-end and back-end) with both Foundation and Bootstrap, with the goal of getting very familiar with both of them.

In that context, Pure looks great, congratulations.

IMO the goal of these frameworks should be to enable the use of most common design patterns, while normalizing across browsers and enabling responsive design.

We used to write our own JS for these patterns (tabs, navigation etc) and then JQuery made that easier. Now these frameworks are going one step further and giving us these patterns ready-to-go. My only suggestion would be to ensure that the most common design patterns are handled by your framework.

(Based on my experience, a suggestion that would be nice to have. For reference, its the design pattern behind the menu system that Wordpress uses: a nice "menu" list as a sidebar, like on your site, that allows flyouts or accordion style behavior.)
KolibriOS – Help Them Organize Their Own Summer Of Code 2013
Introducing Suspend - Generator-based Control Flow for Node
Why You Can't Judge The Quality Of Your Own Work (And What To Do About It)
This looks very similar to linear programming. Is CP similar to LP? Is CP just another name for or type of linear programming? What are the differences(if any)?
On a Gentoo system you can install it with:

layman -a haskell
emerge haskell-platform
This is my observation: http://imgur.com/zfxvWzV
This is a terrific idea. I've done many FOIA requests. It's worthwhile in so many ways.

If the gatekeepers don't provide the information (malicious compliance, obfuscation, foot dragging, denying request), you've got grist for the mill. EVERYONE supports "open government" and will support your efforts.

It's best (PR wise) to get the incriminating information after a long drawn out fight.
The Pure CSS Website is open source too
Yet another Paypal PR disaster, they're good at spinning everything in the worst possible way. What are they trying to do, get some award for world's least popular company?
Show HN: Our new startup on inspiring design notebooks
A salt is not for adding extra secrecy. It's for making it take more work to solve a large number of passwords at once. It doesn't need to be stored separately to do this.

What you're thinking of is a secret-splitting scheme; where you split a secret among multiple parties, where you need the information from both parties to reconstruct the secret. That's a valid cryptographic technique, but that's not what's meant when you say "salted password".

The problem is, for passwords, that approach isn't really workable. Whatever machine is verifying the passwords will need access to the full hash to do so, so if it's compromised, you could get access to the full hash.

I suppose you could split the verification into two parts, on two separate machines. Each one would have it's own password database, with independent salts, and the machine trying to authenticate the user would request verification from each of the other machines before allowing you in. However, that would make your password system slower and more fragile; now if either of those machines goes offline, your login functionality breaks (and yes, you could do a "two out of three" system to avoid that, but now you're talking about tripling your hardware requirements just for your password verification system).

Really the best bang for your buck will come from (a) securing your system so that it doesn't reveal your password database in the first place and (b) using bcrypt, scrypt, or PBKDF2 to make brute forcing a database that is disclosed much more difficult. It's far more likely that you will build a secure system by following basic security practices like isolating services and giving each the minimum privilege that it needs, doing code review, keeping inessential services off of important machines, using prepared statements rather than building SQL queries from user-supplied strings, and so on, as well as using off-the-shelf security components that have been well tested like the above hash algorithms, than you will by designing your own password system using some novel technique to spread the secret out among multiple machines.
Realize that whatever path you take, if you are looking for a future/career and web development you need to be actively developing. Use your free time to build a bullet proof portfolio showcasing your talent. If you have a strong portfolio, the work will find you with or without that piece of paper.

I see red flags though in reading that you have applied to 50 companies and only received 4 responses. Your approach in contacting these companies is flawed or the representation of your skillset and capabilities is weak/inaccurate.

Also, put yourself in the shoes of the hiring manager. A 20 year old is telling you they have 4-5 years experience. It takes a fairly unique 15-16 year old to be building something of use at that age. Best case scenario (in the mind of the hiring manager) is you have may have 1-2 years of real working experience that would be of value to the role they are tying to fill. And these days, who doesn't?

Take a good hard look at where you motivation lies and pursue a path that will convince prospective employers that you have what it takes contribute at a high level. Production guys are a dime a dozen, what sets you apart?
Who originally popularized flat design?
Insanely Simple Two-Ingredient Recipes
Indeed, the best resource I've found for adversely affecting brute-force password cracking comes from the *coin cryptocurrencies.

GPUs allow us to generate much much longer chains in rainbow tables than before. This means that there's a re-evaluation of space trade-off based on chain length, so simple salting mechanisms (e.g. 4 char alphanumeric such as Cisco Type 5) become feasible. For now they're not incredibly practical for full mixalphanum 1-8 at 99.99% probability but it looks possible.
Pretty sweet. The real-ish station status data's got to be pretty interesting in aggregate.

I'm also looking forward to people competitively racing these things with the personal trip data a part of the platform.
Hey! It is great to see good use of our API. (The WordReference translation API, you see the WR translations when you click on a word.) This is the type of application that we created it for.

Congratulations!
Presentation About The Rise Of Mobile And The Massive Implications
Because systemd doesn't run on BSD, and probably never will.
Crowdfunding Won't Be for the Tech Industry
"I want people with a good heart and a giving personality" - it's a little weird to hear this from a proprietary trader and hedge fund manager :)
How Divshot Hacked An April Fools Joke Into Serious Customers