skysight-inc/HackerNews huggingface dataset:
MySQL is a fine DB for most cases. There are some specific features it lacks that do make it annoying (and make Postgres a better choice):

1. Indexes are too simplistic. You can't index the output of a function.

2. InnoDB lacks full text search. MyISAM has it, but MyISAM is bad since it doesn't support transactions.

3. Unicode support by default does not support all Unicode characters. That's right, even though it says UTF-8, not everything is supported, and you have to specifically enable support for some character subsets for your DB.

4. MySQL replication is... how should I put it? Delicate. There is no integrity checking, and since by default it's just replaying an SQL log you can easily get inconsistencies between the master and the slave. There are lots of ways to confuse replication, such as `INSERT INTO my_table (foo) VALUES (RAND())`. There are no built-in tools for integrity checking the slave, and the third party tools that exist have to resort to some really crazy things, like re-inserting tables. I could go on about replication, and its issues for a while, but I want to move on to the other points.

5. No transactional DDL. This really sucks when using with something like Django migrations.

6. No point in time backups. You either use mysqldump with a transaction (you aren't using MyISAM, right?), or you stop the database server.

7. Logs suck. No, really, have you tried debugging an issue with your queries, deadlocks, configuration errors, etc.? MySQL's server logs (not query logs), are not very verbose, and what the do write is mostly useless.

8. Row level locking semantics are at times doing unexpected things. Last time I used MySQL for complex real time write-heavy stuff, I actually moved to advisory locks instead (the support for which is not exactly great in MySQL and could be expanded). This invites contention, deadlocks, and other nastiness where it isn't necessary.

9. No IPv6 support.

10. Can't index Archive engine tables.

11. Can't partition tables by any arbitrary value. It has to be only specific types which makes it too restrictive.

12. GIS support is not really there. Lots of basic features aren't supported.

13. No materialized views. You can simulate it with triggers, but that's not nearly as convenient.

14. No async drivers.

Note that these are very specific features. If you don't use them, good for you. No reason to switch away from MySQL just because. It has some advantages over Postgres as well:

1. Simple user management.

2. Simple database management. No schemas, objects, etc., just tables and views here.

3. INSERT IGNORE and REPLACE! You don't need to create triggers for these.

4. Decent performance out of the box, and lots of knobs to turn when tuning.

5. Generally, doesn't require a ton of setup time. Install it, create user and DB and code away (Postgres and lots of others have this too, but it is a good feature).

6. Large amount of community brain share, so you won't be braving a new world here.

So, basically, go ahead and use it if it works, but I'd say Postgres deserves a try too and your 4 points apply to it equally as well.
DBMS Comparison
>I believe they only use it for detecting rough location of all visitors which is perfect to determine the lengths of lines at rides or to find where a lost kid is in the parks.

Also, I imagine to determine if the guest is still in the park and if so which park, what part, or which restaurant, etc even if the guest is not swiping any RFID readers. I also think they probably have issues with people hiding in the park after closing and such and I'm sure this helps security find people who do this. Confused elderly person comes to mind as well.

I wonder if this system extends to places like Downtown Disney or Disney Boardwalk and the hotels? Then it becomes a scary privacy issue when its just not theme park goer management, but something that extends beyond the theme park's gates.

>This is perfect for knowing crowd density in an area and estimating line lengths for outdoor areas

Accurate density metrics and tracking of crowds must be invaluable. I bet Disney sits on lots of interesting data. I wonder if people migrate to certain types of rides at certain parts of the day or which rides they ride first. Or how these changes when you have younger or older kids, etc.

I also prefer wearing one of these than giving up my thumbprint, which is the current system. That's always made me nervous. I'm sure its stored forever in some database which is trivially tapped by other organizations.
Use Mechanical Turk with Python and Boto to Crowdsource Tasks
Android is a odd one. Google bought it, and until recently it pretty much acted as a separate fief to Google.

Chrome(OS) on the other hand was, i think, started as one employee's personal project. Likely based on a observation that many of us spend our days mainly using a web browser, with the rest of the OS sitting idle around it.
I figured as much. I have never seen it mentioned in the press. I farm, which is probably the only reason I was made aware of it. I found this government document[1] that touches on the issues, although it appears to be a little dated.

[1] http://www.hc-sc.gc.ca/cps-spc/pubs/pest/_fact-fiche/pollina...
Creativity is here to stay
Yes, that is precisely what I mean. I should have been clearer. Ideally if a copy operation involved busy devices that would be the only time they would queue, but I would settle for a background processing queue that prevented long-running operations from running concurrently. I've never seen anything smart enough to base 'concurrent or not' off of what device a piece of the filesystem is on though, so I'll give that a pass. I'd also really like a file manager that had a little daemon (or interacted with an rsync daemon or such already running) on boxes over the network so when I say 'copy from network share A to share B' the data never has to transit my desktop but goes directly from A to B. I think about file manager a lot. I have a long wishlist...
The colonies that would become the US had more land-per-person in a late-agrarian, almost-early-industrial economy, versus Europe having far less land-per-(white)-person.
PayPal Establishes New Security Center
Just a side note to add about scanning the wristband for a ride's fastpass line or entry into a park: it's a two step process where you put a finger on a finger print scanner and then move on to scanning the wristband. If both are successful, you're let in.

Oddly enough, the fidelity of the fingerprint scans wasn't high enough to read 2 of our party's members, so it was an slightly annoying process having to wait for a supervisor to come over and officially clear them.

The process was seemless for the rest of the party (i.e. 10 people).
What's the minimum level of frustration that justifies this kind of thing.
Ember.js drag and drop file upload – the right(ish) way
I'm afraid it's gonna be very slow due to LUKS encryption and lack of support for it in the CPU.

Does anybody seen any benchmarks?
Endohumans- App that revolutionizes fitness gaming – Indiegogo
I understand the concept of the article, a USB device that will fry your laptop by charging and applying high voltage.

But I don't understand the excerpt about the guy writing number 129 on a USB stick and stuff. Why would he plug it in his laptop if he knew it would burn it? And if it was intential, aren't there easier ways to burn it? Thanks for explaining...
Just to be clear, there was never any kind of vote on any of these spying programs.

The citizens never asked for this intrusion and would likely have resisted if they had been, so it was executed in secret, and would have remained a complete secret if not for Snowden.

Nobody has even tried to "craft a message that appeals to the public" until AFTER the fact, when their overreach had been exposed.

A democracy generally works by citizens' issue A going to politicians B and being passed after debate to agency C which effects action D; in our situation currently the NSA has decided that it is in the best interest of itself to effect surveillance. It isn't democracy in action no matter how you attempt to spin it.
Show HN: Building @SouthBotFunWest, a Twitterbot That Recommends SXSW Parties
Who says that they have to be taken like dogma? Sometimes the one-liners are just easy to remember. Often they are funny. They can be a great tool to quickly illustrate a point or start a conversation.

The one liners can never replace a conversation or explanation. They cannot replace common sense or real knowlege. I would never treat them as laws or follow them by the letter...
If it gets to the point where someone is hacking into my personal communications I no longer am interested in conversing that person. Our differences are too fundamental for a conversation to be productive. My interests at this point are seeing that this person is stripped of power and brought to justice (the knowledgeable members of the NSA should be put in jail, just as any other group conspiring to commit a felony would be). No conversation is going to result in them agreeing that they should be stripped of power and jailed, so discussion is pointless.

The discussions I'm having are not with members of the NSA, they're with other people who might potentially be able to help at least prevent further criminal activity by the NSA.
How to Unlock LG Leon Using Unlock Codes
Guys check this out, if you can please support us!

A seemingly common app that tracks your runs soon turns out to be the beginning of a great adventure

The IDEA
Smartphones and fitness bands and fitness trackers are all over the place as technology companies have quickly realised that there is a large interest and market for such products. The release of countless fitness bands and smartwatches as well as the upcoming Apple Watch have increased the hype and momentum.
I love how grudging this is. It's like when someone apologizes for you feeling a certain way, rather than for what they did. Half the "code" is claiming that nothing is wrong and the kernel is perfect because reasons, and the TAB is 80% white guys. Isn't meritocracy perfect?

On the other hand, this is a step in the right direction and I'm not a kernel developer, so I shouldn't nit pick too much.
I see no way that this is different than using your cc. You can delegate spending privs as you like. Just to yourself, just to adults, etc, and there's a PIN attached. If you can't budget correctly, that's not the problem of mobile payment systems. Personally I can't see the difference between this and credit cards.

If anything, mobile payment systems tend to be more accounting friendly. I can pop open my last google wallet purchases trivially. My credit card requires logging into a website or using a fairly crappy mobile app that's often not updated quickly with my most recent purchases.
OT but, on Chrome and Firefox on FreeBSD, all the images and most of the text have the opacity of the images set to zero in their CSS and I can only see a couple of headlines. I presume their javascript is not detecting something correctly and not doing this right. Interesting. I've never seen that before.

EDIT: I just now noticed that the link above goes to /macbook/ but, if you go to the Apple site and click on Mac, the pathname is /mac/ and now I can see and read everything. Also interesting.

EDIT2: Ah but the Macbook link still doesn't show everything.
How come people jump all over themselves to justify Torvalds' attitude but nobody speaks up to defend Stallman eating stuff off his feet.
I suspect that the Starfighter crew's answer around this is twofold:

1) Of course there will always be other ways to get technical work. You needn't feel compelled to use their product unless you think the time input is worth the reward.

2) If they haven't made the process fun, that is something you want to spend your valuable free time on, they have failed (at least in acquiring you as a product).
link: http://www.cryptonomicon.com/beginning.html

The metaphorical comparison between the operating systems is one I'll never forget.
I've seen lots of articles written by people who benefit from it in benchmarks of software of varying realism. They don't work for Intel.
"You will use real technology. You will build real systems. You will face the real problems faced by the world’s best programmers building the world’s most important pieces of software. You will conquer those problems. You will prove yourself equal to the very best. Becoming a top Starfighter player is a direct path to receiving lucrative job offers from the best tech companies in the world, because you’ll have proven beyond a shadow of a doubt that you can do the work these companies need done."

What an absolute waste of time. You can do all of those things as hobby projects which are yours and actually do something useful in the world besides exist as an achievement to be unlocked.

Show your future employer your github, not your starfighter score.
I made the switch from MySQL to PostgreSQL last year. The learning curve between the two is small and you'll probably find yourself liking PG more.

Even if you don't, give it a chance.
As far as I understand, this is the public release of the issue that caused the bigger providers to force the reboots on their customers. This means that there won't be any more reboots (for these issues at least)
First to ditch wired network connector. Pain in the arse.
Does disk encryption on an SD card cause write amplification at all?

I've killed two decent genuine Sandisk SD cards already in under a year and would worry that this would blast them even quicker even if it is desirable to encrypt the disks.
One doesn't have to take something literally to feel like is hostile and aggressive.
It is worth noting that the S-1 listed one shareholder (among 10 or so individuals) who owned 10 bp of stock. Facebook thought that was worthy of disclosure. Like the commentator above, I'm highly skeptical that employee #100 got 10 bp stock (unless it was matching some google offer etc not something Dustin implied).
Sorry, I know I have some remedial reading to do on this subject -- I'm trying to fill in the gaps. One thing I never see in these articles is why the movement people are seeing in this indicator necessarily means that something bad is happening.

Suppose I rake leaves for a living and only barely make enough to feed myself. Suppose technology allows someone else to succeed in ways that have not previously been possible, and they become billionaires. Didn't the range between poorest (me) and richest (them) become wider? Suppose they succeed even more and become trillionaires. Didn't the range just get wider again? Why is this bad?
Not to mention that at $8/hr it's difficult to accumulate the capital necessary to buy a grill and perishable supplies, or to get a loan for the capital. And how successful is that business going to be competing against the McDonald'ses (how do you pluralize "McDonald's"?) of the world AND all the other burger flippers' grilling businesses without name recognition or a marketing budget?
None of the content is online, but in either the winter or fall 2600 there's a pretty decent tear down / analysis of the wristband.
Reminds me of people who send scripts to sitcoms then complain they've been "ripped off" when a similar storyline emerges. Considering there are something like 6 or 7 unique sitcom plots and only so many possible pairings, its pretty obvious that "invention" here is non-existent. Oh you also wanted Rachel and Ross to get together? You don't say.

We've probably been talking about RFID as people tracker for almost 20 years. Personally, I'm really getting sick of the whole "they stole my idea" bullshit from young entrepreneurs. You aren't as clever as you think.
It matters to me too, but it's not the root of the problem.
He didn't know. After it burnt his laptop, he decided to pass it on and make it easy for somebody to steal the key and burn their laptop.
I agree it's a definite possibility. They did it before with the iPad lineup when everyone thought they'd bring a decent chip to the table, and went with low-end phone chips. Of course very good low-end chips, running highly optimized software, but still.

I just don't really follow their path here. First they make the MB more expensive than the air, but run slower. They also make it lighter, smaller, thinner and quieter than the air (air having light-as-a-feather connotations).

I mean, what's the deal in 2 years? If it's the lowest powered device, it'll probably be the thinnest and lightest etc, too. So what about the Air? Will they just throw that powerful brand name out of the window?

Will they expect people to buy 12' and not the 13' MBA with a bigger screen, 3 hours more battery, more ports and a bunch more (20-30%) powerful yet equally less expensive?

In short, it's a bit of a strange lineup. And while I agree with you that it obviously is, and may likely remain the slowest Macbook (slowest Mac period, the Mini notwithstanding), I don't necessarily see how that means ARM as opposed to continuing with refreshed Intel Ms, or hell even an updated Atom lineup. Is there any indication they want to move away from Intel again? I mean, weak performance is one thing, but this is OS X we're talking about, for a device that costs beyond $1k, which probably has good enough profit margins on an Intel M, would they really underpower it even more with a weaker chip?

I'm not very familiar with CPUs though, would love some more of your thoughts on this. It's definitely true that it's now very feasible, and so it all comes down to who can deliver the best low-power CPU the next few years.
Business class it is then...
I had assumed GigaOM's web property was there to lend brand to GigaOM Research, versus the advertising angle. The ability of journalists to make ad revenue is very disappointing and unfortunate across the board, though it can also be said there's a lot of really poorly researched tech journalism out there too.

If the goal wasn't a self-sufficient web business, this seems to imply (maybe?) that the "research/analyst bits were also unsuccessful.

Which I can also believe, because Tolkein's "Go not to the Elves for counsel" was somewhat written about analysts - "for they shall say both no and yes".
This is awesome. I think this would work great with essays and papers for college students.
Whitepaper: Win Your Competitive Race with Extended Enterprise Learning
I still get them and none of my 3 (4?) accounts are subbed anymore.

Oddly I almost never see WoW ads (excluding telly), but I do get the occasional email with free time/trials. Ofc they're all scams now, but once upon a time it really was a free upgrade...
Real spies don't work for money; they work for/against an ideology. Money would actually be a tip-off that they're a spy; if you have high level security clearance, your bank accounts are monitored.

The NSA/CIA/FBI almost certainly do have moles working within the major tech companies. As do the intelligence agencies of China, Russia, the UK, France, Germany and Israel.
Very minor thing, but funny enough, I was working with MySQL just earlier and need to use my one in a blue moon quota of Full Join ... turned out MySQL doesn't have it :( (yes, I know how to emulate it with union).
tens of thousands of apps have been developed with Backbone,that's not an issue.But tens of thousands of app have been developed with jQuery only too,you understand what i'm getting to.
That is because you have framed offense and defense in that way. If a resourceful attacker's only goal in life is to get access to a particular file on your network connected laptop, the attacker will win. Generally this is not the case, the attacker often wants to:

1. remain undetected over a long period of time,
2. in the face of detection they wish to preserve their anonymity,
3. not be fooled by misinformation,
4. not reveal anything of greater value to them than the value of the file,
5. not open themselves up to reprisals.

This is much harder. While the defender doesn't win short term, a resourceful defender can make the costs to the attacker high enough that future attacks are deterred, the attacker loses, or even that the defender gains more from the attack than they lose. For instance Google in responding to Chinese penetrations via technical, economic, governmental and diplomatic avenues has increased Google's credible deterrence, punished some of the people responsible and increased Google's reputation in the realm of security.
This is reasonable search with high recall, but the UI is awful, at least if your using it on a computer rather than a phone.

It would be interesting to see it do something with the chart data, such as trying to cluster the stocks by correlation.
Is sex somehow fundamentally different than every other act that it should be treated so differently?

Yes, sex is different from other things. That was the point of the post you're replying to.

If I used my power at work to make you eat a literal lunch of feces, is that more or less egregious?

I mean, I'd say "more egregious", but that's because it strikes me as unrestrained cruelty. A rapist at least has clear selfish motives with a disregard for human decency; someone who's power-tripping and saying "you're going to do this thing just because I know you don't like it and want to make you suffer" is far scarier.

But it doesn't matter which one is more egregious. The point is that you can call the one thing "rape." That is a valid word to use to describe it.

Isn't the core bad behavior the concept of abrogating another human's free will? Why is sex in this other classification?

You're looking at a two-dimensional figure edge-on so that it looks one dimensional, which causes you to think that these two questions are related, but they are not clearly -- they are about different things.

There are lots of things that are scary about rape. It's not just that someone has "abrogated your free will" -- they're using you as an object and thereby dehumanizing you. This means that certain other questions emerge naturally, like "where exactly does that stop?". And that's a matter of fear for your life (which in law is the crime of assault). It's as if an axiom of our logic has been violated: If someone disregards the basic standards of human decency, we lose all proofs/guarantees that they won't, say, kill us for fun.

If you don't understand where this fear comes from, rape will be an academic question for you, and you will miss the real need for social change.
> She seems to have understood it to mean it is unacceptable that you should feel uncomfortable and your feelings are unacceptable.

No she hasn't, she's just... I don't have any polite description of what she seems to be doing.

"I think it's saying it's unacceptable if s/o makes you feel that way, but the 1st graf def sets up some apologist precedents" "I know what they actually mean, it's just a funny Freudian insight that no-one caught the bad grammar"

"I'm pretty sure you read that very wrong" "I'm ok with this".
> Given the choice between frying an employee's USB / computer (small monetary loss)

That's a good way to start a fire and have a _large_ monetary loss on your hands.
> Well, guess my Linode's getting rebooted again.

Things happen. We should be glad that these sort of security problems are being found and addressed; it would be naive to believe Xen or any other large codebase has zero security problems.

VM's should be regularly patched anyway, which usually requires a reboot now and then. If it were a physical server, the same would be true; just because things are in the "cloud" now doesn't mean they will have infinite uptime.

I understand that sometimes these services reboot and patch with little notice, but this should be built into any Terms Of Service constructed with your client(s); ie. "We will patch and reboot your service for critical vulnerabilities as quickly as possible, which in some circumstances may leave only short notice."
Spanner: Google’s Globally-Distributed Database [pdf]
I'd love something that protects against this, as well as BadUsb.