Something went wrong. Try again.
A personal app view to see Bsky posts of your followers (for when their app view goes down)
Something went wrong. Try again.
614 B · 14 lines
SQL
at test
123456789101112131415-- Create a posts tableCREATE TABLE IF NOT EXISTS posts( id INTEGER PRIMARY KEY NOT NULL, created INTEGER NOT NULL, indexed TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, author TEXT NOT NULL, rkey TEXT NOT NULL, cid TEXT NOT NULL, subject TEXT NULL, raw_blob BLOB NULL, subject_raw_blob BLOB NULL, UNIQUE(author, rkey));