61
Postgres full-text search is Good Enough (2015)
When you have to build a web application, you are often asked to add search. The magnifying glass is something that we now add to wireframes without even knowing what we are going to search.
Most cited
Posts that commenters keep linking to, ranked by how many different people have cited them in Hacker News comments. 253 posts.
62
63
Why everything you have said about the determinants of health expenditure is wrong in one million charts: a response to Noah Smith.
Household income determines health spending, mostly via higher intensity, not prices. US behaviors are consistent with well-measured income in multiple dimensions.
64
OFFSET is bad for skipping previous rows
OFFSET doesn’t deliver stable results and makes the query slow. Key-set pagination does neither.
65
Target didn’t figure out a teen girl was pregnant before her father did
And that one article that said they did was silly and bad
66
Faster CRDTs: An Adventure in Optimization
Some researchers in France put together a comparison showing lots of ways you could implement realtime collaborative editing (like Google Docs). They implemented lots of algorithms - CRDTs and OT algorithms and stuff. And they benchmarked them all to see how they perform. (Cool!!) Some algorithms worked reasonably…
67
68
Analyzing 1.1B NYC Taxi and Uber Trips
The New York City Taxi & Limousine Commission has released a staggeringly detailed historical dataset covering over 1.1 billion individual taxi trips in the city from January 2009 through June 2015. …
69
Jepsen: On the perils of network partitions
This article is part of Jepsen , a series on network partitions. We’re going to learn about distributed consensus, discuss the CAP theorem’s implications, and demonstrate how different databases behave under partition.
70
Average IQ of students by college major and gender ratio
Randy Olson charts out the IQ of students by their major's gender ratio and reveals a startling trend.
71
Datomic: Event Sourcing without the hassle
When I got started using the Datomic database, I remember someone describing it to me as 'Event Sourcing without the hassle'. Having built Event Sourcing systems both with and without Datomic, I think this is very well put, although it might not be obvious, especially if you don't have much experience with Datomic.
72
Implementing Stripe-Like Idempotency Keys in Postgres
Building resilient services by identifying foreign state mutations and grouping local changes into restartable atomic phases so that every request can be driven to completion.
73
Web SQL Database: In Memoriam
All signs seem to indicate that Apple will finally ship IndexedDB in Safari 7.1 sometime this year. This means that Safari, the last holdout against IndexedDB,…
74
Anti-RDBMS: A list of distributed key-value stores
Please Note: this was written January 2009 - see the comments for updates and additional information. A lot has changed since I wrote this.
75
Top Books on Amazon Based on Links in Hacker News Comments
This visualization shows the top 30 books ranked by total number of links to Amazon in Hacker News comments from Oct 2006 to Oct 2015.
76
Just use Postgres for everything
Replace Redis, MongoDB, Kafka & more with PostgreSQL. Reduce complexity, boost development speed. Complete guide with real examples.
77
ASCII Delimited Text – Not CSV or TAB delimited text
ASCII delimited text solves the problems exporting and importing structured text files and is part of the design of the character set. Unfortunately a lot of people and systems use CSV and other pr…
78
Embeddings: What they are and why they matter
Embeddings are a really neat trick that often come wrapped in a pile of intimidating jargon. If you can make it through that jargon, they unlock powerful and exciting techniques …
79
80
Log-log plot of new vs. total Covid-19 cases by country
Visualizing the exponential growth of COVID-19 across the world.
81
Call me maybe: Elasticsearch 1.5.0
Previously, on Jepsen , we demonstrated stale and dirty reads in MongoDB . In this post, we return to Elasticsearch, which loses data when the network fails, nodes pause, or processes crash.
82
Call me maybe: Cassandra
Cassandra is a Dynamo system; like Riak, it divides a hash ring into a several chunks, and keeps N replicas of each chunk on different nodes. It uses tunable quorums, hinted handoff, and active anti-entropy to keep replicas up to date. Unlike the Dynamo paper and some of its peers, Cassandra eschews vector clocks in…
83
How to beat the CAP theorem
The CAP theorem states a database cannot guarantee consistency, availability, and partition-tolera...
84
On Uber’s Choice of Databases
Uber provides bad advice about PostreSQL vs. MySQL
85
86
Relational shell programming
Unix is a bestiary of ad hoc databases: comma-, colon-, tab- and space-separated tables. Think of /etc/* or /var/log/* , or of columnar commands.
87
Natural Language Corpus Data: Beautiful Data
Data files are derived from the Google Web Trillion Word Corpus , as described by Thorsten Brants and Alex Franz, and distributed by the Linguistic Data Consortium.
88
OrmHate
Object-Relational Mappers get a lot of hate from people who misjudge the complexities of the task.
89
Common statistical tests are linear models
By Jonas Kristoffer Lindeløv ( blog , profile ). Last updated: 28 June, 2019 (See changelog ). Check out the Python version and the Twitter summary .
90
1.1B Taxi Rides on Kdb+/q and 4 Xeon Phi CPUs
Benchmarks & Tips for Big Data, Hadoop, AWS, Google Cloud, PostgreSQL, Spark, Python & More...