Syncing large attachments/files directly using PowerSync is not recommended. Smaller files can be stored as base64-encoded data, but syncing many larger files using database rows may cause performance degradation.
On the other hand, PowerSync works well for syncing the attachment metadata, which could include the file path, name, size, and type. The client may then download the file from the storage provider, such as Supabase Storage or AWS S3.
We currently have these helper packages available to manage attachments: