OSS software I am most excited about right now: - TanStack Router (type safe routing) - ElectricSQL (local first PG) - Coolify & Kamal (self hosted docker - UV (better python environments) - DuckDB from MotherDuck (single file columnar analytics) So much good stuff.

NPM download stats are down again. Don't panic if npm download graphs are collapsing. It's not the end of web dev. It's not AI coming to replace us all. It's just the weekly sliding window catching up.

New Browsertech Podcast episode: People are Actually Using WebAssembly in the Browser! share.transistor.fm/s/b33089bc

WASM shines when you use it for it's strengths: - numeric processing for vector or 3D graphics, and simulations - binary data processing for databases, rasterisation - working in combination with WebGL or WebGPU Use it to get close to the hardware.

Live queries with PGLite + Drizzle ORM 🧙 Combine drizzle query builder, compile it to sql, and pass it to PGLite live query Sync changes with local db at lighting-speed ⚡️

The incredible TinyBase now supports PGlite for persistence 🚀🎉 If you've not tried it you must, James Pearce has built something special!

Love this, and it's the best argument for doc in packages yet! We include our TS types for our editors LS, we should also include the docs for our editors LLMs. Now, how to do this in a monorep with a single docs dir...

Seems we're debating SQL... It's not bad, it's just not perfect, but no language is. Two main problems: 1. It's usually used inside another language as a string, that causes friction. 2. doesn't do hierarchical/tree shaped results, when everything is a tree.

I'll be at this next week, looking forward to it. Come chat to me in the coffee breaks about PGlite, running databases in the browser with WASM and local first software.

Great line-up for Netlify Compose, including the panel on local-first featuring Kyle Mathews Quale Whale (no such issue) Peter van Hardenberg and Brooklyn Zelenka netlify.com/compose/agenda/

Badges are ready! #pgdayuk

I'm at PGDay UK #pgdayuk in London today. Come chat about PGlite (WASM Postgres), ElectricSQL sync and local-first software 🚀

PGlite (WASM Postgres) running in jupyterlite (WASM Jupyter + WASM Python) all in the browser 🚀🤯

This is very cool! A tiny app for launching PGlite (lightweight Postgres) instances for local development 🚀 It uses pg-gateway by Greg Richardson to expose the PGlite to any Postgres client.

Discover a fully local, in-browser semantic search experience, with: - PGlite for storing text and embeddings locally in IndexedDB - pgvector for inner product search - Hunggingface's Transformers.js with Supabase/gte-small to generate embeddings supabase.com/blog/in-browse…

Sync is the new default for app dev.

PGLite brings lightweight, reactive databases directly to your browser or server, opening up endless possibilities. Learn how we built Bookshelf, where each bookshelf becomes its own version-controlled database using Pinata! 📚✨ Explore now ⤵️ bit.ly/3XtZNI7