powersync

Release powersync-v2.3.2

• Fix state after calling disconnect() not consistently representing the correct sync status.

Release powersync-v2.3.1

• Fix BucketStorage.select() acquiring a write lock for read-only queries.
• Restore SQLCipher support on native platforms.

• Improve tab close detection for shared sync worker in #425
• Support custom HTTP clients in #424

Full Changelog: powersync-v2.2.0...powersync-v2.3.0

Release powersync-v2.2.0

• Fix disconnect() call leaving stale database isolates behind.
• Web: Update to SQLite 3.53.1.
• Web: Support OPFS-based file systems in Safari without additional headers. Remember to update the web worker with dart run powersync:setup_web after upgrading.
• Support latest versions of package:hooks and package:code_assets.

Release powersync-v2.1.0

• Add a DevTools extension to inspect running PowerSync databases in your app.

Release powersync-v2.0.2

• Update PowerSync SQLite core extension to version 0.4.13.
• Fix changes in active Sync Stream subscriptions causing a reconnect delay.

Release powersync-v2.0.1

• Fix documentation not generating.

Release powersync-v2.0.0

• Upgrade sqlite packages: Version 3.x of sqlite3, 0.6.x of sqlite3_web, 0.14.x of sqlite_async.
  • Remember to download updated db workers and sqlite3.wasm files after upgrading!
  • Breaking: Remove package:powersync/sqlite3_open.dart, since SQLite is now loaded through build hooks exclusively.
  • Breaking: Remove AbstractPowerSyncOpenFactory and PowerSyncOpenFactory. If you want to customize how databases
    are opened, use conditional imports for package:powersync/native.dart and package:powersync/web.dart to extend
    NativePowerSyncOpenFactory or WebPowerSyncOpenFactory, respectively.
  • Improve performance of native databases.
  • Native databases can now be opened on multiple isolates or Flutter engines (e.g. for background tasks).
    They will automatically share write locks and table updates. Note that only one instance may connect to the PowerSync service though.
  • For Chrome browsers, we now use OPFS by default instead of IndexedDB. This improves performance. Existing databases are still loaded from IndexedDB.
  • The maxReaders parameter on PowerSyncDatabase constructors is no longer functional, set that parameter on
    SqliteOptions instead.
  • Add watchUnthrottled and onChangeUnthrottled as variants of watch and onChange that only take backpressure
    from paused subscriptions into account withut using a fixed delay.
  • Add abortableReadLock and abortableWriteLock, which can be used to acquire a read/write context with a flexible
    abort signal instead of a fixed timeout.
• Breaking: The powersync_core, powersync_sqlcipher and powersync_flutter_libs packages have been removed.
  The powersync package now provides the entire SDK for all platforms (both for Flutter and standalone Dart apps).
• Breaking: The powersync_sleep and powersync_connection_name SQL functions have been removed. Also, it is
  no longer possible to define additional user-defined functions in Dart.
• Add encryption support to the powersync package (see the EncryptionOptions class for details).
• Remove the legacy Dart sync client. The new Rust client has been the default since version 1.17.0.
• Deprecate re-exports of other packages (package:powersync/sqlite_async.dart, package:powersync/sqlite3_common.dart,
  package:powersync/sqlite3.dart). Instead, add a dependency on the respective package and import it directly.
• Remove powersync_sync.worker.js. powersync_db.worker.js now covers both database access and sync.
• Fix sync isolate retry loop (#397).

• Add RawTable.inferred constructor, which can be used to specify raw tables without manual put and delete statements.
• Update PowerSync SQLite core extension to version 0.4.11.

• FEAT: Custom App Metadata (#354). (8188bb90)
• FEAT: Update core to 0.4.10 (#361). (d28dcd9d)

• Support latest version of sqlite_async.

• Web: Fix decoding sync streams on status.

• Add getCrudTransactions() returning a stream of completed transactions for uploads.
• Add experimental support for sync streams.
• Add new attachments helper implementation in package:powersync_core/attachments/attachments.dart.
• Add SwiftPM support.

• Fix excessive memory consumption during large sync.

• Support latest versions of package:sqlite3 and package:sqlite_async.
• Stream client: Improve disconnect() while a connection is being opened.
• Stream client: Support binary sync lines with Rust client and compatible PowerSync service versions.
• Sync client: Improve parsing error responses.

• Update the PowerSync core extension to 0.4.2.
• Add support for raw tables, which are user-managed regular SQLite tables instead of the JSON-based views managed by PowerSync.

• Rust client: Fix uploading local writs after reconnect.
• PowerSyncDatabase.withDatabase: Rename loggers parameter to logger for consistency.
• Fix parsing HTTP errors for sync service unavailability.

Add a new sync client implementation written in Rust instead of Dart. While this client is still experimental, we intend to make it the default in the future. The main benefit of this client is faster sync performance, but upcoming features will also require this client. We encourage interested users to try it out by passing SyncOptions to the connect method:

database.connect(
  connector: YourConnector(),
  options: const SyncOptions(
    syncImplementation: SyncClientImplementation.rust,
  ),
);

Switching between the clients can be done at any time without compatibility issues. If you run into issues with the new client, please reach out to us!

• Use package:http instead of package:fetch_client on the web (since the former now uses fetch as well).
• Allow disconnecting in the credentials callback of a connector.
• Deprecate retry and CRUD upload durations as fields and independent parameters. Use the new SyncOptions class instead.
• Fix sync progress report after a compaction or defragmentation on the sync service.

• Report real-time progress information about downloads through SyncStatus.downloadProgress.
• Add trackPreviousValues option on Table which sets CrudEntry.previousValues to previous values on updates.
• Add trackMetadata option on Table which adds a _metadata column that can be used for updates. The configured metadata is available through CrudEntry.metadata.
• Add ignoreEmptyUpdates option which skips creating CRUD entries for updates that don't change any values.

• Update a dependency to the latest release.

This updates powersync_core to version 1.2.3, which includes these changes:

• Introduce locks to avoid duplicate sync streams when multiple instances of the same database are opened.
• Refactor connect / disconnect internally.
• Warn when multiple instances of the same database are opened.
• Fix race condition causing data not to be applied while an upload is in progress.
• Web: Fix token invalidation logic when a sync worker is used.

• Update a dependency to the latest release.

• Update a dependency to the latest release.

• Support bucket priorities and partial syncs.

• Update a dependency to the latest release.

• Web: Support running in contexts where web workers are unavailable.
• Web: Fix sync worker logs not being disabled.
• powersync_sqlcipher: Web support.

• Fix statusStream emitting the same sync status multiple times.

• Increase limit on number of columns per table to 1999.
• Avoid deleting the $local bucket on connect().

• This package now uses the powersync_core package to provide its base functionality.

• Update a dependency to the latest release.

• [Web] Automatically flush IndexedDB storage to fix durability issues

• Flutter Web Beta release

• FEAT: Use a sync worker for web that offloads the task of synchronizing databases to a separate worker, allowing it to be coordinated across tabs even when the database itself is not in a shared worker.

• FIX: issue where CRUD uploads were not triggered when the SDK reconnected to the PowerSync service after being offline.

• Update dependency powersync_flutter_libs

• FIX: Validate duplicate table names. (47f71888)

• Update dependency sqlite_async to v0.9.0

• Update dependency powersync_flutter_libs

• FEAT: Added a warning if connector uploadData functions don't process CRUD items completely.

• FIX: Pass maxReaders parameter to PowerSyncDatabase.withFactory().

• Added refreshSchema(), allowing queries and watch calls to work against updated schemas.

• Fix powersync_flutter_libs dependency

• Requires journeyapps/powersync-service v0.5.0 or later when self-hosting
• Use powersync-sqlite-core v0.2.1
• Customize User-Agent header
• Add client_id parameter to sync requests
• Persist lastSyncedAt
• Emit update notifications for watch queries on disconnectAndClear()
• Validate that the powersync-sqlite-core version number is in a compatible range of ^0.2.0
• Always cast target_op (write checkpoints) to ensure it's an integer
• Sync optimizations for MOVE and REMOVE operations

• FEAT: Include schema validation check
• FEAT: Include new table check for maximum number of columns allowed

• CHORE: Update dependency powersync_flutter_libs

• CHORE: Update dependency powersync_flutter_libs

• CHORE: Update dependency powersync_flutter_libs

• FIX: hasSynced status should be reset after disconnectAndClear has been called. (5e12a079)

• FIX: Move JS to dev dependencies and lower version range ">=0.6.7 <0.8.0"

• FEAT: Introduces a custom script to download the sqlite3 wasm and powersync worker files. The command dart run powersync:setup_web must be run in the application's folder.

• FIX: Reintroduce waitForFirstSync.

• Web support is now included in the standard release but remains in alpha. Web support may have some limitations or bugs.

• Added support for client parameters when connecting.
• Fix watch query parameter triggerOnTables to prepend powersync view names.
• Upgrade dependency sqlite_async to version 0.8.1.
• Fix issue where hasSynced is cleared when offline.

• Fix issue where hasSynced is cleared when offline.

• Fix watch query parameter triggerOnTables to prepend powersync view names.
• Upgrade dependency sqlite_async to version 0.8.1.

• Added support for client parameters when connecting.