931
How to get the most out of Postgres memory settings
Engineering deep-dives, product updates, and company news from Tembo — the platform for running coding agents across your stack.
Topics /
Databases & Data
The most popular blog posts about databases & data on Hacker News. 4,222 posts.
932
Implementing a distributed key-value store on top of implementing Raft in Go
Implementing the Raft distributed consensus protocol in Go
933
934
Composable SQL
Better SQL through typed, composable query fragments.
935
Pandas 3.0
We're excited to announce the release of pandas 3.0.0. This major long-awaited release brings significant improvements to pandas, but also features some potentially breaking changes.
936
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.
937
PostgreSQL 9.2 released
The PostgreSQL Global Development Group announces PostgreSQL 9.2, the latest release of the leader in open source databases. Since the …
938
Fast B-Trees
( This is part of a series on the design of zest . See the list of posts here .)
939
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.
940
Log Structured Merge Trees
A detailed look at the interesting LSM file organisation seen in BigTable, Cassandra and most recently MongoDB.
941
942
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%.
943
Safe relational database queries using the Rust type system
New database library for Rust
944
Android Fragmentation Visualized
Our reports examine national and regional trends in mobile and broadband network experience, and develop in-depth insights into trends impacting consumer network experience.
945
946
Mamba Explained: The State Space Model Taking On Transformers
The State Space Model taking on Transformers
947
948
949
We need new data books, so we started one: Cloud Data Management
Introducing Chartio and Data School’s new book Cloud Data Management (4 Stages for Informed Companies).
950
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…
951
Generating JSON Directly from Postgres
PostgreSQL has built-in JSON generators that can be used to create structured JSON output right in the database, upping performance and radically simplifying web tiers.
952
953
954
How does a B-tree make queries fast?
B-tree is a structure that helps to search through great amounts of data. It was invented over 40 years ago, yet it is still employed by the majority of modern databases. Although there are newer index structures, like LSM trees, B-tree is unbeaten when handling most of the database queries.
955
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…
956
Are hard drives getting better?
After 13 years, the data is clear—the bathtub curve does not apply to hard drives. And, more importantly, hard drives are failing less and lasting longer.
957
958
Pebble: A RocksDB Inspired Key-Value Store Written in Go
Today we’re introducing Pebble, a RocksDB-inspired and RocksDB compatible key-value store written in Go that brings greater stability to CockroachDB.
959
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.
960
I/O Access Methods for Linux
Explore the four different ways to perform disk I/O on Linux and the tradeoffs and what we chose for ScyllaDB to build a high-performing database.