From 6b6b5d2e35ff182a0732da245f4eb37c8afa0564 Mon Sep 17 00:00:00 2001 From: grm Date: Wed, 16 Sep 2026 18:37:20 +0300 Subject: Add an HTML mode to posts, page intros and announcements Markdown is the default and unchanged; the editor's new Format switch stores the text as raw HTML instead, put on the blog exactly as written. Like the custom HTML module it is unsanitised on purpose: the escape hatch for embeds, scripts and inline styles that Markdown cannot express. The source column keeps holding the text in both modes and a `format` column says how to read it, so the public templates and the feed still print the stored `*_html`. The dashboard preview of HTML goes into a sandboxed iframe rather than the page, because a superadmin edits other people's blogs and their markup must never run on the dashboard origin. Search snippets of HTML posts are cut from a tag-stripped copy. Co-Authored-By: Claude Opus 5 Claude-Session: https://claude.ai/code/session_01Sd8UPWrvyYCLj97JexNw3A --- internal/db/migrations/blog/00006_format.sql | 11 +++++++++++ 1 file changed, 11 insertions(+) create mode 100644 internal/db/migrations/blog/00006_format.sql (limited to 'internal/db/migrations/blog') diff --git a/internal/db/migrations/blog/00006_format.sql b/internal/db/migrations/blog/00006_format.sql new file mode 100644 index 0000000..865e4d8 --- /dev/null +++ b/internal/db/migrations/blog/00006_format.sql @@ -0,0 +1,11 @@ +-- +goose Up +-- Posts, page intros and announcements can be written as raw HTML instead of +-- Markdown; the *_md column holds the source either way, format says which. +ALTER TABLE posts ADD COLUMN format text NOT NULL DEFAULT 'markdown' CHECK (format IN ('markdown', 'html')); +ALTER TABLE pages ADD COLUMN format text NOT NULL DEFAULT 'markdown' CHECK (format IN ('markdown', 'html')); +ALTER TABLE sections ADD COLUMN format text NOT NULL DEFAULT 'markdown' CHECK (format IN ('markdown', 'html')); + +-- +goose Down +ALTER TABLE posts DROP COLUMN format; +ALTER TABLE pages DROP COLUMN format; +ALTER TABLE sections DROP COLUMN format; -- cgit v1.2.3