Top posts
Every blog post that took off on Hacker News, ranked by the votes of its best submission. 2,337 posts.
The semantic web is now widely adopted
Web 3.0 was not about the blockchain, thank god
Litestream: Revamped
Bringing in what we learned from LiteFS
ggsql: A Grammar of Graphics for SQL
Introducing ggsql, a grammar of graphics for SQL that lets you describe visualizations directly inside SQL queries.
Meilisearch 1.0 – Open-source search engine built in Rust
Meilisearch launches the first completely stable, forward-compatible, and enterprise-ready version of its highly performant open-source search engine.
Backblaze Hard Drive Stats for 2018
This review looks at the hard drive failure rates by make and model for 100,000+ disk drives in operation in our data centers.
My Favorite PostgreSQL Queries and Why They Matter
In today's data-driven world, data is valuable. Extracting insight, answering questions, and meaningful metrics from data by way of querying and data manipulation is an integral component of SQL in general. This blog presents a combination of 8 interesting, differing PostgreSQL queries or types of queries to explore…
New health insurance “transparency data” looks suspiciously wrong
Blog for DoltHub, a website hosting databases made with Dolt, an open-source version-controlled SQL database with Git-like semantics.
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:
SQLite: Wal2 Mode
"Wal2" mode is very similar to "wal" mode. To change a database to wal2 mode, use the command:
Discovering Millions of Datasets on the Web
Dataset Search launches publicly with an index of 25 million datasets, helping scientists, journalists, students, data geeks to find data.
Case study: Algorithmic trading with Go
In this case study, we are excited to share an insider's perspective and look under the hood of how a Massive.com customer built an automated retail trading bot that is capable of monitoring the entire stock market in real-time.
Learn SQL Interactively on Khan Academy
There are millions of SQL users around the world. Who are these people, what is SQL, and what are they all using it for? Start learning S...
How Discord Stores Billions of Messages Using Cassandra
Discover the latest news and app updates, stories, company insights, and plenty more about Discord, all in one place.
Postgresql 9.3 Released
The PostgreSQL Global Development Group announces the release of PostgreSQL 9.3, the latest version of the world's leading open source …
Beating GPT-5.6 Sol on retrieval with 100x cheaper open models
A 4B open-source model post-trained with Castform retrieved search results as accurately as GPT-5.6 Sol, while costing 100x less.
How Discord stores trillions of messages (2023)
Engineer Bo Ingram shares insight into how Discord shoulders its traffic and provides a platform for our users to communicate.
PingCap TiDB Leaks
PingCAP Inc. / TiDB Cloud • Distributed databases • 10.6 TB total exfiltration • 200 GB stage one release
Jepsen: NATS 2.12.1
NATS is a popular streaming system. Producers publish messages to streams , and consumers subscribe to those streams, fetching messages from them. Regular NATS streams are allowed to drop messages. However, NATS has a subsystem called JetStream , which uses the Raft consensus algorithm to replicate data among nodes…
Emerging Architectures for Modern Data Infrastructure
To help data teams stay on top of the changes happening in the industry, this article reviews an updated set of data infrastructure architectures.
Pg_GraphQL: A GraphQL Extension for PostgreSQL
GraphQL support is in development for PostgreSQL + Supabase.
Litestream v0.5.0
Same Litestream goodness but better, faster, stronger
Postgres 15 improves UNIQUE and NULL
Postgres 15 beta 2 was released recently! I enjoy Beta season... reviewing and testing new features is a fun diversion from daily tasks. This post takes a look at an improvement to UNIQUE constraints on columns with NULL values . While the nuances of unique constraints are not as flashy as making sorts faster (that's…