31
Peppering (Password Storage)
Website with the collection of all the cheat sheets of the project.
Most cited
Posts that commenters keep linking to, ranked by how many different people have cited them in Hacker News comments. 561 posts.
32
HTTP Analytics for 6M requests per second using ClickHouse
One of our large scale data infrastructure challenges here at Cloudflare is around providing HTTP traffic analytics to our customers. HTTP Analytics is available to all our customers via two options:
33
AA-Omniscience v1.1: Knowledge and Hallucination Benchmark
Compare AI model performance on AA-Omniscience v1.1: Knowledge and Hallucination Benchmark. A benchmark measuring factual recall and hallucination across various economically relevant domains.
34
Why SQLite Does Not Use Git
SQLite does not use the Git version control system. SQLite uses Fossil instead, which is a version control system that was specifically designed and written to support SQLite.
35
Fabrice Bellard's TS Zip (2024)
Results and speed for other programs on enwik8 and enwik9 are available at the Large Text Compression Benchmark .
36
37
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.
38
Many small queries are efficient in SQLite
200 SQL statements per webpage is excessive for client/server database engines like MySQL, PostgreSQL, or SQL Server.
39
A Visual Introduction to Machine Learning (2015)
What is machine learning? See how it works with our animated data visualization.
40
Consistency Models
Jepsen analyzes the safety properties of distributed systems–most notably, identifying violations of consistency models. But what are consistency models? What phenomena do they allow? What kind of consistency does a given program really need?
41
42
Are You Sure You Want to Use MMAP in Your Database Management System? (2022)
MMAP Databases = 💩
43
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.
44
Hard Drive Cost per Gigabyte
For hard drive prices, the race to zero is over: nobody won. As you’ll see, the hard drive pricing curve has flattened out.
45
Asynchronous Python and Databases
To quote the last part of this blog post, "I think it's [asyncio] really well done, it's fun to use, and I still am interested in having more of a SQLAlchemy story for it, because I'm sure folks will still want this no matter what anyone says.". To that end, SQLAlchemy 1.4 now includes complete support for asyncio …
46
47
SQLite Archive Files (2018)
An "SQLite Archive" is a file container similar to a ZIP archive or Tarball but based on an SQLite database.
48
Backblaze Vaults: Zettabyte-Scale Cloud Storage Architecture
Backblaze Vaults are not only incredibly durable, scalable, and performant, but they dramatically improve availability and operability.
49
EDB Postgres AI
Experience zero data sprawl with EDB Postgres AI. Capable of handling 30B+ trades a day and managing 50 TB.
50
Against SQL
But SQL is the only widely-used implementation of the relational model, and it is:
51
Call me maybe: Elasticsearch
This post covers Elasticsearch 1.1.0. In the months since its publication, Elasticsearch has added a comprehensive overview of correctness issues and their progress towards fixing some of these bugs.
52
Postmortem of database outage of January 31
Postmortem on the database outage of January 31 2017 with the lessons we learned.
53
54
Storing UTC is not a silver bullet
Note: this is a pretty long post. If you’re not interested in the details, the conclusion at the bottom is intended to be read in a standalone fashion. There’s also a related blog post …
55
Data is a Toxic Asset
Thefts of personal information aren’t unusual. Every week, thieves break into networks and steal data about people, often tens of millions at a time. Most of the time it’s information that’s needed to commit fraud, as happened in 2015 to Experian and the IRS. Sometimes it’s stolen for purposes of embarrassment or…
56
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.
57
58
59
Data Compression Explained (2012)
Copyright (C) 2010-2012, Dell, Inc . You are permitted to copy and distribute material from this book provided (1) any material you distribute includes this license, (2) the material is not modified, and (3) you do not charge a fee or require any other considerations for copies or for any works that incorporate…
60
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.