421
Topics /
Databases & Data
The most popular blog posts about databases & data on Hacker News. 1,888 posts.
422
423
The power of interning: making a time series database smaller
This week-end project started by browsing the open-data repository of Paris’ public transport network, which contains various APIs to query real-time departures, current disruptions, etc.The data reuse section caught my eye, as it features external projects that use this open data.In particular, the RATP status…
424
425
How FoundationDB works and why it works (2021)
FoundationDB is a very impressive database. Its paper won the best industry paper award in SIGMOD’21. In this post, I will explain, in detail, how FDB works and discuss a few very interesting design choices they made. It’s a dense paper packed with neat ideas. Many details (sometimes even proof of correctness) are not…
426
Implementing a distributed key-value store on top of implementing Raft in Go
Implementing the Raft distributed consensus protocol in Go
427
Composable SQL
Better SQL through typed, composable query fragments.
428
SQLite on Rails: The how and why of optimal performance
This is my personal site, where I write about Ruby, programming, and any of my varied fascinations.
429
Fast B-Trees
( This is part of a series on the design of zest . See the list of posts here .)
430
Optimizing Ruby's JSON, Part 1
I was recently made maintainer of the json gem, and aside from fixing some old bugs, I focused quite a bit on its performance, so that it is now the fastest JSON parser and generator for Ruby on most benchmarks.
431
Log Structured Merge Trees
A detailed look at the interesting LSM file organisation seen in BigTable, Cassandra and most recently MongoDB.
432
The Decline of Imgur on Reddit and the Rise of Reddit's Native Image Hosting
Before Reddit added native image hosting, Imgur accounted for 15% of all submissions to Reddit. Now it’s below 9%.
433
Safe relational database queries using the Rust type system
New database library for Rust
434
435
Mamba Explained: The State Space Model Taking On Transformers
The State Space Model taking on Transformers
436
437
Why Use Postgres
This post is a list of many of the reasons to use Postgres, much this content as well as how to use these features will later be curated within PostgresGuide.com. If you need to get started check out Postgres.app for Mac, or get a Cloud instance at Heroku Postgres for free UPDATE: A part 2 has been posted on Why Use…
438
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…
439
Text Editor: Data Structures
The first step in building my text editor is to implement the core API. If you’re wondering why I want to do this, the original article is here.
440
Call me maybe: Cassandra
Cassandra is a Dynamo system; like Riak, it divides a hash ring into a several chunks, and keeps N replicas of each chunk on different nodes. It uses tunable quorums, hinted handoff, and active anti-entropy to keep replicas up to date. Unlike the Dynamo paper and some of its peers, Cassandra eschews vector clocks in…
441
Thinking Psycopg3
Sponsoring this project will help achieve swift completion and ensure the maintenance of psycopg2, psycopg3 and other related projects.
442
Tesla Model S battery degradation data
Want to read about the acceleration we are seeing in our society in the area of mobility? Read our new book ‘Forward’. Updated June 9, 2020. Today, Tesla Motors published their 2019 Imp…
443
All you need is Wide Events, not "Metrics, Logs and Traces"
This quote from Charity Majors is probably the best summary of the current state of observability in the tech industry - a total, mass confusion.
444
445
446
Managing database schema changes without downtime
How we manage schema changes at Discourse minimizing downtime
447
An Introduction to Stock Market Data Analysis with R – Part 1
This is my first article in a two-part series introducing stock data analysis using R.
448
SQL is Agile
Thoughts about why relational databases are not a bad choice when starting a new project.
449
Does offering ChatGPT a tip cause it to generate better text?
Modern AI rewards being very weird.
450
In Defense of OpenStreetMap's Data Model
Who's the customer, anyway?