chrisandClaude Opus 5.5
68ec5a8d99
Feed and profile cards now show one slim line (small artwork, title, artist, Open button) with the progress bar and reactions. The arrow opens the rest: album, your other services, Share, and lyrics. Lyrics come from LRCLIB (open source; LRCLIB_URL can point at a self-hosted copy, or be empty to turn lyrics off). The server looks each song up once and caches it, including misses (retried after a week). Timed lyrics follow along with the song; otherwise the first lines show with "All lyrics". Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>
10 lines
417 B
SQL
10 lines
417 B
SQL
CREATE TABLE "lyrics" (
|
|
"track_id" uuid PRIMARY KEY NOT NULL,
|
|
"synced" text,
|
|
"plain" text,
|
|
"instrumental" boolean DEFAULT false NOT NULL,
|
|
"source_url" text,
|
|
"fetched_at" timestamp with time zone DEFAULT now() NOT NULL
|
|
);
|
|
--> statement-breakpoint
|
|
ALTER TABLE "lyrics" ADD CONSTRAINT "lyrics_track_id_tracks_id_fk" FOREIGN KEY ("track_id") REFERENCES "public"."tracks"("id") ON DELETE cascade ON UPDATE no action; |