📇 Database Indexes - lincketheo

Morphsec88/conscious-data: A method where each file includes a tiny piece of metadata that tells the system where it is, making it accessible almost without searching.

⚙️Database Internals Code

github.com··Hacker News

Star Schema vs Snowflake Schema in PostgreSQL

☁️Storage Disaggregation

digitalocean.com·

How We Ditched Postgres for ClickHouse to Process 12 Billion Caches Per Day

📊Columnar Execution Blog

momentic.ai··Hacker News

Autonomous agents have met their biggest challenge yet: The database.

🔗WCOJ

thenewstack.io·

How the Other Half Counts

🚀Query Optimization Blog

thebuild.com··Hacker News

Learn SQL Once, Use It for 30 Years

🔀Join Algorithms Discussion

news.ycombinator.com··Hacker News

Day 3 of 100 Days of ClickHouse® - ClickHouse® vs PostgreSQL

📊Columnar Execution

quantrail-data.com··DEV

FokosDB: A strongly consistent bottomless storage database ontop of Cloudflare Durable Objects | Lambros Petrou

💾Storage Replication

lambrospetrou.com··Hacker News

Shaun Thomas: Looking Forward to Postgres 19: Query Hints

🧠Query Planners Blog

pgedge.com··Lobsters, Hacker News, r/PostgreSQL

SQLite improving performance with pre-sort

🗄️Database Engines

andersmurphy.com··Hacker News, r/coding, r/programming

jdalang/jda-lang: Jda: A high-performance systems language bootstrapped from assembly. Beats C on sudoku & LZ77. Self-hosted compiler, no GC, built-in concurrency & ML.

⚙️C Programming Code

github.com··DEV

Less-relevant results

rfgplk/micron.cpp: a pure C++ implementation (& redesign) of libc and the standard library

⚙️C Programming Code

github.com··Hacker News

How Fast Is DoltLite?

The perils of UUID primary keys in SQLite

Postgres vs. MySQL: Engineering the Right Trade-off for Heavy Workloads

Multiversion Concurrency Control for Multiversion B-Trees

Row vs Columnar Storage for Analytics: Why PostgreSQL Scans Are Slower Than They Should Be

Pagination patterns in Amazon Aurora DSQL

New comment by mleku in "Ask HN: Who wants to be hired? (June 2026)"

Christophe Pettus: All Your GUCs in a Row: cursor_tuple_fraction

Morphsec88/conscious-data: A method where each file includes a tiny piece of metadata that tells the system where it is, making it accessible almost without searching.

Star Schema vs Snowflake Schema in PostgreSQL

How We Ditched Postgres for ClickHouse to Process 12 Billion Caches Per Day

Autonomous agents have met their biggest challenge yet: The database.

How the Other Half Counts

Learn SQL Once, Use It for 30 Years

Day 3 of 100 Days of ClickHouse® - ClickHouse® vs PostgreSQL

FokosDB: A strongly consistent bottomless storage database ontop of Cloudflare Durable Objects | Lambros Petrou

Shaun Thomas: Looking Forward to Postgres 19: Query Hints

SQLite improving performance with pre-sort

jdalang/jda-lang: Jda: A high-performance systems language bootstrapped from assembly. Beats C on sudoku & LZ77. Self-hosted compiler, no GC, built-in concurrency & ML.

rfgplk/micron.cpp: a pure C++ implementation (& redesign) of libc and the standard library