skysight-inc/HackerNews huggingface dataset:
I would like to add Backendless http://backendless.com to the list. It's pretty similar to Parse in terms of API and Dashboard. I've never used it but met the CEO and loved his vision for the future of the company.
Everything?

https://plus.google.com/112218872649456413744/posts/dfydM2Cn...
Learn to write SQL views. It'll make you feel all warm and giggly inside.
Sorry, can't help it. What a stupid list!
Coming soon to the real world with Ben's continued money printing. Maybe we can rollback the bank accounts to pre-1999!
Google cache/mirror: http://goo.gl/3tclG
Conceptually WHERE is filtering the table rows that get considered and HAVING is filtering the result rows - functions and all - that get returned. That's how my mental model of it all works.
I respectfully disagree. A title such as "Show HN: My Employee Rewards Site" would have been more applicable.

However, I don't begrudge the OP, as he's certainly gaining lots of useful feedback for his site.

I just can't help but feel slightly gamed ;)
Yes you have a "good definition" in the law there, but what is the law for? It can't have been too important if they repealed it and some people deny its existence

AFAIK, that law was actually a protectionist scheme to favor African (ex-colonies) banana producers against South American ones in EU markets.
> then replacing the ORM entirely with raw SQL,

anyway it is usually never the case. Why would you build a complex app only to tear it appart with going back to raw SQL ?

i'm not talking about SQLAlchemy but often the main problem with ORM is performance. Especially when a orm has its own query language on top of the SQL language ( Like Hibernate or Doctrine ).

A good ORM imho is what you described , something very light but still usefull enough so one doesnt have to do data transformation from rows to objects. How does SQLAchemy fetch related objects ? is it is lazy ? or does it fetch everything when doing a join query for instance.

Anyway thank you for your great work with SQLAlchemy.
At the very least you have to give him credit for his persistence and attempt at hacking the YC.
That's a poor question.

The Revolutionaries were really just opportunists. They could have received the representation they wanted in parliament, however they saw the chance to start their own government, a new one, built by them, however they wanted. I'm not saying it was a bad thing that they decided to focus their efforts on starting a new government instead of working with their current one, but they didn't have to.

The Declaration of Independence was written to discredit parliament and the king (who, at this time, didn't have power anymore, it was already with the House of Commons), and to drum up support with other powers who didn't really like England (specifically France). They could have worked out a deal with the House of Commons giving them a representative spot, but their declaration explicitly decided against it.

Take a history class. You might get some context to the events you cite.
If you're designing for mobile at all, then retina is meaningless, unless you're disabling page zooming.

Because zoom levels can be anywhere from 0.25, say, to 8x. One user might be viewing part of the page at 2.78x. Another, at 1.3x.

So all this talk of "2x" or "4x", or serving up different files for diffrent resolutions, or aligning to pixel boundaries is quickly becoming meaningless.
That's no challenge at all!

How about this instead: Get a bunch of investors to pitch to an audience of founders who would then evaluate, select/reject which investors they would take. Now that is true founders power!

I call that inverse-YC.
If you already have a layer of abstraction to your SQL statements, then it can be arguable. But if your are littering SQL statements everywhere, making changes to the database can be more tedious.

Also if you want to support more than one type database, I would use an ORM.
The article is from a publication which wants policy change in the US. I guess they don't care as much for the welfare of us Europeans :)
Good. Now I can use the "anti-authoritarian" card when I tell my boss to go crunch a biscuit.
We'll take a look at this. We're about to push out a 1.1 with better crash reporting so we can look at this stuff.

As for the OAuth with Stripe -- it's a little slow and hokey, so our arms are tied there. Glad to hear you got in though.
Issue: What about VPN? If you're connecting to your corporate network with OpenVPN, and you are restricted to one connection (common sense security policy) then you need to get your infrastructure team to issue you a separate key for each VM that you're running that you want to be able to access a tunnel and get on your corporate network.

I realize that this isn't an issue for 99.9% of startups, but in the non-startup corporate world where there are security implications to keeping everything in a publicly accessible code repo (healthcare, government, education in some states) then you've got another complication.

The only thing I've been able to work up so far is sharing a folder on my desktop through to the VM and running commits from my desktop.
Ah, yes! I wanted to point that out. Do you have an idea of what the number for iPad should be?
It happens in any type of economic system, except in capitalism, it happens much slower. I'd prefer eventual stagnation with the possibility of reviving innovation to a forced stagnation by a particular economic system.
Well, any revenue usually accounts for more than 100% of profit.
Thanks. This is one of the occasional comments I find on HN that is so helpful that I put it in my notes so that I can refer to it again in the future.

While the parent article itself is really great and somewhat similar, (a) you have a better explanation of melatonin, and (b) the morning wake-up light you recommend appears (from quickly scanning comments) to be much higher quality than the one the parent article links to.
Indeed. I do worry about the level of SQL knowledge that developers have in general these days. Without understanding it - and the relational model (which I'm a big fan of) - it's impossible to optimise the way you use the ORM.

OT but thanks for SQLAlchemy. It's the model ORM in my opinion. It's the only one I've ever used that feels like it respects SQL. When I started working with Python fulltime I spent days reading through the SQLAlchemy source - I learnt a lot from that.
I think you missed the point, it is not about me, otherwise the "mole" would not be very anonymous and be self-defeating...yes I put that in a prior comment directly to PG's comment, but this is a separate post and I do not suggest me. Separately, " OP admits no one wants" I do not know where you got that, in fact I picked up users from HN who have posted they think geotagged videos could be very useful in many different industries, but yes I applied to Google Ventures and YouTube created a similar product a few months later - did I say they ripped me off? No I just said it sucks...As to the plug-in you are correct my product would be better if it did not require a plug-in, but I can not just demand Google release an API for Google Earth that does not require a plug-in.

Now...if I can smoothly transition your post about me back to my OP, I did not require PG to take a position that Founders have more power with Investors than any other time, I just disagree. I never said YC guarantees success, but it does guarantee funding, and as you will note my post is about PG's take on investment not success as you seem to read into my post.

If you believe you as a Founder have more power today with investors than any other time, that is fine, you do not need to attack me personally because you disagree, maybe it is a fair characterization to say I called PG out, but I am not attacking PG personally just offering a way to prove his statement. Others have already commented my "challenge" would not prove anything, but admit my hypothesis is correct.

I agree there is an inherent problem with YC putting someone they rejected in front of investors, unbeknownst to investors, but "ruin YC's credibility" that is a joke. However, I think your position proves my point as to PG's statement that the power does not rest with Founders otherwise if a investor liked a start-up they should not care whether they were a YC company or not, ie. if you invest after a demo at YC only to revoke your investment upon learning that Company was not accepted into YC, then my point is proven. So I guess a alternative challenge could be informing investors that a YC company that received investment is not really a YC company and see if the investors revoke their "hand-shake deal".
As a practical matter, how is that different than assigning the copyright?
Want to Spam Your LinkedIn Contacts and Be Humiliated? Try FounderDating
Aging, cryonics, and the quest for immortality
Cars will be seen as noxious as tobacco is today
Dunno about the downvotes but is the best argument we have for reducing suicides, well if we make it more awkward then less folks will top themselves and instead will lead lives of miserable desperation?

We have to be better than harm reduction surely?
I honestly don't understand why you are so aggressively against my opinion? Genetic-engineering isn't bad per se, I see huge value of it in Reversing the genetical damage (esp. RNAi and siRNA therapies).

I said: "..we cannot create something better (in a few hundred years)."

You said: "We created those foods". [..] all been genetically engineered [..]

Where is the proof that these processed or genetically engineered foods are better? To clarify things, we DID NOT create those foods, we modified them. Creating is food is clearly something entirely different. We've not advanced that far in Bio-sciences.
Object-relational mapping.

http://en.wikipedia.org/wiki/Object-relational_mapping
Why would you ever want to use such a horrible statement instead of using an inner join?

scope :with_assignments, joins(:assignments)

(or :assignment, depending on how your association is defined)
I had to check to make sure that article wasn't written ten years ago.

"E-commerce is clearly the future of retail and there is a growing battle brewing for dominance in this new world"

Where's the 1998 time stamp?
Registrar Name.com Hacked, Account Data Compromised
It doesn't necessarily mean that they're storing it plaintext (ie it could simply be a front-end input validation). But in any case it doesn't inspire confidence that they're following best practices.
okay guys, can we also talk about good will hunting ?

right.

If therapists had to take care of all the problems caused by society, there'd be no end.

On top of it, ODD is for kids, not for grown adults.
The amount of cash you had was stored in savegame files as 4 bytes. A few changes with a binary editor and suddenly you had millions of cash ;-)
I'm still amazed that there are developers who would rather spend more time maintaining/debugging/optimizing ORM code in a mature app that just learning a simple INSERT statement.
They wouldn't fix a dead pixel on my retina MBP even though it went out just 3 months after I purchased it!
> If there was a drug shown to improve self-esteem in children, it would likely become one of the most profitable drugs of all time.

It's called alcohol. It's wildly profitable.
Also the chart only dates back 1 year... why not do a 5 year comparison? Oh right.. because Apple stock has outperformed AOL by a factor of 2 even with the recent 30% dive in market value.
*That's what that was

A9 failed to compete in general search, so Amazon turned it completely inward as a product search engine.
This is a textbook semijoin, but you can see what the postgres planner does with explain and explain analyze tacked in front of a query.
I'll prefix my question by saying I'm unfamiliar with QC beyond knowing of its existence and roughly what it does in terms of generating test values:

Am I misunderstanding, or is this akin to QuickCheck for C#?
I would say that you probably shouldn't be doing VPN to your development boxes in general. I'd see this as a security risk. I generally don't let anything 'production' touch directly anything which might not have the same security standards as the production gear.
No, they're also working on storage.
Okay, so let's go down that line a little bit more.

In a species (alongside a whole host of other species) that depended on rape for survival, how is an inability to rape not a mental illness? [1]
In a species that depended on rigidly defined gender roles of women child rearing and men being hunters, how is aberrant behavior not a mental illness?

I think what's happening is you're falling prey to appeal to nature fallacy. Consider here also the results of the loners, the outliers, the dropouts -- a lot of them go on to contribute greater value to society than the ones following the pack/tribe behavior.

[1]: Researchers Thornhill and Palmer say rape is an evolved reproductive strategy and not a crime of violence. See their piece 'A Natural History of Rape: The Biological Bases of Sexual Coercion' for more.
Asheron's Call had a very viable (unofficial) real-money trading system via ebay. I never even played the game but knew some people who did and they made fairly substantial amounts of money selling virtual crap on ebay. This was before the rise of the hardcore Chinese gold farming industry, in-game limitations on item trading (ala WOW), ebay restrictions, etc.
Most of my experience is with the Django ORM. The point of the django ORM is not to replace SQL knowledge, even though that is feasible. The main point is reusability.

I had to work with SQL through PHP for a while and I found myself "composing" SQL queries in a myriad of ways. I tried to not repeat myself, but it felt like the Django ORM would have gone a lot further in cleaning up the query-building.

In conjunction with Django forms and Django Admin, maybe even the template language, the ORM makes query construction reusable.

One of the kickers is the ability to unify object construction from table columns. It's easy to convert a string or number to some Python field. It's more elaborate with Decimal, Json, or whatever you want to cook up.
"What is the goal that is towering above all else for the EU? The one it has actually been relatively successfully implemented?"

I thought it was an attempt to stop Europe engaging in endless major land wars.
I seriously hope for YC's sake that PG has better things to do with his time than an n=1 experiment.
Not my intention. I'll follow up with more how I learned to program posts. I have some from a few months ago. See http://spencerfry.com/why-and-when-to-learn-to-program for example.
Checked out the site and some of your blogs, congrats on launch! I have a similar path so far, with no formal coding education (biz background) but a front end dev job which is going great.

Question: Did you and your 2 partners quit your jobs all at the same time completely to build this? Would love to hear more about the work/money/time side of things that allowed you to get to this point. Best of luck.
Like a lot of other political decisions in the US - they still choose to go with the unlogical choices which in this case would be to not implement some of these bans. I guess there are commercial interests behind these decisions like the gun politics, alcohol laws, etc. What else can you expect in this semi-corrupt country?
Glass getting Banned. Knee jerk legislation might ruin Glass.
You can use CROSS APPLY on tsql, and it allows you to use an order by in the inner query, for example, if you wanted to know the id of the employee's latest assignment.
SELECT e.*
, assignment_id = b.id
FROM employees e
CROSS APPLY (SELECT top 1 a.id
FROM assignments a
WHERE a.employee_id = e.id
ORDER BY a.assignment_date DESC
) b

In tsql, you are not allowed to have order by in a subquery (if memory serves me right)

Edit: Oh crap, I forgot this isn't SO, and the formatting went out the window.
PayPal, Multicaja evolve e-commerce landscape in Chile
he forgot to mention two years of under graduate computer science courses
Nature's bananas are bloody awful.
Well, AnyPerk and similar services are discount based. From our what we believe section: "Discounts aren't effective. There's a difference between "here's a discount" and offering something special."

With Uncover, you can provide both ongoing perks as well as individual recognition. We call those two products "Benefits" and "Rewards".
Those buttons just instruct the hosts to do things and don't actually have power themselves.
Don't forget econ and statistics.
Well, but the article was actually speaking out against Boxen a bit. Essentially, you're still shoehorning all of the dev stuff onto your local machine with Boxen. It's much better than installing it all manually, but still not a separate dev environment.
Incidentally, Eve is the source of my favorite overflow bug! By putting a ship into a region of space that reduces the range of its weapons and using various range-debuffs, players were able to decrease the range of certain weapons by enough to get the range variable to roll over. This gave them near-infinite range on weapons that were intended to be short range. Since the short range was a tradeoff for very high damage, suddenly having infinite range was game breaking. However, the people who discovered the bug were clever, and did not abuse the power enough to be detected for nearly a year.

http://massively.joystiq.com/2010/09/17/new-eve-exploit-give...
Implying America is not run by a parliament of whores. Google will get what it needs.
Well, adding joins to the outermost query can limit your options re how you use the scope. For instance, `joins` sets a read-only flag on the AR result, so you can't say Employee.with_assignments.destroy_all, for example, to, um, fire all your busy people. :-)
I consider aliases only a workaround, not a fix anyway.
Thank you!

We're bootstrapped for now. I have had some previous exits with TypeFrag and Carbonmade, so financially I haven't had to work another job while bootstrapping Uncover. Mike and Jason have been doing contract work to pay their bills while working on Uncover.

Happy to go into it more privately (email in my profile) or I can potentially write a bigger blog post on it.
Zach Braff Responds to Kickstarter Critics [video]
Stop focusing on inanimate objects, and start paying attention to behavioral consequences. Unenforceable prohibition does not proceed well.
> I honestly don't understand why you are so aggressively against my opinion?

Because statements like "took billions of years for the nature to create the foods that are perfect for us" are false and absurd. Nature didn't create foods to be perfect for us. The goal of natural selection was for those organisms to survive, not necessarily to be tasty to humans, and most of the foods we eat were modified by us to our liking.

It's the same sort of argument anti-vaccine nuts use. "We were fine before vaccines!" No, we weren't. Millions upon millions died of easily preventable, natural diseases.

> Where is the proof that these processed or genetically engineered foods are better?

Try surviving off wild bananas or the wild grasses we bred into wheat and rice. They're harder to digest, yield less, etc.

> To clarify things, we DID NOT create those foods, we modified them.

And? We're doing that with GMO foods, too. Humanity hasn't yet created even a single-celled bacterium from scratch, let alone a corn plant.
MP3 would be standard codec for audio if the only concern was interoperability. It was officially motivated by non-encouraging of usage of patented formats.
I'd lean more toward your second comment. One of the comments on the previous HN coverage inferred that leaving the eggs unwashed was so that dirty eggs would never make it to the consumer -- thereby encouraging farmers to keep a cleaner chicken coop.
Weird. I thought amazon made more from cloud services than they did through retail. I wouldn't doubt a collision course, but in search? seems unlikely.
I don't like being data mined, full stop. Advertisers don't get a free pass; I would much rather pay for any service than have companies I don't even know the names of compile mile-long paper trails of my online (and possibly offline) activities.
It gets better with time. I'd really recommend getting something out there as soon as possible, so you can breathe a sigh of relief.
The nice thing about SQL is that it doesn't take very long to learn how to use it and then it's incredibly useful any time you have a database to interact with. I think all novice programmers should take a crack at it.
Not a daddy, eh?
Yeah, I clicked around some after I posted and realized it was not as general purpose as I remembered it. I am not a search person, though, so wasn't how far removed from general it was. In particular, the visual search stuff seems even more impressive, honestly. Assuming it works. (I would guess that is a huge assumption.)
> If I can't buy it via Amazon, I probably won't buy it.

This was 100% true of me as well for a decade or more. But getting into the Google Shopping Express beta changed everything. Same day delivery (i.e., even faster than Prime), competitive prices, up-to-the-minute order and delivery tracking, and sharply dressed and exceptionally polite and courteous couriers, means that for a large portion of "just use Amazon" products I'm now going with Google instead. See http://google.com/shopping/express/about/.

Selection and availability are of course the caveats of the early Google tests (limited to just San Francisco and parts of the Bay Area for now), and I was skeptical at first, but boy is this a game changer if we can pull it off. I've averaged almost an order a day since we started.

Granted, Amazon's use of OnTrac in San Francisco for Prime is also a factor. I may not renew my Prime membership for the first time since it launched as a result of OnTrac's poor service here.

(Ob. disclosure: I've worked at both companies.)
Is there a health concern from pigs eating pig meat, or is it just something that seems gross?
The kickstarter isn't really about making money, or about getting a film "made". It's about connecting to fans, and I think it's working just fine.
I have no immediate way of verifying that what you call a compelling evidence referenced in that blog post is in fact compelling and accurate. I could go through all linked sources, but I don't presently have time for that. On the other hand I read several books on typography and I am partial to the type design. From that exposure I do know that the common consensus between people involved in creating said serifs and sans-serifs is that sans-serifs are generally harder to read. So when I am presented with an evidence to the contrary, you can be damn sure I will doubt it.

Throwing around power words like "science" and "compelling evidence" based on a couple of references plucked from a blog post - sorry, but you are well in a meta area, preaching about general subject matter without any regard to the context. You are not the only one who's aware what science and scientific methods entitle, but then you should also be well aware of a bunch of junk that gets published in a format of scientific research, gets quoted and re-quoted and eventually accumulates notable status even though it hasn't even been peer-reviewed once. This happens all the time and it's a part of "science", so being skeptical is a part of the package. And the more obscure the area of the research, the more skepticism is warranted. You surely know that being that well-versed in all things science.

--

Your e-reader doesn't have the resolution required for good quality rendering of serif fonts. Hence the Gill Sans.
You miss the point entirely. "Playing a card" is usually in reference to having some condition. The author's point is that anti-authoritarian is no condition. So. If you are anti-authoritarian go tell him to "crunch a biscuit". If you are also not an idiot, have a fallback plan.