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
- Following787
- Followers2.2K
- Likes1.7K
PowerSync retweeted
We’re doubling down on open source.
Today we're making PowerSync's entire core open source by moving our remaining source-available (FSL) repos to Apache-2.0
Our hypothesis: less legal friction → more adoption → a stronger business → more investment in open source.
Read 👇
PowerSync retweeted
Super interesting move by Powersync.
Moving their core from "fair source" to apache2. What's the opposite of a rug pull? They're making the dining room extra cozy and are inviting everyone in!
#opensource
PowerSync retweeted
📵 No network? No problem.
Go offline-first with Azure DocumentDB + PowerSync: apps read/write against local SQLite while Change Streams help sync cloud updates back down. 🔄⚡
Explore the alpha integration 👇 msft.it/6012aaTgg
ALT A digital graphic promoting offline-first apps using Azure DocumentDB and PowerSync. Features a blue cloud, a database icon, and various connected devices like laptops and mobile phones. Text highlights the technologies involved.
PowerSync retweeted
TanStack DB + @powersync_ is goated for mobile apps
PowerSync retweeted
The data loading and caching story of both ChatGPT and Claude are horrendous
I was really expecting better from trillion dollar companies but when you let AI drive the implementation without proper investment into infrastructure I guess this is doomed to happen
Please use a proper sync engine folks
PowerSync retweeted
Been a big fan of @powersync_ for a long time! Deeply researched alternatives at the time, and have kept a close eye on the space ever since.
I haven't seen anything that does quite as much, while staying relatively unopinionated and open ended.
So much of day to day building comes down to moving data from one place to another, and a sync engine simplifies so much!
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_