Blog Sync Pipeline
Motivka's blog posts live in PocketBase but are cross-posted to Substack for newsletter distribution. This feature added a two-way sync that keeps status (draft, published, archived) consistent across both platforms.
The sync runs via a Bun script that can be triggered manually or scheduled. It handles conflict resolution by treating PocketBase as the source of truth for content and Substack as the source of truth for subscriber engagement metrics.