PGlite (WASM Postgres) now gets over 1 million downloads a week! 🤯🚀 Absolutely incredible to see how people have embraced what we have built. Awesome work by the team!

Here’s @samwillis.uk talking about how we built @pglite.dev and the future of the project at @pgconf.dev in Montreal last month.

Cc @pglite.dev

PGlite can now be used with any Postgres client, and pairs perfectly with AI app builders for vibe coding. Love that with @bolt.new *everything* runs in the browser - node, the dev server, and now even PGlite 🚀🤯 Awesome job by the team to get this out!

🧵 More play less infra => vibe coding with the database inside the sandbox. Apps built with AI app builders like @bolt.new usually need to connect to a database to actually work. With @pglite.dev you can have the database inside the sandbox, so you can vibe code without even thinking about infra.

One week till my talk @pgconf.dev! Very excited to be visiting Montreal 🇨🇦 Give me a shout if you want to meet up a chat @pglite.dev, @electric-sql.com, Sync Engines or Local-first app development.

PGlite is now based on Postgres 17 🎉🚀 v0.3, which we just released, is a big step forward for the project, and the foundation for a lot of exciting things coming soon!

Last but not least, huge special mention to the crew behind pglite.dev - fully-featured Postgres-in-the-browser via WASM 🤯 - which Bluesky Inbox uses to store your data locally. Massive shout out to @thruflo.com and the gang at electric-sql.com

A visual guide to database query execution querydoctor.com built by @simp.engineer using @pglite.dev

Exciting day, @electric-sql.com is now in Beta 🚀 Electric makes realtime replication between Postgres & *any* client side store possible! (And we've scaled it to 1 million connections 🤯) Here it is syncing 100k rows to a @pglite.dev app:

ElectricSQL is now in BETA! We're a Postgres sync engine. Check out our new 1 million clients benchmark and demos: electric-sql.com/blog/2024/12... Electric is ready to sync with companies like Trigger.dev, Ottogrid.ai and Doorboost.com using us in production. Great time to take another look!

I had a great conversation with @thruflo.com about ElectricSQL. They've massively simplified their product over the last year making it a lot simpler and scalable. I particularly enjoyed diving into read-path vs write-path syncing. We also discuss PGlite which is absolutely wild.

New project landing next week Tuesday 26 November 🚀 Local-only calories tracker app 🏗️ @effect-ts.bsky.social ⚡️ @pglite.dev with live queries 📄 @drizzle.team 🔗 Actors with XState 🧱 @tanstack.com router Your next local-first stack 👇

pglite (pglite.dev) has completely replaced sqlite for me when bootstrapping new projects When deploying, all I have to do is replace the drizzle-orm postgres adapter from pglite to a different one and that's it!

New project coming: Local-only calories tracker app A key component of a local-first app is a local data store This is how to implement a local postgres database 👇 www.typeonce.dev/course/calor... @drizzle.team @pglite.dev @tailwindcss.com @vite.dev @tanstack.com @effect-ts.bsky.social

If you haven't already seen it, check out database.build 🤯 AI assisted Postgres sandbox in the browser developed by Supabase on PGlite.

With PGlite + ElectricSQL sync you can build an issue tracker handling 100k issues + 500k comments, synced from Postgres to PGlite in the browser! Super fast UI updates with all writes going though the local database, and Postgres FTS in PGlite for search 🔥

pglite is so cool… I expect big things

Live queries with PGLite and @drizzle.team 👉 Compose query using drizzle 👉 `toSQL` to extract raw query and params Exactly what it's needed inside `useLiveQuery` to make PGLite live sync with db changes ⚡️