uploads

1 row where ext = "png"

descending

sha256 ▼	filepath	ext	size
704ab23c6ea7d143d50fedc5e435a3e1cf4abb201630ad0229dad24be817565a	/Users/simon/Pictures/Photos Library.photoslibrary/originals/C/C9AA2D9B-2CC7-43FC-8315-7CB184C5D490.png	png	1733341

Advanced export

JSON shape: default, array, newline-delimited, object

CREATE TABLE [uploads] (
   [sha256] TEXT PRIMARY KEY,
   [filepath] TEXT,
   [ext] TEXT,
   [size] INTEGER
);
CREATE INDEX [idx_uploads_filepath]
                ON [uploads] ([filepath]);