Recommendation: Integrating brick into existing supabase project.

[SebastianKlaiber]

If I understand it correctly, then an ID based on UUID is recommended for brick to check which entries need to be synced with Supabase. Do you have any recommendation how to migrate from an INT based ID to a UUID based ID without breaking the existing apps?

[tshedor]

@SebastianKlaiber

1. Add a non-null UUID column to all tables. The default value should be a generated UUID (gen_random_uuid())
2. In Dart, specify both fields. Annotate both with @Sqlite(index: true, unique: true) and @Supabase(unique: true)
3. Specify an initializer list property for uuid, i.e. }) : uuid = uuid ?? const Uuid().v4();
4. After all clients have migrated to use the uuid field, remove the final int id field