-
Notifications
You must be signed in to change notification settings - Fork 0
Diary
The diary is a personal scratchpad with optional dated reminders. Entries are private to the author. The editor is built on tiptap and supports headings, lists, tables, links, text alignment, and code blocks.
Open /diary and click New. The page opens a rich-text editor. The body is stored as HTML in diary_entries.content. Set an optional remind_at date to be reminded by email on that day.
A cron at 07:00 UTC selects all entries whose remind_at == today and emails the entry body back to the author. The reminder is single-shot: once fired, the row's last_reminded_on is stamped so the same entry does not fire again today.
Diary entries are protected by Row Level Security. The author is the only person who can read, edit, or delete their entries. There is no admin override: even the platform admin cannot read another user's diary.
diary_entries(id, user_id, title, content TEXT, remind_at DATE, last_reminded_on DATE, created_at, updated_at).