271
Historically, 4NF explanations are needlessly confusing
4NF presented in a straightforward way, with some investigation of history of teaching 4NF.
New
The latest blog posts to take off on Hacker News. 1,888 posts.
272
Sensible SQLite Defaults
SQLite is cool now. DHH uses it, Laravel defaults to it. Here is a list of _sensible defaults_ when using sqlite.
273
Lossless Log Aggregation – Reduce Log Volume by 99% Without Dropping Data
Reduce Log Volume by 99% Without Dropping Data
274
7 Databases in 7 Weeks for 2025
7 databases to explore in 2025.
275
PostgreSQL High Availability Solutions – Part 1: Jepsen Test and Patroni
Note: code used in this article can be found on the Github repo jepsen-postgres-ha .
276
Safe relational database queries using the Rust type system
New database library for Rust
277
Ask questions of SQLite databases and CSV/JSON files in your terminal
I built a new plugin for my sqlite-utils CLI tool that lets you ask human-language questions directly of SQLite databases and CSV/JSON files on your computer. It’s called sqlite-utils-ask. Here’s …
278
DELETEs Are Difficult
Why are database DELETEs complex and inefficient? Uncover challenges from physical data removal to autovacuum, and find strategies for managing large deletions.
279
SQL, Homomorphisms and Constraint Satisfaction Problems
Database queries are a pretty surprisingly powerful tool that can solve seemingly intractable problems.
280
Foursquare Open Source Places: A new foundational dataset
I did not expect this! [...] we are announcing today the general availability of a foundational open data set, Foursquare Open Source Places ("FSQ OS Places"). This base layer of …
281
Understanding the BM25 full text search algorithm
BM25 is a widely used algorithm for full text search. I wanted to understand how it works, so here is my attempt at understanding by re-explaining.
282
OpenStreetMap's New Vector Tiles
Benchmarks & Tips for Big Data, Hadoop, AWS, Google Cloud, PostgreSQL, Spark, Python & More...
283
FireDucks: Pandas but Faster
Introduction My main background is a hedge fund professional, so I deal with finance data all the time and so far the Pandas library has been an indispensab...
284
SQLite Index Visualization
Explores SQLite B-Tree index structure with visualizations, explaining on-disk and in-memory storage mechanisms
285
Visualizing 13M Bluesky users
Joel Gustafson
286
What I wish someone told me about Postgres
I’ve been working professionally for the better part of a decade on web apps and, in that time, I’ve had to learn how to use a lot of different systems and tools. During that education, I found that the official documentation typically proved to be the most helpful.
287
SQLite does not do checksums
SQLite does not do checksums by default. Disk corruptions go silently unnoticed.
288
All the data can be yours: reverse engineering APIs
I’ve built a lot of unofficial software for my schools, Brown University and previously Macalester College. To name a few: an “everything app” called 75grand with dining hall menus, Moodle assignments, building hours, an event calendar, and more; two unfinished course catalogs; and a university shuttle tracker. None…
289
What Shapes Do Matrix Multiplications Like?
Divining order from the chaos
290
Nutrient levels in retail grocery stores
A counterintuitive conclusion
291
131M American Buildings
Benchmarks & Tips for Big Data, Hadoop, AWS, Google Cloud, PostgreSQL, Spark, Python & More...
292
293
Get me out of data hell
It is 9:59 AM in Melbourne, 9th October, 2024. Sunlight filters through my windows, illuminating swirling motes of dust across my living room. There is a cup of tea in my hand. I take a sip and savor it.
294
Lisp Query Notation (LQN)
Query language and terminal utility for transforming various data formats
295
OpenZFS deduplication is good now and you shouldn't use it
OpenZFS 2.3.0 will be released any day now, and it includes the new “Fast Dedup” feature. My team at Klara spent many months in 2023 and 2024 working on it, and we reckon it’s pretty good, a huge step up from the old dedup as well as being a solid base for further improvements. I’ve been watching various forums and…
296
Fruits (2020)
Fruits - Graph All The Things, a math blog by Martin Loncaric
297
298
MVCC – the part of PostgreSQL we hate the most (2023)
As much as Andy loves PostgreSQL, there is one part that is terrible and causes many headaches for people. Learn what it is and why it sucks.
299
Sampling with SQL
Sampling is one of the most powerful tools you can wield to extract meaning from large datasets. It lets you reduce a massive pile of data into a small yet representative dataset that’s fast and easy to use.
300
Zero-latency SQLite storage in every Durable Object
Kenton Varda introduces the next iteration of Cloudflare's Durable Object platform, which recently upgraded from a key/value store to a full relational system based on SQLite. For useful background on …