skysight-inc/HackerNews huggingface dataset:
> Column names not parameterizeable in prepared statements.

You should still use prepared statements for these types of queries as more than likely they will have parameters as well. You might end up with a couple more SQL statements in you statement cache but that should be a non-issue and if anything be faster, not slower.

> Thus, you will need to do input sanitization in this case.

If you're dynamically sorting based on user input then you shouldn't sanitize the input, you should white list it. If you're using an RDBMS then there's a fixed, finite, set of columns the user can sort on that you can check against.

Sanitizing fields for sorting (or even querying) is more important for NoSQL databases as the interface is programmatic. MongoDB is a good (bad?) example as it interprets strings as commands so; you have to go out of your way to escape inputs even though you're programmatically using them as field names.
Sounds interesting, but it might be an idea to install Google Analytics (or anything similar) to see if there is really significant traffic coming from AT&T in the first place before going to this trouble.
20 TB per day is nothing these days.
there is respect even between enemies. if his religion is anti religious, then he should respect them even more because they are his opponents. taking your enemies lightly is reckless.
In my experience? Exactly 0% of ISPs are strict IPv6-only. That doesn't mean there isn't one anywhere, we don't have millions of users throughout the continent, mostly Taiwan and (to a lesser extent) China. But we've yet to find one.

When I say the issue has not arisen, I mean it. We have two infrastructures, one is basically 8 years old, the other is about three. At the time the latter was setup, our provider wasn't even ready to deploy IPv6 widely, they were still learning and testing with a handful of select customers.

Both legacy and modern run solely on IPv4, and we've not had cause to revisit the issue.

When we get reports of network problems not attributable to simple user error, the cause is almost always either misconfigured routers breaking path MTU discovery, or ridiculously strict firewall rules that don't even allow port 443 out.

I don't even know how many of our users have IPv6 at all. I have no reason to know nor any good way to measure it short of calling all the ISPs or sending people to our customer's homes to check.
>Also I doubt the veracity of the claim that they collect "nearly everything". Wouldn't they show up on, say, Sandvine's Internet traffic reports?

Why would they? They deal with ISPs, backbones and such.
Beware of bugs in the above code; I have only proved it correct, not tried it.

-- Don Knuth
I checked out psd-tools and it's good. Any chance of you adding their features to yours or vice versa? I know I know, I should do it myself and do a pull request, but just asking if you are planning to?
If they are not nationals, they are illegals.

If it's not a very long sentence, OP is better off trying that after he's done with it. Maybe ask for asylum, but afterwards.
Imagine if the American people weren't holding back the NSA.

Oh, wait...
Ask HN: Can Stripe Be Used for Crowdfunding Sites? Amazon Banned Me for Asking
I'm working on a crowdfunding site (similar to Kickstarter and Indiegogo, but with a different model) and I'm wondering if Stripe's terms of service would allow it's use for crowdfunding?

The reason I'm a bit reluctant to just ask their customer support is that I was just "permanently banned" from Amazon Payments for simply asking their customer support if it was an acceptable usage.

Also, any other options out there? Last I heard Paypal doesn't allow donations or payments for a product or service that does not yet exist.
i said not jail, but outcast, until he learns to respect other cultures. then he is welcome again. that is 100 times better than jail.
You insulted him by showing apathy towards his religiously held beliefs for a just law and proportionate punishment for the crime and his dislike for mob justice as you proposed in your earlier post.

----

icebraining, I couldn't have used better words than those.
If you want to learn more, I'd suggest at first reading (or at least skimming) Bjarne Stroustrup's "The C++ programming language".

Also, the C++ FAQ http://www.parashift.com/c++-faq/ is useful for getting an overview on the corner cases of C++.

After which you should visit its inverse, the C++ FQA (frequently questioned answers, i.e. an anti-C++ answer to the FAQ) http://www.yosefk.com/c++fqa/ to learn why no-one in their right mind would ever use C++.

That won't teach you C++ per se, but would give you a useful look at the breadth of the language and how and why things happen the way they do.
XKeyscore presentation from 2008 – read in full
Just like suspected. If you use encryption like PGP, you become person of interest.
Snowden deserves the Nobel Peace Prize and the Vatican should consider canonizing him.
I hope you don't mean for the students themselves. I live in NYC and know at least two people who don't have a connection at home... I'm sure there are thousands more.

Most (if not all) of our public libraries have Wi-Fi, but at any given location you're more likely to be near a Starbucks than a library.
Hmm spend time in a civilized nation's prison or 3rd world prison... doesn't seem hard to decide.

(Insert joke about not sure if the .au prison is the civilized one or the 3rd world one ... oh oh look what I just said, now I'm about to be sharing a cell with OP)

This goes double for the Norway comparison... whats the worst thing they can do to you in a Norway prison, serve lutefisk for dinner?
Not GER, it's GBR as in Great Britain

http://en.wikipedia.org/wiki/UKUSA_Agreement
It seems like a joke , but then kinda doesn't... 2 stars.
I'm pretty sure that's actually GBR - Great Britain.
I am a secular humanist. As part of my faith, I believe that human beings have an inalienable right to freedom of speech without fear of persecution. I find your advocation of outcasting from society those who say things that you find offensive as offensive as you would find a Quran being flushed down a toilet. There's the door.
How is performance per watt? I mean, that's mainly what makes older Atom boards interesting, isn't it?
Rightmove have a new API in private beta (they call it the Real-Time Data Feed).

I called them to complain about the lack of an API, and they said there was a project in the works... so we got ourselves access to test out in their sandbox.

The app will be paid for by agents on monthly subscriptions. We're testing out pricing now (we're close to settling at £45 per branch, per month).

A 'How it works' section is coming; video should be up by the end of the week, with better screen shots the following week. Thanks for helping to name the section. :)

I get what you're saying about the opening page. Would you like a paragraph, more screenshots in the 'phone', a illustration, or something else?

Thanks so much for commenting.

Rayhan
Psychotherapy via Internet found as good as or better than face-to-face
Honest question... what is he purpose of such a rally?
I'm not sure having a synchronous 1Gbps connection really counts as "usually" in most of the world, but I guess in that case you'd want to avoid wifi to get the best out of it.

For the rest of us, wifi is far from the bottleneck. I'm currently working from a holiday home in the country where I'm sharing 2Mbps down with 4 other houses.
True, this also works.
I don't think cold dating one-on-one is rarely a good idea: try the group dating options so people can get to know you by conversation and interests. Something like https://www.joingrouper.com maybe (not affiliated nor have I tried it)
He can leave any time he wants for a cafe, a conference room, or even take a drive and go home for the day...If he wants to spend the whole day playing video games, he can.

Why do you think a developer can't do these things?

I don't disagree that there are power dynamics and office politics. They are just orthogonal to the seating arrangement.

I've occasionally wondered if it might be better if there were outward signs of power. At the very least, it would give us apolitical developers a visual clue that ignoring or talking down to person X might be something to avoid.
Pandacodium - A free worldwide online hackathon with great prizes
So far their firmware isn't open source. Tianocore isn't useful on real x86 hardware without hardware initialization code (which Tiano doesn't provide).

Let's see if an Intel group manages to coerce the chipset group to release those "precious" (but in reality, very boring) details on memory initialization to the world.

So far I'm doubtful, even if it's "just" for Atom.

[edit: In fact, their website (http://www.minnowboard.org/technical-features/) states "All software will be provided in image and Open Source form (with binary elements per IP restrictions)". That exception _will_ cover Platform Initialization code...]
Go produces a statically linked compiled binary.
How to save money by making stuff with 3D printers
It doesn't matter why the cable is $40, just that you need a $40 cable to use a $300 dock.
How is there 8x more space to fill on the iPad compared to the iPhone? 768*1024/320/568 ~= 4.3x.
Only those that come by boat. Many many more asylum seekers come by plane which is not such a problem. Detaining boat people is meant to deter others risking their lives the same way.
I do similar things, but also as part of getting new people into mountain biking and building new, legal, open-to-bikes trails. It's pretty amazing the diversity of people that I've ended up friends and acquaintances with; people who I wouldn't hesitate to call up (or hesitate if they called me) looking for some professional help.
If you break unjust laws there is no reason to accept whatever punishment the law mandates. In fact, I'd argue that the right thing to do is to not forfeit your freedom. Note that OP wasn't posting to escape punishment. He was asking for advice on keeping the site alive.

Also, and perhaps more importantly, someone is about to be imprisoned for a lengthy period for exercising free speech.
Usually the slowest part of the connection is 3G (or worse 2G) via a tether or dongle. Wifi is an order of magnitude more
As someone raised where I was raised, I agree with you.

As someone firmly rooted in reality - I can't. When we participate in a community (be it religious or otherwise, be it of our own informed choice or not) we are bound by the rules of that community. When we knowingly break the rules of that community, we implicitly accept the potential consequences.

No matter how petty or offensive it seems that insulting a religion is grounds for imprisonment -- within the context of that community this is not something up for debate.

You say that the religion's rules "should not be" part of the rules that run a country. Maybe to your view and mine, this is true - but to the view of a sufficient number of people who actually make up that community, this is not true.

If enough people question it, then the rules of the community will change. But unfortunately, such change will require a critical mass of people breaking those rules - and being willing accept the consequences.

And unfortunately, it's that simple.
It definitely is; look at the actual (hi-res) presentation: http://www.theguardian.com/world/interactive/2013/jul/31/nsa...
You will definitively feel weaker and be unable to work out as hard. Even a days worth of poorly timed meals and/or too little protein can mess my weight lifting up for the following day, and fasting quickly forces my lifting volume down substantially (though amino acids from your protein intake can stay in your blood stream for a few days, so if you've kept protein intake high, you can keep things normal through a couple of days of fasting).

But the main predictor of how quickly you'll recover your strength afterwards will be whether or not you keep up resistance exercise. After a weak of lazing about during vacation, it can take me 2-3 weeks of hard exercise to be back at my peak. After eating too little or fasting for a short while, it's mostly just a matter of getting well fed enough again. I don't have experience with longer fasts, so I can't say how much they'd affect me, but it does take time to trigger substantial muscle breakdown, and even if you do lose muscle, getting back up to the same strength is much quicker.
Fuck religion; the lack of existence of any kind of deity can be proven with etymology
Not sure if this is the case...
http://www.cnn.com/2013/07/31/world/meast/saudi-blogger-sent...
mmh... but maybe the military is also ahead in that area? Maybe DARPA has 1TB GB/s drives?
The Optimistic Case on a theoretical Snowden Trial
That's one of the stupidest things I've ever read.
This is actually OP's case. About page from his startup: http://zuupy.com/about/
Also depending on the country you're in, keep in mind that you might be marked as suspicious for visiting a foreign embassy. Perhaps send a friend or someone to do the advice getting and only go when you have solid advice from a professional diplomat or embassy staffer that recommends that you do so.
Slick site.
This is overwhelming. Even when you always hear the claims about we knew this was going on, somehow it is still shocking when you see it all laid out infront of you with screenshots and the capabilities described.

I can see how they get HTTP information, since they would intercept at transit hubs - but how are they getting all Facebook private messages and Gmail?

I was also looking for another unique ID that users are identified by - perhaps a machine or browser fingerprint or some form of intel that can 'glue' different browsers together and make a best guess if they are the same person (Facebook does this with device and user cookies) but couldn't find anything. It seems they rely solely on email addresses, IP addresses, cookies and HTTP headers.

So if you are browsing via 16 tor circuits and a browser that defaults to incognito with session histories being wiped, they couldn't reconstruct your history.

Users of PGP/encryption products being singled out is terrifying. The sooner we have the whole world using decent encryption tools, the better.

Edit: Gmail messages must only be captured when they leave the Google network. They are the only provider to support server-to-server TLS: https://twitter.com/ashk4n/status/346807239002169344/photo/1

They must only be getting a slice of the Facebook chat data, since the transport there is also https.

Facebook Messenger, on the other hand, uses MQTT, so it transmits and stores in plaintext. It has support for encrypted + signed messages with OTR if you are using an alternate client such as Adium or Pidgin.

Really need to go out an audit all of these services and let users know which are better.
You need to take ppi into account. The iPhone has more screen density.
Programming is expressing what you want. It's much easier to express yourself using language than by drawing. Democratizing programming by removing coding is just like democratizing literature by replacing all the words with pictures.
What does this even mean? Google provides the leased line to the store? The store obtains an Internet connection the normal way, but then tunnels to Google? Or is Google's level of involvement that they have paid for an ad in the SSID?

Google Fiber is a nice business opportunity for them, but that requires infrastructure. This comes with none of that. It's not even a precursor to Google Fiber rollout. Either they are getting a similar-quality leased line to _one_ place, or it's just an ad. And even if the Starbucks uplink is "Google Fiber", the wireless connection itself will be a huge bottleneck, as it always is when you have more than around five devices communicating at once.
It's still completely infeasible without better tools for doing it automatically.
with this, can I print money bills?
Slide 6 of the presentation clearly shows that pretty much every government is in on the program, with heavy concentration in western Europe.

One question, how did the dot in China get there?

http://www.theguardian.com/world/interactive/2013/jul/31/nsa...
From the slides
http://www.theguardian.com/world/interactive/2013/jul/31/nsa...

"Show me all the VPN startups in country X, and give me the data so I can decrypt and discover the users"

Does this mean using VPN is not very safe from dragnet?
>To get a revolution the government would have to start to starve people.

That's like the naive marxist notion that it's all about the economy. People have revolted without being starved and people have starved without revolting. Culture, patriotism, hummiliation, religion, and tons of other factors come into play.

>Technology is a force multiplier.

Yes, and if the government is allowed to have 10 times the force of regular citizens, then the government ends with 10multipler power using technology, where the people with just 1multiplier. That's why technology is not a solution.

>Moreover, technology shapes the environment we live in. We can all see that groups of people behave like water. They do what they have always done

The last 3000 years of history show great shifts of power, strikes, revolts, changes in government and culture etc. And the 2400 of them (e.g 1600 AD and before) are not even related with any great changes in technology.

Of course if people are convinced that they "behave like water", they will behave like water.

But that's not what history shows they did (and do).
Only Muslims from eastern countries(India, Pak, Malaysia(duh), etc. consider it offensive. From purely legal POV, there is no precedence from authentic Islamic history on people being punished for eating in front of fasting Muslims. On the contrary, there are a number of precedences where fasting Muslims were offered food, and they would refuse saying "I am fasting" and the other people(Muslims and non Muslims) would simply continue eating.

From religious POV, a fasting Muslim actually gets reward when others are eating in front of them.
Whose land? He probably couldn't find legal work anywhere in the world.
Assume that Tor is broken. With this level of deep network monitoring, low-latency onion routing is essentially useless.
Thank god. As someone who routinely visits coffee shops to help maintain some semblance of sanity as I work from home most of the time, entering a nearly full Starbucks almost always means the internet will be sluggish. Hopefully this means I can actually stream music and work at the same time now.
Holy shit... Apparently, the only way to ensure privacy is to go Stallman. Funny how yesterday's "conspiracy crackpot" became today's visionary.
you shouldn't sanitize the input, you should white list it

I think of sanitizing user input as including white listing.
Sucks that the vast majority of Americans don't give a shit.
If you haven't done any design/development for iPad, it is a very different experience from that of the iPhone. I think Jack does a pretty good job of explaining that difference here. You really can't approach it with the mindset of "Just scale everything up!"

> When I go the ‘My Trips’ tab I’m hit with marketing modules telling me about fare specials and the glory of the Delta Sky Club. These have nothing to do with My Trips.

Although I agree that it feels like they originated in the marketing department, I don't agree that they have nothing to do with My Trips. If you don't have any trips, you would need to book one to interact with that section of the app. Fare specials serve as a call-to-action to do that. Also, note that these modules change based on the logged in user.

There are far better examples of "filling space for the sake of filling space" in the store.

Disclosure: I know the team that worked on the app; I worked on its iPhone counterpart.
Amazing.

It's great to know that you are simply not safe if you are using pure HTTP for anything.

They even automatically scan sent Office documents, VPN traffic and so on. Crazy.
All of this feels like a bit of stunt-ism to me. Encouraging behavior in humans that is fundamentally bad for us.
Thanks for the tip on Quick File Creator. I'm a pretty heavy Sublime Text user and that just solved a pain point for me.

Another one that's useful for me in web-related work and not specific to any particular language is the Web Encoders plugin: https://github.com/revolunet/sublimetext-web-encoders -- I often use it when I need to test URL encoding/decoding stuff.
The $ and # of VC: founders, size, stages, type of investments
And look at slide 17:

"Show me all VPN startups in country X, and give me data so I can decrypt and discover users."

Holy crap. Is all encryption broken?
You have to admit these guys are working on some cool problems. If you don't have a problem with the legality of it or potential for misuse it looks like a really interesting place to work.
I don't remember to ever read an article about DOS or Windows or Linux fragmentation...

In other news, "DOS vs. VMS fragmentation", Only 5% of PC are manufactured by IBM, Digital manages to capture 100% of the VMS market!
Offending a religion is just pissing a bunch of people off. So instead of one person that needs to grow up its a whole bunch of them.

Difference in degree, not in kind.
Another data point on the relationship between government and terrorism:

I live in Columbia, South Carolina. A mile from my house there is a prominent statue of Ben Tillman. Tillman was an explicit advocate of terrorism, and indeed personally engaged in it [1], which drove his popularity and ensured his election to the governorship and the United States Senate.

Government programs such as the NSA's exist to protect the interests of the powerful. Same as it ever was.

http://en.wikipedia.org/wiki/Benjamin_Tillman
I recognize the fact that there are countries with quite a few frustrated people that would like nothing better than to be able to control the rest of their fellow human beings and to tell them how to live and that in such countries one could easily get in trouble with the law for behavior that is perfectly ordinary elsewhere.

My way of dealing with that is to refuse to do business with places that are set up like that. It seems to be the easiest way to deal with this problem, then I don't need to wonder what to say/do/not say/not do in order to avoid giving offense to someone with an ax to grind.

There are countries where it is illegal to write certain words, paint pictures, teach women, get an education, complain that you've been raped and so on. The list is long and makes for very sad reading because it shows us how far we as humanity still have to go to get to a more enlightened level. Some people would happily revert to the stone age if that meant that their bearded invisible friend gets to call the shots.

In the end, it's all just little people wrecking it for the rest of us, and this makes me slightly sad that I'm an atheist and not a Roman Catholic because then I'd be confident that all these little men (the pope included) would one day burn in hell.
Those are the Five Eyes countries: http://en.wikipedia.org/wiki/Five_Eyes
What lower prices? I pay off my credit card every month, and therefore pay nothing ever. Reward points are icing on the cake, all of these are pulled out from Merchant transaction fees.

Have you ever looked at what you're paying for in a credit card? Basically nothing. The merchant pays for everything. (occasionally, the merchant passes back the savings to you... like the occasional gas station that doesn't take credit cards, or a store that only accepts credit cards on purchases over $5)

Consumers pay damn near nothing on credit cards. That is why they use them.
Can you flee the country?
You have a CTO co-founder (http://zuupy.com/about/), is he going to jail as well?
Ex-Facebookers Feed Zuck’s Code Into New Data Revolution
Are you in Singapore? This doesn't make sense - you say you live in a Muslim country? I know Singapore is socially strict, but I thought it was secular.

Singapore is big on social harmony. There are laws against offending other cultures and anything considered pornography is illegal. But I think he's in trouble in Malaysia.