obsession
|
8 years ago
|
on: Bobby Tables
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.
obsession
|
10 years ago
|
on: Get notified whenever there’s a new top post on Hacker News
Considering how much time I already spend on Hacker News, I certainly wouldn't want any notifications popping up.
obsession
|
11 years ago
|
on: 6.0 Northern California earthquake
I believe it's your phone. The emojis are unicode after all. 😁
obsession
|
11 years ago
|
on: Show HN: Stellar – Git for PostreSQL and MySQL
Interesting, I'll have to take a look.
obsession
|
11 years ago
|
on: Show HN: Stellar – Git for PostreSQL and MySQL
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).
obsession
|
11 years ago
|
on: Show HN: Stellar – Git for PostreSQL and MySQL
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.
obsession
|
11 years ago
|
on: Show HN: Stellar – Git for PostreSQL and MySQL
MySQL support was definitely an afterthought and could probably be improved (maybe tracking the binary files directly?).
obsession
|
11 years ago
|
on: Show HN: Stellar – Git for PostreSQL and MySQL
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.
obsession
|
11 years ago
|
on: Show HN: Stellar – Git for PostreSQL and MySQL
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).
obsession
|
11 years ago
|
on: Repeated six-second bursts of exercise 'can transform health'
I have heard lots of good about interval training. I remember Freakonomics podcast mentioning it being the most effective exercise versus time spent.
obsession
|
11 years ago
|
on: Show HN: Pangoly – Build your shiny new PC
Wow, this is really neat!
obsession
|
12 years ago
|
on: Security Hole in Sendgrid
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.
obsession
|
12 years ago
|
on: New message from Mt. Gox
Even if you were a shady drug dealer, revenge doesn't get your money back.
obsession
|
12 years ago
|
on: Redesigned Conversations
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.).
obsession
|
12 years ago
|
on: If Immunity Project (YC W14) succeeds, they'll offer AIDS vaccine for free
Where can I donate?
obsession
|
12 years ago
|
on: The Workers Who Bring You Black Friday
This is so horrifying to read. Is there anything we can do to help?
obsession
|
12 years ago
|
on: Tell HN: jQuery is way slower than plain Javascript
I really hate these kinds of benchmarks. No-one will ever have jQuery as a bottleneck on their application.
obsession
|
12 years ago
|
on: How Hacker News ranking really works: scoring, controversy, and penalties
Yeah. I really would like to see a version of HN where there are no arbitrary penalties applied.
obsession
|
12 years ago
|
on: 120,000 Apps in BlackBerry World, 47,000 by one developer
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)
obsession
|
12 years ago
|
on: Show HN: Web service for monitoring web pages (weekend project)
What do need my full name for?
