skysight-inc/HackerNews huggingface dataset:
Has been done:

http://www.facebook.com/apps/application.php?id=114232425072
Right, but replace a 13 year old with a 20 year old in a wheel chair and you can see where this gets interesting. If it is a requirement for his degree, I am not sure physical fitness can be used as a determent.

I have to say though, I just finished up a fields method class and they are not easy. And mine was just in the woods of Connecticut not in Africa.
I’m starting a Single Founder mastermind group
Are Business Plans a Waste of Time?
Additionally:
"None of the hackers targeted Google's Chrome web browser.

However, one should be careful with drawing conclusions about the security of the individual products. Pwn2Own is mainly a hacking extravaganza. Nobody knows who spent how much time on finding security holes and developing the appropriate exploits. Charlie Miller, for instance, told the The H's associates at heise Security that he focused on Safari from the start. He added that it's open to speculation whether it would have taken him the same amount of time to find an exploit in Chrome. In Miller's opinion, Pwn2Own isn't a suitable basis for conclusions about which product is the most secure."

Taken from
http://www.h-online.com/security/news/item/Pwn2Own-2010-iPho...
I can't imagine any halfway decent database engine failing to utilize at least one index. Maybe the author is thinking of cases where you have multi-column indexes that are ordered incorrectly and as a result can't be used? I'm more inclined to suspect that they just don't know what they're talking about, though. It's pretty trivial to verify that any decent database engine will use one of your indices to optimize that query if possible.

The hack for detecting table scans seems like it would be super useful if using MSSQL but I'm inclined to be wary of such a solution to what appears to be a basic education problem.

It takes about 2 minutes to test this out in SQLite:

CREATE TABLE response (
text TEXT,
questionId INTEGER,
participantId INTEGER
);

CREATE INDEX i1 ON response (questionId);
CREATE INDEX i2 ON response (participantId);

EXPLAIN SELECT text FROM response WHERE questionId = 27 AND participantId = 38

The resulting bytecode clearly makes use of an index instead of performing a table scan. If you drop both indexes and explain the query again, the bytecode changes to indicate that it is performing a table scan.
HTML5 Forms Are Coming
Yes, I completly understand that (which is as well true for many other words like "ass" and "behind" f.e.)...

Just wanted to point out this little maybe unknown "fact".

cheers
The Fundamentals of Writing English Term Paper
The most difficult task for students is writing an essay of any kind. One of them is English term paper. English paper writing is intended to describe different concepts or events. Term paper requires several typed pages in length. It is due at some certain term – either a quarter or semester
Someone being an "elite" has nothing to do with it. I don't care who it is; you should talk as if you're talking to someone's face. This is a guideline that's been here for a while ("Be civil. Don't say things you wouldn't say in a face to face conversation.") because it works well in keeping the discussion focused on the issues, rather than degrading into pissing matches.
> the fructose thing is more nuanced than the fruitcakes on either side would have you believe

Can you enlighten us on these nuances? By "fruitcakes" I assume you're referring to Aragon and Lustig?
What SQLServer provides is interesting: I need to read more about it.

From the Oracle side, you'd normally run the query through "explain plan". This utility generates the optimizer's plan for query execution. Reading the plan takes some practice but you clearly see where full table scans, indexes, etc. are used. All the Oracle databases I've developed against for the past 10 years use cost-based optimization: the plan utility shows you the cost at each step, the overall cost, the cardinality, and the space used.

If you want to get more into the system figures, you can set trace on and run the query. After execution, you'll have a file on the db server that shows disk I/O stats and many other system level measurements.

My own workflow is that I write the query first - typically nowadays in Toad - and run explain plan against it. I make sure the data returned is what is required and then move onto plan tuning. When I'm satisfied with the plan and overall cost, I copy/paste the query into my code.

It sounds like the overall workflow is different when developing against SQLServer.
I hope that's true, less of them is good :)
To be fair, that study has a few procedural gaps that make me want to wait for confirmation and expanded testing.

Even though I'm predisposed to agree with it's conclusions --or perhaps because I'm so predisposed to agree with it's conclusions-- I'd prefer to wait for better science before calling the race.
Well, in my experience full table scans are quite rare. What happens often though is an index scan, but those happen so often that you would get a ton of false positives.

Plus, at least in my company, the unit tests run on a different database which means different statistics, different number of rows and different decisions in the query optimizer.
http://sivers.org/book/Influence
Are You Squandering Your Intelligent Failures?
Clearly we need a WikileaksWikileaks
L4 Microkernel to support quad core Cortex A9 cpus
Yes, I would recommend avoiding clicking through to it if you're worried about potentially NSFW content.
Looks really painful to do. I had better memories of my relation with SQL Server than this.

Also, if your table is sufficiently small, a clever database would prefer a table scan instead of using the index, rendering the check useless.

The only sane way it to check with a representative amount of data.
Plenty.

250 grand in the bank leaves you a long way from being a millionaire, yet still makes 25k a realistic (albeit relatively large) percentage to invest in one asset.
>With only an index on one of the columns, Oracle at least will still use that index.

Not necessarily. Oracle, and every other decent database, will look at stats to guess how many hits will return, comparing that with the total row count of the target table, and will often choose not to use indexes.

Say you only have an index on QuestionId, and you have 10 questions with 100 answers each. If you did a select for QuestionId = 5 and ParticipantId = 100, and included in the results or the where clause a column not in the index (the index isn't covering, and participantid and text aren't in the index), the query engine will estimate that the index will return 100 rows give or take (often stats yield wrong results), and to perform and then dereference from 100 index lookups loses way more than it gains, so it will simply do a table scan.
Moral != (Legal != Moral)
This isn't entirely correct. Regulation D also includes requirements that the investor be knowledgeable and experienced enough to evaluate the potential risks and rewards of the investment, and be able to tolerate those risks. However, the net worth/income test is a pre-requisite.

Now, in practice, an investor's knowledge and risk tolerance are usually established by signing a piece of paper attesting to such, or at most by having the investor check "YES" in a check-box.
WHY did this get so many upvotes?!
Hmm... sounds like an opportunity.

Juan Gonzalez says this is happening all around the country with cities and states converting to digital systems.

The consultants are being paid $400,000 a year. Nice. Because it is a capital expenditure no one knew what these people were being paid so you have to dig into the city records.

For what?

Basically a digital payroll and time-keeping system with features such as "biometric hand scanners to avoid city workers punching in for other workers" and digital timecards.

Anyone up for going after cities and governments who are doing this or looking to do this? It's taken 7 years in New York at a cost of almost $1 billion, I say we can do it for... oh, I don't know, 1% of that and in 1/7th the time?
>Yup, and with single-column indexes on both of the columns it will try to pick one with better selectivity

If the selectivity yields an estimated result more than -- in most cases -- about 2% of the data, the database system will not use the index.
I'm assuming SE are going to have an in-house appliance or virtual machine version for companies.

No company is going to have it's knowledge base on someone else's servers - especially not any industry 'knowledge rich' (urghhh) enough to need an SE site
By that reasoning, we should all fall toward the sun.
Big on Twitter, Not Suitable for The Major Tech News
Open source needs business revenue to survive
>The resulting bytecode clearly makes use of an index instead of performing a table scan. If you drop both indexes and explain the query again, the bytecode changes to indicate that it is performing a table scan.

You have no data. It knows that. It's showing you a query plan based upon no stats.

http://www.sql-server-performance.com/articles/per/index_not...

Fairly true across different RDBMS products.
SoftLayer Gets Additional Growth Capital
If you know nothing about a topic, then yes, best to listen to someone that does. But both individuals here are at least knowledgeable enough to debate this without us automatically choosing a side. This isn't the case of a sales director arguing with a senior programmer. It's a junior programmer taking on a senior programmer.

> Likewise, if a doctor thought he knew more about software than me, he'd likely be mistaken.

Usually, but I would hope if a Con Kolivas offered an opinion on your code, you wouldn't brush him aside merely because he was a doctor :) Reminds me of this thread: http://news.ycombinator.com/item?id=930117
More Fun with the Python Class Dispatcher
http://wiki.xiph.org/Games_that_use_Theora

That's not a complete list since it is missing e.g. Starcraft 2
How Happy Are We?
Where to get clients that need data encoding services?
I've looked at freelance sites like Odesk but I think it's too saturated there and the competition is too fierce, hourly rates are too low. I thought of looking elsewhere. Is there an alternative place where I can look for businesses in need of data encoding? I am assembling a team of encoders for this purpose. We are based in the Philippines.
Ask HN: How much does it cost to live in London?
I am considering moving out of Italy because here I'm paying a lot of taxes and I can't even afford a rent alone. One choice I'm considering is moving in London with a friend.

I am a freelancer programmer and I have a budget of 2600 dollars/month before taxes. This is for working 3 days per week but I could always find a part time job. I don't have special requirements, but what I'm really interested in is how much would it cost to open a company there, and how much taxes I would have to pay there. Also health insurance and common expenses are something I need to consider.

Thanks
And most of them are crap (I say this as an Android fanboy).
The Escher circuits make me think of the 'Mentats' (humans trained to process vast quantities of information like computers) in Frank Herbert's Dune series.
His advice is very good, and I know that he is saying that artists should use these opportunities. He just seems so frustrated with with process even thought he was making progress. In my comment I wanted to restate that the artists should be looking to themselves to organize and better their situation, and not to outside forces.
TLDR; Anytime one of your friends uses an app with default settings, it has access _your_ information. To disable, Facebook -> Account -> Privacy Settings -> Applications and Website, uncheck everything. Even then apps can still access basic info like your name and location.
If it's easy, chances are many people will participate and the fork will take on a life of its own. If not, you will have to merge back the patch from time to time.

It's not a terrible thing, if the parts the patch changes don't get changed often. If they do, it could quickly turn into a nightmare
Table scans aren't the enemy; sometimes, they're actually cheaper than index scans. Random IO is expensive, especially with spinning platters. It's likely that, if you're pulling enough rows off disk, you'll end up in a situation where you're hopping back and forth across the table, seeking left and right, and "head-thrashing". Sometimes it really is cheaper to simply read the entire table and deal with finding the rows you're interested in once it's buffered -- particularly if your disk controller is smart about readahead.

Sure, for simple cases where you're pulling a row or two from the heap, an index scan will be vastly cheaper, but just because they're sometimes better, doesn't make them always better.
Moral != 1?
I've worked with non profits (habitat for humanity, etc) who were too busy to take on more help. Each untrained helper needs resources to be trained. If you're lucky they need of unskilled labor (or untrained labor - skilled is the wrong word) but if they don't then you probably wont get a call back.

I've started some of the work unsolicited. Advertising and fundraising to be precise. I kept them in the loop and eventually they want to be involved.

Organizations often need to put more work into allow people to help them but they often need to put more work into everything.
This still does not contradict the earlier statement. Apple had $1.2 billion in cash in reserve.

Presuming they were going to continue losing $800M a year, an investment of $150M does not "save" the company by any means. It only buys a tiny bit of time.

Keep in mind that competitors such as Compaq were losing far more money in the same period. Apple was having a bad year, but other companies were going under. The press at the time kept reporting how Apple was on the verge of bankruptcy, which was never true, while completely ignoring how the entire industry was in a state of severe turmoil.

The real purpose of the Microsoft investment was to solidify their commitment to producing Microsoft Office for Mac, something which was far from certain at the time even though it was reported Microsoft was pulling in $400M in annual revenue from that business unit.
While I plan on calling my Congresspeople in opposition to this measure, I think it's important to understand WHY it's a part of the banking reform bill. Start-ups aren't the only companies that operate under this exemption. So do hedge funds and folks like Bernie Madoff. A company that only sells shares to accredited investors doesn't have to provide information on its operations to its shareholders or the public, and so has much more opportunity to hide shady business practices. If the limit comes down far enough in real dollars, you open up the opportunity for a "shadow stock market" that essentially skirts the regulations that we voted into place.

That said, my inner libertarian ranks the potential damage to legitimate start-ups much more highly than saving millionaires from ill-advised investments.
I have not heard of either and am excited to check them out...
It is the government's place to tell you how to invest your money when they are backstopping all of society's risk.
I'd really like to see some sort of setup where rat is pitted against man and other species.
Are you sure your 486/66 can play streamed H.264 videos?

Besides, Flash isn't only about video. Although currently is the only working cross-browser method to show video.
That's easy for Thoreau to say when he lives alone in the woods. And that peaceful place in the woods was only his to live in because earlier English-speaking settlers in North America had gained that land from the aboriginal inhabitants.
Try adding a lot of data to the table; with different kinds of correlation between questionId and participantId. (i.e., many questionIds per participantId, many participantIds per questionId, and both.)

A databases query optimizer attempts to guess whether going through the index would actually require less work than going through each row. Remember, unless you're the special "rows are in this order" index, there's an extra set of disk seeks involved in following an index. If you thought that going through the index would result in you visiting all the rows anyway, then you should just avoid the index and go through all the rows. More specifically, if going through the index does not eliminate the need to visit enough of the rows, then it should have just gone through all of the rows to begin with.
Yes, but the original post makes no mention of things like statistics. It states a general principle that is, in very many cases, not true.

Of course if the database engine has statistics on the table it can choose not to use the index, the point is that I don't know of any database engine that isn't able to use the index.
Science In the News as related to the Vedic Conception
It's very hard to argue with this:

"Now I'm not suggesting that, just because your company needs a business plan, you necessarily need to hire a high-priced MBA or consultant to write it. What I am advising is that you take the time to map out your strategy in words and numbers so that you can figure out for yourself where you want your business to go and how you're going to get there. You'll be glad you did."
I don't know if it's meaningful to call the query a table scan when the database engine intelligently guesses that it's faster to scan the table than run through the index. Usually when you're talking about table scans in the context of optimization, it's queries that must be a table scan, no?

I'm sure there are lots of cases where the database engine's heuristics can be wrong, or an index-based scan is less efficient than a full table scan, but the source article isn't explicitly talking about any of those cases.
How RFID technology could alter the plots of our favourite movies
cd ~/code
ctags -R .
echo "set tags=~/code/tags" >> ~/.vimrc
vim -t SomeClass
The actual payoff matrix the experimenters used is here: http://www.plosone.org/article/slideshow.action?uri=info:doi...

It does follow the rules of prisoner's dilemma, as far as I can tell.

(Found via the link to the original paper, http://www.plosone.org/article/info:doi/10.1371/journal.pone...)
The Flake Equation: Analyzing the Alien and UFO Sightings
Business plans are only as much a waste of time as any other sort of plan is. Yes, things change; that doesn't mean you shouldn't think out your strategy. I think a more important thing to say would be that inflexible business planning is a waste of time. But that's not good link bait. In fact, it's so well known it's pretty much just a platitude. (Maybe I'm onto something here; reword platitudes into controversies and blog...)
My workflow is very different when using SQL Server. Usually it involves writing a query the only way I know how, sending it to a DBA to review it, getting laughed at and then having the DBA rewrite the whole thing.
Out of curiosity, where did you get that number? It's a very interesting, informative factoid. Is it in the Oracle documentation, or is it based on observation/testing?
Over 100 different versions of Avatar were shipped to theaters
Both of my in-laws work for the USDA and they have been complaining for quite a while about a new system that was also way behind schedule and really didn't solve the needs of the department anyway. It's a typical case of "gather some requirements, go off into a black whole and build it for a few years, than come back and act surprised when it isn't relavent anymore and half the features don't even work." There are a lot of companies out there making a lot of money for doing a really bad job, waste is everywhere, and unfortunately I'm not getting any of it :-)
The median citizen would be unemployed. The recent credit crisis caused a surge in the unemployment rate; a US default, even if partial, would be way worse.

If you read about basic finance you'll understand why. Google for "risk-free rate" and "repo", for instance.

The role of the US dollar now is much bigger now than in FDR's time.
The talent and ingenuity of South African developers has been limited for years due to the 'tariffs' on international bandwidth. The removal of bandwidth caps is a step in the right direction.

I agree, the last-mile has not been the biggest problem given that there are 6 mbit ADSL lines available at rates on par with major US metro areas.

I would love to see a large WiMAX/LTE tower installed on top of Sandton City (and throughout Gauteng) to bring 20+ mbit wireless internet to the CBD.

Happy to see PayPal entering the South African market even if SARS wants to see all the transactions.
If you choose to bear the additional risk hat should be your choice.
Yes, I did read the article, and what I meant was that I don't install any of those apps both to protect myself and all of my friends. I agree with you that it is pretty scary how much info is being shared automatically.
Something using 50% flat on both cores usually tells you that the cpu scheduler is just broken. You get that kind of result by having a single-threaded cpu-limited task that the scheduler tosses from one core to another very frequently. Many naive scheduling algorithms do this.
Dedicated servers
Gogax offers affordable dedicated servers. Great prices and service, starting as low as $59/month.
The university should have told him when he enrolled for the course that some classes might not be possible because of his age.

This may not be reported in the submitted article, but if I remember correctly, some press report or another states that the family asked about this issue before enrolling the boy in UConn. He is pursuing a college major that involves fieldwork, and my recollection is that he took initiative to make sure that he would be allowed to do fieldwork before deciding where to enroll for his college major program.

From involvement in the nonprofit organizations that I lead, I have also become aware of federal statutory law on the subject, which generally bars age discrimination (against the old OR THE YOUNG) in educational programs funded by federal appropriations, which would definitely include UConn. It would be the university's burden of proof to show that there is some specific reason that the specific student is unable to participate in the fieldwork (not likely, in this case) rather than the university's prerogative to declare that students below some age are ipso facto ineligible for the program.
"The authors of the PLoS study noted that when experimenters observed low cooperation rates, the animals had been food deprived. Fully satiated rats, on the other hand, freely cooperated and easily solved the Prisoner’s Dilemma. These results show that the primordial drive for food in a hungry animal simply clouds judgement."

Rather than say "hunger clouds judgement", it's more likely that hunger leads to short-term optimization, and the prisoner's dilemma is all about long-term optimization where you will usually get another chance to cooperate or not.

If you're hungry, and you cooperate and get chumped... well you may not eat again. ;)
I totally agree and look forward to seeing you all. If there is any desire for this, I'd be happy to arrange for something in the Nagoya region. My ex-ex-day job (technology incubator) would probably be thrilled to have you all.
My guess is that London is not at all cheaper than the Veneto, just that you can earn more money there, and, likely, more money in proportion to your expenses.
You know what they say about spending other people's money.

There seems to be a huge opportunity for a website like ChallengePost to get local governments to post IT contracts online.
Then the government should review all financial transactions, not just a specific minority based on haphazard benchmarks.

(executed regular expression as proposed)