We’re excited to share our roadmap for 2025! Also read on to see what we shipped in January, including using the latest SQLite implementation for web and the release of CloudCode which lets you deploy necessary backend components directly on our cloud environment. Oh, and Simon Binder joined our team!
2025 Roadmap: SQLite, Web, Speed & Versatility
Announcing our roadmap for 2025 that will level-up PowerSync for the new era of web apps powered by sync engines, while preserving our offline & mobile DNA.
New: Turnkey Backend Functionality with CloudCode
CloudCode is a component that makes it possible to implement the backend API and JWT generation functionality required for using PowerSync directly on our cloud environment.
This makes PowerSync easier to implement for developers who prefer not having to maintain their own backend code and infrastructure. Initial support for MongoDB.
OPFS Outshines IndexedDB
Advancements in browser standards now enable SQLite to use filesystem storage via the OPFS browser APIs.
Version 1.13.0 of our JS Web SDK introduces support for this, with significantly improved performance over storing SQLite block data in IndexedDB.
Thanks to @json, @Yahya, @ak11, @Oussama and @rhashimoto for their help!
Self-Hosters Can Now Use Postgres for Bucket Storage
Self-hosting PowerSync no longer has a requirement to use MongoDB for sync bucket storage — you can use Postgres instead!
H/T @Isaac Hinman, @grinko, @Venkatesh Chittimuri and @noteeeeer.
JVM Compatibility for Kotlin Multiplatform
The latest version of our Kotlin Multiplatform SDK introduces support for the JVM target, which means that you can now deploy your PowerSync app to desktop platforms including Linux, Windows, and macOS.
Take a look at our %%hello-powersync%% demo app, which now includes the JVM target.
H/T @SalomonBrys!
Encryption Support for Flutter Web
Version 0.1.4 of %%powersync_sqlcipher%% brings database encryption support to Flutter Web using SQLCipher. Note that using the %%powersync_sqlcipher%% package replaces the need for the %%powersync%% package.
Thanks to @sbeltran10 and @willsmanley for spurring us on here :)
New Tutorial: Sequential ID Mapping
When using auto-incrementing or sequential IDs in your backend database, how do you handle offline client-side record creation?
A good solution is to use a secondary UUID on the client, then map it to a sequential ID when performing an update on the backend database.
Blog Post: Migrating a MongoDB Atlas Device Sync App to PowerSync
Moving away from MongoDB Atlas Device Sync / Realm? This is for you.
Blog Post: How Fast is Our Flutter SDK?
Benchmarks of our Flutter Client SDK, focusing on two key metrics: initial sync time and incremental sync latency.
Blog Post: Ditto vs PowerSync
We’ve completed a thorough analysis of the two systems and can share our findings.
Community Focus
New starter kit: PowerSync + Supertokens + Postgres + Email
Amazing work by Guillem Puche 👏
See it here
That's it for the January update, happy coding!
