obsession

Now that we are on the topic of prepared statements, does anyone know how to do "SELECT * FROM WHERE x IN (list of values...)" properly? As far as I know, you cannot do it with prepared statements (as they can only be single values) and you are forced to roll your own escaping mechanism.

Considering how much time I already spend on Hacker News, I certainly wouldn't want any notifications popping up.

I believe it's your phone. The emojis are unicode after all. 😁

Interesting, I'll have to take a look.

While doing single restore is fast enough, you will have problems doing multiple restores in a row as the background process needs to finish before another restore is possible (which may take several seconds when you are dealing with big databases).

Yes, Stellar will probably trip over this. Similarly, if the attacker can edit stellar.yaml, they probably can edit your .bashrc as well.

Im adding this to my TODO list.

MySQL support was definitely an afterthought and could probably be improved (maybe tracking the binary files directly?).

I have regularly used this with database that's nearing 1000 megabytes. I don't particularly mind slow snapshotting because my workflow is more about restoring database back to baseline than taking copies.

Please don't use this for production. It is not stable enough and you only end up with lost data.

Transaction is only reverted if the migration fails. Stellar helps you if your migration succeeds but does the wrong thing (deleting wrong column, missing WHERE in UPDATE statement).

I have heard lots of good about interval training. I remember Freakonomics podcast mentioning it being the most effective exercise versus time spent.

Wow, this is really neat!

I think these services could use timed release. If you have locked yourself out, the timer starts running. If after 30 days no one has denied the request, access is granted. I'm pretty sure this approach would foil most if not all social engineering.

Even if you were a shady drug dealer, revenge doesn't get your money back.

This is a good redesign but I wish they put more focus on developing Github Issues. The back button doesn't work (old issues randomly show) and filtering needs work (for example, how can I show issues from two milestones? how about showing issues with no comments? etc.).

Where can I donate?

This is so horrifying to read. Is there anything we can do to help?

I really hate these kinds of benchmarks. No-one will ever have jQuery as a bottleneck on their application.

Yeah. I really would like to see a version of HN where there are no arbitrary penalties applied.

Does anyone know a way to contact BlackBerry World? Somebody copied my html5 game and is making money from it. It's been two years and my DMCA requests have been ignored. I have both tried email and Twitter.

http://appworld.blackberry.com/webstore/content/41515/?count... (The same author has several other ripoffs as well)

What do need my full name for?

Have you used pgAdmin? It certainly does everything but it's user interface is too horrific for any simple tasks (like viewing rows or filtering by column etc.)

It worked for Instagram.

I wonder if the move to create Google Chrome was a due to a concern that Firefox would disturb Google's ad-serving business some day.

Google has killed APIs before. Examples include Google Translate and private weather API.

Github has 99.9585% uptime past month. That's like 22 minutes of downtime per month.

This is an perfect example on how not to do url validation. I tried it on http://hs.fi (Helsingin sanomat, Finnish news magazine) but the site says it is an invalid URL.

After being banned from Google Adsense (I still don't know the reason why) I have used Adbrite as an alternative. It's no surprise they are shutting down. The ads they deliver are borderline suspicious and they don't make publishers any money at all. I have earned $0.07 with Adbrite whereas I could have earned $60 in the same time frame with Google Adsense.

Does anyone know good alternatives?

I don't host anything sensitive on the cloud but this makes me think twice before using Linode or Amazon. It's a shame really. I don't know any cloud services that don't have any American presence.

This was surprisingly fun to do. Adding just one cell in the right place destroyed the whole metagame.

I don't think Javascript tricks work very well against motivated spammers. It is trivial to use headless WebKit client to execute Javascript and ajax requests.