+1 for WIRED in paper format. The layout is beautiful and ever-changing.

Infoporn anyone?

Instead of "sharding" (split customers across multiple copies of the database) you should try a NoSQL solution to handle the flood of writes as the first layer. Then an recurring process can query the data in your NoSQL object store (by timestamp) and aggregate it into an SQL database for reporting. You could archive those processed entries, or wait until they get old, to another object store for your "data warehouse" -- basically just an archive in case you need to do different aggregate reporting in the future (depending on storage size of course).

I must ask, do you really need to store each full piece of information written by these clients at such a high volume?

Depending on your use of the data, you could even just store the results in memory for X hours/minutes, and then aggregate-process that and write the results to your SQL DB. A single DB with many application servers would be fine in this condition, with writes every X hours/minutes. (You are probably already flat-file logging the incoming requests; that is an archive if you *really* need to go back.) If you cannot afford memory loss if an app server dies, solutions like EhCache (java) will persist the memory to disk, in case of hardware/software failure.

Was your 5000 tps using normal insert/update/delete statements or using the COPY statement? (I guess it's a form of batching: meaning, you issue large copy statements instead of many insert statements, if your application can data that way.)

Also, was your hstore experience with 9.3+ or what version(s) had problems?

Once you have done trend reporting, can you just store that aggregate info instead of all the data from the beginning?

RRDB style (round robin data base) where you store daily stats, weekly, monthly, yearly, etc.

If you've done a factory reset, then the phone owner doesn't need to worry about their data anymore...

Follow-up: Are any Creative Commons (CC) licenses an answer to the GFDL issues illustrated above?

Do you see crowd funding as a means to economically provide for the development of Free Software and even Free Hardware?

Have any small projects grown to a critical mass where only a few funding rounds bootstrapped them into having a sustainable Libre/Free product?

Or even Firefox OS?

Is it even possible to avoid firmware blobs?

Thanks for listing these! If the game doesn't run natively on linux, I'm not interested. (No windows computer, and no time to mess with settings/wine.)

Open Arena works great with pulse audio btw.

Open Arena is still very much alive... There's always people playing death match, CTF instant gib, CTF all weapons. There are lots of mods like freeze tag and rocket-rail, and defrag (where you learn how to strafe jump and circle jump to beat the puzzle map).

That's why you create your own CNAME to point to your customer's hostname!

(Or you could use a hosts file or pdsh groups of hosts)

If she organizes it, it'll be with her and two dudes.

Should all of the <link rel>'s be excluded from the dataset used to build the giant graph?