61
Monarch: Google’s Planet-Scale In-Memory Time Series Database
These paper reviews can be delivered weekly to your inbox , or you can subscribe to the Atom feed . As always, feel free to reach out on Twitter with feedback or suggestions!
Topics /
Databases & Data
The most popular blog posts about databases & data on Hacker News. 300 posts.
62
Cache made consistent: Meta’s cache invalidation solution
Caches help reduce latency, scale read-heavy workloads, and save cost. They are literally everywhere. Caches run on your phone and in your browser. For example, CDNs and DNS are essentially geo-rep…
63
64
ClickHouse Cloud is now in Public Beta
ClickHouse Cloud has entered public beta. Get your free trial now!
65
2022 Cloud Report
The 2022 Cloud Report is the only cloud performance report to compare AWS, Azure, and GCP on benchmarks that reflect critical applications and workloads.
66
Facebook increased satisfaction and usage by sending fewer notifications
We are members of the Facebook Notifications Data Science team at Meta. We ran surveys on how users felt about on-site notifications…
67
For Want of a JOIN
Once upon a time, I was on a small team tasked with building a data pipeline. On this team was someone we’ll call Bob, who was fresh out of grad school and hadn’t had much experience with software engineering, and no experience with SQL. As part of this data pipeline, Bob had to combine the data from two tables. JOIN…
68
In Defense of OpenStreetMap's Data Model
Who's the customer, anyway?
69
Airflow's Problem
In 2022, data engineers manage forests, not trees
70
How We Built Fly Postgres
The database. The app. The legend.
71
Tricking PostgreSQL into using an insane, but faster, query plan
At Spacelift, we use PostgreSQL (specifically Aurora Serverless) for most of our primary database needs. This article will show you our optimization story and how PostgreSQL row count estimation can go very wrong.
72
Introduction to K-Means Clustering
Under unsupervised learning, all the objects in the same group (cluster) should be more similar to each other than to those in other clusters; data points from different clusters should be as different as possible. Clustering allows you to find and organize data into groups that have been formed organically, rather…
73
UUIDs are popular, but bad for performance (2019)
MySQL UUIDs are still very popular despite a majority of posts warning against their usage. Learn what UUIDs are and why they are very bad for MySQL performance.
74
The DynamoDB Paper
This week at USENIX ATC’22, a group of my colleagues 1 from the AWS DynamoDB team are going to be presenting their paper Amazon DynamoDB: A Scalable, Predictably Performant, and Fully Managed NoSQL Database Service . This paper is a rare look at a real-world distributed system that runs at massive scale.
75
Shipping Multi-Tenant SaaS Using Postgres Row-Level Security
At Nile, we’re making it easier for companies to build world-class control planes for their infra SaaS products
76
Select ’Hello, World’: Serverless Postgres Built for the Cloud
We have just launched Neon to provide you with the best Postgres experience in the cloud. You can sign up to our waitlist right now and experience serverless Postgres enabled by the separation of storage and compute. The service is still gated by the waitlist as we are onboarding more and more users every day, and we…
77
DynamoDB 10 years later
Amazon DynamoDB was introduced 10 years ago today; one of its key contributors reflects on its origins, and discusses the 'never-ending journey' to make DynamoDB more secure, more available and more performant.
78
79
ML is not that good at predicting consumers' choices
I wanted to share the attached paper on choice prediction that I recently co-authored with Itamar Simonson in case it’s of interest.
80
Machine Learning Algorithms Cheat Sheet
Machine learning is a subfield of artificial intelligence (AI) and computer science that focuses on using data and algorithms to mimic the way people learn, progressively improving its accuracy. This way, Machine Learning is one of the most interesting methods in Computer Science these days, and it'
81
PostgreSQL query performance bottlenecks
PostgreSQL query planner is full of surprises, so a common-sense approach to writing performant queries is sometimes misleading. In this blog post, I'll describe examples of optimizing seemingly obvious queries with the help of EXPLAIN ANALYZE and Postgres metadata analysis.
82
83
84
Store SQLite in Cloudflare Durable Objects
This is my journey of creating a proof-of-concept of persisting an SQLite database in a Cloudflare Durable Object. It is not meant as a tutorial, but rather as something I myself can get back to it, to revisit what and why I did certain things.
85
SQLite internals: How the most-used database works
Explore SQLite Internals: How The World's Most Used Database Works by Abdur-Rahmaan Janhangeer. Deep dive into database internals, systems engineering, and advanced Python.
86
Hacker News “Who is Hiring?” top-level comments over time
tl;dr: I believe HN Who is Hiring? posts are down; scroll to the bottom for the chart, code lives here. Hacker News. The Orange Site. Since April 2011, it’s had a thread every month, which dares potential employers to answer one question: who is hiring? I take a quick skim through this thread every month. ... Hacker…
87
How SQLite scales read concurrency
Understanding how the write-ahead log turns your scaling up to 11.
88
Phlare: open-source database for continuous profiling at scale
Grafana Labs is helping enable continuous profiling at cloud native scale for the open source community and enterprises, giving developers a better understanding of resource usage of their code.
89
PostgreSQL 14 Internals book – Part II
I’m pleased to announce that Part II of the “ PostgreSQL 14 Internals ” book is available now. This part explores the purpose and design of the buffer cache and explains the need for write-ahead logging. Please download the book freely in PDF. There are three more parts to come, so stay tuned! Thanks to Matthew Daniel…
90
