skysight-inc/HackerNews huggingface dataset:
Lots of things, really. They don't have a real 'limit' capability that I've found that works in any way like mySQL's.

To mimic MySQL's "SELECT last_name FROM employees LIMIT 50,50" you have to do something like this:

SELECT last_name FROM (SELECT last_name, ROW_NUMBER() OVER (ORDER BY last_name) R FROM employees) WHERE R BETWEEN 51 and 100;

Aside from that, it's general operational differences and variations from the SQL spec on a pretty grand scale. The flip side to that though is that most serious Enterprise companies are generally using Oracle already anyway, so it's safe to target Oracle or MS-SQL and know that almost all of your customers will have one or both.
It only detects iPad in portrait, not landscape... Is that correct?
Anyone curious what interviews are like can get an idea from the office hours we've done at TC Disrupt and Startup School. Interviews are similar, but with more questions (partly because there are more of us asking them, and partly because we need to arrive at a decision, not just have a conversation).

http://techcrunch.com/2011/05/25/absolute-must-watch-office-...

http://techcrunch.com/2011/09/12/tc-disrupt-office-hours-wit...

http://www.justin.tv/startupschool/b/298808297
Panoptikos is indeed a nice mashup, however picture reddits only.
Deepika Padukone’s Cousin bonds with John Abraham
I've found that people don't really notice or care when IE shows them square corners.

The thing about IE6/7 support is that it's a complete known quantity at this point. The problems & workarounds are well documented. There's tons of experienced HTML coders out there that know IE backwards and forwards. CSS frameworks like OOCSS include built-in workarounds.

So if IE support doubles the cost, it must either be something very complex, or a real nickle-and-dime project. (Either that or the webdev doesn't really what they're doing.)
Creating that web of connections online and offline is highly valuable to a company. The more loyalty you have the better. The online world should help reinforce offline relationships. The internet is, after all, a tool.
What are your thoughts on the whole design by committee? This seems to foster that.
How many patent lawyers are there in Congress? I'd be surprised if it's more than one or two.
The suppliers don't need that much of a warehouse, either. Let's assume that Apple is forecasting that 100,000 iPods per week will meet demand. They go to the supplier, and tell them that they need the screens delivered at 100,100 per week(assuming that a very high .1% of all screens are defective, after the supplier's QA). The supplier gets their factories producing around that number per week, and ships them out immediately. Apple takes them in, and immediately produces iPods with them, where they the go out to retail. This way, neither Apple nor the supplier need to keep more than a week's worth of stock.

The reason that Apple keeps a similar deal with another supplier is if anything goes wrong with the other company. So in the previous example, if in week 5, Fukushima happened, and the first company was unable to keep production up, Apple could go to the other supplier and keep up production, with a very short(maybe a couple of weeks) delay. This is vital, since Apple doesn't maintain that much inventory of new parts.

The other benefit to this setup is that it allows Apple to almost instantly double their supply inputs for new product releases or for the holiday season. If necessary, Apple can use both suppliers to get 200,000 screens per week, then just rent a few warehouses for the temporary storage of new products or the holiday rush inventory.
Interviews are all about failing gracefully
E*Trade won't let me short it, at the moment anyway, because they say they can't borrow shares for it.

I haven't felt this strongly about a short in a long time, either.
Oh wow they have coupons on the internet. There is no technology or hacking going here other than the fact that they take orders from the internet. Whoopty-do.
"Even if they don’t care about accessibility, my responsibility is to make the website somewhat accessible." I'm unclear on who the legal requirements for accessibility fall on exactly so I may not understand properly... but I'd think this is a legal requirement to make your website accessible (at least in the US under Section... 508?)
You are still creating another site even when using polyfills. The surface area for display bugs in a polyfill is > 0.
> Trial by jury is the reason why East Texas is the court of choice for patent claims.

Not true. The local rules in the Eastern District are seen as favorable to patent plaintiffs. It's (basically) nothing to do with the jury pool out there.
You are right will. In every sense of it. Anyone starting a startup would want to succeed. I will do this too. Its that, your post gives me a new level of extreme. Startups are hard, we get to hear the success stories all around. But your post was an exception and it gives real sense of what a founder goes through before he makes it.

Nice post.
How many paid staffers does Wikileaks have?

How much of the budgets for "Productions" and "Research" and whatnot are paid on a project basis to people affiliated with Wikileaks?

How much of that legal budget goes directly to defend Julian Assange? I know they've broken out Assange's Stockholm legal defense from the rest of WL for donations. Does this number also break that out?
90 days is pretty standard. Some companies offer a discount if accounts are paid early. There's no indication that's the case here, so Apple is likely paying when they're supposed to.
Affiliate Network Marketing Tips
Does this mean that google would have to stop linking to some of the pages on its own website if the litigation goes through?
ie: their 'secret books project' where they scanned thousands of books into their google reader database without first getting permission from the authors?
I recommend just running "vimtutor" in terminal once you've installed Vim. It's the best introduction. Far better than the online tutorials that sometimes pop up on HN.

Once I got the basics down (15 minutes in vimtutor), I noticed enough productivity gains to use it immediately for note taking and scripting. Then I just decided to jump in and use it for a real project. I learn new hotkeys, plugins, and config tricks every week and I just feel my productivity inch its way up and up.
Everyone is making (probably well deserved) ad hominem attacks on the ad agency, but the principle of structured creativity isn't a bad one. Steven King once said his muse is a drill sergeant with a flat top lurking in his basement.

The book The War Of Art has a similar perspective from a dance choreographer about how she breaks through creative blocks.
Funny to see Oink launch with almost the exact same feature set. Well wait, I guess Jotly isn't invite-only, so they aren't really the same at all.
> For some reason jury verdicts there seem to be biased towards the patent holder.

The jury is instructed to assume the patent is valid until they are convinced it is not.

If the patent holder's lawyer can confuse the jury, the patent will be upheld. It's pretty easy for a lawyer to do that.
See also http://www.reddpics.com
Most banks and financial systems around the world are so closely integrated with governments that they might as well be pseudo-governmental institutions.
I looked at the graph, and it looked like only 2.4% of students are majoring in computer science. I would have thought that was much higher with all the buzz about social networks, startups and VC money falling from the skies. I guess I live in a bubble when it comes to that kind of news, at least to some extent.

I'm used to seeing students follow the money, like they did with engineering in the 1980's. I had to get a 3.5 GPA to get accepted to the EE program at my school. The school used GPA as it's valve to restrict students, which had it's drawbacks, but demand was so high for EE back then, they had to raise the GPA that high.

I also wonder if it isn't the calculus the keeps CS majors from completing, it's the recursion, pointers and such that really tied my brain in knots.

Likewise with EE, which was my major - I handled calculus, but eventually I ended up solving systems of equations with complex numbers and doing math beyond freshman calculus.

Of course, I gained problem solving skills that I use throughout my life and a career that's been great. I'm not sure how to better communicate those benefits to an 18-year-old in a way they'd understand.
Good size on the posts - large enough to read on 13" screen.

Would like to see it centered (not sure if you are leaving the right margin for future ads)

Link to the comments?

You just increased my work productivity by 300% not having to click on every damn meme. Great work. Will use often.
nice. only question is when will the bubble pop?
This is going to be big. I am selling all of my Bit Coins at once to invest. Out of my way suckers.
I think there's at least a slight difference between UX design by committee and creative design (for want of a better term) by committee.

UX design in groups makes more sense- there are a series of rules and guidelines you can follow to make a good UI. Everyone can co-operate on that, in the sense that they have a rule sheet, and can assess how the design fits those rules.

The more creative side of it (logos, colour schemes, etc) is far more subjective, so attempting to do it by committee always brings everything to an "offend no-one" median.
It would be nice if "Plans & Pricing" on https://www.mybalsamiq.com/ actually took you to http://balsamiq.com/buy?p=myb rather than http://balsamiq.com/products/mockups/mybalsamiq#pricingtable and then having to click another "Plans and Pricing" link.

Looks cool though, will definitely have to check it out.
What a brilliant platform to create a safe online viewing/playing environment within the confines of a smartphone!
I would be upset if they were not following Twitter and Facebook.

When the story comes out that CIA has been given ongoing access to the page view data that ad networks collect, I'll be concerned.

But the Twitter and Facebook firehoses are public. These are "open sources" (in the intelligence sense), and if anything, the real concern I have with intelligence agencies is that they waste tremendous amounts of time and money trying to duplicate those sources.
I've been getting what seem to be Groupon-ish offers from both Amazon and Google. Basically discount deals for things in my area, "pay $10 for $20 worth of foo" kind of things.

I never (that I'm aware of) asked for these offers, and it seems that if both Google and Amazon are actively pushing these out to their user base that Groupon is already borked.
Good examples of the power of the UI:

http://www.scrolldit.com/?r=listentothis

http://www.scrolldit.com/?r=itookapicture
YT comment: "Give it a﻿ knife and a hand!"
The issue for intelligence agencies has seemed less about being able to access and collect information, and more about how to filter the firehose.
That is also how all public companies are valued. Only a fraction of shares are traded on any particular day, and that is what's used to determine the market cap.
But people do...
Totally agreed. Compete on products or results, not on legal process
In addition to what others have said, don't forget that ActiveX also played a strong role. ActiveX was pretty widely used in business-oriented web applications, which hindered business adoption of firefox even among those companies or individuals who wanted to move to it.

There was also a general distrust of open source software during the time that firefox was gaining adoption. With so much malware being spread via the browser (IE6), there was a fear that firefox's open source development model and perceived immaturity were a security and support risk.
If you tell me the ip addr I can whitelist it. pg@ycombinator.com
In the future, they should create the microholes and keep the logo dimly lit in the orientation that faces the user when they open the laptop. Once the laptop is open, the array of LEDs could change to make the logo oriented the current way.

There is already something similar on one of the numerous android handsets out there where the 4 hardware keys turn 90 degrees when you switch from portrait to landscape mode. Not quite as polished, but similar in concept.
WhiteyPaint Turns Walls Into Whiteboards Without Cramping Your Wallpaper’s Style
This seems to encourage the sort of thing CSS Media Queries are exactly made to prevent: trying to detect the device and make some special case code for that, instead of thinking about what is possible given the capabilities.

It's also broken.

The iPad queries should incorrectly trigger on some Android devices, the "SmartPhone" category will be outdated soon. And it fails to detect my desktop.
Since it's only ten minutes, it's pretty hectic as the YC partners try to understand the company/team. Because of the time constraint, they interrupt you, and they even interrupt each other.

It's on the interviewee to get his or her key points across. Go in knowing the three or four main bullet points you want to convey, and make sure you get them out.
And this one is not blocked in Opera.
I'd certainly consider it.... especially if it was targeted for specific industries/regulations (HIPAA, SAS 70, etc).
We home educate our kids and I can tell you the differences in math ability between each child.

One of my daughters can hit anything thrown at her. My other daughter is more advanced than most kids her age at math, but I know that she has already learned more math than she will ever use in her life (she is in eight grade but is doing very advanced algebra). Her interests will never lead her to a career that requires more than she already knows.

The problem is pushing everyone to one standard, when they do not need it. It makes them feel stupid, and is a waste of time that could be used developing other skills.
I'm curious about the statement you made that the UK uni's won't let you work on a startup during your course of study. I plan to apply for the PhD (as an American in the UK) in personal informatics. I have been very upfront when speaking to advisors in the uni's that it directly relates to my company and no one has mentioned that I can't work on my business and PhD.

Anyway - to answer your question: have you looked at the Eastern European schools? Slovakia, Czech - both countries have wonderful tech uni's.
> Look at Moniz (in the article), he bailed on engineering and went to an English/Psych where the classes are "a lot more discussion based."

The impression that I got wasn't that he bailed for discussion courses because he was afraid of being wrong, but rather that the discussions in English classes at least gave him some outlet to feel like he was applying what he was learning.

There's a very weird death march of lectures for 2-3 years in some engineering programs during which you're expected to cram in a ton of knowledge but given zero opportunity to see how it will be applied in the real world. Compared with my own CS background it looks horrific; if I had been expected to spend my sophomore and junior years doing nothing but sit in lecture halls doing theory courses and "practical" courses in which I memorized syntax for programming languages, or facts about OpenGL, or the ISA of a MIPS CPU, etc without being allowed near a computer to actually build some kind of project using that knowledge, I'd have fucked off into Philosophy or English, too. At least it would have made time for me to make stabs at using what I was learning to do philosophy instead of simply regurgitate facts. But luckily for my future employability, CS isn't so lost to bad pedagogy that it's thrown out most of its practical learning opportunities.

My primary take away from this piece, and talking to people who have burned out of physics and engineering programs, has been that a lot of said programs are simply structured in a way almost guaranteed to try the patience of a lot of otherwise bright people who just wanted to feel like they were making progress towards being able to accomplish something more than regurgitate facts on midterms.
Wow, I wonder what people think when I tell them I spend a lot of time on reddit. This content looks absolutely nothing like what I'm used to seeing. I suppose I hide away in subreddits and miss all this weird frontpage material.

It looks so...alien.
The Hustler's Manifesto
Thanks! Good to hear you enjoy it on your 13' screen, one of my goals was to increase the usability of Reddit on mobile devices. Right margin is not left for ads, it's there because another box couldn't fit (try to play with your browser width to see what I mean). Comments are accessible through the title of the box. Have fun!
The Amazon offerings are provided by livingsocial... just an FYI.
Some (MMOT) classmates are trying to do that (loyalty cards for small shops plus online advertising).

The main block is actually apathy from the storeowners - they don't believe they need it, most of them are conformists and traditionalists, not enterprising or risk-takers.
Facebook vs Google: The battle for the future of the web
I didn't really see the article describe much about the principle of structured creativity. I would have liked to have seen that.
Don't worry, multiple subreddits work as well on Scrolldit: http://www.scrolldit.com/?r=science%2Bprogramming%2Baww
Ask HN: where have all the designers gone?
Long story short, my cofounder had to leave for personal reasons. I'm going to carry on and do the business development as well as coding, but I find UX and design incredibly difficult. In fact, that's what's stopping me launching a beta.

I've been contacting freelance designers but I'm getting quotes of around 3k which is beyond my budget. No joy with odesk or elance either - I can only find web designers with experience of brochure sites on there. I'm not looking for a "heavyweight" designer, just someone with a good eye for usability that knows html and css. Does anyone have suggestions about where else to look?
very good point about instant gratification...I completely agree!
It's nice, but picture only like panoptikos.com :)
The mobile version of this article is terrible. The scrolling "jerks" to whatever page it thinks I should be on - very strange.
Building the World's Safest Bank
The author of this article is exactly the customer credit card companies don't want. They actually lose money. The irony of extolling the virtues of good credit card use is that if everyone who owned a credit card did the same, credit cards would cease to exist because they would no longer be profitable.
>"Bad" typography isn't a big deal IMO. Yes, it's slightly embarrassing and ugly, in this Unicode-enabled era, that we use <= for "less than or equal to" and != for "not equal to", when Unicode has given us better glyphs. But honestly, I don't see how that costs us much time to get used to.

<= and != are easier to type than using alt-codes for unicode characters. Unless you want your programming language to come with a keyboard driver for every OS that only is used for that language, there is no reason to use it.
Show HN: Fetchful - Fetch page information previews from any link
can you check out the collab features of http://www.mockuptiger.com
I agree with you on this. If I was starting something in a space with regulations I would love to buy something that's guaranteed rather than figuring it out myself. It would allow me to work on my product rather than compliance.
Wow! Hooking up to my monitor now for an 8 wide reddit overload. Beautiful.
I'm surprised something like that doesn't exist...
Can you (or someone else) recommend SRS for iOS? Ideally I'd use it while walking my dog, waiting for an elevator, etc.
A programmers opinion of Java goes a long way in showing what kind of a programmer he/she really is!
Meghalayas' Living Bridge
Why would the legend of Facebook motivate someone to finish a degree in CS? Zuckerberg dropped out!

Steve Jobs dropped out, Bill Gates dropped out, I believe Steve Wozniak saved himself the trouble of dropping out by never going in the first place... Larry and Sergey have big-time CS degrees, but they also aren't as famous.

Let's assume (apparently falsely, according to Alexis Ohanian's anecdotes) that PG is universally famous among techie 18-year-olds. PG literally wrote important books in CS. But does PG encourage everyone who applies to YC to get their CS degree as a top priority? Methinks not. He wants you to build something. To the extent that studying engineering and math doesn't feel like building anything, it doesn't feel like a hot new SV startup.

There's a big demand for software talent, but how are teenagers supposed to grasp that getting a difficult CS degree is the best way to acquire or demonstrate that talent? Especially when we're not even very sure that's true? On the one hand, I've got a lot of Ph.D.-trained colleagues in my job (though, perhaps tellingly, none are in CS) but on the other hand several of our most valuable colleagues have degrees in music or English, and others are too young to have a degree at all.
No there's a definite creep factor going on with this site. The article page has his image as the background of the website and in the logo...::shudder::
Ask HN: 15' Macbook Pro or 13' Macbook Air for web dev?
Both "maxed out". I do take the train, so the small screen size can be an asset. However, I prefer to use just the laptop screen for development all the time, so having a large screen is nice.

The maxed out macbook air is (disk size ignored because I don't intend to go over 100 gigs).

1.7GHz Dual-Core Intel Core i5
4GB 1333MHz DDR3 SDRAM
128GB Flash Storage

Macbook Pro

2.4GHz Quad-core Intel Core i7
4GB 1333MHz DDR3 SDRAM — 2x2GB
128GB Solid State Drive
SuperDrive 8x (DVD±R DL/DVD±RW/CD-RW)
MacBook Pro 15-inch Hi-Res Antiglare Widescreen Display

I've heard several people prefer the Airs now, what's your experience been?
My respect for him remains the same because when you multiply infinity by any number what you get is still infinity!
The problem may not be that you are losing those capable of original research (though I am sure that many of them are lost), but that not all scientists need to be able to do that research. For each researcher, you need people capable of assisting, people in factories making the tools and reagents and measuring devices, etc.

These may be considered not as prestigious as research, but they are just as valuable nonetheless.
They need to start video on hover.
Hubble Spots Disk Around Distant Black Hole
That's another scandal. Swedish prosecutors never issue international arrest warrants to question random Joe Sixpacks, certainly not for very dubious accusations like these. It's a shame that such a civilized country is being dragged through the mud by politically-motivated scumbags.
Wow, thanks! Email sent.
Where have all the people who can pay for experienced designers gone?
True point!
Actually our technology stack is quite impressive and we are solving problems that are not quite apparent when simply viewing it as an ecommerce site. Your arguments would go against Gilt Groupe, BuyWithMe (when they were around) and Groupon.

There is always more than meets the eye - I would hope that someone working in the technology sector would realize that.
21 Ways To Create A Sales Stampede On The Internet [Paperback]