Store some fields in CloudKit unencrypted

[finnvoor]

Hi, sqlite-data seems to encrypt every value stored on CloudKit-synced CKRecords at the moment. CloudKit doesn’t support indexes on encrypted fields, so I can't query the CloudKit database using any predicates or sort descriptors (i.e. sort by addedAt date). It would be nice if some fields could be marked as unencrypted for use when querying the CloudKit database outside of sqlite-data.

[stephencelis]

@finnvoor We could definitely support something like:

try SyncEngine(
  for: $0.defaultDatabase,
  tables: RemindersList.self, Reminder.self,
  unencryptedFields: RemindersList.title, Reminder.title
)

And maybe even a flipped initializer for encryptedField. Folks would just need to take care when adding this configuration to an existing deployed app.

Can you explain a bit more about your use case, though? What kind of CloudKit querying do you need to do that can't be done using SQLiteData's tools?

[finnvoor]

In this case I'm interested in creating a web based version to view data using CloudKit js alongside an app, similar to Apple Notes/Reminders.