--- title: We're building Postgres in Rust. Using the LLVM of databases description: Turso, the Rust-based SQLite rewrite, is announcing a new project to build a modern Postgres-compatible database on top of its core engine. The architecture... canonical: https://daily.dev/posts/we-re-building-postgres-in-rust-using-the-llvm-of-databases-yohpna7ee twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: We're building Postgres in Rust. Using the LLVM of databases | daily.dev og:description: Turso, the Rust-based SQLite rewrite, is announcing a new project to build a modern Postgres-compatible database on top of its core engine. The architecture... og:url: https://daily.dev/posts/we-re-building-postgres-in-rust-using-the-llvm-of-databases-yohpna7ee og:image: https://api.daily.dev/og/posts/yoHPNA7Ee.png og:image:alt: We're building Postgres in Rust. Using the LLVM of databases 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. # We're building Postgres in Rust. Using the LLVM of databases **[Lobsters](https://daily.dev/sources/lobsters)** · 12 min read · 20 upvotes · 1 comments ## Summary Turso, the Rust-based SQLite rewrite, is announcing a new project to build a modern Postgres-compatible database on top of its core engine. The architecture positions Turso as the 'LLVM of databases': a single reliable Rust core (using a VDBE bytecode VM) with multiple SQL frontends — SQLite first, Postgres next. Key differentiators include auto-updating materialized views, MVCC concurrent writes, full async support (runs in browsers via WASM), and deterministic simulation testing. The Postgres frontend is already runnable from source. The project aims for broad Postgres compatibility rather than 100% parity, is MIT-licensed, and is open to community contributions. Extensions may be supported via WASM containers. The team frames this as a multi-year effort prioritizing correctness over speed. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Questions this post answers ### Is Turso building a version of Postgres written in Rust? Yes, Turso announced an official project to build a Postgres-compatible database by compiling Postgres SQL into an abstract syntax tree that is then compiled down to Turso's existing VDBE bytecode engine, the same core used for its Rust rewrite of SQLite. The project grew out of an earlier proof-of-concept called pgmicro, now merged into the main Turso codebase, and can be built from source via cargo run, though no packages are published yet. _daily.dev surfaces updates like this for developers tracking new options in the Postgres and Rust database ecosystem._ ### Does Turso support materialized views that update automatically, unlike standard Postgres? Yes, Turso's materialized views update live and automatically, unlike Postgres, which requires manually running REFRESH MATERIALIZED VIEW or faking live behavior with triggers. This self-updating capability is one of several features, alongside MVCC-based concurrent writes and a rich type system, that Turso already supports beyond plain SQLite compatibility. _developers weighing database features for live-updating views can follow projects like this on daily.dev._ ### What is the VDBE in SQLite and Turso, and can it run arbitrary programs like Doom? VDBE is the internal bytecode virtual machine that SQLite (and Turso, its Rust rewrite) compiles SQL into, using database-specific higher-level operations rather than general-purpose instructions like a JVM or WASM. Turso proved the VDBE is expressive enough to be a general-purpose target by writing a small C-to-VDBE compiler and running Doom as VDBE bytecode inside a browser tab, with each frame produced as a query result row. _engineers curious about database internals and bytecode VMs can track deep dives like this on daily.dev._ ## Community discussion Top comments from developers on daily.dev. **@andradei** · 1 upvotes > that's a lofty goal. curious to see what they pull off. ## Similar posts on daily.dev - [Deep dive into Turso, the "SQLite rewrite in Rust"](https://daily.dev/posts/deep-dive-into-turso-the-sqlite-rewrite-in-rust--kn9wn7dsd) · Hacker News · 58 upvotes · 6 comments - [Why We Created Turso, a Rust-Based Rewrite of SQLite](https://daily.dev/posts/why-we-created-turso-a-rust-based-rewrite-of-sqlite-weanb5tiz) · The New Stack · 106 upvotes · 4 comments --- Tags: [#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/we-re-building-postgres-in-rust-using-the-llvm-of-databases-yohpna7ee) ```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":"TechArticle","headline":"We're building Postgres in Rust. Using the LLVM of databases","url":"https://daily.dev/posts/we-re-building-postgres-in-rust-using-the-llvm-of-databases-yohpna7ee","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/we-re-building-postgres-in-rust-using-the-llvm-of-databases-yohpna7ee"},"datePublished":"2026-07-17T12:14:35.327Z","dateModified":"2026-09-13T19:15:31.968Z","description":"Turso, the Rust-based SQLite rewrite, is announcing a new project to build a modern Postgres-compatible database on top of its core engine. The architecture...","image":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/fa368eef4242394ace1d427a56594fe1?_a=AQAEuop","thumbnailUrl":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/fa368eef4242394ace1d427a56594fe1?_a=AQAEuop","isAccessibleForFree":true,"articleSection":"Lobsters","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"Lobsters","logo":"https://media.daily.dev/image/upload/s--tl8v_Fku--/f_auto,t_logo/v1698841318/logos/lobste.jpg","url":"https://daily.dev/sources/lobsters"},"commentCount":1,"discussionUrl":"https://daily.dev/posts/we-re-building-postgres-in-rust-using-the-llvm-of-databases-yohpna7ee","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":20},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":1}],"keywords":"rust,postgresql,sqlite","timeRequired":"PT12M"} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"Lobsters","item":"https://daily.dev/sources/lobsters"},{"@type":"ListItem","position":3,"name":"We're building Postgres in Rust. Using the LLVM of databases"}]} {"@context":"https://schema.org","@type":"WebPage","@id":"https://daily.dev/posts/we-re-building-postgres-in-rust-using-the-llvm-of-databases-yohpna7ee","comment":[{"@type":"Comment","text":"that’s a lofty goal. curious to see what they pull off.","datePublished":"2026-07-17T16:00:30.728Z","url":"https://daily.dev/posts/yoHPNA7Ee#c-aM8DgGrfg","author":{"@type":"Person","name":"Isaac de Andrade","url":"https://daily.dev/andradei","image":"https://avatars.githubusercontent.com/u/2653546?v=4"},"interactionStatistic":{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":1}}]} {"@context":"https://schema.org","@type":"FAQPage","@id":"https://daily.dev/posts/we-re-building-postgres-in-rust-using-the-llvm-of-databases-yohpna7ee#faq","mainEntity":[{"@type":"Question","name":"Is Turso building a version of Postgres written in Rust?","acceptedAnswer":{"@type":"Answer","text":"Yes, Turso announced an official project to build a Postgres-compatible database by compiling Postgres SQL into an abstract syntax tree that is then compiled down to Turso's existing VDBE bytecode engine, the same core used for its Rust rewrite of SQLite. The project grew out of an earlier proof-of-concept called pgmicro, now merged into the main Turso codebase, and can be built from source via cargo run, though no packages are published yet. daily.dev surfaces updates like this for developers tracking new options in the Postgres and Rust database ecosystem."}},{"@type":"Question","name":"Does Turso support materialized views that update automatically, unlike standard Postgres?","acceptedAnswer":{"@type":"Answer","text":"Yes, Turso's materialized views update live and automatically, unlike Postgres, which requires manually running REFRESH MATERIALIZED VIEW or faking live behavior with triggers. This self-updating capability is one of several features, alongside MVCC-based concurrent writes and a rich type system, that Turso already supports beyond plain SQLite compatibility. developers weighing database features for live-updating views can follow projects like this on daily.dev."}},{"@type":"Question","name":"What is the VDBE in SQLite and Turso, and can it run arbitrary programs like Doom?","acceptedAnswer":{"@type":"Answer","text":"VDBE is the internal bytecode virtual machine that SQLite (and Turso, its Rust rewrite) compiles SQL into, using database-specific higher-level operations rather than general-purpose instructions like a JVM or WASM. Turso proved the VDBE is expressive enough to be a general-purpose target by writing a small C-to-VDBE compiler and running Doom as VDBE bytecode inside a browser tab, with each frame produced as a query result row. engineers curious about database internals and bytecode VMs can track deep dives like this on daily.dev."}}]} ```