Sync engine for keeping backend databases in sync with client-side SQLite. Postgres | MongoDB | MySQL | SQL Server | Azure DocumentDB 🐘🌿🐬🛢️«-» 🪶
Distributed
Joined May 2023
- Tweets1.6K
- Following786
- Followers2.2K
- Likes1.6K
PowerSync retweeted
Are healthcare apps your jam? Here's how HosTalky uses @powersync_ in its AI-powered, HIPAA compliant platform for clinicians (mobile: React Native, desktop: Electron)
powersync.com/blog/how-hosta…
PowerSync retweeted
Huge thanks to our speakers, volunteers, venue staff, and sponsors @Cloudflare , @powersync_ , @coderabbitai , @jazz_tools , @bluesky , @tangled_org, and solstone.app/ for making this possible at an accessible price. And to everyone who came: this only works because you show up. See you in 2027.
PowerSync retweeted
We had the opportunity to represent @powersync_ (our mascot is a dinosaur 🦖) at @localfirstconf in Berlin.
Had a lot of fun manning our booth and engaging with developers championing the local-first space!
The best chats included SQLite and @tan_stack's TanStack DB project.
PowerSync retweeted
A few months ago I tested LLMs as a prototyping accelerator... and ended up going down the rabbit hole of adding support for Convex to PowerSync... and ended up actually shipping it 🙈
If your users are asking for your Convex app to work offline, I'd love to hear your thoughts on this.
Notes 👇
PowerSync retweeted
We shipped initial support for Convex as a source database.
"Adding PowerSync to a Convex app gives you offline-first behavior, optimistic updates, and partial sync."
PowerSync retweeted
We got our @powersync_ dashboard rewrite blogpost out. It took a while but at least we got it out before Bun could get their rust port post out 😅. Good read by @Manrich121.
powersync.com/blog/rebuildin…
PowerSync retweeted
SQLite on the web continues to get better and faster
wa-sqlite now supports concurrent readers + a writer in Chromium, unlocking some massive performance gains for certain situations.
How does this work?
OPFSWriteAheadVFS avoids direct writes to the main database file during normal transactions. Instead, a writer records changed pages in separate log files first. That means readers can keep using a stable view of main DB plus any already-known newer pages, instead of fighting writers over the same file state.
PowerSync retweeted
I've been taking all my learnings of building AI applications of the past 14+ months and distilling them into a single blog series
Starting with this first post, with many more to come
PowerSync retweeted
This caught my eye so I added Xata to the @powersync_ setup guide (after thorough testing of course 😉)
Lightning fast partial sync from Xata to in-app SQLite - check my lil' video 👇
Xata is now open source. Apache 2.0.
Postgres platform with Copy-on-write branching at the storage layer. Copy a TB-sized database in seconds. Inactive copies scale to zero automatically. 100% vanilla Postgres.
Two use cases driving this:
• Preview and testing environments with real production data
• Platforms provisioning per-user Postgres at scale
Built on CloudNativePG + OpenEBS. Runs on Kubernetes.
What's in the release:
• SQL gateway, responsible for routing, IP filtering, waking up scaled-to-zero clusters, serving the serverless driver over HTTP / websockets, etc.
• Branch operator managing all resources related to a branch.
• Clusters and projects services for the control-plane and REST APIs
• Auth service, based on Keycloack for API keys
• CLI that makes use of the REST API
• Scale-to-zero CNPG plugin for automatically hibernating branches on inactivity
This is the first of several announcements. More next week.
PowerSync retweeted
Apparently there's a lot of myths surrounding sync engines that lead people to believe they are not a good fit for their use cases (or most use cases)
I'm trying to debunk these myths. Tell me why I'm wrong.
PowerSync retweeted
WAL on web, faster than indexeddb, working from multiple tabs, cheaper write tx cost than indexeddb. waow
Exciting news for SQLite on the web:
wa-sqlite supports a new OPFSWriteAheadVFS virtual file system that unlocks much better performance by allowing multiple workers to read the database concurrently with a writer.
This means your UI no longer needs to lock up during heavy writes!
Only works in Chromium right now.
PowerSync users will benefit from this, and anyone using SQLite persistence in the browser can leverage this via wa-sqlite
PowerSync retweeted
Really exciting news today: @mozilla announced Thunderbolt, an open-source sovereign AI client offering full ownership of data and optional E2E encryption, and it's built using @powersync_ 🥳
PowerSync retweeted
Should I ship this? Working prototype of offline support for Convex using @powersync_
PowerSync retweeted
some crazy new VFS science just dropped in wa-sqlite that enables concurrent readers on the web
PowerSync retweeted
V2 of the PowerSync Dart SDK has a huge number of improvements like: better performance, multiple isolate support and better defaults for a bunch of stuff. Check out the release notes.
dart pub add powersync
PowerSync retweeted
For the PowerSync Hackathon I hacked cross-device sync for my @lmstudio !
This project turns my LM Studio into the execution engine behind a synced, shareable, remotely accessible chat UI
PowerSync retweeted
I have implemented CRDTs and synchronized clients before but PowerSync does make it a lot easier. Especially on web with per tab sync as well.
Y’all have an awesome product 🚀
PowerSync retweeted
I have a new AI-friendly stack that has started to emerge in my @FlutterDev apps
- flutter_hooks in lib/ui/hooks
- injectable for DI in lib/src/services
- go_router / go_router_builder in lib/ui/screens
- shadcn_ui in lib/ui
I am also using signals, flutter_gemma, powersync too
PowerSync retweeted
The best part about building this app is how easy @powersync_ makes it to build AI apps that are reliable
Durable, resumable, and multiplayer LLM streams out of the box!
Building instant UI is as easy as making SQL queries from the UI components