CHANGELOG.md

main 5.5 KB · 65 lines · markdown

1	# Changelog
2
3	What changed in OpenVibe.Meme, newest first.
4
5	## Unreleased
6
7	- Public caption saves now queue a content-free `meme.caption.created` activity event in the same transaction; hidden and unlisted captions do not emit it. The relay starts when `MEME_CAPTION_EVENTS_ENABLED=on` after Events accepts the contract.
8
9	- The maker, second slice. `/make` is a phone-first editor: template search, draggable and resizable caption
10	boxes, crop and type/outline controls, emoji stickers, optional signed-out caption ideas from OpenVibe.AI's cheapest
11	route, and PNG/GIF/MP4 downloads. Captions save their editor state as text and geometry, never as a rendered image.
12	Member-uploaded templates go to OpenVibe.Media and stay hidden until staff approve them; migration 0010 adds the
13	moderation and editor-state columns above 0009. Public templates, entries and the render request are checked against
14	`meme.template@1`, `meme.entry@1` and `meme.render@1` (contracts v0.373.0). Saved captions gain copy/native share,
15	Community, Pics and Chat links, and a render endpoint.
16	- One title, one public entry. `meme_entries.title_key` is the title lowercased with quotes/punctuation stripped
17	and whitespace collapsed; a trigger keeps it current and a partial unique index on `(kind, title_key)` stops two
18	public entries sharing a title. The importer upserts on the key instead of the slug, so a second phrase that the
19	judge titles the same way enriches the entry that exists. Migration 0009 merges the existing public duplicates into
20	the oldest entry, moves their citations, votes, reports, judgements, origins, spread, examples, variations, related
21	rows and revision history, records the merge in the kept entry's history, and turns the old slug and id into 301
22	redirects (`meme_entry_redirects`).
23	- The hidden duplicates 0009 left. The old candidate miner kept inserting hidden candidates after 0009: it
24	deduped the phrase's slug before the judge rewrote the title, so a new window of the same line became a hidden row
25	with the public entry's title and its own citations — and one took back `close-and-enemies`, hiding the 301.
26	Migration 0011 merges every hidden entry that shares a public entry's `(kind, title_key)` into the public keeper,
27	moves its citations, votes and history, and turns its old slug/id into 301s. A redirect now wins over a hidden row
28	for readers (staff and the author still see it), and a new entry can never take a merged slug back.
29	- Tests. Two ingests of one normalised title stay one entry; 0009 moves everything and old addresses 301; 0011
30	merges a hidden duplicate and the merged slug still 301s.
31
32	## 0.1.0 — 2026-10-28
33
34	The first version: the open meme database, rebuilt with AI.
35
36	- Entries and citations. `meme_entries` with kind, AI summary (`noLooks`; a look-naming summary becomes the
37	title), status and `meme_status_events`, first/last seen, visibility and a revision that goes up on every change.
38	`meme_citations` carries a verbatim quote, its sha256, the canonical VOD second and URL, and
39	`live\|hidden\|gone`. VOD 5709 and clip 483 are a fixed deny list: never cited, kept or rendered.
40	- The importer. Every 30 minutes (off under `MEME_DRILL`) it reads Chat's public history and timeline, Live's
41	Rundown and VOD transcripts, finds a 3–6 word phrase in at least two uses on two different days, follows
42	OpenVibe.Video's joined-VOD redirect, and inserts one hidden candidate with an origin and its uses. It never
43	publishes. A second run enriches the same slug, never duplicates it.
44	- Re-verification. Daily, every citation URL is read again: 404/410 → `gone`, 401/403 → `hidden`, a redirect
45	updates the canonical VOD second. An entry whose origin is gone is hidden and tombstoned. A transient 5xx changes
46	nothing.
47	- The API. Public cursor-paged `GET /entries`, one entry with its citations and timeline,
48	`GET /entries/:slug/series?days=30` zero-filled per UTC day, `GET /trending`, `GET /week`, `POST /week/vote` (one
49	ballot per week and person), `GET/POST /templates` and `/captions` (1–4 lines × 120 characters, blocked words,
50	text only), `GET /captions/:id`, `POST /entries/:slug/report`, and staff `publish\|hide\|PATCH` behind Network role
51	`global_mod`+ plus `GET /reports`.
52	- The week and the generator. ISO `YYYY-Www` weeks, candidate counts and the reader's own vote; a caption
53	preview is server-rendered HTML text over a template image and a saved caption is its jsonb lines.
54	- Search. Each public entry is one `search.index-document@1` (owner `meme`, type `entry`, `/m/<slug>`, revision
55	from the entry, provenance per citation) queued in `meme_outbox` in the same transaction; hiding writes a
56	tombstone. The relay waits for the `search.document.write` grant.
57	- The service. Network sign-in as OAuth client `meme` (PKCE S256, `meme_at`/`meme_rt`/`meme_oauth`), truthful
58	readiness, Prometheus metrics on loopback, discovery, deploy files, and server-rendered pages with stable `mm-`
59	ids. `public/css/meme.css` and `public/js/meme.js` are one-comment placeholders for the main session.
60	- The first proof. `scripts/seed-proof.js` creates `cozmo-offline` hidden from Chat message 86957 and VOD 6025
61	@ 1541 s (the canonical target of `/v/6026?t=864`), with its two citations and a noLooks-cleaned summary.
62	- Tests. Migration, importer, re-verification, deny list, noLooks, votes, captions, staff, Search document,
63	SSO, pages/cache and account export/deletion, each in its own process on a temporary PGlite database with a mock
64	Network and a Chat/Live/Video fixture server.
65