4201
Summary of the 1.1 Billion Taxi Rides Benchmarks
Benchmarks & Tips for Big Data, Hadoop, AWS, Google Cloud, PostgreSQL, Spark, Python & More...
Top posts
Every blog post that took off on Hacker News, ranked by the votes of its best submission. 4,226 posts.
4202
How FriendFeed uses MySQL to store schema-less data
We use MySQL for storing all of the data in FriendFeed . Our database has grown a lot as our user base has grown. We now store over 250 million entries and a bunch of other data, from comments and "likes" to friend lists.
4203
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.
4204
Demonstrations and Political Violence in America: New Data for Summer 2020
The report covers 2020 trends in political violence and demonstrations in the US, focusing on the BLM movement.
4205
EDB Postgres AI
Experience zero data sprawl with EDB Postgres AI. Capable of handling 30B+ trades a day and managing 50 TB.
4206
Jepsen: Postgres
Previously on Jepsen , we introduced the problem of network partitions . Here, we demonstrate that a few transactions which “fail” during the start of a partition may have actually succeeded.
4207
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.
4208
Farming Hard Drives: How Backblaze Weathered the Thailand Drive Crisis
The rain started in August and by mid-October 2011, violent floods in Thailand had damaged the factories that helped produce nearly half of the world’s
4209
What’s behind the recent surge in the M1 money supply?
While the terms “money” and “wealth” often mean the same thing in everyday parlance, economists define money more narrowly as the component of wealth consisting of
4210
Spanner: TrueTime and external consistency
Understand Spanner's TrueTime and external consistency, ensuring globally consistent reads and writes across the distributed database.
4211
Latest Data on COVID-19 Vaccinations by Race/Ethnicity
KFF is collecting and analyzing data on COVID-19 vaccinations by race/ethnicity to gain increased insight who is receiving the vaccine and whether some groups are facing disparities in vaccination.
4212
Percentage of Bachelor's degrees conferred to women, by major (1970-2012)
Randy Olson charts out the percentage of Bachelor's degrees conferred to women (by major) and makes some startling findings.
4213
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.
4214
Will ZFS and non-ECC RAM kill your data?
This comes up far too often, so rather than continuing to explain it over and over again, I’m going to try to do a really good job of it once and link to it here.
4215
Scaling SQLite to 4M QPS on a Single Server (EC2 vs Bare Metal)
Discover how Expensify achieved remarkable scaling: 4M QPS on one server! Dive into optimizing SQLite for impressive performance gains.
4216
Waiting for PostgreSQL 12 – Allow user control of CTE materialization, and change the default behavior.
This is pretty important change, as it has the chance to cause performance issues in some cases.
4217
We need tool support for keyset pagination
Pagination without OFFSET has many benefits but one problem: there is no tool support. Please help changing this.
4218
Jepsen: Redis
Previously on Jepsen , we explored two-phase commit in Postgres . In this post, we demonstrate Redis losing 56% of writes during a partition.
4219
[109] Data Falsificada (Part 1): “Clusterfake”
This is the introduction to a four-part series of posts detailing evidence of fraud in four academic papers co-authored by Harvard Business School Professor Francesca Gino. In 2021, we and a team o…
4220
US Federal Agricultural Farm Subsidies: How Much Farmers Get By Year
Federal farm subsidies make up an average of 13.5% of net farm income.
4221
Sizing Up Twitter Users
Twitter users are younger, more likely to identify as Democrats, more highly educated and have higher incomes than U.S. adults overall.
4222
OFFSET is bad for skipping previous rows
OFFSET doesn’t deliver stable results and makes the query slow. Key-set pagination does neither.
4223
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
4224
Object-Relational Mapping is the Vietnam of Computer Science
I had an opportunity to meet Ted Neward at TechEd this year. Ted, among other things, famously coined the phrase “Object-Relational mapping is the Vietnam of our industy” in late 2004. It’s a scary analogy, but an apt one. I’ve seen developers struggle for years with the
4225
Jepsen: MongoDB
Previously in Jepsen , we discussed Redis . In this post, we’ll see MongoDB drop a phenomenal amount of data. See also: followup analyses of 2.6.7 and 3.4.0-rc3 .
4226
Claude Code Historical Performance
Historical Claude Code performance tracker across model generations on SWE-Bench-Pro.