Skip to main content
The supported client-side SQLite types are:
  1. null
  2. integer: a 64-bit signed integer
  3. real: a 64-bit floating point number
  4. text: A UTF-8 text string
  5. blob: Binary data

​
Postgres Type Mapping

Postgres types are mapped to SQLite types as follows:
Binary data can be accessed in the Sync Streams / Sync Rules, but cannot be used as parameters. To sync binary columns/fields to clients, those columns need to be converted to hex or base64 representation using the relevant functions.

​
Convex Type Mapping

The Convex replicator is currently released as an experimental feature. APIs and behavior may change, and we can’t yet guarantee continued support or long-term stability.
Convex values are mapped to SQLite types as follows:
  • Convex documents are converted to a flat list of columns, one column per top-level field.
  • Nested objects and arrays are converted to JSON, and JSON functions and operators can be used to query them in Sync Streams or on the client-side SQLite database.
  • Cast Convex Int64 fields to INTEGER in Sync Streams when you want SQLite integer values on the client, for example CAST(an_int64_column AS INTEGER) AS an_int64_column.

​
MongoDB Type Mapping

MongoDB types are mapped to SQLite types as follows:
  • Data is converted to a flat list of columns, one column per top-level field in the MongoDB document.
  • Special BSON types are converted to plain SQLite alternatives. For example, ObjectId, Date, UUID are all converted to a plain TEXT column.
  • Nested objects and arrays are converted to JSON, and JSON functions and operators can be used to query them (in the Sync Streams / Sync Rules and/or on the client-side SQLite statements).
  • Binary data nested in objects or arrays is not supported.
Binary data can be accessed in the Sync Streams / Sync Rules, but cannot be used as parameters. To sync binary columns/fields to clients, those columns need to be converted to hex or base64 representation using the relevant functions.

​
MySQL Type Mapping

MySQL support is currently in a Beta release.
MySQL types are mapped to SQLite types as follows:
Binary data can be accessed in the Sync Streams / Sync Rules, but cannot be used as parameters. To sync binary columns/fields to clients, those columns need to be converted to hex or base64 representation using the relevant functions.

​
SQL Server Type Mapping

SQL Server support is currently in a Beta release.
SQL Server types are mapped to SQLite types as follows:
Binary data can be accessed in the Sync Streams / Sync Rules, but cannot be used as parameters. To sync binary columns/fields to clients, those columns need to be converted to hex or base64 representation using the relevant functions.