---
title: "A WebAssembly build of Postgres 17"
publication: "Postgres Weekly"
issue: 598
published_at: "2025-05-01"
canonical_url: "https://postgresweekly.com/issues/598"
---

Plus what really happens when you drop a column in Postgres. |        

#​598 — May 1, 2025 

[Web Version](https://postgresweekly.com/issues/598)  

Together with [![pgAnalyze\](https://res.cloudinary.com/cpress/image/upload/c_fill,g_auto,e_trim,w_350,h_100/e_make_transparent/co_white,e_outline:7/lhwcvgc1asd4fzaahty4.png)](https://pganalyze.com/webinars/pganalyze-latest-features-for-tuning-postgresql?utm_campaign=postgresweeklyexclprimary04302025)   

Postgres Weekly 

[![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60,q_auto/gm0omqymldqlicv5hgup.jpg)](https://pglite.dev/)  

[PGlite 0.3: Postgres on WASM, Now Based on Postgres 17](https://pglite.dev/) — PGlite is a WebAssembly-based build of Postgres that enables you to run an instance of Postgres wherever WebAssembly can be run (such as in the browser [as in this demo](https://pglite.dev/repl/)). v0.3 takes a big step forward in moving up to Postgres 17.4. ([GitHub repo.](https://github.com/electric-sql/pglite)) 

ElectricSQL   

[What Really Happens When You Drop a Column](https://www.thenile.dev/blog/drop-column) — When you run a `ALTER TABLE .. DROP COLUMN` you probably don’t think too hard about what’s going on behind the scenes, but sometimes specifics of the process can rear their ugly head. In short, ‘dropped’ columns may be gone but not forgotten. 

Gwen Shapira   [![\](https://res.cloudinary.com/cpress/image/upload/c_limit,w_480,h_480,q_auto/copm/8eb729fb.png)](https://pganalyze.com/webinars/pganalyze-latest-features-for-tuning-postgresql?utm_campaign=postgresweeklyexclprimary04302025) 

[Is Your Application Prepared for Your Next High Traffic Event?](https://pganalyze.com/webinars/pganalyze-latest-features-for-tuning-postgresql?utm_campaign=postgresweeklyexclprimary04302025) — Are you tired of your Postgres database feeling like a black box? Watch Postgres expert Lukas Fittl walk through the latest pganalyze features to tune slow queries, catch regressions, and keep Postgres running at its best in this on-demand video. 

pganalyze sponsor   

[Jepsen: Amazon RDS for PostgreSQL Multi-AZ Clusters Violate Snapshot Isolation](https://jepsen.io/analyses/amazon-rds-for-postgresql-17.4) — Jepsen is well known for its analysis of distributed systems. After some experimentation, the author found that Amazon RDS for PostgreSQL multi-AZ clusters (specifically) violate Snapshot Isolation, the strongest consistency model supported across all endpoints. 

Kyle Kingsbury   

[Why All Your Workflows Should Be Postgres Rows](https://www.dbos.dev/blog/why-workflows-should-be-postgres-rows) — It may be no surprise the folks behind the DBOS durable execution/workflow library think storing workflows in Postgres is a good idea, but here’s how they think about it from a schema POV. 

Kraft and Li (DBOS)   

📄 [A Postgres Planner Gotcha with CTEs, `DELETE` and `LIMIT`](https://www.shayon.dev/post/2025/119/a-postgresql-planner-gotcha-with-ctes-delete-and-limit/) – _“What seemed straightforward turned out to have a surprising interaction with the query planner.”_ Shayon Mukherjee 

📄 [Trusted Extensions Explained for Beginners](https://www.cybertec-postgresql.com/en/postgresql-trusted-extensions-for-beginners/) Pavlo Golub 

📄 [Postgres to ClickHouse: Data Modeling Tips](https://clickhouse.com/blog/postgres-to-clickhouse-data-modeling-tips-v2) Palacin and Srirampur (ClickHouse)   

**QUICK RELEASES:** 

- [DbGate 6.4](https://github.com/dbgate/dbgate) – Database manager app for both SQL and NoSQL databases. Now supporting DuckDB too.
- [pgAdmin 4 v9.3](https://www.pgadmin.org/docs/pgadmin4/9.3/release_notes_9_3.html) – Popular, feature-rich administration tool.
- [pspg 5.8.9](https://github.com/okbob/pspg) – Unix terminal pager for tabular data.
- [Dbmate 2.27](https://github.com/amacneil/dbmate) – Framework-agnostic, Go-powered database migration tool.
- [Good Job 4.10](https://github.com/bensheldon/good_job) – Postgres-backed job queue for Ruby on Rails.    

**Got a new email?** You can [change your address here](https://postgresweekly.com/edit_subscription/*|UID|*). 

--- 

**Bored of us?** [Click here to stop getting Postgres Weekly](https://postgresweekly.com/leave/*|UID|*). 

--- 

**Got a link for us?** Reply and tell us. We can't include everything but we'll look at anything you send. _Thanks!_ 

--- 

Published by Cooper Press Ltd.
Fairfield Enterprise Centre, Louth, LN11 0LS, United Kingdom 

Postgres, PostgreSQL and the Slonik Logo are trademarks or registered trademarks of the PostgreSQL Community Association of Canada. 

[Stop getting this newsletter](https://postgresweekly.com/leave/*|UID|*).