@powersync/react-native

Enumerations

Enumeration	Description
ColumnType	-
LockType	-
OpTypeEnum	-
PSInternalTable	-
RowUpdateType	Update table operation numbers from SQLite
SyncStreamConnectionMethod	-
UpdateType	Type of local change.

Classes

Class	Description
AbortOperation	Calls to Abortcontroller.abort(reason: any) will result in the `reason` being thrown. This is not necessarily an error, but extends error for better logging purposes.
AbstractPowerSyncDatabase	-
AbstractPowerSyncDatabaseOpenFactory	-
AbstractRemote	-
AbstractStreamingSyncImplementation	-
BaseObserver	-
Column	-
CrudBatch	A batch of client-side changes.
CrudEntry	A single client-side change.
CrudTransaction	A batch of client-side changes.
DataStream	A very basic implementation of a data stream with backpressure support which does not use native JS streams or async iterators. This is handy for environments such as React Native which need polyfills for the above.
FetchImplementationProvider	Class wrapper for providing a fetch implementation. The class wrapper is used to distinguish the fetchImplementation option in [AbstractRemoteOptions] from the general fetch method which is typeof "function"
Index	-
IndexedColumn	-
OpType	Used internally for sync buckets.
OplogEntry	-
PowerSyncDatabase	A PowerSync database which provides SQLite functionality which is automatically synced.
RNQSDBAdapter	Adapter for React Native Quick SQLite
RNQSPowerSyncDatabaseOpenFactory	-
ReactNativeQuickSqliteOpenFactory	Opens a SQLite connection using React Native Quick SQLite
ReactNativeRemote	-
ReactNativeStreamingSyncImplementation	-
Schema	A schema is a collection of tables. It is used to define the structure of a database.
SqliteBucketStorage	-
SyncDataBatch	-
SyncDataBucket	-
SyncStatus	-
Table	-
TableV2	Generate a new table from the columns and indexes
UploadQueueStats	-

Functions

Function	Description
extractTableUpdates	-
isBatchedUpdateNotification	-
isContinueCheckpointRequest	-
isDBAdapter	Tests if input is a DBAdapter
isPowerSyncDatabaseOptionsWithSettings	Tests if the input is a PowerSyncDatabaseOptionsWithSettings
isSQLOpenFactory	Tests if input is a SQLOpenFactory
isSQLOpenOptions	Tests if the input is a SQLOpenOptions
isStreamingKeepalive	-
isStreamingSyncCheckpoint	-
isStreamingSyncCheckpointComplete	-
isStreamingSyncCheckpointDiff	-
isStreamingSyncData	-
isSyncNewCheckpointRequest	-
parseQuery	-
usePowerSync	Custom hook that provides access to the PowerSync context.
usePowerSyncQuery	-
usePowerSyncStatus	-
usePowerSyncWatchedQuery	-
useQuery	A hook to access the results of a watched query.
useStatus	Custom hook that provides access to the current status of PowerSync.

Interfaces

AbstractStreamingSyncImplementationOptions

Properties

Property	Type	Description
`adapter`	`BucketStorageAdapter`	-
`crudUploadThrottleMs?`	`number`	-
`identifier?`	`string`	An identifier for which PowerSync DB this sync implementation is linked to. Most commonly DB name, but not restricted to DB name.
`logger?`	`ILogger`	-
`remote`	`AbstractRemote`	-
`retryDelayMs?`	`number`	-
`uploadCrud`	() => `Promise`<`void`>	-

BaseObserverInterface<T>

Extended by

DBAdapter

Type parameters

Type parameter
`T` extends `BaseListener`

Methods

registerListener()

registerListener(listener): () => void

Parameters

Parameter	Type
`listener`	`Partial`<`T`>

Returns

Function

Returns

void

BasePowerSyncDatabaseOptions

Extended by

Properties

Property	Type	Description
`crudUploadThrottleMs?`	`number`	Backend Connector CRUD operations are throttled to occur at most every `crudUploadThrottleMs` milliseconds.
`logger?`	`ILogger`	-
`retryDelay?`	`number`	Delay for retrying sync streaming operations from the PowerSync backend after an error occurs.
`schema`	`Schema`<`SchemaType`>	Schema used for the local database.

BatchedUpdateNotification

Properties

Property	Type
`groupedUpdates`	`Record`<`string`, `TableUpdateOperation`[]>
`rawUpdates`	`UpdateNotification`[]
`tables`	`string`[]

BucketChecksum

Properties

Property	Type	Description
`bucket`	`string`	-
`checksum`	`number`	32-bit unsigned hash.
`count?`	`number`	Count of operations - informational only.

BucketRequest

Properties

Property	Type	Description
`after`	`string`	Base-10 number. Sync all data from this bucket with op_id > after.
`name`	`string`	-

BucketState

Properties

Property	Type
`bucket`	`string`
`op_id`	`string`

BucketStorageAdapter

Extends

BaseObserver<BucketStorageListener>.Disposable

Properties

Property	Type	Inherited from
`dispose`	() => `Promise`<`void`>	`Disposable`.`dispose`

Methods

autoCompact()

autoCompact(): Promise<void>

Exposed for tests only.

Returns

Promise<void>

forceCompact()

forceCompact(): Promise<void>

Exposed for tests only.

Returns

Promise<void>

getBucketStates()

getBucketStates(): Promise<BucketState[]>

Returns

Promise<BucketState[]>

getClientId()

getClientId(): Promise<string>

Get an unique client id.

Returns

Promise<string>

getCrudBatch()

getCrudBatch(limit?): Promise<null | CrudBatch>

Parameters

Parameter	Type
`limit`?	`number`

Returns

Promise<null | CrudBatch>

getMaxOpId()

getMaxOpId(): string

Returns

string

hasCompletedSync()

hasCompletedSync(): Promise<boolean>

Returns

Promise<boolean>

hasCrud()

hasCrud(): Promise<boolean>

Returns

Promise<boolean>

init()

init(): Promise<void>

Returns

Promise<void>

iterateAsyncListeners()

iterateAsyncListeners(cb): Promise<void>

Parameters

Parameter	Type
`cb`	(`listener`) => `Promise`<`any`>

Returns

Promise<void>

Inherited from

BaseObserver.iterateAsyncListeners

iterateListeners()

iterateListeners(cb): void

Parameters

Parameter	Type
`cb`	(`listener`) => `any`

Returns

void

Inherited from

BaseObserver.iterateListeners

nextCrudItem()

nextCrudItem(): Promise<undefined | CrudEntry>

Returns

Promise<undefined | CrudEntry>

registerListener()

registerListener(listener): () => void

Parameters

Parameter	Type
`listener`	`Partial`<`BucketStorageListener`>

Returns

Function

Returns

void

Inherited from

BaseObserver.registerListener

removeBuckets()

removeBuckets(buckets): Promise<void>

Parameters

Parameter	Type
`buckets`	`string`[]

Returns

Promise<void>

saveSyncData()

saveSyncData(batch): Promise<void>

Parameters

Parameter	Type
`batch`	`SyncDataBatch`

Returns

Promise<void>

setTargetCheckpoint()

setTargetCheckpoint(checkpoint): Promise<void>

Parameters

Parameter	Type
`checkpoint`	`Checkpoint`

Returns

Promise<void>

startSession()

startSession(): void

Returns

void

syncLocalDatabase()

syncLocalDatabase(checkpoint): Promise<{
  checkpointValid: boolean;
  failures: any[];
  ready: boolean;
}>

Parameters

Parameter	Type
`checkpoint`	`Checkpoint`

Returns

Promise<{ checkpointValid: boolean; failures: any[]; ready: boolean; }>

Member	Type
`checkpointValid`	`boolean`
`failures`	`any`[]
`ready`	`boolean`

updateLocalTarget()

updateLocalTarget(cb): Promise<boolean>

Parameters

Parameter	Type
`cb`	() => `Promise`<`string`>

Returns

Promise<boolean>

BucketStorageListener

Extends

BaseListener

Properties

Property	Type
`crudUpdate`	() => `void`

Checkpoint

Properties

Property	Type
`buckets`	`BucketChecksum`[]
`last_op_id`	`string`
`write_checkpoint?`	`string`

ChecksumCache

Properties

Property	Type
`checksums`	`Map`<`string`, { `checksum`: `BucketChecksum`; `last_op_id`: `string`; }>
`lastOpId`	`string`

ColumnOptions

Properties

Property	Type
`name`	`string`
`type?`	`ColumnType`

CompilableQuery<T>

Type parameters

Type parameter
`T`

Methods

compile()

compile(): CompiledQuery

Returns

CompiledQuery

execute()

execute(): Promise<T[]>

Returns

Promise<T[]>

CompiledQuery

Properties

Property	Modifier	Type
`parameters`	`readonly`	readonly `unknown`[]
`sql`	`readonly`	`string`

ContinueCheckpointRequest

For sync2.json

Properties

Property	Type	Description
`buckets`	`BucketRequest`[]	Existing bucket states. Only these buckets are synchronized.
`checkpoint_token`	`string`	-
`limit?`	`number`	-

CrudRequest

For crud.json

Properties

Property	Type
`data`	`CrudEntry`[]

CrudResponse

Properties

Property Type Description

Property	Type	Description
`checkpoint?`	`string`	A sync response with a checkpoint >= this checkpoint would contain all the changes in this request. Any earlier checkpoint may or may not contain these changes. May be empty when the request contains no ops.

checkpoint?

string

A sync response with a checkpoint >= this checkpoint would contain all the changes in this request.

Any earlier checkpoint may or may not contain these changes.

May be empty when the request contains no ops.

DBAdapter

Extends

BaseObserverInterface<DBAdapterListener>.DBGetUtils

Properties

Property	Type
`close`	() => `void`
`execute`	(`query`: `string`, `params`?: `any`[]) => `Promise`<`QueryResult`>
`executeBatch`	(`query`: `string`, `params`?: `any`[][]) => `Promise`<`QueryResult`>
`name`	`string`
`readLock`	<`T`>(`fn`: (`tx`) => `Promise`<`T`>, `options`?: `DBLockOptions`) => `Promise`<`T`>
`readTransaction`	<`T`>(`fn`: (`tx`) => `Promise`<`T`>, `options`?: `DBLockOptions`) => `Promise`<`T`>
`writeLock`	<`T`>(`fn`: (`tx`) => `Promise`<`T`>, `options`?: `DBLockOptions`) => `Promise`<`T`>
`writeTransaction`	<`T`>(`fn`: (`tx`) => `Promise`<`T`>, `options`?: `DBLockOptions`) => `Promise`<`T`>

Methods

get()

get<T>(sql, parameters?): Promise<T>

Execute a read-only query and return the first result, error if the ResultSet is empty.

Type parameters

Type parameter
`T`

Parameters

Parameter	Type
`sql`	`string`
`parameters`?	`any`[]

Returns

Promise<T>

Inherited from

DBGetUtils.get

getAll()

getAll<T>(sql, parameters?): Promise<T[]>

Execute a read-only query and return results.

Type parameters

Type parameter
`T`

Parameters

Parameter	Type
`sql`	`string`
`parameters`?	`any`[]

Returns

Promise<T[]>

Inherited from

DBGetUtils.getAll

getOptional()

getOptional<T>(sql, parameters?): Promise<null | T>

Execute a read-only query and return the first result, or null if the ResultSet is empty.

Type parameters

Type parameter
`T`

Parameters

Parameter	Type
`sql`	`string`
`parameters`?	`any`[]

Returns

Promise<null | T>

Inherited from

DBGetUtils.getOptional

registerListener()

registerListener(listener): () => void

Parameters

Parameter	Type
`listener`	`Partial`<`DBAdapterListener`>

Returns

Function

Returns

void

Inherited from

BaseObserverInterface.registerListener

DBAdapterListener

Extends

BaseListener

Properties

Property	Type	Description
`tablesUpdated`	(`updateNotification`: `BatchedUpdateNotification` \| `UpdateNotification`) => `void`	Listener for table updates. Allows for single table updates in order to maintain API compatibility without the need for a major version bump The DB adapter can also batch update notifications if supported.

DBGetUtils

Extended by

Methods

get()

get<T>(sql, parameters?): Promise<T>

Execute a read-only query and return the first result, error if the ResultSet is empty.

Type parameters

Type parameter
`T`

Parameters

Parameter	Type
`sql`	`string`
`parameters`?	`any`[]

Returns

Promise<T>

getAll()

getAll<T>(sql, parameters?): Promise<T[]>

Execute a read-only query and return results.

Type parameters

Type parameter
`T`

Parameters

Parameter	Type
`sql`	`string`
`parameters`?	`any`[]

Returns

Promise<T[]>

getOptional()

getOptional<T>(sql, parameters?): Promise<null | T>

Execute a read-only query and return the first result, or null if the ResultSet is empty.

Type parameters

Type parameter
`T`

Parameters

Parameter	Type
`sql`	`string`
`parameters`?	`any`[]

Returns

Promise<null | T>

DBLockOptions

Properties

Property	Type
`timeoutMs?`	`number`

DataStreamListener<Data>

Extends

BaseListener

Type parameters

Type parameter	Value
`Data` extends `any`	`any`

Properties

Property	Type
`closed`	() => `void`
`data`	(`data`: `Data`) => `Promise`<`void`>
`error`	(`error`: `Error`) => `void`
`highWater`	() => `Promise`<`void`>
`lowWater`	() => `Promise`<`void`>

DisconnectAndClearOptions

Properties

Property	Type	Description
`clearLocal?`	`boolean`	When set to false, data in local-only tables is preserved.

Disposable

Extended by

Properties

Property	Type
`dispose`	() => `Promise`<`void`>

IndexColumnOptions

Properties

Property	Type
`ascending?`	`boolean`
`name`	`string`

IndexOptions

Properties

Property	Type
`columns?`	`IndexedColumn`[]
`name`	`string`

LockContext

Extends

DBGetUtils

Extended by

Transaction

Properties

Property	Type	Description
`execute`	(`query`: `string`, `params`?: `any`[]) => `Promise`<`QueryResult`>	Execute a single write statement.

Methods

get()

get<T>(sql, parameters?): Promise<T>

Execute a read-only query and return the first result, error if the ResultSet is empty.

Type parameters

Type parameter
`T`

Parameters

Parameter	Type
`sql`	`string`
`parameters`?	`any`[]

Returns

Promise<T>

Inherited from

DBGetUtils.get

getAll()

getAll<T>(sql, parameters?): Promise<T[]>

Execute a read-only query and return results.

Type parameters

Type parameter
`T`

Parameters

Parameter	Type
`sql`	`string`
`parameters`?	`any`[]

Returns

Promise<T[]>

Inherited from

DBGetUtils.getAll

getOptional()

getOptional<T>(sql, parameters?): Promise<null | T>

Execute a read-only query and return the first result, or null if the ResultSet is empty.

Type parameters

Type parameter
`T`

Parameters

Parameter	Type
`sql`	`string`
`parameters`?	`any`[]

Returns

Promise<null | T>

Inherited from

DBGetUtils.getOptional

LockOptions<T>

Abstract Lock to be implemented by various JS environments

Type parameters

Type parameter
`T`

Properties

Property	Type
`callback`	() => `Promise`<`T`>
`signal?`	`AbortSignal`
`type`	`LockType`

OplogEntryJSON

Properties

Property	Type
`checksum`	`number`
`data?`	`string`
`object_id?`	`string`
`object_type?`	`string`
`op`	`string`
`op_id`	`string`
`subkey?`	`string` \| `object`

ParsedQuery

Properties

Property	Type
`parameters`	`any`[]
`sqlStatement`	`string`

PowerSyncBackendConnector

Properties

Property Type Description

fetchCredentials

() => Promise<null | PowerSyncCredentials>

Allows the PowerSync client to retrieve an authentication token from your backend which is used to authenticate against the PowerSync service.

This should always fetch a fresh set of credentials - don't use cached values.

Return null if the user is not signed in. Throw an error if credentials cannot be fetched due to a network error or other temporary error.

This token is kept for the duration of a sync connection.

uploadData

(database: AbstractPowerSyncDatabase) => Promise<void>

Upload local changes to the app backend.

Use AbstractPowerSyncDatabase.getCrudBatch to get a batch of changes to upload.

Any thrown errors will result in a retry after the configured wait period (default: 5 seconds).

PowerSyncCloseOptions

Properties

Property	Type	Description
`disconnect?`	`boolean`	Disconnect the sync stream client if connected. This is usually true, but can be false for Web when using multiple tabs and a shared sync provider.

PowerSyncConnectionOptions

Configurable options to be used when connecting to the PowerSync backend instance.

Properties

Property	Type	Description
`connectionMethod?`	`SyncStreamConnectionMethod`	The connection method to use when streaming updates from the PowerSync backend instance. Defaults to a HTTP streaming connection.
`params?`	`Record`<`string`, `JSONValue`>	These parameters are passed to the sync rules, and will be available under the`user_parameters` object.

PowerSyncCredentials

Properties

Property	Type
`endpoint`	`string`
`expiresAt?`	`Date`
`token`	`string`

PowerSyncDBListener

Extends

StreamingSyncImplementationListener

Properties

Property	Type	Description	Inherited from
`initialized`	() => `void`	-	-
`statusChanged?`	(`status`: `SyncStatus`) => `void`	Triggers whenever the status' members have changed in value	`StreamingSyncImplementationListener`.`statusChanged`
`statusUpdated?`	(`statusUpdate`: `SyncStatusOptions`) => `void`	Triggered whenever a status update has been attempted to be made or refreshed.	`StreamingSyncImplementationListener`.`statusUpdated`

PowerSyncDatabaseOptions

Extends

BasePowerSyncDatabaseOptions

Properties

Property	Type	Description	Inherited from
`crudUploadThrottleMs?`	`number`	Backend Connector CRUD operations are throttled to occur at most every `crudUploadThrottleMs` milliseconds.	`BasePowerSyncDatabaseOptions`.`crudUploadThrottleMs`
`database`	`DBAdapter` \| `SQLOpenFactory` \| `SQLOpenOptions`	Source for a SQLite database connection. This can be either: A DBAdapter if providing an instantiated SQLite connection A SQLOpenFactory which will be used to open a SQLite connection SQLOpenOptions for opening a SQLite connection with a default SQLOpenFactory	-
`logger?`	`ILogger`	-	`BasePowerSyncDatabaseOptions`.`logger`
`retryDelay?`	`number`	Delay for retrying sync streaming operations from the PowerSync backend after an error occurs.	`BasePowerSyncDatabaseOptions`.`retryDelay`
`schema`	`Schema`<`SchemaType`>	Schema used for the local database.	`BasePowerSyncDatabaseOptions`.`schema`

PowerSyncDatabaseOptionsWithDBAdapter

Extends

BasePowerSyncDatabaseOptions

Properties

Property	Type	Description	Inherited from
`crudUploadThrottleMs?`	`number`	Backend Connector CRUD operations are throttled to occur at most every `crudUploadThrottleMs` milliseconds.	`BasePowerSyncDatabaseOptions`.`crudUploadThrottleMs`
`database`	`DBAdapter`	-	-
`logger?`	`ILogger`	-	`BasePowerSyncDatabaseOptions`.`logger`
`retryDelay?`	`number`	Delay for retrying sync streaming operations from the PowerSync backend after an error occurs.	`BasePowerSyncDatabaseOptions`.`retryDelay`
`schema`	`Schema`<`SchemaType`>	Schema used for the local database.	`BasePowerSyncDatabaseOptions`.`schema`

PowerSyncDatabaseOptionsWithOpenFactory

Extends

BasePowerSyncDatabaseOptions

Properties

Property	Type	Description	Inherited from
`crudUploadThrottleMs?`	`number`	Backend Connector CRUD operations are throttled to occur at most every `crudUploadThrottleMs` milliseconds.	`BasePowerSyncDatabaseOptions`.`crudUploadThrottleMs`
`database`	`SQLOpenFactory`	-	-
`logger?`	`ILogger`	-	`BasePowerSyncDatabaseOptions`.`logger`
`retryDelay?`	`number`	Delay for retrying sync streaming operations from the PowerSync backend after an error occurs.	`BasePowerSyncDatabaseOptions`.`retryDelay`
`schema`	`Schema`<`SchemaType`>	Schema used for the local database.	`BasePowerSyncDatabaseOptions`.`schema`

PowerSyncDatabaseOptionsWithSettings

Extends

BasePowerSyncDatabaseOptions

Properties

Property	Type	Description	Inherited from
`crudUploadThrottleMs?`	`number`	Backend Connector CRUD operations are throttled to occur at most every `crudUploadThrottleMs` milliseconds.	`BasePowerSyncDatabaseOptions`.`crudUploadThrottleMs`
`database`	`SQLOpenOptions`	-	-
`logger?`	`ILogger`	-	`BasePowerSyncDatabaseOptions`.`logger`
`retryDelay?`	`number`	Delay for retrying sync streaming operations from the PowerSync backend after an error occurs.	`BasePowerSyncDatabaseOptions`.`retryDelay`
`schema`	`Schema`<`SchemaType`>	Schema used for the local database.	`BasePowerSyncDatabaseOptions`.`schema`

PowerSyncOpenFactoryOptions

Extends

Partial<PowerSyncDatabaseOptions>.SQLOpenOptions

Properties

Property	Type	Description	Overrides	Inherited from
`crudUploadThrottleMs?`	`number`	Backend Connector CRUD operations are throttled to occur at most every `crudUploadThrottleMs` milliseconds.	`Partial.crudUploadThrottleMs`	`Partial.crudUploadThrottleMs`
`database?`	`DBAdapter` \| `SQLOpenFactory` \| `SQLOpenOptions`	Source for a SQLite database connection. This can be either: A DBAdapter if providing an instantiated SQLite connection A SQLOpenFactory which will be used to open a SQLite connection SQLOpenOptions for opening a SQLite connection with a default SQLOpenFactory	`Partial.database`	`Partial.database`
`dbFilename`	`string`	Filename for the database.	`SQLOpenOptions`.`dbFilename`	`SQLOpenOptions`.`dbFilename`
`dbLocation?`	`string`	Directory where the database file is located.	`SQLOpenOptions`.`dbLocation`	`SQLOpenOptions`.`dbLocation`
`debugMode?`	`boolean`	Enable debugMode to log queries to the performance timeline. Defaults to false. To enable in development builds, use: debugMode: process.env.NODE_ENV !== 'production'	`SQLOpenOptions`.`debugMode`	`SQLOpenOptions`.`debugMode`
`logger?`	`ILogger`	-	`Partial.logger`	`Partial.logger`
`retryDelay?`	`number`	Delay for retrying sync streaming operations from the PowerSync backend after an error occurs.	`Partial.retryDelay`	`Partial.retryDelay`
`schema`	`Schema`<`SchemaType`>	Schema used for the local database.	`Partial.schema`	`Partial.schema`

SQLOpenFactory

Methods

openDB()

openDB(): DBAdapter

Opens a connection adapter to a SQLite DB

Returns

DBAdapter

SQLOpenOptions

Extended by

PowerSyncOpenFactoryOptions

Properties

Property Type Description

dbFilename string Filename for the database.

dbLocation? string Directory where the database file is located.

debugMode?

boolean

Enable debugMode to log queries to the performance timeline.

Defaults to false.

To enable in development builds, use:

debugMode: process.env.NODE_ENV !== 'production'

SQLWatchOptions

Properties

Property	Type	Description
~~`rawTableNames?`~~	`boolean`	Deprecated All tables specified in tables will be watched, including PowerSync tables with prefixes. Allows for watching any SQL table by not removing PowerSync table name prefixes
`signal?`	`AbortSignal`	-
`tables?`	`string`[]	-
`throttleMs?`	`number`	The minimum interval between queries.

StreamingSyncCheckpoint

Properties

Property	Type
`checkpoint`	`Checkpoint`

StreamingSyncCheckpointComplete

Properties

Property	Type
`checkpoint_complete`	{ `last_op_id`: `string`; }
`checkpoint_complete.last_op_id`	`string`

StreamingSyncCheckpointDiff

Properties

Property	Type
`checkpoint_diff`	{ `last_op_id`: `string`; `removed_buckets`: `string`[]; `updated_buckets`: `BucketChecksum`[]; `write_checkpoint`: `string`; }
`checkpoint_diff.last_op_id`	`string`
`checkpoint_diff.removed_buckets`	`string`[]
`checkpoint_diff.updated_buckets`	`BucketChecksum`[]
`checkpoint_diff.write_checkpoint`	`string`

StreamingSyncDataJSON

Properties

Property	Type
`data`	`SyncDataBucketJSON`

StreamingSyncImplementation

Extends

BaseObserver<StreamingSyncImplementationListener>.Disposable

Properties

Property	Type	Inherited from
`dispose`	() => `Promise`<`void`>	`Disposable`.`dispose`
`getWriteCheckpoint`	() => `Promise`<`string`>	-
`hasCompletedSync`	() => `Promise`<`boolean`>	-
`isConnected`	`boolean`	-
`lastSyncedAt?`	`Date`	-
`syncStatus`	`SyncStatus`	-
`triggerCrudUpload`	() => `void`	-

Methods

connect()

connect(options?): Promise<void>

Connects to the sync service

Parameters

Parameter	Type
`options`?	`PowerSyncConnectionOptions`

Returns

Promise<void>

disconnect()

disconnect(): Promise<void>

Disconnects from the sync services.

Returns

Promise<void>

Throws

if not connected or if abort is not controlled internally

iterateAsyncListeners()

iterateAsyncListeners(cb): Promise<void>

Parameters

Parameter	Type
`cb`	(`listener`) => `Promise`<`any`>

Returns

Promise<void>

Inherited from

BaseObserver.iterateAsyncListeners

iterateListeners()

iterateListeners(cb): void

Parameters

Parameter	Type
`cb`	(`listener`) => `any`

Returns

void

Inherited from

BaseObserver.iterateListeners

registerListener()

registerListener(listener): () => void

Parameters

Parameter	Type
`listener`	`Partial`<`StreamingSyncImplementationListener`>

Returns

Function

Returns

void

Inherited from

BaseObserver.registerListener

waitForReady()

waitForReady(): Promise<void>

Returns

Promise<void>

waitForStatus()

waitForStatus(status): Promise<void>

Parameters

Parameter	Type
`status`	`SyncStatusOptions`

Returns

Promise<void>

StreamingSyncImplementationListener

Extends

BaseListener

Extended by

PowerSyncDBListener

Properties

Property	Type	Description
`statusChanged?`	(`status`: `SyncStatus`) => `void`	Triggers whenever the status' members have changed in value
`statusUpdated?`	(`statusUpdate`: `SyncStatusOptions`) => `void`	Triggered whenever a status update has been attempted to be made or refreshed.

StreamingSyncKeepalive

Properties

Property	Type	Description
`token_expires_in`	`number`	If specified, token expires in this many seconds.

StreamingSyncRequest

Properties

Property	Type	Description
`buckets?`	`BucketRequest`[]	Existing bucket states.
`client_id?`	`string`	-
`include_checksum`	`boolean`	Whether or not to compute a checksum for each checkpoint
`only?`	`string`[]	If specified, limit the response to only include these buckets.
`parameters?`	`Record`<`string`, `JSONValue`>	Client parameters to be passed to the sync rules.
`raw_data`	`boolean`	Changes the response to stringified data in each OplogEntry

SyncLocalDatabaseResult

Properties

Property	Type
`checkpointFailures?`	`string`[]
`checkpointValid`	`boolean`
`ready`	`boolean`

SyncNewCheckpointRequest

Properties

Property	Type	Description
`buckets?`	`BucketRequest`[]	Existing bucket states. Used if include_data is specified.
`limit?`	`number`	-
`request_checkpoint`	{ `include_checksum`: `boolean`; `include_data`: `boolean`; }	-
`request_checkpoint.include_checksum`	`boolean`	Whether or not to compute a checksum.
`request_checkpoint.include_data`	`boolean`	Whether or not to include an initial data request.

SyncResponse

Properties

Property	Type	Description
`checkpoint?`	`Checkpoint`	-
`checkpoint_token?`	`string`	-
`data?`	`SyncDataBucketJSON`[]	Data for the buckets returned. May not have an an entry for each bucket in the request.
`has_more`	`boolean`	True if the response limit has been reached, and another request must be made.

TableOptions

Properties

Property	Type	Description
`columns`	`Column`[]	-
`indexes?`	`Index`[]	-
`insertOnly?`	`boolean`	-
`localOnly?`	`boolean`	-
`name`	`string`	The synced table name, matching sync rules
`viewName?`	`string`	-

TableUpdateOperation

Extended by

UpdateNotification

Properties

Property	Type
`opType`	`RowUpdateType`
`rowId`	`number`

TableV2Options

Properties

Property	Type
`indexes?`	`IndexShorthand`
`insertOnly?`	`boolean`
`localOnly?`	`boolean`
`viewName?`	`string`

Transaction

Extends

LockContext

Properties

Property	Type	Description	Inherited from
`commit`	() => `Promise`<`QueryResult`>	Commit multiple changes to the local DB using the Transaction context.	-
`execute`	(`query`: `string`, `params`?: `any`[]) => `Promise`<`QueryResult`>	Execute a single write statement.	`LockContext`.`execute`
`rollback`	() => `Promise`<`QueryResult`>	Roll back multiple attempted changes using the Transaction context.	-

Methods

get()

get<T>(sql, parameters?): Promise<T>

Execute a read-only query and return the first result, error if the ResultSet is empty.

Type parameters

Type parameter
`T`

Parameters

Parameter	Type
`sql`	`string`
`parameters`?	`any`[]

Returns

Promise<T>

Inherited from

LockContext.get

getAll()

getAll<T>(sql, parameters?): Promise<T[]>

Execute a read-only query and return results.

Type parameters

Type parameter
`T`

Parameters

Parameter	Type
`sql`	`string`
`parameters`?	`any`[]

Returns

Promise<T[]>

Inherited from

LockContext.getAll

getOptional()

getOptional<T>(sql, parameters?): Promise<null | T>

Execute a read-only query and return the first result, or null if the ResultSet is empty.

Type parameters

Type parameter
`T`

Parameters

Parameter	Type
`sql`	`string`
`parameters`?	`any`[]

Returns

Promise<null | T>

Inherited from

LockContext.getOptional

UpdateNotification

Notification of an update to one or more tables, for the purpose of realtime change notifications.

Extends

TableUpdateOperation

Properties

Property	Type	Inherited from
`opType`	`RowUpdateType`	`TableUpdateOperation`.`opType`
`rowId`	`number`	`TableUpdateOperation`.`rowId`
`table`	`string`	-

WatchHandler

Properties

Property	Type
`onError?`	(`error`: `Error`) => `void`
`onResult`	(`results`: `QueryResult`) => `void`

WatchOnChangeEvent

Properties

Property	Type
`changedTables`	`string`[]

WatchOnChangeHandler

Properties

Property	Type
`onChange`	(`event`: `WatchOnChangeEvent`) => `void` \| `Promise`<`void`>
`onError?`	(`error`: `Error`) => `void`

Type Aliases

AbstractRemoteOptions

type AbstractRemoteOptions: {
  fetchImplementation: FetchImplementation | FetchImplementationProvider;
  socketUrlTransformer: (url) => string;
};

Type declaration

Member	Type	Description
`fetchImplementation`	`FetchImplementation` \| `FetchImplementationProvider`	Optionally provide the fetch implementation to use. Note that this usually needs to be bound to the global scope. Binding should be done before passing here.
`socketUrlTransformer`	(`url`) => `string`	Transforms the PowerSync base URL which might contain `http(s)://` to the corresponding WebSocket variant e.g. `ws(s)://`

BSONImplementation

type BSONImplementation: typeof BSON;

BaseColumnType<T>

type BaseColumnType<T>: {
  type: ColumnType;
};

Type parameters

Type parameter
`T` extends `number` \| `string` \| `null`

Type declaration

Member	Type
`type`	`ColumnType`

BaseListener

type BaseListener: {};

Index signature

[key: string]: (...event) => any | undefined

ColumnsType

type ColumnsType: Record<string, BaseColumnType<any>>;

DataStreamCallback()<Data>

type DataStreamCallback<Data>: (data) => Promise<void>;

Type parameters

Type parameter	Value
`Data` extends `any`	`any`

Parameters

Parameter	Type
`data`	`Data`

Returns

Promise<void>

DataStreamOptions

type DataStreamOptions: {
  closeOnError: boolean;
  logger: ILogger;
  pressure: {
     highWaterMark: number;
     lowWaterMark: number;
    };
};

Type declaration

Member	Type	Description
`closeOnError`	`boolean`	Close the stream if any consumer throws an error
`logger`	`ILogger`	-
`pressure`	{
`highWaterMark`: `number`;
`lowWaterMark`: `number`;
}	-
`pressure.highWaterMark`	`number`	-
`pressure.lowWaterMark`	`number`	-

ExtractColumnValueType<T>

type ExtractColumnValueType<T>: T extends BaseColumnType<infer R> ? R : unknown;

Type parameters

Type parameter
`T` extends `BaseColumnType`<`any`>

FetchImplementation

type FetchImplementation: typeof fetch;

IndexShorthand

type IndexShorthand: Record<string, string[]>;

OpId

type OpId: string;

64-bit unsigned integer stored as a string in base-10.

Not sortable as a string.

OpTypeJSON

type OpTypeJSON: string;

QueryResult

type QueryResult: {
  insertId: number;
  rows: {
     _array: any[];
     item: (idx) => any;
     length: number;
    };
  rowsAffected: number;
};

Object returned by SQL Query executions.

Type declaration

Member	Type	Description
`insertId`	`number`	Represents the auto-generated row id if applicable.
`rows`	{
`_array`: `any`[];
`item`: (`idx`) => `any`;
`length`: `number`;
}	if status is undefined or 0 this object will contain the query results
`rows._array`	`any`[]	Raw array with all dataset
`rows.item`	(`idx`) => `any`	A convenience function to acess the index based the row object
`rows.length`	`number`	The length of the dataset
`rowsAffected`	`number`	Number of affected rows if result of a update query.

RemoteConnector

type RemoteConnector: {
  fetchCredentials: () => Promise<PowerSyncCredentials | null>;
};

Type declaration

Member	Type
`fetchCredentials`	() => `Promise`<`PowerSyncCredentials` \| `null`>

RowType<T>

type RowType<T>: { [K in keyof T["columnMap"]]: ExtractColumnValueType<T["columnMap"][K]> } & {
  id: string;
};

Type declaration

Member	Type
`id`	`string`

Type parameters

Type parameter
`T` extends `TableV2`<`any`>

StreamingSyncLine

type StreamingSyncLine: 
  | StreamingSyncDataJSON
  | StreamingSyncCheckpoint
  | StreamingSyncCheckpointDiff
  | StreamingSyncCheckpointComplete
  | StreamingSyncKeepalive;

StreamingSyncRequestParameterType

type StreamingSyncRequestParameterType: JSONValue;

SyncDataBucketJSON

type SyncDataBucketJSON: {
  after: string;
  bucket: string;
  data: OplogEntryJSON[];
  has_more: boolean;
  next_after: string;
};

Type declaration

Member	Type
`after`	`string`
`bucket`	`string`
`data`	`OplogEntryJSON`[]
`has_more`	`boolean`
`next_after`	`string`

SyncDataFlowStatus

type SyncDataFlowStatus: Partial<{
  downloading: boolean;
  uploading: boolean;
}>;

Type declaration

Member	Type
`downloading`	`boolean`
`uploading`	`boolean`

SyncRequest

type SyncRequest: ContinueCheckpointRequest | SyncNewCheckpointRequest;

SyncStatusOptions

type SyncStatusOptions: {
  connected: boolean;
  dataFlow: SyncDataFlowStatus;
  hasSynced: boolean;
  lastSyncedAt: Date;
};

Type declaration

Member	Type
`connected`	`boolean`
`dataFlow`	`SyncDataFlowStatus`
`hasSynced`	`boolean`
`lastSyncedAt`	`Date`

SyncStreamOptions

type SyncStreamOptions: {
  abortSignal: AbortSignal;
  data: StreamingSyncRequest;
  fetchOptions: Request;
  headers: Record<string, string>;
  path: string;
};

Type declaration

Member	Type
`abortSignal`	`AbortSignal`
`data`	`StreamingSyncRequest`
`fetchOptions`	`Request`
`headers`	`Record`<`string`, `string`>
`path`	`string`

Variables

DEFAULT_CRUD_UPLOAD_THROTTLE_MS

const DEFAULT_CRUD_UPLOAD_THROTTLE_MS: 1000 = 1000;

DEFAULT_INDEX_COLUMN_OPTIONS

const DEFAULT_INDEX_COLUMN_OPTIONS: Partial<IndexColumnOptions>;

DEFAULT_INDEX_OPTIONS

const DEFAULT_INDEX_OPTIONS: Partial<IndexOptions>;

DEFAULT_LOCK_TIMEOUT_MS

const DEFAULT_LOCK_TIMEOUT_MS: 120000 = 120000;

Requesting nested or recursive locks can block the application in some circumstances. This default lock timeout will act as a failsafe to throw an error if a lock cannot be obtained.

DEFAULT_POWERSYNC_CLOSE_OPTIONS

const DEFAULT_POWERSYNC_CLOSE_OPTIONS: PowerSyncCloseOptions;

DEFAULT_POWERSYNC_DB_OPTIONS

const DEFAULT_POWERSYNC_DB_OPTIONS: {
  crudUploadThrottleMs: number;
  logger: Logger.ILogger;
  retryDelay: number;
};

Type declaration

Member	Type
`crudUploadThrottleMs`	`number`
`logger`	`Logger.ILogger`
`retryDelay`	`number`

DEFAULT_PRESSURE_LIMITS

const DEFAULT_PRESSURE_LIMITS: {
  highWater: number;
  lowWater: number;
};

Type declaration

Member	Type
`highWater`	`number`
`lowWater`	`number`

DEFAULT_REMOTE_LOGGER

const DEFAULT_REMOTE_LOGGER: Logger.ILogger;

DEFAULT_REMOTE_OPTIONS

const DEFAULT_REMOTE_OPTIONS: AbstractRemoteOptions;

DEFAULT_STREAMING_SYNC_OPTIONS

const DEFAULT_STREAMING_SYNC_OPTIONS: {
  crudUploadThrottleMs: number;
  logger: Logger.ILogger;
  retryDelayMs: number;
};

Type declaration

Member	Type
`crudUploadThrottleMs`	`number`
`logger`	`Logger.ILogger`
`retryDelayMs`	`number`

DEFAULT_STREAM_CONNECTION_OPTIONS

const DEFAULT_STREAM_CONNECTION_OPTIONS: Required<PowerSyncConnectionOptions>;

DEFAULT_TABLE_OPTIONS

const DEFAULT_TABLE_OPTIONS: {
  indexes: never[];
  insertOnly: boolean;
  localOnly: boolean;
};

Type declaration

Member	Type
`indexes`	`never`[]
`insertOnly`	`boolean`
`localOnly`	`boolean`

DEFAULT_WATCH_THROTTLE_MS

const DEFAULT_WATCH_THROTTLE_MS: 30 = 30;

InvalidSQLCharacters

const InvalidSQLCharacters: RegExp;

MAX_AMOUNT_OF_COLUMNS

const MAX_AMOUNT_OF_COLUMNS: 63 = 63;

MAX_OP_ID

const MAX_OP_ID: "9223372036854775807" = "9223372036854775807";

PowerSyncContext

const PowerSyncContext: React.Context<AbstractPowerSyncDatabase>;

STREAMING_POST_TIMEOUT_MS

const STREAMING_POST_TIMEOUT_MS: 30000 = 30_000;

column

const column: {
  integer: BaseColumnType<number | null>;
  real: BaseColumnType<number | null>;
  text: BaseColumnType<string | null>;
};

Type declaration

Member	Type
`integer`	`BaseColumnType`<`number` \| `null`>
`real`	`BaseColumnType`<`number` \| `null`>
`text`	`BaseColumnType`<`string` \| `null`>

Enumerations​

Classes​

Functions​

Interfaces​

AbstractStreamingSyncImplementationOptions​

Properties​

BaseObserverInterface<T>​

Extended by​

Type parameters​

Methods​

registerListener()​

Parameters​

Returns​

Returns​

BasePowerSyncDatabaseOptions​

Extended by​

Properties​

BatchedUpdateNotification​

Properties​

BucketChecksum​

Properties​

BucketRequest​

Properties​

BucketState​

Properties​

BucketStorageAdapter​

Extends​

Properties​

Methods​

autoCompact()​

Returns​

forceCompact()​

Returns​

getBucketStates()​

Returns​

getClientId()​

Returns​

getCrudBatch()​

Parameters​

Returns​

getMaxOpId()​

Returns​

hasCompletedSync()​

Returns​

hasCrud()​

Returns​

init()​

Returns​

iterateAsyncListeners()​

Parameters​

Returns​

Inherited from​

iterateListeners()​

Parameters​

Returns​

Inherited from​

nextCrudItem()​

Returns​

registerListener()​

Parameters​

Returns​

Returns​

Inherited from​

removeBuckets()​

Parameters​

Returns​

saveSyncData()​

Parameters​

Returns​

setTargetCheckpoint()​

Parameters​

Returns​

startSession()​

Returns​

syncLocalDatabase()​

Parameters​

Returns​

updateLocalTarget()​

Parameters​

Returns​

Enumerations

Classes

Functions

Interfaces

AbstractStreamingSyncImplementationOptions

Properties

BaseObserverInterface<T>

Extended by

Type parameters

Methods

registerListener()

Parameters

Returns

Returns

BasePowerSyncDatabaseOptions

Extended by

Properties

BatchedUpdateNotification

Properties

BucketChecksum

Properties

BucketRequest

Properties

BucketState

Properties

BucketStorageAdapter

Extends

Properties

Methods

autoCompact()

Returns

forceCompact()

Returns

getBucketStates()

Returns

getClientId()

Returns

getCrudBatch()

Parameters

Returns

getMaxOpId()

Returns

hasCompletedSync()

Returns

hasCrud()

Returns

init()

Returns

iterateAsyncListeners()

Parameters

Returns

Inherited from

iterateListeners()

Parameters

Returns

Inherited from

nextCrudItem()

Returns

registerListener()

Parameters

Returns

Returns

Inherited from

removeBuckets()

Parameters

Returns

saveSyncData()

Parameters

Returns

setTargetCheckpoint()

Parameters

Returns

startSession()

Returns

syncLocalDatabase()

Parameters

Returns

updateLocalTarget()

Parameters

Returns