A newsroom needs to publish fast, keep drafts private until an editor signs off, and be found on Google the moment a story goes live. Photonews.pk runs all of that off a single SQLite file, with no external database service to operate.
Admin, Editor and Author roles are enforced server-side: authors draft and edit only their own stories, editors publish and feature anyone's, admins manage everything including users.
A Tiptap-based editor handles headings, formatting, blockquotes, lists, links, inline image upload and code blocks, with a cover-image upload and preview per article.
Server-side rendering, per-article meta title/description and canonical URL, OpenGraph and Twitter card tags, plus NewsArticle and BreadcrumbList JSON-LD on every story.
Sitemap.xml auto-includes every published article and category; robots.txt blocks /admin and /api; drafts are never exposed or indexed.
Runs on Node's built-in node:sqlite driver — nothing to provision or manage beyond the app itself.
Multi Solution Services