1801
New
The latest blog posts to take off on Hacker News. 1,888 posts.
1802
Dammit, MySQL
Update May 2018: This is more rant-ish than I would write now, but it’s my only post to hit the front page of HackerNews (it got to the number 2 spot back in 2010; I saved screenshots), so has a soft-place in my heart.
1803
What people want (according to Google Suggest)
Mergesort and Quicksort are two well-known sorting algorithms, familiar to both researchers and practitioners. Both are typically presented as examples of divide and conquer . Other than this fact, they are usually not seen to be very closely related. Let’s look at Mergesort and Quicksort in a somewhat unusual way…
1804
In defence of SQL
SQL is ugly but powerful, ORM is genuinely dumb, and "NoSQL" should really be called OMADS: Obviously More Appropriate Data Stores. Start every project with an RDBMS, add specialized stores where they fit, and stop apologizing for using SQL. Forty years on, nothing beats it for ad-hoc questions about your data.
1805
1806
1807
1808
1809
Data visualization - 9 Years of Sleep
For the last ten years or so, I used to turn on my PC when I came home from school or work and shut it down again right before I went to bed. So most of the time when my PC is running, I'm awake. I've also been idling in IRC for as long as I had Internet – when my PC is running, so is my IRC client.
1810
Stop Words as Social Signals (a result that goes against IR common knowledge)
Your daily dose of insights across life's diverse topics
1811
1812
When to use Excel, when to use R?
Encyclia — acquisition, retention, and advocacy consultancy
1813
1814
1815
1816
NoSQL vs. RDBMS: Let the flames begin
I’ve been getting solidly flamed recently, as have my former coworkers at Digg, my friends at Twitter, etc. about our adoption and promotion of various NoSQL storage systems. It seems that some DBAs are very, very upset that us internet kids are considering abandoning SQL’s ship. I’m not here to throw out a bunch of…
1817
1818
1819
Visual Guide to NoSQL Systems
There are so many NoSQL systems these days that it's hard to get a quick overview of the major trade-offs involved when evaluating relational and non-relational systems in non-single-server...
1820
1821
Gay marriage: the database engineering perspective
Update, 2017-09-25 Hi! This essay is undergoing a long-overdue rewrite. In the meantime, consider my 2015 follow-up essay, Obergefell v. Hodges: the database engineering perspective....
1822
Six Months of HackerNews Front Page Data
Back in September 2009 I launched a small web app called HNTrends.com, a tool for visualizing the movement of stories on HackerNews’s front page over time. I haven’t worked on the site …
1823
1824
A Collection Of Redis Use Cases
Interested in Redis? You might be interested in the Redis Handbook I’m currently working on.
1825
1826
1827
1828
PostgreSQL 9.0 - Hot Standby, Streaming Replication
The BIG feature. The feature that made PostgreSQL leap from 8.4 to 9.0. Patch was written by Fujii Masao, and committed by Heikki Linnakangas on 15th of January 2010:
1829
1830