stream_positions
7 rows
This data as json, CSV (advanced)
| Link | rowid ▼ | stream_name | instance_name | stream_id |
|---|---|---|---|---|
| 1 | 1 | device_lists_stream | master | 32 |
| 2 | 2 | presence_stream | master | 23814 |
| 3 | 3 | account_data | master | 903 |
| 4 | 4 | events | master | 19765 |
| 5 | 5 | receipts | master | 3694 |
| 6 | 6 | pushers | master | 2 |
| 7 | 7 | to_device | master | 41 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE stream_positions (
stream_name TEXT NOT NULL,
instance_name TEXT NOT NULL,
stream_id BIGINT NOT NULL
);
CREATE UNIQUE INDEX stream_positions_idx ON stream_positions(stream_name, instance_name);