151
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.
Most cited
Posts that commenters keep linking to, ranked by how many different people have cited them in Hacker News comments. 561 posts.
152
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…
153
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.
154
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.
155
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,…
156
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.
157
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 ):
158
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.
159
Just use Postgres for everything
Replace Redis, MongoDB, Kafka & more with PostgreSQL. Reduce complexity, boost development speed. Complete guide with real examples.
160
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…
161
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 …
162
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.
163
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.
164
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:
165
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.
166
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.
167
168
Codeq
The free database designed for immutable values and a time-aware information model.
169
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…
170
Log-log plot of new vs. total Covid-19 cases by country
Visualizing the exponential growth of COVID-19 across the world.
171
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.
172
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…
173
How to beat the CAP theorem
The CAP theorem states a database cannot guarantee consistency, availability, and partition-tolera...
174
175
On Uber’s Choice of Databases
Uber provides bad advice about PostreSQL vs. MySQL
176
177
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.
178
179
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.
180
OrmHate
Object-Relational Mappers get a lot of hate from people who misjudge the complexities of the task.