61
Million Lines of Code - Infographic
Is a million lines of code a lot? How many lines of code are there in Windows? Facebook? iPhone apps? Let our data-visualization program your brain.
Most cited
Posts that commenters keep linking to, ranked by how many different people have cited them in Hacker News comments. 308 posts.
62
63
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.
64
The technology behind GitHub’s new code search
A look at what went into building the world's largest public code search index.
65
Lepton image compression: saving 22% losslessly from images at 15MB/s
Dash knows your context, your team, and your work, so your team can stay organized, easily find and share knowledge, and keep projects secure, all from one place.
66
SQLite Is Serverless
Most SQL database engines are implemented as a separate server process. Programs that want to access the database communicate with the server using some kind of interprocess communication (typically TCP/IP) to send requests to the server and to receive back results. SQLite does not work this way. With SQLite, the…
67
Sqlite 3.30.0
This page provides a high-level summary of changes to SQLite. For more detail, see the Fossil checkin logs at https://sqlite.org/src/timeline and https://sqlite.org/src/timeline?t=release . See the chronology a succinct listing of releases.
68
Globally Distributed Postgres
Documentation and guides from the team at Fly.io.
69
Exactly-once Semantics: How Kafka Does it
Exactly-once is a hard problem to solve, but we've done it. Available now in Apache Kafka 0.11, exactly-once semantics.
70
71
Ways to paginate in Postgres (2016)
Pagination, pervasive as it is in web applications, is easy to implement inefficiently. This post examines different methods of server-side pagination and their tradeoffs in PostgreSQL. Methods explored include limit-offset, cursors, keyset pagination, as well as more exotic techniques.
72
Inside Cloud Spanner and the CAP Theorem
Building systems that manage globally distributed data, provide data consistency and are also highly available is really hard. The beauty of the cloud is that someone else can build that for you.
73
74
Pipeworld: Spreadsheet Dataflow Computing (2021)
Now for something completely different. In the spiritual vein of One Night in Rio: Vacation photos from Plan9 and AWK for multimedia, here is a tool that is the link that ties almost all the projec…
75
The DeWitt Clause: Why You Rarely See Database Benchmarks
Back in the early 1980s, Dr. David DeWitt – who you might know from past PASS Summit keynotes, formerly of Microsoft (LinkedIn) – was working on measuring database performance. His team wrote a benchmark, ran it against Oracle, and Oracle didn’t fare well in the results. Oracle reacted as one would expect – they were…
76
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.
77
RethinkDB is shutting down
Today I have sad news to share. After more than seven years of development, the company behind RethinkDB is shutting down. We worked very hard to make RethinkDB successful, but in spite of all our efforts we were ultimately unable to build a sustainable business. There is a lot of information to unpack – over the next…
78
Big data is dead
Big data is dead. Long live easy data. | Reading time: 18 min read
79
Pyodide: Bringing the scientific Python stack to the browser
Pyodide is an experimental project from Mozilla to create a full Python data science stack that runs entirely in the browser. We think it’s worthwhile to work on moving the ...
80
Laion-5B: A new era of open large-scale multi-modal datasets
We present a dataset of 5,85 billion CLIP-filtered image-text pairs, 14x bigger than LAION-400M, previously the biggest openly accessible image-text dataset…
81
Building columnar compression in a row-oriented database
Read how we built a flexible, high-performance columnar compression mechanism for PostgreSQL to add scalability to our favorite database.
82
ChaosDB Explained: Azure's Cosmos DB Vulnerability Walkthrough
This is the full story of the Azure ChaosDB Vulnerability that was discovered and disclosed by the Wiz Research Team, where we were able to gain complete unrestricted access to the databases of several thousand Microsoft Azure customers.
83
Stack Overflow Creative Commons Data Dump
We decided early on that all user-generated content on Stack Overflow would be under a Creative Commons license . All those great Stack Overflow questions, answers, and comments, so generously contributed by all of you , are licensed under cc-wiki (also known as cc-by-sa ):
84
Postgres LISTEN/NOTIFY does not scale
Learn why Postgres LISTEN/NOTIFY doesn't scale for high-throughput use cases and what architectural alternatives Recall.ai uses in production.
85
JPEG XL and the Pareto Front
Full details on libjxl v. 0.10 and how it affects jpeg xl lossless compression using Pareto Front for a closer analysis.
86
What if OpenDocument used SQLite? (2014)
Suppose the OpenDocument file format, and specifically the "ODP" OpenDocument Presentation format, were built around SQLite. Benefits would include:
87
Redis adopts dual source-available licensing
Developers love Redis. Unlock the full potential of the Redis database with Redis Enterprise and start building blazing fast apps.
88
The case for JPEG XL
The recent decision by Chrome developers to no longer support JPEG XL has sent a ripple through the developer community and is a bit premature given the relative newness of the image format.
89
Codeq
The free database designed for immutable values and a time-aware information model.
90
YC Portfolio Stats
We get asked a lot for statistics on the YC portfolio. Even though some of these aren’t that helpful [1], here is the latest update on the numbers we get asked about the most. As always, all the credit goes to the founders. Total market cap of all YC companies: >$30 billion Total money raised by all YC companies: >$3…