PGlite
pglite.dev
PGlite
@pglite.dev
Lightweight WASM Postgres by @electric-sql.com

https://pglite.dev
Reposted by PGlite
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!
July 14, 2025 at 3:28 PM
Reposted by PGlite
Here’s @samwillis.uk talking about how we built @pglite.dev and the future of the project at @pgconf.dev in Montreal last month.
We've posted a video of Sam Willis's talk Compiling Postgres to WASM with PGlite (PGConf.dev 2025) https://youtu.be/hlW...
#post##postgresqlo##PGConfdev
June 9, 2025 at 1:12 PM
Reposted by PGlite
May 24, 2025 at 6:55 PM
Reposted by PGlite
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.
June 5, 2025 at 12:06 PM
Reposted by PGlite
🧵 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.
June 5, 2025 at 11:51 AM
Reposted by PGlite
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.
May 7, 2025 at 5:45 PM
Reposted by PGlite
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!
April 24, 2025 at 3:25 PM
Reposted by PGlite
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
PGlite
Lightweight WASM Postgres
pglite.dev
February 12, 2025 at 7:54 PM
Reposted by PGlite
A visual guide to database query execution querydoctor.com built by @simp.engineer using @pglite.dev
Query Doctor - Power Up Your Database
Fine-tune your queries, optimize and visualize your indexes
querydoctor.com
January 14, 2025 at 7:47 PM
Reposted by PGlite
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:
December 10, 2024 at 8:37 PM
Reposted by PGlite
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!
Electric BETA release | ElectricSQL
The Electric sync engine is now in BETA. If you haven't checked out Electric recently, it's a great time to take another look.
electric-sql.com
December 10, 2024 at 8:31 PM
Reposted by PGlite
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.
Episode #18 is out.

James Arthur (@thruflo.com) on ElectricSQL, read/write-path syncing and PGlite to run Postgres everywhere via WASM.

Full episode links and show notes in the comments.
December 3, 2024 at 1:16 PM
Reposted by PGlite
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 👇
November 24, 2024 at 10:39 AM
Reposted by PGlite
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!
November 24, 2024 at 10:12 PM
Reposted by PGlite
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
Local-only calories tracker app | Typeonce
A local-only calories tracker app made with TanStack Router, PGlite, Effect, XState and drizzle. The app is all client-side, fast, private, and reactive using a local postgres database.
www.typeonce.dev
November 21, 2024 at 11:40 AM
If you haven't already seen it, check out database.build 🤯 AI assisted Postgres sandbox in the browser developed by Supabase on PGlite.
Postgres Sandbox
In-browser Postgres sandbox with AI assistance
database.build
November 21, 2024 at 9:48 AM
Reposted by 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 🔥
October 25, 2024 at 8:52 AM
Reposted by PGlite
pglite is so cool… I expect big things
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 🔥
October 25, 2024 at 2:58 PM
Reposted by PGlite
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 ⚡️
November 10, 2024 at 6:04 PM