skysight-inc/HackerNews huggingface dataset:
A concrete example is some folks like the abstraction of a row as your primary "thing" and some folks like the abstraction that the data defines a row and rows don't really exist just the data.

Consider the hated multiple primary key situation where you've got a autoincrementing prikey and a "real" key where you make an unique index off "full name" or something. So which is the real conceptual primary key? Shouldn't you use the full name as the "primary key"?

Problem: What if the business logic of what a distinct user is changes from unique "full name" to unique "full name" and "telephone number". Whoops now all your foreign keys need messing with, its just a bad scene. Ditto schema changes like you finally change from ascii to utf8 or something, now all your foreign keys need changing (well thats maybe a bad example unless your ascii datatype enforces 7 bits or you're running into byte length vs character length limits...) Or you change the length, which changes the truncation perhaps, which changes your foreign keys. Also you can't just use a rule like all foreign keys are BIGINT now some are CHAR(20) some are FLOAT who knows.

On the other hand lets say you implement just a prikey. Now you can have multiple rows with the same data, because you never set up a UNIQUE INDEX.

Generally speaking if you KNOW absolutely KNOW that your schema will never change, you should probably optimize it to not have multiple keys aka a primary key and unique indexes, or data definition will never change. Very few people can guarantee it so they're better off in the real world with imaginary prikeys.

You can read a lot more about this in "SQL antipatterns" I think chapter 4 or so, but always keep in mind that beyond noob level of being able to define the overall issue, short term snapshots will occasionally (but not always) conflict with longer term thinking.
I've recently discovered livescript (livescript.net), a puckishly named coffee-script-inspired transpiler for node. Its syntax captures some of the best of Haskell, without going down the 'HaskellScript' route followed by e.g. Fay (which I find tends to trade off usability and fitness for purpose against fidelity to the original.) Livescript's answer to underscore is called 'prelude-ls' and is pretty powerful. Highly recommended for Haskell fans stuck in a sandbox.
It would be funny if you had this on a clip-board and just posted it on every question, you could even add a link to google.
> The main reason I use Opera: Editing preferences for every site separately.

Does firefox's about:permissions do what you want?
I, for one, am glad that IEEE is making an effort to get people excited about a formal education in data science. My education was a disjoint combination of CS and Statistics (my degree is formally in statistics), with no union between the two except what I made of it. In neither CS nor Statistics did my education formally cover problems associated with having too much data to fit in memory or store on one hard disk.

My biggest issue with the teams of statisticians I've worked with before is that they lack a basic understanding of computer science. My biggest complaint dealing with the software developers on analytics projects is they don't understand statistics. I heard a great quote for which I don't remember the source (I paraphrase here): "A data scientist is someone who knows more computer science than a statistician, and more statistics than a computer scientist." The nature of the analytics world right now suggests that this type of specialty is sorely needed in many places.
Appurify brings true continuous integration to mobile
I'm happy to see RC4. Ember has really come a long way since I started using it. Ember itself has really stabilized. I'm really looking forward to 1.0.

There is one more thing I'd really like to see before hitting 1. https://github.com/tildeio/router.js/pull/19 is probably the most important thing happening right now. 1.0 will not be there until these problems are addressed. I hope to see the PR make it to 1.0.
Sounds like you'll remember it.
Social by Design Startups.
Did you see the Google I/O keynote? They're looking at selling Android smartphones to the whole world, and they're not just talking about the Western world for once. I'd say that'd be pretty world-changing.
That's the way Mac OS X is written. They certainly haven't bundled the entire universe into a single master "system daemon" project.

A few, off the top of my head:

configd: A configuration store that handles storing (and monitoring changes to) configuration. It supports arbitrary plugins, such that other dependent systems can inject their own implementation code if necessary. It depends on kernel notification APIs and network notification APIs that are implemented at a different level.

launchd: Starting/stopping/restarting services, on-demand and on a schedule, per-user and system-wide.

diskarbitrationd: Handles mounting/unmounting of file systems, and notifies clients of changes to mounted file systems.

opendirectoryd: Handles namespacing of local and remote user/data directories. This includes LDAP, local user accounts, etc.

mDNSResponder: Used to be just the mdns daemon, now handles all name resolution and local caching.

All of these things have been iterated on independently over time, are loosely coupled with each other, and do not create tight bindings between Mac OS X and open source software, nor do they require huge non-portable changes to open-source software.

The precursor to opendirectoryd was netinfo, which also used to handle name resolution and caching. Later releases of Mac OS X moved name resolution into directory services, and then eventually into mDNSResponder. launchd replaced system starter (similar to initd/rc), cron, and a number of other services, but maintained 'perfect' backwards compatibility with the standard configuration file formats (eg, crontab(5)).

These are just a few of the (independently maintained, internally) projects/daemons that Mac OS X layers together to produce the desktop. You don't need a huge monolthic project to tackle all these problem domains, as evidenced by the fact that Mac OS X works.

You also benefit from laying these projects cleanly, as it allows them to tackle what they're good at, provide a stable interface, or even be swapped out entirely later.
Should you happen to use Mac OS, have you seen Tinderbox (Eastgate systems)? Windows (and Wine) users may want to look at Inspiration.

Both allow 'unconstrained' mind mapping/concept mapping where the spatial arrangement of objects is not enforced.
Login to play => ??? => uninstall.
There are about 2000 work hours in a week. Useful when converting hourly rate to annual salary, e.g. $50/hour = $100K/year.
Show HN: DevPressed, a forum for mental illness in the tech community.
Ask HN: How do twice-exceptional kids do in Gifted and Talented programs?
Our son, 9, probably has an IQ in the 150-160 range but he just failed the local district's gifted and talented testing. Why? He has ADHD and got sidetracked. In the testing, he answered 50 out of 51 correct. The problem is that there were 68 questions. He got bored/tired/sidetracked/typical and just didn't answer the others. So the district failed him.

In talking with the person in charge of the G&T program, she basically said that twice-exceptional [1] kids typically struggle in this environment. She said that, if he didn't do well on the test, it's sort of harbinger of how he would do in the G&T program. Which sucks.

So I'm trying to decide if I should fight for this or not. I don't want to basically put him in AP/honors classes if he's going to struggle because of the district's design of their G&T program. Anyone else gone through this?

We already had a 504 [2] letter on file for his ADHD but they did nothing to identify this prior to the test. As such, he took the test like everyone else.

1 - http://en.wikipedia.org/wiki/Twice_exceptional

2 - Code for "has special needs" and it's due to his ADHD
Show HN: Instant feedback for SMF forum posts
I'm hoping this changes the pace of the project. Public releases should keep us focused.
Washington Post Hunt 2013
I keep getting headhunted for positions in the bay area. I keep saying no. Founders and recruiters can't seem to understand why -- as if it has never occurred to them that someone would turn down an offered interview based solely on location. Michael Church's answer is exactly why I won't ever, ever move to the SF Bay area.
Could be. I couldn't find a report of a kid reporting their own transgression to the school, to see if admitting active drug or alcohol use is tantamount to possession on school property. The administrator may still be required to report the crime to the police, however.
Remind HN: Startup Conference is Thursday in Redwood City
Please expand, how would you see fit a framework that isn't like the rest? I'd love to know. Personally I don't see a lot of room for innovation in design. The early 2000s had its table-based designs, and micro designs with small bitmap fonts.. that only appealed to a niche audience. Websites then were much less accessible and had horrible UX. In today's modern design, you're either flat (Foundation, etc.) or you're Bootstrap. If Yahoo didn't mimic the aesthetics of the most popular frameworks, people would complain about it being too different, and it would not gain wide-spread adoption.
Agreed. People like Jesse Thomas usually have had ample advice on how not to be jerk and why, but they ignored it.

Unfortunately I think there are a lot of people out there that think that being a raging jerk is an acceptable and even desirable part of being a leader. Especially those who blindly idolize Steve Jobs. The problem is that many people don't understand that:

A. They are not as talented as Steve Jobs
B. Steve Jobs succeeded in spite of his assholery
C. Steve Jobs got fired from his own company, partly because of his behavior
D. Steve Jobs learned to mellow out a bit in his later years

I live in DC, and I remember when I saw the first JESS3 sticker of his face and thought, "There goes an out of control ego." Didn't know that it would turn out this bad.
There's still at least one order of magnitude of performance to be had with ASICs, and honestly that's conservative.

The danger is specialising such expensive silicon just on BTC, which is much more likely to cause a wall to be hit, rather than the raw performance that could be had if really serious resources were thrown into a very high end design on today's leading edge manufacturing processes.
During the Iraq war and what we're still doing in Afgahnistan the US has spent over $400/gallon to transport fuel to bases. The Pentagon already acknowledges this is not sustainable. In Iraq they adopted soar and wind power for bases to reduce fuel consumption and learned to become so efficient that at times some bases were supplying free electricity to locals. The DOD has also invested in private biofuel companies with the intent of eventually being able to grow fuel for combustion on their bases.

The wiser long term strategy the defense establishment is taking isn't just stockpiling weapons for a resource war, but learning how to innovate so they won't even need to fight over those resources.
Inky is an excellent mail client. http://inky.com/

There was a thread on HN a few months back that talks about its unique security/password sharing model. It's clear that the developers put a whole lot of love into it.
Transform any Unity project into a relativistic playground with OpenRelativity
Wow. Looks nice.
Vivek Wadhwa's article is here: http://techcrunch.com/2010/08/28/silicon-valley%E2%80%99s-da...
Poll: How does HN support next generation of STEM graduates?
I'm curious about how HN readers give back to the next generation of scientists, technologists, engineers and mathematicians (STEM).

The following poll is centered around my thinking of Silicon Valley, where many folks, born and raised outside of California, started their careers with judicious college degrees or well-timed STEM programs, and are now "living the dream" with significant incomes. California is also home to a significant undocumented population, and there are many minority groups living in the Bay Area, so to me this is an interesting place to consider.

I would like to enable more "pay it forward" support between STEM generations: I am inspired by https://watsi.org/ and http://letsfund.it/ . Please share your feedback and ideas with me. If you'd like to work on this further, my email is in my profile.
I never donate. (No one is judging you. This poll is anonymous. You don't have to explain your situation. Note: Taking care of your own family does not count as a donation.)
I have never donated before, but I'd like to now (please explain past difficulties or current reasoning in comments)
I would never donate for someone to go to college, even in STEM fields, but I regularly donate to school, after school or summer STEM programs.
I regularly donate specifically for undocumented students to go to college in STEM majors.
I regularly donate specifically for immigrants and foreigners to go to college in STEM majors in my country.
I regularly donate specifically for STEM minorities to go to college in STEM majors.
I regularly donate to the next generation of scientists, engineers or mathematicians, regardless of background.
What obligations as a school system employee did he not fulfill?
This is nothing but a great example on why you should not read blogs. The map presented is not even close to the real story.

http://www.pitzer.edu/academics/faculty/zuckerman/Ath-Chap-u...

http://www.norc.org/PDFs/Beliefs_about_God_Report.pdf
It probably won't go on forever, but at this point there's three years of the trend and only a small fraction of the globe has even heard of bitcoin. Would be surprised if network hashrate didn't grow like it has been for the foreseeable future.
“that if you are using an ORM, you probably don't want a relational database. You should learn something like Riak and let it handle the distribution and provide all the partitioning and availability for you”

These are not the same concept: a relational database makes sense when your application relies on relations between records. If you need to do lots of joins across many records, Riak is going to perform horribly because it's designed for a different problem.

CAP says nothing whatsoever about whether you want a relational or non-relational database, merely what tradeoffs you'll have to make to satisfy your business needs.

Using an ORM doesn't factor into this discussion at all other than for providing a convenient place to implement whatever system you devise to meet those needs.
When I was interviewing, I was told to think carefully about my answers to the "rate yourself 1-10 on your Python/Java knowledge" pre-screen questions.

If you answered 10, you just might find Guido or Josh Bloch on your interview panel.
It is a good way to expose real world experience.

Client requirements are usually vague enough (heck, internal requirements are sometimes vague enough) for there to be problems like this discovered later. or a given business it might be valid for there to be departments that are empty at a particular time.

Someone with extensive real world experience will know to never assume any detail not included in the specification no matter how much of a non-brainer that assumption might seem at the time. They will either ask if empty sets need to be considered, or they will preface/suffix their answer with "assuming there are no empty departments or you don't want to report on them if there are" or "assuming there might be empty departments and you want them included in the report" - either way they are showing an ability to parse requirements and identify possible ambiguity that should to be queried.

You've got a multi-level differentiator there:

* The bad candidates will not be able to give a working answer

* The fine candidates will give a working answer though might miss the exact requirement (as it isn't properly stated and they just assume)

* The best candidates will spot the deficiency in the spec
Wouldn't the random tokens also be vulnerable to a replay? If I copy a session cookie from one client to another, regardless of how that cookie authenticates itself, won't most servers accept it? Seems to me that once the client has been compromised, session hijacking is going to happen.

The server can be set to check that the client IP address and HTTP fingerprint match. That makes the replay attack harder but not impossible. It also introduces some usability concerns--valid sessions may expire sooner than intended.
‘Liking’ your content costs me nothing, so what’s to stop me from ‘Liking’ everything I see without considering how it affects the popularity of that content?

Is there evidence that a significant # of users are doing this?
If scamming is not a significant proportion of Ghanaian internet activity then why is it even being mentioned in a discussion about increasing internet access across sub-Saharan Africa?

"White guilt"? Would you care to expand? Guilt which causes me to ignore the problem of pesky Africans using the internet to scam honest folk in rich countries?
Try the OOCSS classes:

/spacing.css/
/* spacing helpers
p,m = padding,margin
a,t,r,b,l,h,v = all,top,right,bottom,left,horizontal,vertical
s,m,l,n = small(5px),medium(10px),large(20px),none(0px)
*/

https://gist.github.com/cloudchen/5626174
Cartoon Social MediaWork
http://en.wikipedia.org/wiki/Color_scheme#On_the_color_wheel

Part of color theory.
>>"[Moveabletype] was also easy to install."

You remember a vastly different Moveabletype than I do. It was horrible to install and only became better years after Wordpress was picking up huge market share.

I do agree about your comment on licensing. The MT licensing fiasco was the nail in the coffin.

That, and the fact that where Perl once dominated the web - PHP was picking up huge traction and won over the script kiddies due to it's kitchen-sink approach to including everything you need for web development into the language.
What is wrong with American Cable News-the people respond
I have yet to experiment with this feature - seen it used on a few different websites. I am curious on how to handle prerender requests vs an actual visit. Is there a way to distinguish between the two?
I was under the impression that Mozilla has already moved to support h.264 by using the host OS support for h.264:

http://www.webmonkey.com/2013/01/mozilla-brings-native-h-264...
The bikes ride slowly, which again seems right for a commuting bike in a crowded urban setting.

You're spot-on with this description, but there's a nuance that many commenters here are overlooking: these bikes are designed for novice bike riders. These bikes are tanks. They force you to ride slowly, sit upright, and they are easy to jump off of. They're designed to get novice riders across town safely.

The same bike-sharing program is currently in it's second year here in Boston. Our version is called "Hubway" (www.thehubway.com). Same equipment. It's great a great way for tourists to see our city and gives many of us a much-needed alternative to our subway system (the "T").
I would like to see "cost to mine[1]" vs values in dollars over time. Go lazy web, go!

[1] In a unit expressible in dollars. Like the cost to run a Linode machine to do it for the time needed to mine it, or something.
I'd the feeling from the website that it's a better implementation of something I've already seen.
E-Book Singles: Digital Salvation for Writers and Publishers
Flashback. I worked on a failed mindmap startup with a web-based tool just like this (it was 1999 so of course it was Flash!).

As the other commenter said, there's a split in people who learn well with mindmaps and others like me who prefer lists.

The startup I worked on: Mindwarp Pavillion in Dundee got licensing rights to stacks of textbooks. They created loads of mindmaps based on study books and sold access to students for a few bucks a month.

Even (better?) the mindmaps were a quiz where the student had to answer the next node. There were studies showing that using this method they retained a lot more information.

I was told that the whole mindmap concept was protected somehow (patent?) which they paid a license fee to use. They also got the endorsement of its creator.

£30m valuation when the local authority invested. They lasted a year then died, leaving my last invoice unpaid.

They failed because:
- Students didn't pay
- They could do it on pen and paper for free, while they're learning
- The product wasn't driven by a real customer need: 12 months of dev on super-whizzy software without getting a MVP in students hands
It does not apply to the first question, but how does the ORM handle joined columns from other tables? Is it embedded somewhere in the returned object? The best way I could think to handle this using an ORM would be for the object to contain a set of arbitrary key/value pairs to contain joined columns but it seems like a hack.
I second the "not keeping up with the Stanford Course".
> I'm not American, but I'm pretty sure the fifth amendment applies to any and all self incriminating statements that can be used to support a criminal charge against you.

The core of the rule is narrower than that: http://www.law.cornell.edu/wex/fifth_amendment ("The Fifth Amendment protects criminal defendants from having to testify if they may incriminate themselves through the testimony.")

It has been broadened beyond that, ("In the landmark Miranda v. Arizona ruling, the United States Supreme Court extended the Fifth Amendment protections to encompass any situation outside of the courtroom that involves the curtailment of personal freedom"), but note that Miranda itself is inapplicable because the "custody" element is missing.

I can't find any case law on the subject, but there is an old law review article that discusses some of the issues: http://scholarship.law.wm.edu/cgi/viewcontent.cgi?article=20....

Even within the framework of the article, which argues in favor of students having 5th amendment rights in general, it's hard to see how a survey aimed at gathering information for psychological evaluation would implicate the 5th amendment. The most likely answer seems to be that it's permissible so long as the student retains the right to invoke the 5th in any criminal action against him.
Hi Greg, Dan Pink has used idonethis every day for over 2 years. He loves the product so much that he decided to invest. http://lifehacker.com/im-daniel-pink-and-this-is-how-i-work-...

Many of these prominent people found us via word of mouth and our popular blog.
Can anyone who has tried Ember and Angular on moderately sized apps (500-1k+ LOC) compare their experiences?

I'm using Angular, I love how little code I have to write to make testable apps with their two-way binding, and dependency injection. I went from 0 to Todo App in about an hour after I started to learn Angular. Should I give Ember a try?
Poll: What Cloud Storage Do You Prefer?
As many as possible (more storage the better)
Yes, it really is not. OAuth on mobile is frustrating experience of matching up responses and posts and figuring out which of the 5-10 variables and secrets or keys or tokens to give.
Miranda is not implicated because the students are not in "custody" as required for Miranda to apply.