--- title: PGRust passes all 46k Postgres tests, lobste.rs cuts VPS... description: A Rust reimplementation of PostgreSQL called PGRust has passed all 46,000 official regression queries and speaks the real wire protocol — still experimental,... canonical: https://daily.dev/posts/pgrust-passes-all-46k-postgres-tests-lobste-rs-cuts-vps-cost-in-half-with-sqlite-ghfwnci5h twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: PGRust passes all 46k Postgres tests, lobste.rs cuts VPS cost in half with SQLite | daily.dev og:description: A Rust reimplementation of PostgreSQL called PGRust has passed all 46,000 official regression queries and speaks the real wire protocol — still experimental,... og:url: https://daily.dev/posts/pgrust-passes-all-46k-postgres-tests-lobste-rs-cuts-vps-cost-in-half-with-sqlite-ghfwnci5h og:image: https://api.daily.dev/og/posts/GHfwNCi5H.png og:image:alt: PGRust passes all 46k Postgres tests, lobste.rs cuts VPS cost in half with SQLite og:image:width: 1200 og:image:height: 630 og:locale: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # PGRust passes all 46k Postgres tests, lobste.rs cuts VPS cost in half with SQLite **[Databases Digest](https://daily.dev/sources/databases_digest)** · 5 min read · 0 upvotes · 0 comments ## Summary A Rust reimplementation of PostgreSQL called PGRust has passed all 46,000 official regression queries and speaks the real wire protocol — still experimental, but a serious technical milestone. Lobste.rs completed its MariaDB-to-SQLite migration on July 11th and is already seeing lower CPU, lower memory, and roughly half the VPS cost. PostgreSQL 19 gets a closer look today with SQL/PGQ graph queries and new checkpoint control modes worth understanding before GA. Turso is also announcing a Postgres-compatible frontend on top of its Rust/SQLite core, framing itself as the 'LLVM of databases.' ## Content **TLDR:** A Rust reimplementation of PostgreSQL called PGRust has passed all 46,000 official regression queries and speaks the real wire protocol — still experimental, but a serious technical milestone. Lobste.rs completed its MariaDB-to-SQLite migration on July 11th and is already seeing lower CPU, lower memory, and roughly half the VPS cost. PostgreSQL 19 gets a closer look today with SQL/PGQ graph queries and new checkpoint control modes worth understanding before GA. Turso is also announcing a Postgres-compatible frontend on top of its Rust/SQLite core, framing itself as the 'LLVM of databases.' --- ## PGRust: full PostgreSQL reimplementation in Rust passes 46,000 regression tests PGRust is a complete Rust rewrite of PostgreSQL that passes all 46,000 official regression queries, speaks the real wire protocol, and can boot from an existing Postgres 18.3 data directory. An unpublished development branch replaces the process-per-connection model with threads, with developers claiming roughly 50% better transactional throughput and 300x better analytical performance — those numbers are unverified. It's not production-ready and lacks full extension compatibility, but the fact that it passes the full regression suite is a real result. The project also raises a practical question: AI coding agents were used heavily to accelerate the rewrite, which makes large infrastructure rewrites cheaper to attempt than they used to be. [Read more](https://daily.dev/posts/7vcsduyso) ## lobste.rs migrates from MariaDB to SQLite, cuts VPS cost roughly in half The Lobsters link aggregator completed its production migration from MariaDB to SQLite on July 11th, driven partly by MariaDB's acquisition by K1 and a desire to reduce operational complexity. The result: lower CPU and memory usage, a snappier site, and roughly half the VPS cost once the MariaDB server is decommissioned. The migration took multiple attempts over several months — key technical work included fixing full table scans on large tables, resolving an N+1 query, and adding a slow query log. The post covers WAL mode, busy timeout, strict tables, and a restic-based backup strategy, which pairs well with the practical SQLite production lessons covered in a separate post today. [Read more](https://daily.dev/feed-by-ids?id=zaLR6Qf3j&id=lnBwnHcLc) ## PostgreSQL 19 SQL/PGQ and checkpoint control modes explained PostgreSQL 19 Beta 2 is out now, with GA expected around September or October 2026. The headline feature is SQL/PGQ — ISO-standard graph queries rewritten to regular SQL joins under the hood, which means your existing indexes apply but you don't get index-free adjacency. The practical target is authorization graphs, org hierarchies, and dependency trees, not deep traversal over massive connected datasets. The new CHECKPOINT syntax adds MODE SPREAD, which paces writes over a longer window to avoid I/O spikes on busy servers — in benchmarks it took over two minutes on a 517MB dataset versus 400ms for MODE FAST, so it's about reducing disruption to concurrent workloads, not raw speed. There's also FLUSH_UNLOGGED for forcing dirty buffers from unlogged tables to disk on demand. [Read more](https://daily.dev/posts/fFxnYUzfk) ## Turso announces Postgres-compatible frontend on its Rust/SQLite core Turso is building a Postgres-compatible database on top of the same Rust core that powers its SQLite rewrite, positioning the engine as the 'LLVM of databases' — one VDBE bytecode VM with multiple SQL frontends. The Postgres frontend is already runnable from source. Differentiators include auto-updating materialized views, MVCC concurrent writes, full async support including WASM, and deterministic simulation testing. The team is explicit that this targets broad Postgres compatibility rather than 100% parity, and frames it as a multi-year effort prioritizing correctness first. [Read more](https://daily.dev/posts/yoHPNA7Ee) --- ## Also notable - **Cosmos DB query burned 2 million RUs before noon via cross-partition fan-out:** A three-line query combining SELECT *, no partition key filter, and ORDER BY caused a cross-partition fan-out across 4 million documents; compounded by a dashboard polling every 30 seconds across 40 browser tabs, RU cost ran into the millions before the fix — filtering on partition key and switching to change feed plus caching dropped per-call cost to single digits. [Read more](https://daily.dev/posts/3v2BNWPso) - **Patroni failover can silently skip WAL on logical replicas; Postgres 17 and Patroni 4.1+ fix it:** When Patroni promotes a standby, it creates a new logical replication slot at the current LSN, skipping any WAL the logical replica hadn't consumed yet — Postgres 17's sync_replication_slots with the failover slot parameter, combined with Patroni 4.1+, closes the gap without external tooling. [Read more](https://daily.dev/posts/EgaZaMrGt) - **Groww Holdings Service: ETags in Redis cut 66% of requests before any downstream call:** At 1 million requests per minute at market open, Groww's new Holdings Service uses HTTP ETags stored in Redis to return 304 Not Modified when holdings haven't changed, eliminating 66% of requests before they reach Portfolio or Positions services; the service is built on CockroachDB for future cell-based architecture. [Read more](https://daily.dev/posts/enOuF6yQx) - **BigQuery IAM data governance tags in preview supersede regional-only policy tags:** Google Cloud's preview of IAM data governance tags in BigQuery replaces policy tags with a global, hierarchical (up to 5 levels) alternative that auto-replicates for disaster recovery, enabling column-level PII masking across multi-region environments without the regional constraint. [Read more](https://daily.dev/posts/DI1gwjDT3) - **DuckDB v1.5.4 and v1.4.5 LTS ship with bugfixes and security hardening; PostHog migrated from ClickHouse:** The July 2026 DuckDB newsletter confirms patch releases v1.5.4 and v1.4.5 LTS with security hardening, and notes PostHog migrated from ClickHouse to single-tenant DuckDB instances — a concrete production signal for teams evaluating DuckDB as an embedded OLAP replacement. [Read more](https://daily.dev/posts/vBq5wDyAS) ## Similar posts on daily.dev - [GitHub - malisper/pgrust: Postgres rewritten in Rust, now passing 100% of the Postgres regression tests](https://daily.dev/posts/github---malisper-pgrust-postgres-rewritten-in-rust-now-passing-100-of-the-postgres-regression-te-t4anp8pcl) · Hacker News · 4 upvotes · 0 comments - [lobste.rs is now running on SQLite](https://daily.dev/posts/lobste-rs-is-now-running-on-sqlite-5hlawqyuh) · Lobsters · 1 upvotes · 0 comments --- Tags: [#database](https://daily.dev/tags/database), [#backend](https://daily.dev/tags/backend), [#rust](https://daily.dev/tags/rust), [#postgresql](https://daily.dev/tags/postgresql), [#sqlite](https://daily.dev/tags/sqlite) [View this post on daily.dev](https://daily.dev/posts/pgrust-passes-all-46k-postgres-tests-lobste-rs-cuts-vps-cost-in-half-with-sqlite-ghfwnci5h) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@type":"DiscussionForumPosting","mainEntityOfPage":"https://daily.dev/posts/pgrust-passes-all-46k-postgres-tests-lobste-rs-cuts-vps-cost-in-half-with-sqlite-ghfwnci5h","headline":"PGRust passes all 46k Postgres tests, lobste.rs cuts VPS cost in half with SQLite","text":"A Rust reimplementation of PostgreSQL called PGRust has passed all 46,000 official regression queries and speaks the real wire protocol — still experimental, but a serious technical milestone. Lobste.rs completed its MariaDB-to-SQLite migration on July 11th and is already seeing lower CPU, lower memory, and roughly half the VPS cost. PostgreSQL 19 gets a closer look today with SQL/PGQ graph queries and new checkpoint control modes worth understanding before GA. Turso is also announcing a Postgres-compatible frontend on top of its Rust/SQLite core, framing itself as the 'LLVM of databases.'","url":"https://daily.dev/posts/pgrust-passes-all-46k-postgres-tests-lobste-rs-cuts-vps-cost-in-half-with-sqlite-ghfwnci5h","datePublished":"2026-07-18T04:18:01.457Z","dateModified":"2026-07-18T04:18:22.126Z","author":{"@type":"Organization","name":"Databases Digest","logo":"https://media.daily.dev/image/upload/s--ir1hdV8b--/f_auto,q_auto/v1773839400/logos/databases_digest?_a=BAMAMiiu0","url":"https://daily.dev/sources/databases_digest"},"interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":0},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"isPartOf":{"@type":"WebPage","url":"https://daily.dev/sources/databases_digest","name":"Databases Digest"}} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"Databases Digest","item":"https://daily.dev/sources/databases_digest"},{"@type":"ListItem","position":3,"name":"PGRust passes all 46k Postgres tests, lobste.rs cuts VPS cost in half with SQLite"}]} ```