skysight-inc/HackerNews huggingface dataset:
I agree with you that in this particular instance, this is probably not the optimal solution to the problem at hand. I would argue, however, that you are significantly overreaching by implying that one should never take advantage of advanced features of your RDBMS. While the OP's problem was rather easy to solve in the application layer, there are many problems where that approach is absolutely unreasonable.

As an example, I'm currently working on a project that involves modeling a directed cyclic graph in the database. Trying to pull the logic out into the application layer is simply unfeasible. There is no performant way to do it, period. However, it's easy enough to work with it in the database, either by using a function that performs a recursive query, making a materialized view out of that same query, or using triggers to maintain the transitive closure in a table proper.

You also seem to have a pretty narrow perspective of the situations in which RDBMSs are used. As it happens, there are a lot more use cases than 'persistence layer for web apps', and in many of those use cases the idea of not using advanced features of your RDBMS would be absolutely ludicrous.

I do agree with one complaint made in another reply to your post, which is that version control, testing, etc. are much more difficult when your logic is residing in the database. There are a lot of solutions out there for that, though (migrations alone solve many of the headaches), so it's really not a knockdown argument. As for portability, the SQL itself is as portable as any SQL is. WITH RECURSIVE was added to the standard in '99.
About 20 years(?) ago Michael Moore did this in Greenwich, CT. Same deal: in CT, all beaches are public from the water to the high-tide mark. Greenwich imposes ridiculous parking/beach entry fees ($100+ IIRC) for non-residents so the only access is often from the water. He took a bunch of people and a film crew and hung out below the high-tide mark while the Greenwich cops hung out above it to make sure no-one crossed.

Not sure what the point of it all was, since there are many other nice public beaches. Maybe it was worth it just pissing off a bunch of people with sticks up their collective asses?
> It took me 3h last week to get it on a CentOS installed

This matches my experience with a significant amount of software on CentOS. Since CentOS is just a rebuild of RHEL, and RHEL is extremely conservative when it comes to new software, CentOS tends to be out of date at release and get progressively worse.
>I realize this may not be a popular opinion,

I think you hit the nail on the head.

>To that America it is easy to see Snowden as a traitor

We shouldn't pander to those who refuse to open a dictionary and learn the meaning of the word "traitor".

> running to China and Russia isn't helping.

The important thing to notice here is to ask why anyone might find this necessary. There simply aren't any other places who can or would resist US "diplomacy"

>1. Snowden is a civilian. He has not submitted himself to military law.

I think it is not imprudent for Snowden to assume that he may be treated as an "enemy combatant". If the gov't declares him to be under the auspices of the military, I doubt they will announce that publicly.

>the more Snowden acts like a criminal, the more he will be perceived to be a criminal.

Considering the recent conduct of the US gov't WRT related whistleblowers, I cannot find fault in Snowden for wishing to avoid that. Either for the sake of his personal safety, or for the sake of keeping the issue in the press, and forcing more attention to the illegal spying.
Have you read them? Because so far it has only been encyclopedic (to me) because of the vast amount of material he covers, and the depth with which he covers it.

Aside from that, his writing style is actually conversational and clear to follow; he includes numerous exercises and strongly recommends the reader to do them. He also clearly marks which exercises are appropriate for more Mathematically enclined readers vs. Programmers wanting to level up.

Don't get me wrong, it's thick material, but his exposition of it is clearly well thought out and there's an easy-to-follow path between the topics and ideas he covers. Unlike most encyclopedias which are generally a repository of knowledge with loose links between topics and concepts.
You're just missing the point entirely. Fry isn't setting up Cancer and Diabetes and Depression or suicidal thoughts as equals, but rather as equally likely ailments. "Make an effort" is blaming the victim for something usually out of their control which is similar to blaming you for getting cancer. Imagine if you were telling someone with skin cancer or lung cancer that they should "make an effort" to stay out of the sun or quit cigarettes. You're trivializing the disease that's already there.

And you're not the only one. This is a common attitude people have. It's as if people who really feel detached from this life and want to end it do not have that right. Instead, millions of people would rather sit down and debate whether it's ethical for someone to kill themselves or have a physician-assisted suicide. Maybe we all want to believe that everything is a Hollywood-esque setting where you just need to find the right people and love of your life to get everything back together. In reality, mental illness (cyclothymia, in this case) is just as real as every other illness and you can't just "make an effort" to get rid of it. I'm sorry about your illness, but try to not to trivialize other's, it isn't a competition.
I wish there was some indication of which ones were free, freemium, paid, etc.
I was referring to putting business logic in your database, and not any particular query technique.
Right, if I get someone else's, and later we trade back, what happens if we each think there is a problem the other caused by (say) pushing it too hard?

If Tesla only loans you a Tesla battery and you have to swap back to yours that they don't give anywhere else, that could make it manageable.
Ask HN: Can software become conscious?
What are you're thoughts on the hard problem of consciousness (https://en.wikipedia.org/wiki/Hard_problem_of_consciousness)? Is consiousness just a complex physical process in the brain or is there something else to it? Theoretically speaking, can software running on contemporary computer become consciouss?
> Money itself is something the state made, so consider taxes a charge to use it

That's a nonsense. Money itself are not a goods, because they are worthless: you can eat those banknotes you have in your wallet or do anything usefull with them. They only serve as a symbol that allows more convenient trade of real goods. And I'm not gonna create any "widgets" to replace them, but still many people uses alternative to state made money, like Bitcoin. Thinking about money the way you think is a main reason of the current economical crysis.

>No they can't because you've bought up all the land and allocated all the resources despite using a small fraction of them.

Billionaires usually don't spend much on consumption, neither they keep their resources unused. Most of every billionaire wealth is his company, or companies, in which they employ thousands of people (giving them opportunity to earn for their living) and produce things that fulfill needs of millions. That's all they owe to the rest of society.
Scientific (style) inquiry doesn't require that one have no preconceived notions, only that he be willing to be proven wrong about his preconceived notions. It is unfortunately difficult for outsiders to judge whether Snowden cherry-picked or is accurately representing what he found.

But why does this not increase Snowden's credibility? He went undercover to gather evidence of malfeasance. How does that not turn him from a leaker into an investigative journalist getting an inside scoop?
That portion of the article is referring to clinical depression, not general loneliness and unhappiness. You just demonstrated his point (that people have a hard time seeing mental conditions like bipolar disorders as actual diseases of the mind and not just bad attitudes) quite nicely.

Pardon me for being frank, but when I pause to imagine having my life taken from me before I was done living it, or being so profoundly unhappy that I would sincerely attempt to kill myself, I can only see both as terrible in their own right. There's no sense in trying to compare the severity of one to the other.
Writing your own games (either in your free time or as an attempt to make a living from it) is extremely fun though, and I would recommend that any developer pick up an intro to game dev book and have at it :)
..Or stop the company you're talking to from shipping off information to a 3rd party after it's been received.
Manning isn't the only example of vindictive prosecutors run amok. Aaron Swartz was facing a deck stacked so heavily that he was risking 35 years in prison for excercising his basic right to a trial by jury. And if you doubt that the same psychotic vindictivness would be in play here, consider the case of Thomas Drake.

Indeed, Drake's case is the essential precursor to understanding Snowdwn's, in that it was the one that unambiguously revealed (a) how out of bounds the NSA had grown and (b) how effectively the whistleblower system had been transformed into a means of ferreting out principled opponents with the law on their side.

Snowden had no illusions about getting a fair trial. He's running from a kangaroo court, not impartial justice. And if you think his "legitimacy" as a "conscientious objector" has any bearing whatsoever, then the thrust of the entire revelation has been lost on you. This isn't some theatrical act of protest. This is hard evidence of a massive criminal conspiracy conducted by the US military against the American people. And the power to which he's speaking truth isn't them, it's us. Some can handle it, and respond judiciously. Others freak out, and retreat to blanket denials. Insisting that Snowden stand trial on dubious charges in a court rigged against him is probably the worst imaginable response to the confirmation he's risked his life to deliver.
The demand sums of money are usually just slightly less than the cost of defending oneself in court, around $7,500.

Publishing silly C&D letters has been effective for some people.
New Siri voice!

iPad Update!
Um, doesn't thin margins mean generally mean the industry is mature and most things have been tried? I guess if you hold constant the "degree of difficult" for innovation, then large revenue make an industry "ripe for innovation". But this applies just as well to Apple, right? A 1% increase in efficiency in a $100 billion industry nets the same profits, regardless of the existing margins. Or am I misunderstanding?
Isn't this very close to impersonating police? Impersonating the government?

Google says yes, in certain cases: "http://blog.lawinfo.com/2011/03/23/impersonating-a-governmen...
I think you're replying to the wrong comment tree. Spammers already do this today, by including your name and other data in the message, and varying the wording, but that is not enough to fool the spam blockers, and there are diminishing rewards as your addresses/IPs begin to get marked as source of spam regardless of the content.
The bulk of your comment - your second, third and fourth paragraphs - focus on issues of speed, bandwidth and reliability in a third party hosting/cloud-based architecture, which are a design-time tradeoff, so I don't see them as strictly relevant (though anecdotally informative).

Your fifth paragraph describes problems related to operations process, which are entirely avoidable.
I will take another go at explaining what OP said. Things you do have consequences; if you beat your wife every day, it is likely that your son will solve his problems by beating people. You will be dead soon, he will live on to inflict this on the world.
You see clearly, like seeing Godzilla
rising from the East River and
about to come ashore. And you
are 100% correct.

"All we need is another man
like Richard Nixon again" --
sung to the theme song of
'All in the Family'. So,
Tricky Dicky had an "enemies
list" and wanted to use IRS
data. If he had had IRS data,
NSA data, CIA data, FBI data,
and Obamacare data, we might
not have a country now.
in SoCal that would be the $300,000 kickstarter follow on round.
In the forward secrecy modes of TLS, RSA isn't used to encrypt anything.
I don't know... Some of those signs look like they are government signs, and that could be a public safety issue.
Most Actually Prefer iOS 7 Icon Designs To iOS 6, Study Finds
You're not wrong, but continue your thought process and think bigger picture.

If you do actual research on older computer users, you'll see that many prefer a desktop environment for the sole reason that they can get a monster monitor.

"But my Grandma!" you might say, and you might be right.

But expand your dataset and you'll start to understand why desktops and iMacs haven't become obsolete.
Taking off my tin foil hat for a moment, I would propose that encryption adds latency which they felt most users didn't care about. However most users demand land line quality voice.
Fraud is typically not protected by free speech rights. For example, if you put up a fraudulent "No Parking" sign on your property so that people wouldn't park on the curb next to your house, that would be illegal even if it were on your property.
You can run salt masterless. See the quickstart.

http://docs.saltstack.com/topics/tutorials/quickstart.html
All the apps like ckEditor, Pacmini ... (notanos/notanos/apps)

were those developed from scratch in JS or ported ?
"Keep your ugly, fucking, gold-bricking ass out of my beach community, Lebowski!"
There is profound irony that each of these various PRISM protest sites thus far has used Google Analytics. While I have great respect and admiration for Google, Analytics and other centralization tools like it make the task of nefarious tracking dramatically easier, all to have a slightly easier to obtain visitor graph.
Kelo: Takings clause. (Fifth amendment, "http://en.wikipedia.org/wiki/Fifth_Amendment_to_the_United_S...). I would not be so hasty to decide that it's not "a threat to the US". It's a big deal as to what constitutes a "public use", by and large, urban complaints over gentrification are exacerbated because cities will declare whole neighborhoods "blighted" and then turn it over to a politically connected rich guy to bulldoze and flip for wealthier tenants. One might argue the kelo case just got a lot of attention because Suzette Kelo is a white woman. Another big eminent domain abuser is Walmart, which without eminent domain would have a much much harder time building massive box stores.

Arguably eminent domain abuse is more of a big deal than NSA wiretapping, it's something that has an impact, an disproportionate impact on the unwealthy and politically marginalized, and it happens in your backyard, all the time, for example: http://reason.com/reasontv/2007/11/15/national-city

As for myriad, I happen to be against patents in general, but my point was that the myriad lawyers really did a solid job of patenting genes. Despite my objection to patenting, given that it's constiutional and legal, I disagree with the SCOTUS decision, that the PCR product (cDNA or otherwise) is actually an artificial molecule by any reasonable definition of molecule and should be allowed to be patented. More subtly, I think it is Congress' responsibility to decide whether or not genes (in the fashion of myriad's patents) should be patentable. So it's an example of crafty lawyers (myriad's lawyers) extending their de jure power (using "composition of matter" patents to de facto become "gene" patents). And then the SCOTUS comes and creates this convoluted judgement about cDNA vs PCR, and introns versus no introns, which speaks to my point about how the court (probably not deliberately) works to incentivise legal cleverness, further justifying the existence of its own profession - possibly at the expense of society's broad interest in having a simpler legal code.
The title of the article is "A: like D, except it doesn't suck."
Housing has gotten cheaper for the actual cost of constructing the house, but other things have eaten up what could've otherwise been consumer surplus.
"will find that the database is the inevitable bottleneck that can't simply be scaled by putting machines in parallel"

In context, the alternatives available are something like:

1. Issue one recursive query
2. Issue many non-recursive queries
3. Use some kind of denormalized structure that is tuned to the one specific recursive query in question, but might perform badly on other queries.

#3 can work if you are focusing on the optimization of a single query and can pick a structure tuned to that one query. You can even parallelize it, because you can know the partitioning scheme that will work best for that one query. But outside of those constraints, or if the query profile changes over time, it does not work well. You end up needing to duplicate the data into many different structures to accommodate many different queries.

And I don't see how #2 has any advantage over #1 performance wise. Add caching layers or other performance hacks as needed.
Any evidence of this? I had read and posted about the same, but more recently found an older discussion on HN (which, absurdly, I cannot find now) which explains in more detail how the end to end encryption actually works and does so in a way that Apple almost definitely cannot intercept the plaintext messages.
I use Salt to run commands across our EC2 environment to do things like restart Varnish, clear logs, and run updates. Paired with Unison for file synchronization it works well when your auto-scaling kicks in and you need your new AMI to be synched from staging.
I want to offer a better metric: Scala is number 15 on GitHub.

Answering the question: Yes, it is.

- Scala is bringing the best combination of functional and OO programming to the masses.

- New languages out there are asked "how do you improve on Scala?", which is a huge change, considering that a few years ago Java was the main comparison target.

- Languages like Java or C# are adopting improvements from Scala, which shows that Scala seems to have done a lot things right.

The explanation of the bad rating on Tiobe is the search string being used by Tiobe:

Tiobe searches for phrases like "$LANG programming", but in Scala (and Haskell) the phrase "programming in $LANG" is much more common. Therefore, both languages suffer from a bad rating. People at Tiobe are aware of it, but it seems as if they don't plan to fix it.

Some other language communities started to modify their websites to cheat the index.
For example, the Delphi community went through all their documentation and blog and modified existing texts to read "Delphi programming" and gained a few positions afterwards.

Further info: http://blog.timbunce.org/2009/05/17/tiobe-index-is-being-gam...
Public beaches and their required-to-be-public access points presumably aren't private property, and I'd bet that those 'no parking' signs are on public property as well, given that the parking spaces themselves are apparently public.
> "Hundreds or thousands of people peacefully (and cleanly) making use of the public beaches in these "exclusive" areas for the entire summer. Keep it clean, civilized, respectable, don't leave trash behind and be considerate."

This is a nice idea, but I don't think it's at all possible. Looking at Occupy and other large protest movements in recent memory, none of them were really above reproach to this degree, at least not once they reached scale.

I still remember the SF Occupy camp. Civilized, respectable, clean, and considerate lasted about two days. You put 500 modern, young protesters on a beach and "clean, civilized, respectable, considerate" will be a distant memory.
> "... seats are laid out by a politically neutral Electoral Commission. There's no gerrymandering ..."

Would love to see this here in the states.
> we should be _very_ clear that puppet does a spectacularly bad job of solving a very ordinary problem that I have

Well, yes. If you want to use a tool for something it was _very_ clearly not created for, you're going to have a bad time.

If you had used even a few minutes reading about puppet, you would know about MCollective[1] which _can_ help you with these kinds of problems.

MCollective integrates pretty well with puppet and hiera, but there's nothing stopping you from using puppet + ansible for example.

1: http://docs.puppetlabs.com/mcollective/
SSH is secure. The configuration of SSH, and the system that it's running on, its operating system, accounts and applications, might not be. It all comes down to how secure you want to be.

There is a longer conversation that can be had to explain this. There are lots of mistakes one can make in managing a box with SSH that will easily lead to an account compromise, not even considering universal methods like 0-days, stack attacks, mitm, phishing, etc. The simplest defense to all these problems is a hardened VPN device on a separate network segment with separate authentication and strictly defined ACLs.

If you just run a personal VPS, I wouldn't worry about it. But if you ever start handling customer data, get serious about security and don't run SSH in the open.
Can you recommend a book on game dev for senior developers? IE I do not want to be hand-held through how to program, just the physics and concepts of good structure for game development.
This argument makes no sense. Why not paint the curb in front of your house red or yellow to discourage parking, then? Why not pop a few "free speech" stop signs on the road as part of a private traffic-calming initiative? Why not leave it up to the informed motorist to figure out whether the curb is painted red for a safety reason or merely because the homeowner is a jackass?

Trying to enforce one's will over public property and public behavior with misleading, official-looking signs is scarcely any better than impersonating a police officer for the same effect--it's just a matter of degree.
Founder of https://commando.io here. We are a web based interface for doing remote executions via SSH. Our approach is a beautiful web interface with no external dependencies (agents). Salt and Ansible are amazing, but they still have a bit of a learning curve and setup "costs". Our target market also tends to be less technically proficient, and thus not willing to dive into more robust solutions. Think cPanel for operations. SandBOx, if you'd like to try out Commando.io, let me know, and I'll get you a private beta invite.
IPad web usage increases
Seems like a hacker could exploit that to bootstrap in a loader.
Ah yes. I remember in 2005 some friends and I hung out at Carbon Beach in front of David Geffen's house soon after he lost a court battle... https://en.wikipedia.org/wiki/David_Geffen#Court_battles

edit: photo http://i.imgur.com/zCQEfZY.jpg
Problem: Surveillance of all internet activity by a third party is bad!

Solution: Inject third party JavaScript into as many websites as possible!
Security and coding issues aside, the point of this is unclear to me. If the U.S. (or any) government is going to collect and analyze personal data, they're going to do it, and good luck stopping them through voting, protests, etc. The best way to advocate privacy is to provide technology that makes the data difficult to analyze. Outside the technology industry, very few know or (surprisingly) care if their information is encrypted when providing it.
First thoughts:

1) NSA’s PRISM logo is hideous and it’s copyrighted. You might want to create your own graphics.

2) Add an explanation of what PRISM is and how people can help fight it. For instance, link to a template letter for people to send to their representative.

3) You should create a page that generates a list of all participating websites. That gives websites some incentive to join.
No. Amazon is famous for seeking out low-margin businesses; that's what attracted them about AWS as a business. Walmart is another example.