361
SQLite (with WAL) doesn't do `fsync` on each commit under default settings
SQLite doesn’t do fsync unless specified.
New
The latest blog posts to take off on Hacker News. 4,224 posts.
362
Materialized views are obviously useful
As programmers we spend a lot of time shuttling data back and forth between different systems and transforming it from one format to another. Sometimes it gets pretty miserable!
363
Why was Apache Kafka created?
The story behind how LinkedIn created Apache Kafka
364
The two versions of Parquet
The adoption of Parquet version 2 is limited due to the lack of support in the ecosystem, which affects its evolution despite its improvements in compression and performance.
365
Why Semantic Layers Matter (and how to build one with DuckDB)
Learn what a semantic layer is, why it matters, and how to build a simple one with DuckDB and Ibis using just YAML and Python | Reading time: 22 min read
366
450× Faster Joins with Index Condition Pushdown
Introduction Readyset is designed to serve queries from cached views with sub-millisecond latency. This post focuses on the cold path—cases where a cache miss forces execution against the base tables. In these scenari...
367
Positron, a New Data Science IDE
We are excited to introduce Positron , a free, next-generation Integrated Development Environment (IDE) for data science by Posit PBC. Positron brings the spectrum of exploration and production work together in one environment so you can move from ideation to insight to application without switching context…
368
ClickHouse vs PostgreSQL UPDATE performance comparison
See how ClickHouse’s update speed stacks up against PostgreSQL on the same data and hardware.
369
Faster Index I/O with NVMe SSDs
The Marginalia Search index has been partially rewritten to perform much better, using new data structures designed to make better use of modern hardware. This post will cover the new design, and will also touch upon some of the unexpected and unintuitive performance characteristics of NVMe SSDs when it comes to read…
370
Lessons learned from building a sync-engine and reactivity system with SQLite
Welcome to my personal blog! I use it to share what I'm currently learning or thinking about, usually on topics related to technology, business, and health.
371
372
Neki – Sharded Postgres by the team behind Vitess
Sharded Postgres by the team behind Vitess
373
Build durable workflows with Postgres
In this blog post, we’ll dive deep into why we chose to build DBOS durable workflow execution on the PostgreSQL DBMS.
374
How we replaced Elasticsearch and MongoDB with Rust and RocksDB
Radar offers geocoding, place search, and fraud detection APIs, powered by HorizonDB, a Rust-based engine delivering 20k QPS and sub-millisecond latency.
375
376
A new database on police use of force and misconduct in California
UC Berkeley Journalism offers a two-year Master of Journalism (MJ) degree and a summer minor, preparing students for careers in journalism.
377
Representing Python notebooks as dataflow graphs
How and why marimo represents notebooks as dataflow graphs
378
Writing a storage engine for Postgres: An in-memory table access method (2023)
Writing a storage engine for Postgres: an in-memory Table Access Method
379
Gemini Embedding: Powering RAG and context engineering
Explore how organizations leverage Gemini Embedding for context-aware AI systems improving performance, accuracy, and efficiency across diverse industries.
380
Making Postgres slower
As an respectable unemployed person must do, I tried to make Postgres as slow as possible
381
PSA: SQLite WAL checksums fail silently and may lose data
SQLite WAL has checksums, but on corruption it drops all the data and does not raise error
382
Don't bother parsing: Just use images for RAG
If search is the game, looks matter
383
We made Postgres writes faster, but it broke replication
Exploring LSM tree implementation in PostgreSQL for better write performance.
384
Async I/O on Linux in databases
I've been working on a complex multi-model database for a few weeks now, and recently I took time to simplify and test out an idea I had on a simple key-value database. I started with the basics: A hash table in memory, a simple append-only log
385
Parsing Protobuf like never before
Historically I have worked on many projects related to high-performance Protobuf, be that on the C++ runtime, on the Rust runtime, or on integrating UPB , the fastest Protobuf runtime, written by my colleague Josh Haberman . I generally don’t post directly about my current job, but my most recent toy-turned-product is…
386
When Sigterm Does Nothing: A Postgres Mystery
A story about a bug with logical replication slot creation on Postgres read replicas
387
Embedding user-defined indexes in Apache Parquet
Posted on: Mon 14 July 2025 by Qi Zhu (Cloudera), Jigao Luo (Systems Group at TU Darmstadt), and Andrew Lamb (InfluxData)
388
Extending That XOR Trick to Billions of Rows
Learn how to extend the classic XOR trick to find thousands of missing values using Invertible Bloom Filters
389
Big Data was used to see if TCM was scientific (2023)
People love to show that skeptics were wrong about something, especially when national pride hangs in the balance. The South China Morning Post published the following headline on November 3rd: “Scientists find traditional Chinese medicine is based on a complex network of proteins – 3,000 years before modern science.”…
390
Supabase MCP can leak your entire SQL database
Indirect prompt injection through support-ticket data lets an MCP-enabled assistant cross trust boundaries and query private tables with Supabase’s privileged service role.