> Selecting a sync engine is a lot about knowing the constraints of your application.

Not so sure about this. These seem more like fundamentals than sliding scales.

> How many people will concurrently edit the same resources?

More than 1.

> How write-heavy is it?

Write-heavy enough that you'll encounter an unexpected write between two reads.

> Can you expect unreliable connections or offline usage?

Yes.

CAP with Electron and SQLite is no different from CAP with Tauri and MySQL.