PowerSync 1.2.0

• Improved CrudBatch and CrudTransaction complete function extensions. Developers no longer need to specify nil as an argument for writeCheckpoint when calling CrudBatch.complete. The base complete functions still accept an optional writeCheckpoint argument if developers use custom write checkpoints.

guard let finalBatch = try await powersync.getCrudBatch(limit: 100) else {
  return nil
}
- try await batch.complete(writeCheckpoint: nil)
+ try await batch.complete()

• Fix reported progress around compactions / defrags on the sync service.
• Use version 0.4.0 of the PowerSync core extension, which improves sync performance.
• Add a new sync client implementation written in Rust instead of Kotlin. 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 opting in to experimental APIs and passing options when
  connecting:

  @_spi(PowerSyncExperimental) import PowerSync
  
  try await db.connect(connector: connector, options: ConnectOptions(
      newClientImplementation: true,
  ))

  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!
• In addition to HTTP streams, the Swift SDK also supports fetching sync instructions from the
  PowerSync service in a binary format. This requires the new sync client, and can then be enabled
  on the sync options:

  @_spi(PowerSyncExperimental) import PowerSync
  
  try await db.connect(connector: connector, options: ConnectOptions(
      newClientImplementation: true,
      connectionMethod: .webSocket,
  ))

PowerSync 1.1.0

• Add sync progress information through SyncStatusData.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.

PowerSync 1.0.0

• Improved the stability of watched queries. Watched queries were previously susceptible to runtime crashes if an exception was thrown in the update stream. Errors are now gracefully handled.

• Deprecated PowerSyncCredentials userId field. This value is not used by the PowerSync service.

• Added readLock and writeLock APIs. These methods allow obtaining a SQLite connection context without starting a transaction.

• Removed references to the PowerSync Kotlin SDK from all public API protocols. Dedicated Swift protocols are now defined. These protocols align better with Swift primitives. See the BRAKING CHANGES section for more details. Updated protocols include:

  • ConnectionContext - The context provided by readLock and writeLock
  • Transaction - The context provided by readTransaction and writeTransaction
  • CrudBatch - Response from getCrudBatch
  • CrudTransaction Response from getNextCrudTransaction
  • CrudEntry - Crud entries for CrudBatch and CrudTransaction
  • UpdateType - Operation type for CrudEntrys
  • SqlCursor - Cursor used to map SQLite results to typed result sets
  • JsonParam - JSON parameters used to declare client parameters in the connect method
  • JsonValue - Individual JSON field types for JsonParam

• Database and transaction/lock level query execute methods now have @discardableResult annotation.

• Query methods' parameters typing has been updated to [Any?] from [Any]. This makes passing nil or optional values to queries easier.

• AttachmentContext, AttachmentQueue, AttachmentService and SyncingService are are now explicitly declared as open classes, allowing them to be subclassed outside the defining module.

BREAKING CHANGES:

• Completing CRUD transactions or CRUD batches, in the PowerSyncBackendConnector uploadData handler, now has a simpler invocation.

- _ = try await transaction.complete.invoke(p1: nil)
+ try await transaction.complete()

• index based SqlCursor getters now throw if the query result column value is nil. This is now consistent with the behaviour of named column getter operations. New getXxxxxOptional(index: index) methods are available if the query result value could be nil.

let results = try transaction.getAll(
                sql: "SELECT * FROM my_table",
                parameters: [id]
            ) { cursor in
-                 cursor.getString(index: 0)!
+                 cursor.getStringOptional(index: 0)
+                 // OR
+                 // try cursor.getString(index: 0) // if the value should be required
            }

• SqlCursor getters now directly return Swift types. getLong has been replaced with getInt64.

let results = try transaction.getAll(
                sql: "SELECT * FROM my_table",
                parameters: [id]
            ) { cursor in
-                 cursor.getBoolean(index: 0)?.boolValue,
+                 cursor.getBooleanOptional(index: 0),
-                 cursor.getLong(index: 0)?.int64Value,
+                 cursor.getInt64Optional(index: 0)
+                 // OR
+                 // try cursor.getInt64(index: 0) // if the value should be required
            }

• Client parameters now need to be specified with strictly typed JsonValue enums.

try await database.connect(
    connector: PowerSyncBackendConnector(),
    params: [
-        "foo": "bar"
+        "foo": .string("bar")
    ]
)

• SyncStatus values now use Swift primitives for status attributes. lastSyncedAt now is of Date type.

- let lastTime: Date? = db.currentStatus.lastSyncedAt.map {
-     Date(timeIntervalSince1970: TimeInterval($0.epochSeconds))
- }
+ let time: Date? = db.currentStatus.lastSyncedAt

• crudThrottleMs and retryDelayMs in the connect method have been updated to crudThrottle and retryDelay which are now of type TimeInterval. Previously the parameters were specified in milliseconds, the TimeInterval typing now requires values to be specified in seconds.

try await database.connect(
            connector: PowerSyncBackendConnector(),
-           crudThrottleMs: 1000,
-           retryDelayMs: 5000,
+           crudThrottle: 1,
+           retryDelay: 5,
            params: [
                "foo": .string("bar"),
            ]
        )

• throttleMs in the watched query WatchOptions has been updated to throttle which is now of type TimeInterval. Previously the parameters were specified in milliseconds, the TimeInterval typing now requires values to be specified in seconds.

let stream = try database.watch(
            options: WatchOptions(
                sql: "SELECT name FROM users ORDER BY id",
-               throttleMs: 1000,
+               throttle: 1,
                mapper: { cursor in
                    try cursor.getString(index: 0)
                }
            ))

PowerSync 1.0.0-Beta.13

• Update powersync-kotlin dependency to version 1.0.0-BETA32, which includes:
  • Removed unnecessary User-Id header from internal PowerSync service requests.
  • Fix getNextCrudTransaction() only returning a single item.

PowerSync 1.0.0-Beta.12

• Added attachment sync helpers
• Added support for cancellations in watched queries

PowerSync v1.0.0-Beta.11

Fix deadlock when calling connect() immediately after opening database.

PowerSync v1.0.0-Beta.10

• Added the ability to specify a custom logging implementation

  let db = PowerSyncDatabase(
    schema: Schema(
        tables: [
            Table(
                name: "users",
                columns: [
                    .text("name"),
                    .text("email")
                ]
            )
        ]
    ),
    logger: DefaultLogger(minSeverity: .debug)
)

• added .close() method on PowerSyncDatabaseProtocol
• Update powersync-kotlin dependency to version 1.0.0-BETA29, which fixes these issues:
  • Fix potential race condition between jobs in connect() and disconnect().
  • Fix race condition causing data received during uploads not to be applied.
  • Fixed issue where automatic driver migrations would fail with the error:

Sqlite operation failure database is locked attempted to run migration and failed. closing connection

PowerSync v1.0.0-Beta.9

• Update PowerSync SQLite core extension to 0.3.12.
• Added queuing protection and warnings when connecting multiple PowerSync clients to the same database file.
• Improved concurrent SQLite connection support. A single write connection and multiple read connections are used for concurrent read queries.
• Internally improved the linking of SQLite.
• Enabled Full Text Search support.
• Added the ability to update the schema for existing PowerSync clients.
• Fixed bug where local only, insert only and view name overrides were not applied for schema tables.

PowerSync v1.0.0-Beta.8

• Improved watch query internals. Added the ability to throttle watched queries.
• Added support for sync bucket priorities.
• Fixed uploading and downloading sync status indicators.

PowerSync v1.0.0-Beta.7

• Fixed an issue where throwing exceptions in the query mapper could cause a runtime crash.
• Internally improved type casting.