prawnstar
Joined 5 years ago
Karma
101
Submissions
13
Member since
Jan 18
Born -> Walked -> Ran -> Hit my head -> Studied -> Went into sales -> Worked at a start up -> Now a developer/writer :)
View on Hacker NewsRecent submissions
Comment · 2 years ago
Hi ricg thanks for the great question! We have a docs page that speaks to this https://docs.powersync.com/usage/sync-rules/client-id:
"PowerSync does not perform any validation that IDs are unique. Duplicate IDs on a client could occur in any of these scenarios:
- A non-unique column is used for the ID.
- Multiple table partitions are used, with the same ID present in different partitions.
- Multiple data queries returning the same record. This is typically not an issue if the queries return the same values (same transformations used in each query)."
Comment · 2 years ago
Thanks for the feedback! Along with the docs we also have an active Discord that anyone is welcome to join for any queries, requests, discussions etc https://discord.gg/powersync
Comment · 2 years ago
Hey there's a comparison of the two here https://powersync.com/blog/electricsql-vs-powersync