home / chat

stream_positions

7 rows

✎ View and edit SQL

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

CSV options:

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);
Powered by Datasette · Queries took 9.954ms