In April we published a Vue composables package, added full-text-search to our Web SDK and presented at Postgres Conf USA. We also saw community releases of a TinyBase PowerSync persister and an Ignite Cookbook recipe for implementing Supabase and PowerSync. Let’s get into it.
Conrad at Postgres Conf USA
Postgres Conference USA is the marquee Postgres event in North America and organized by the US Postgres community. Conrad took the stage to present Local-first apps using Postgres logical replication.
We'll publish a video of the presentation on our YouTube channel soon.
Check out the PowerSync YouTube channel
Vue Composables Package
Vue developers can now use PowerSync. We released the alpha version of a Vue Composables package that introduces reactivity/live queries for PowerSync functionality. We also added a demo project that shows how this package can be used with Supabase.
Shout out to Mow for prompting some of our work here.
JavaScript and React Native SDK Updates
We’ve done a lot of work to make our JS Web and React Native SDKs more capable and user-friendly. Here are some highlights:
- Added [.inline-code-snippet]hasSynced[.inline-code-snippet] property on [.inline-code-snippet]SyncStatus[.inline-code-snippet]. This value is managed in [.inline-code-snippet]AbstractPowerSyncDatabase[.inline-code-snippet], and becomes true after the first sync has completed.
- Added [.inline-code-snippet]waitForFirstSync[.inline-code-snippet] method to allow users to await on the state change of [.inline-code-snippet]hasSynced[.inline-code-snippet] to true.
- Added [.inline-code-snippet]executeBatch[.inline-code-snippet] method. This allows a SQL statement with multiple parameters to be executed in a single transaction, improving performance and consistency.
Thanks to Roman, Oleksii, AMayer and Mow for your discussions and feedback.
Ignite CookBook: PowerSync Recipe
The Ignite Cookbook was created to be an easy way for developers to browse and share React Native code snippets (or “recipes”) that actually work. In April, the PowerSync and Supabase for Local-First Data Management recipe was added.
Kudos to Trevor Coleman for creating a masterful guide.
TinyBase Persister Released
TinyBase is a reactive data store for local-first apps that can make use of various persisters. In April, TinyBase released v4.8 which added the [.inline-code-snippet]persister-powersync[.inline-code-snippet] module to allow TinyBase to rely on PowerSync as the underlying persistent storage.
Community member Benedikt Müller drove this initiative and wrote about the reasons why:
Full-Text Search for Web
We added full-text search (FTS) functionality to our fork of the [.inline-code-snippet]wa-sqlite[.inline-code-snippet] package, which means FTS can now be implemented alongside the PowerSync Web SDK.
Our React Todo List Demo app was updated to include FTS, which can be referenced when implementing FTS in your project. We share a few more details and a guide through our implementation in the docs.
Thanks to Moe A for spurring us on here!
Coming Up: Local-First Conf in Berlin
The inaugural Local-First Conf will be held in Berlin on May 30 and 31, and we’re proud to be a sponsor of this event. If you were lucky enough to get tickets, reach out to Ralf on our Discord who will be there to represent PowerSync.
That's it for the April update, happy coding!
