Case Sensitivity
For simplicity, we recommend using only lower case identifiers for all table/collection and column/field names used in PowerSync. If you need to use a different case, continue reading.
Case in Sync Rules
PowerSync converts all table/collection and column/field names to lower-case by default in Sync Rule queries (this is how Postgres also behaves). To preserve the case, surround the names with double quotes, for example:
When using SELECT *
, the original case is preserved for the returned columns/fields.
Client-Side Case
On the client side, the case of table and column names in the client-side schema must match the case produced by Sync Rules exactly. For the above example, use the following in Dart:
SQLite itself is case-insensitive. When querying and modifying the data on the client, any case may be used. For example, the above table may be queried using SELECT description FROM todos WHERE listid = ?
.
Operations (PUT
/PATCH
/DELETE
) are stored in the upload queue using the case as defined in the schema above for table and column names, not the case used in queries.
As another example, in this Sync Rule query:
Each identifier in the example is unquoted and converted to lower case. That means the client-side schema would be:
Last updated