Top posts
Every blog post that took off on Hacker News, ranked by the votes of its best submission. 4,225 posts.
PostgreSQL DBaaS vendor comparison and calculator
This is a comparison of PostgreSQL DBaaS providers with an interactive calculator.
Starting data analysis with R: Things I wish I'd been told
R is a very powerful open source environment for data analysis, statistics and graphing, with thousands of packages available. After my previous blog post about likert-scales and metadata in R , a few of my colleagues mentioned that they were learning R through a Coursera course on data analysis . I have been working…
We built a persistent agent memory layer on Elasticsearch with 0.89 recall
Persistent agent memory on Elasticsearch: three-index architecture, hybrid retrieval, supersession and DLS isolation. R@10 0.89, zero cross-tenant leaks.
How Airbnb Built “Wall” to prevent data bugs
Gaining trust in data with extensive data quality, accuracy, and anomaly checks.
Postgres Insider Terminology
If you've ever wondered - What is a tuple? What is a Postgres page? What's the difference between a record and a row? What is a relation? What's an array? What is TOAST? This post is for you! These are terms you hear all the time in the Postgres world. This post breaks down what these terms mean and how they are used.
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.
Sparrow, a modern C++ implementation of the Apache Arrow columnar format
A Modern C++ Implementation of the Apache Arrow Columnar Format
LLM Classification Is Feature Engineering
LLMs make good classifiers but even better features
databow: a Rust CLI to query any database with an ADBC driver
One command-line tool to query them all, built with Rust and ADBC
Recommending items to more than a billion people
Visit the post for more.
The mean means nothing: data visualization to debug a latency problem
I was recently trying to validate some performance improvements related to lld at $DAYJOB and it was a little frustrating to see the improvements in our benchmarks but not in the live-production dashboards.
Postgres text search: balancing query time and relevancy
How do you balance query time and relevance with Postgres text search? Stephen Gutekanst, an engineer working on Sourcegraph's API docs feature, shares tips for stirring code analysis with search indexing.
Querying the GitHub archive with the ClickHouse playground
Via this comment on Hacker News I started exploring the ClickHouse Playground . It's really cool, and among other things it allows CORS-enabled API hits that can query a decade of history from the GitHub events archive in less than a second.
Datasette Facets: Faceted Browse and a JSON API for any CSV File or SQLite DB
Datasette 0.22 is out with the most significant new feature I’ve added since the initial release: faceted browse. Datasette lets you deploy an instant web UI and JSON API for …
A Comparison of Distributed Machine Learning Platforms
This paper surveys the design approaches used in distributed machine learning (ML) platforms and proposes future research directions. This ...
Distributed consensus revised
Distributed consensus revised Howard, PhD thesis Welcome back to a new term of The Morning Paper! To kick things off, I’m going to start by taking a look at Dr Howard’s PhD thesis, ‘Distributed con…
Why query planning for streaming systems is hard
Many groups are working on running sql queries in incremental/streaming systems . Query planning in this context is not a well understood problem. This post is a quick pointer towards the many open problems. It's not intended to be complete or authoritative, because I haven't engaged with the problem much beyond…
Hi My Name is John…and I am addicted to analytics
…and I am addicted to analytics. It all started when I was a wee lad. I quite enjoyed playing Tecmo NBA Basketball, among other games. One day, while…
The Impact of Index Investing: A Follow-Up
The prior piece received a much stronger reaction than I expected. The topic is complicated, with ideas that are difficult to adequately convey in words, so I’m going to use this piece as a follow-up. I’m going to look at the specific example of the Tech Bubble, which is a clear case in which the broad adoption of a…
ZFS: Use mirror vdevs, not RAIDZ
Continuing this week’s “making an article so I don’t have to keep typing it” ZFS series… here’s why you should stop using RAIDZ, and start using mirror vdevs instead.
Modern Transactional Stack
Transactional databases have long been the most critical component of application design. Why? Because a steadfast database is generally the ultimate enforcement point for correctness in a messy, distributed world. Without them we’d overpay and undercharge. We’d lose riders trying to get home from the airport, and…
Gravwell Community Edition: A Splunk Alternative Built with Go
Initial Gravwell testers did a lot of home monitoring with the software and wanted to get licenses for their friends and colleagues but Gravwell was built for larger enterprises and our pricing model isn't set up for home use. All of that changes with the Community Edition...