skysight-inc/HackerNews huggingface dataset:
The last MySQL limitation to bite me was that time columns are truncated to whole-second granularity - no milliseconds or microseconds.

http://bugs.mysql.com/bug.php?id=8523

If you want sub-second granularity, the advice is to store milliseconds-since-epoch as a BIGINT and have your application convert it to a time:

http://feedblog.org/2007/05/26/why-doesnt-mysql-support-mill...
put http://searchyc.com/ as a search feature and ban google and other popular search engines from indexing HN. Please tell me why this is a bad idea.
A problematic dual-loyalty is embedded in this list.

"5. A journalist is obsessed with the Truth."

and

"6. A journalist serves the people." which was expanded on with "In telling all sides of a story for the benefit of the proletariat alone"

Without getting too deeply into it, you can't serve the people and the truth any more than a democratic vote will always arrive at the best public policy. A bias toward "the people with little or no power or influence in this world" is still a bias and will be a diversion from the truth.
Yes, intuitively I'd also expect it to take many generations. But the article's examples - Sweden, Japan (both effects established post-WWII I suppose), the North Carolina district (1990s!) - surprisingly suggest otherwise.
CloudSleuth
I saw a link somewhere on HN yesterday that suggested you turn off Spotlight (Settings > General > Home Button > Spotlight Search) to improve performance.

I turned off Spotlight for everything except Applications, and I've experienced a slight improvement after rebooting. Since upgrading to 4.0.1 with Spotlight turned off, performance is --much-- better.
I don't see anywhere where he is calling for application logic. He's making sure that the data has integrity, and the database absolutely should be in charge of that. If your database can't enforce integrity, then you're in a very, very bad place.

Putting in sane integrity checks to a database should be a priority. You can fix broken applications, but you can't fix broken data (especially if you collected it from users, sensors).
Michael Mol did a demo of rosetta for the Lansing, MI perl mongers and it was a riot (far better than my DBIC/architecture talk).

There are fewer better forms of entertainment for geeks than eating pizza while discussing common programming expressions implemented in bizarre and obscure languages.
Top Gear concurs: http://www.streetfire.net/video/top-gear-tries-to-destroy-th...
What we’re been trying to do is set it up so that the content we’re displaying is just a portion of what they are publishing. We just give people an excerpt.

This is what killed my initial buzz for this thing. To be useful to me, a media consumption tool has to either provide a nice way to read complete articles or an efficient way to aggregate/filter large numbers of articles. Flipboard fails at the former by forcing a complete context switch half way through the article. It fails at the latter by trying to be the former.

Asking for Facebook and Twitter logins without any apparent need or explanation was also a deal breaker.

The excitement for this product was justified. The iPad reading experience is pretty fragmented and leaves a craving for some sort of universal reader like this, but Flipboard hasn't got it right.
I saw the stills on his blog - it looks like he does this sort of thing on a regular basis. I'd wager that learning how to create the electronics took the longest in terms of learning new skills.
#4 is interesting—but how do you define "devices?"

I have, say, 500GB of music. It doesn't fit on my laptop, so it "lives" on an external HD. Could it sync the laptop with the HD so that I always still have access to a set chunk—say, 10GB—of my most-recently-used music files? This is a capability I've been waiting for something to support ever since I bought the drive.
HN has noprocrast. The default 180 minutes is good for me.
A website is effectively private property. Suppose my house had a nice lawn, and I said to the neighborhood kids, "You're welcome to play on my lawn, just clean up after yourselves and don't hurt the flowers." Is that reasonable? How about if, instead of communicating that to them, I instead put up a sign to that effect? Is it cool if the kids play on my lawn and mess up my flower bed because they don't like those terms and couldn't negotiate them? Of course not: I've laid out the rules for their usage of my private property, and if they don't like the rules they can do something else with their time.

I'm not saying a website should be able to sue you or file criminal complaints if you violate a TOS; I'm just saying that they do have the right to expect you to abide by them if you choose to use the site. They should be able to behave exactly as a restaurant does: kick you out if you violate them, and file criminal complaints only if you actually do something criminal (cause damage, steal stuff, abuse staff, etc.).

Whether or not a TOS is criminally enforceable is a long ways away from your argument, which I interpreted as essentially saying that breaking/ignoring a TOS isn't any sort of ethical violation because it's not a countersigned negotiated contract.
Don't worry about saving minutes with Skype, think data use
The 25 Best Tech Companies to Work For
I have a collection of Model Ms and I love them. However, as my main home and work computers are Macs, and the Ms are missing one of the control keys, I'm out of luck.

I have a das keyboard at work, which is pretty good, but not as nice as the M. I always thought that it had the same mechanism as the M but this article says not.

Time to try a Unicomp.
It depends how valuable your data is to you. For many/most companies, data is incredibly valuable, and as the company grows, it gets more valuable over time.

If you find the usability of MySQL better than Postgres, and you don't put a lot of value on your data, then choosing MySQL is fine. The author is right to point out that a lot of the complaints are really just "this doesn't have to be this way." You should really expect your database to enforce non-null, especially if it lets you specify it and doesn't warn you it's not going to do a damn thing about it.

As I mentioned in my comment above, you can fix buggy applications, but you can't fix incorrect data.
What if you have multiple applications talking to the same database?
Build something and try to sell it.

Better yet, do the above in reverse! Then write a book on what you did.

The best book I read on entrepreneurship was by Yvon Chouinard who started Patagonia. Don't remember the title, but I'm fairly sure it wasn't Let My People go Surfing since I read it over 10 years ago.
I wouldn't feel comfortable with this, as it would destroy the amount of discovery I do on HN.

Not all of the articles are within my technical experience, and some I only barely understand, but I find some seriously mind-blowing things out there.

To the OP...yes. I'm constantly impressed with those who have not only the knowledge and skills, but the sheer drive to build and run a successful startup. Even if I had some crazy-awesome idea that had almost no chance of failure (just as an example), the notion of just...picking up and doing my own thing is a very scary thing to do. I've been job with income stability for so long that the idea of going it on my own scares the hell out of me.
Seems pretty big to me. Here is they why - http://www.bloomberg.com/news/2010-07-22/amazon-com-misses-e...
Nitpicking out of context? Sensationalist headline? I assume you and everyone who voted you up didn't actually read the study.

What Secunia did study was described as "In the first part of the report we look at the global picture covering all vulnerabilities in all products, followed by the analysis of
vulnerabilities affecting the products and the operating system found on typical end-users PCs." And all their graphs are limited to XP, Vista and 7. So...probably limited to Windows. And they also define 3rd-party software for you as non-Microsoft vendors in the sidebar of page 9.

So yeah, everything by Apple is 3rd party software in the context of the study cited.
The design philosophy differences between Postgres and MySQL should be a case study.

When I first started using SQL databases, Postgres had a reputation for being a fully ACID compliant database that paid a performance penalty for it, and was hard to use. They made it "correct" as a top priority.

MySQL had a reputation for being blazingly fast, even outperforming expensive commercial DB's in some areas. However, things like foreign keys were missing. There were debates in the MySQL community as to whether foreign keys were even necessary, since you could just do all that stuff in the application layer.

That seemed reasonable to me at the time and MySQL was trivially easy to install at a time when Postgres was a huge pain, so I picked MySQL. I almost immediately got bitten by the lack of foreign keys, and although I didn't know it at the time, spent most of my time coding application logic that was a workaround for MySQL's lack of views. So I switched to Postgres, it solved many of my problems and have tried to use it whenever possible.

Every release the MySQL people get closer to Postgres's features, but there's always something missing, and as of a few years ago at least, all of these features were dependent on what backend table type you were using, which became especially annoying if you didn't have control over the installation (cheap web hosting.)

The funny thing is, MySQL's performance on microbenchmarks really meant nothing in more complex applications. A few years ago I was doing something more than a simple search that involved a few joins and intersections with MySQL; the query optimizer in MySQL seemed determined to pick the slowest possible path to return a result (intersection of a small set of rows with a huge one somehow would cause MySQL to check every row of the large set for a match). It ended up being 50 times faster to implement the logic in PHP and use two queries instead of one.

So I switched to a host with Postgres access, and the identical query that took forever in MySQL was no problem for Postgres.

After a few experiences like that, you begin to see the virtue in doing things right the first time and optimizing later. You also see the virtue in using a database system that takes the onus off of the application developer to implement logic that should be in the DB.
I'll give you Erlang, but the Ruby solution is cheating rather.
I often use timestamps so I know when a record was created. If I want it to reflect the last change to a row, I would set it to have a trigger on a "last_updated" column.

I haven't been hit with this bug either, but this was by accident (or design in the GUI interface I was using). I find it quite shocking.
The Chipophone - 8-bit synthesizer
MS SQL Server and Oracle use CREATE SCHEMA and ALTER SCHEMA for DDL transactions. I think it is the ANSI/ISO standard way to do it. But, also "The CREATE SCHEMA command does not support Oracle extensions to the ANSI CREATE TABLE and CREATE VIEW commands (for example, the STORAGE clause)."
MySQLs lack of views for a long time was just killer. I'm truly surprised MySQL has done as well as it has for as long as it has done. I thought that it's popularity would have tailed off when people realized just how much it was missing (I felt a little bit unwell when I found it didn't have views), but it seems that it just hit critical mass.
This is a thoughtful response and I have no snippy response to it, other than to point out that companies have tried hurling money at this problem and appear to be bottlenecked at "finding enough software security people to get the job done".

And, like I said, I think they're significantly better at responding to reports than the picture you're painting. We may be talking past each other, but: having an actual human write back and say "thanks, you're secrdar://484799" might not actually make things any better than they already are.

The fact is that large companies haven't figured out how to ship security fixes, and so security fixes are ending up getting triaged alongside all other classes of product flaws. And that isn't working.
Sorry to respond to myself, but I thought of an analogy:

Model M = crunchy like cheerios
das = crunchy like rice krispies
> the researchers hypothesized that, given some premises about evolution, poor women would have more kids earlier.

Um, isn't this already well known? Did they not craft the hypothesis to fit their existing understanding?

> Then they went and tested it.

No comment.
Vanilla 2 (TechStars 2009) has been released
What is great about that is that there is always someone to learn from.
>>my biggest worry about this site is the opposite: that the median awesomeness is decreasing as the number of users increases.

if it worries you so much, why don't you try to make it less popular? eg. by blocking all popular search engines.
Here's a link to think about:

http://www.circleid.com/posts/20090609_verizon_mandates_ipv6...

"The device shall support IPv6. The device may support IPv4"

This is requirements for the LTE devices from Verizon. Of course all the devices being linux-based, I expect dualstack for quite some time.

As for provider-independent addresses, I understand you should be able to get /48: http://www.ripe.net/ripe/docs/ripe-483.html

As for the Locator-ID split problem (which what the BGP scaling problem is about), there are a number of experiments going on at the moment. LISP (http://tools.ietf.org/html/draft-farinacci-lisp) is one of them. There was a few more but with less memorable names (edit: memorable for me. because I did hear more about LISP)

Of course the world is not going to end. It will just start developing an ever increasing slice of IPv6-only, whereas IPv4 growth is bounded.

Google, Facebook, YouTube, Netflix are already IPv6-enabled.
This is "The Internet" for your average mom and pop consumer type. And maintaining the NATs with the few million hosts behind is a bit of work. So I would not be surprised if a cheaper "IPv6-only internet" options might emerge.

Full disclosure: my day job is at cisco. And untangling the creative NAT configurations and bugs caused by them has paid my bills for the past 10 years. Everything posted here is my personal opinion and not of my employer.
I doubt the comments here would ever descend to near YouTube levels. For one, trolls on this site are mercilessly modded into the negative, and quickly. The last time I tried to make a snarky comment just for the sake of snark, it got downmodded so fast that I just deleted it. This same comment would probably have hundreds of thumbs up on YouTube by now.

I changed all of my videos to moderated comments on YouTube, and I still receive completely inane ones every day, along with "thumbs up if ____" comments. These, again, would be modded into oblivion here.

Maybe I'm one of the unwelcome newbies that are changing this site for the worse (as I'm not involved in a startup), but I don't think this culture has anything to fear as far as quality dilution goes. Noisy, sure, but still high quality.
File syncing that includes mobile devices seems to becoming increasingly important as their storage space grows. I'm excited about AeroFS and am looking forward to seeing more posts about the technical aspects.
If only there was actually an Io community... If you notice, practically everyone in here mentions they've "dabbled" with Io, but practically no one is using this for production code.

Io still doesn't even have releases which I find pretty disconcerting.
I haven't seen the final product, but did get to try on the prototype seen at 1:34. This was pre internal padding and any electronics.

Can't wait to see the final working unit.
The 5 Major Stages of Startup Funding
It also doesn't work on 64-bit machines due to mismatched size comparisons. And I confess to finding it humorous you're submitting a patch to Veracity using Git.
Interesting, it seems many C implementations do support this. It's not standard C, though.
The company behind this helmet, Volpin Props (http://volpinprops.blogspot.com/), produces absolutely amazing work, especially considering it's all one guy. Some of his other projects include:

Big Daddy (Bioshock) http://www.flickr.com/photos/14455307@N07/sets/7215762286087...

Portal Gun http://www.flickr.com/photos/14455307@N07/sets/7215761888999...

Force-a-Nature (Team Fortress 2) http://www.flickr.com/photos/14455307@N07/sets/7215762302451...
a device is anything that can run AeroFS. We can (and plan) to do exactly what you described for caching data in between _devices_, but we haven't really considered the use case where you may want access to your most recently used external HDD data (in this case, the external HDD is really more like a part of your laptop device)
Google profiles don't allow links?

http://www.google.com/profiles/112195136944637672112
I would agree with this. Windows is a larger market to attack, but if it's lucrative to sell software to a smaller fraction of the market, it's surely lucrative to infect their computers and harvest personal info.

The Apple computer marketshare is small worldwide, but inside the US, one of the richer countries in the world, Apple has a much larger representation (+20% of laptop sales, +10% desktops), and almost all >$1000 computer sales. A bank account or credit card harvested from a random Mac is probably worth a whole lot more than a random Windows computer when selecting from a global set of computers. Essentially, wealth among computer users is not evenly distributed worldwide, and Apple products are disproportionately represented in wealthier nations.
Short version: You're a journalist if you've been to j-school and if you pass all of Jolie O'Dell's subjective tests. Too bad there aren't hardly any journalists at all who can pass that test, including most likely Jolie herself.

For fun make the same list about who's a developer and who's not.

(I'm not a blogger--at least not since maybe 4 years back)
I think you hit the mark here. An entropic network is not so much the cause of success, as it is the effect of the entrepreneurial mentality that encourages exploration beyond a personal comfort-zone. This is the mind-set so often highlighted in great entrepreneurs; the ability, self-confidence and maybe even playfulness to break through boundaries and adventurously explore the unknown.
An entrepreneur should be fair to all participants in the ecosystem
> we have evolved to produce offspring sooner and faster in response to harsh conditions.

One could also understand the article the other way around: We have evolved to reproduce in response to natural conditions, and one result is women being able to get pregnant at about 15. Now, why should something like this happen if the natural 'optimum' would be rather 20 or 25?

Read this way, the fact that needs an explanation is women getting pregnant rather late.
I wish someone would manage to hack the bootloader of the new Motorolas (Milestone, probably Droid X and Droid 2). We still don't have proper custom ROMs for that...
will try this and report back
Of all things that modern computers have plenty of, it's hard disks I've rarely seen not being almost full...
I've used wuala for linux and have found it quite rough around the edges.

* not completely decentralized or open source. If wuala goes out of business, your data may not be recoverable.
* web interface is lacking (poor folder navigation/listing)
* doesn't work without X on linux
* even with X, not all features are available through the command line or API, though some are
* the interface that is provided is clunky
* the status messages leave me wondering where in the process an update is. If a piece of software can't reliably tell me where it is in a process, I can't trust that the process is happening the way I expect.
I said you can _crawl_ in the sense that it's technically possible & easy. Also I don't think you'd get into trouble if you use it for your own research and not disclose your results.
X11 actually maintains three separate cut/paste buffers - primary (which you access with select/middle click), secondary and clipboard. Ctrl-C/Ctrl-V are probably interfacing with the X11 clipboard, not a distinct Gnome clipboard. (Though I don't use Gnome myself, so I can't check.)

You could probably write a daemon to keep the primary selection empty. The `xsel` program would be a good place to start. I thought you could do it with `while true; do echo -n '' | xsel -n -i; done`, but it quits immediately if the input is empty so that would be constantly executing a new program. Still, I expect there's some trickery you could do with it, or you could look at how it's implemented and copy that.

(edit - or to eliminate a lot of the pain,

while true; do echo -n ' ' | xsel -n -i; done

will keep a space permanently in the selection. I tested and it seemed to work, though there may be edge cases I'm not aware of.)
If you look at these reviews people don't seem happy.. guess this is what the ceo reply is meant to respond to?

http://ax.itunes.apple.com/us/app/flipboard/id358801284?mt=8

Customer Reviews
Will be great? by dlbdlb

At present, not connecting to my Twitter and fb accounts.
Problem with the instant popularity?

Buggy by Chakri

Current version is buggy. Can't login into FaceBook.
Every attempt throws an over the capacity exception.

So Awesome! by katzilla349

Refuses to add any of the content I attempt to add.
Way Cool!

And why is it that I can't copy and paste most of the
text (and who knows what else)? I'm growing weary of
digital media that doesn't leverage the advantages of
being DIGITAL!

Thanks for wasting my time with that one guys!
Yep. You encountered a totally insidious, elusive bug. Even if you had tried it from your wife's computer, it probably wouldn't've shown up then.

At the time, all you had to go on was that there was a probable misconfiguration somewhere in the deep, dark innards of MacOS, and the best way to handle that particular problem is to nuke it from orbit.
YAML formats not lossless
I have a feeling that the basic "need" for ORMs was originally driven purely by the unwieldiness of querying a MySQL database. When everything is in the application layer, you have to write abstractions on top of it to keep it comprehensible.

When you have triggers and views, on the other hand, you can just "ask the right questions" of the database, and get your information; the SQL becomes self-documenting, rather than a tangled mess.
> Um, isn't this already well known?

No idea. The point is that it's a substantive claim that could be tested empirically.

> Did they not craft the hypothesis to fit their existing understanding?

I hope so. Using what you already know helps generate interesting hypotheses. They don't pop into existence asexually.
Can I share stuff with my friends? Suppose they already host my backups and I host theirs, can I easily give them access to some of my files?
Offtopic: I'd like to see an API for SpeakerText where I can point to my own video asset on an Amazon S3 bucket along with an API endpoint that I specify and you would send me a POST with the transcribed text whenever it's finished processing. I'd purchase that service tomorrow.
It has gotten faster. The way I deal with the speed for games is I use it for object creation and hooking things up, and then I let C++ code in the libraries I use take care of the low level. For instance when I create a game object I use Io to create a Bullet physics object and an Irrlicht graphics object, and then I instantiate a motion state (a C++ object) that connects the two instances together. After that, when the physics object updates its position, the update feeds through to updating the graphics object without needing to touch script as a "middleman".
Mixergy: How Ideal Bite (a email newsletter company) sold for $20 Mil