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 ⚡️
