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!

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!

PGlite Lightweight WASM Postgres

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:

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.

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

Postgres Sandbox In-browser Postgres sandbox with AI assistance

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