61
Topics /
Databases & Data
The most popular blog posts about databases & data on Hacker News. 130 posts.
62
PostgreSQL vs MySQL: an apples to oranges comparison
Every time we see people look at PostgreSQL and MySQL on the internet it falls into a flame war fast. I think that a large part of the pr...
63
64
Three things you should never put in your database
There are several things that are not usually appropriate to put into a relational database
65
The Little Redis Book
Karl Seguin's Blog - A mix of coding and creative writing
66
Why Use Postgres - Part 2
This post is a list of many of the reasons to use Postgres, much this content as well as how to use these features will later be curated within PostgresGuide.com. If you need to get started check out Postgres.app for Mac, or get a Cloud instance at Heroku Postgres for free Last week I did a post on the many reasons to…
67
68
A Tour of Amazon's DynamoDB
Amazon’s recent release of DynamoDB, a database whose name is inspired by Dynamo, the key-value database the distributed datastore they’ve been running in production for a good five to six years now. I think it’s great they’ve finally done it, though from my obverservations, there’s little resemblance of what the…
69
70
I’ll Give MongoDB Another Try In Ten Years
A few weeks ago I wrote a small app that fetches JSON documents from app.net’s API and draws a word cloud . At first I wasn’t keeping the content around after generating the images. Later I thought of other things I’d like to do with the documents, so I decided to start storing them.
71
72
73
74
Why MongoDB Never Worked Out at Etsy
In 2010ish, we tried to roll out a feature ( Treasury ) using MongoDB. It was an interesting experience. I learned quite a bit in the process. I wrote about what I was thinking at the time here . But for the most part it was an abject failure and Ryan Young wound up porting the entire thing to the MySQL shards which…
75
76
OkCupid on Trial - 4 Month Experiment
10 fictional profiles were created on OKCupid with the same profiles but different photos to test how online dating is different for men than women.
77
Don't use Scatterplots
In a series of blog posts, Gary Rubinstein attempts show that the Value Added Modelling scores recently released by the NYC Department of Education prove that VAM (Value Added Modelling) is not accurate. However, whatever flaws VAM may have, Gary Rubinstein (henceforth GR) hasn't demonstrated them. All he has…
78
Datomic Free Edition
The free database designed for immutable values and a time-aware information model.
79
New Data Science Certificate Program
Starting in the fall of 2012, the University of Washington will be offering a certificate in Data Science . The program has two sections: one located in Seattle and the other online. The certificate consists of three separate courses each lasting approximately 3 months. Thus the program can be completed in 9 months…
80
81
World `countries` – database table for MySQL
So today, I was buzzing around and searching for a `countries` table script that I could use in MySQL database. As you can imagine, it wouldn’t make any sense to add all world countries into …
82
If the world’s population lived like... (infographic)
Shortly after I started Per Square Mile, I produced an infographic that showed how big a city would have to be to house the world’s 7 billion people.
83
Time Spent Waiting for an Answer in StackOverflow (by language)
I use about.me to show people what matters most to me.
84
Mapping Racist Tweets in Response to President Obama's Re-election
Note: for questions about the methodology/approach of this post, see the FAQ (added 16:20 EST 11/9/2012). Note: as of 11:00 EST 11/10/2012...
85
Three years later, Mr. Moore is still letting us punt on database sharding
Three years ago, I wrote about how improvements in technology keep allowing us to punt on sharding the Basecamp database. This is still true, only more so now. We’ve grown enormously over the last three years but RAM keeps getting cheaper and FusionIO SSD’s keep getting faster. If an…
86
87
Google Homepage Size Over Time
This afternoon, I looked at the source of the main Google page with my browser. It spans my whole monitor and takes 15 pushes of the scroll-wheel to see it all. Whither minimalism? Off to the Wayba…
88
Free Data Science Books
I've been impressed in recent months by the number and quality of free datascience/machine learning books available online. I don't mean fre...
89
Riak 1.2 Officially Released
Nearly three years ago to the day, from a set of green, worn couches in a modest office Cambridge, Massachusetts, the Riak team announced Riak to the world. To say we've come a long way from that first release would be an understatement, and today we’re pleased to announce the release and general a
90
