Human readability is a concern of a client and is independent of the storage mechanism. Every modern database stores integers in binary format, for instance, but clients display them as a decimal string of characters as opposed to a binary or hexadecimal representation. Timestamps are similarly stored in binary fashion, but often formatted for human readability in the client.
If you're using an SQL database you're presumably doing so so that humans can run ad-hoc reports (otherwise there are better datastores). So the UX they get for that is important. And in mysql (yes, not the best choice these days, but a reasonable one when the decision was made), if you store UUIDs as binary (there's no native UUID type) then you do not provide a good UX.
MySQL itself should not be the main interface; there should be some kind of model layer on top of that which does the translation of things like that, such as (for example) ActiveRecord if you were on a Rails stack. That gets you the best of both worlds.
OR you could store the uuid twice, once "natively" and once as a computed column. Searches on the native field would be faster vs. an index on a string column.
> you're presumably doing so so that humans can run ad-hoc reports (otherwise there are better datastores)
oh dear, someone has drank the NoSQL punch... Storing data relationally is NOT something only suitable for ad-hoc queries by end-users! :O
Oh yes, I certainly wouldn't try to argue with that. In classic Apple fashion, they seem to try to sell it as the solution for all things data storage.
OS X isn't flat. There is still shading and drop shadows. They just turned down the gloss from 11 to something less overbearing. When the UI gets chromed to the hilt like iOS6 or older OS X versions, it becomes a distraction from the app/content.
Stackoverflow has of a lot of terrible answers that get voted up by people who aren't equipped to evaluate them properly, and closed threads when anyone starts actual substantive discussions. It also suffers from lack of decent rewards for contribution. That's not what I would consider a good community.
Well, very often I will click through to SO from Google to a closed thread that got downmodded like crazy, but that nevertheless exactly solves my problem in less than a minute from the first answer.
Perhaps on some level SO knows this, and also knows that their mods are perhaps somewhat overzealous, and therefore has adopted the current state of affairs as a sort of compromise/duct-tape solution.
I too, have found so many downmodded questions to have the exact answer I needed for a particular problem. It's by far the most frustrating part of using Stack Overflow.
The overzealous modding has had a chilling effect on my desire to ask a question on SO, because nobody wants their question to be downmodded as a stupid or pointless question.
It would be quite interesting to know which topics you find this happening. I don't tend to see this kind of toxicity on SO. I'm frequenting C# and .NET. Maybe Jon Skeet drags the C# community up to his level!
The overzealous modding is a feature not bug of SE sites.
I find some of the moderation really frustrating but it's worse when the people closing threads and answers are also the ones leaving zero-content comments.
While I also whine about Stack's broken moderation, I still contribute because its heart's in the right place as a site that genuinely wants to help people learn and get answers. The problems you mention are more like implementation details that are subject to ongoing experimentation and can't be changed overnight.
The good thing about Stack is anything I write there will be as easily accessed as if I'd posted it on my own blog, not re-purposed as SEO-bait and blurred or hidden until the user signs up. Furthermore, it's licensed under Creative Commons instead of serving as a donation to the site owner.
Quora is actually a great site once you're logged-in and I find a lot of the content fascinating, but I also wonder why people continue to contribute to such a closed system.
this is absolutely not true, stackoverflow is an invaluable resource and what you say might happen very occasionally, but the vast majority of upvoted answers actually helped a lot of people.
Despite what you claim as lacking rewards it seems to have thrived and attracted contributions. I don't really care what you consider a good community, or even accept the premise that there needs to be any notion of community. Why attribute labels, the model seems to work just fine.
I've heard a few people suggest that with single core performance stagnating we may see more ASICs. I admit I'm skeptical, but this line of development does seem worth exploring.
In your example, I don't know SET BAR = 1 isn't the end until I read the next line.