pushDelta method

@override Future<void> pushDelta({ required String collection, required String recordId, required Map<String, dynamic> delta, required int baseVersion, required DateTime timestamp, })

Push delta (partial update) to backend.

Only sends changed fields instead of the entire document, reducing bandwidth by up to 98%.

Parameters:

• collection: Collection name
• recordId: Document ID
• delta: Only the fields that changed
• baseVersion: Version before this update
• timestamp: When the update occurred

If the backend doesn't support delta sync, this should fall back to a regular push() with the full document.

Implementation

@override
Future<void> pushDelta({
  required String collection,
  required String recordId,
  required Map<String, dynamic> delta,
  required int baseVersion,
  required DateTime timestamp,
}) async {
  // PostgreSQL supports JSON merge - update only changed fields
  await connection.execute(
    Sql.named('''
      UPDATE $collection
      SET data = data || @delta::jsonb,
          updated_at = @timestamp,
          version = version + 1
      WHERE record_id = @recordId
    '''),
    parameters: {
      'recordId': recordId,
      'delta': delta,
      'timestamp': timestamp,
    },
  );
}