Project 03Web + Admin

Memowrite.

Memoir Writing & Printing

A web platform that takes personal stories from guided writing to a printed hardcover book. The workflow connects AI text refinement and photo restoration with cover design, validated PDF generation and print-provider order tracking. An admin dashboard supports order review and fulfilment, alongside subscriptions, gifting and support for eight locales.

My role

I architected and built the customer application, Fastify API, PostgreSQL database and admin dashboard, defining the data model and API contracts across writing, editing, subscriptions and ordering.

Explore the project
Under the hood

What makes
it work.

The stack

Next.jsReactZustandTailwind CSSReact Hook FormZodi18nextFastifyTypeScriptPostgreSQLDrizzle ORMKyselyBetter AuthBunFirebase StorageNodemailerReact EmailSentryPDF-libSharpOpenAIGoogle GeminiPicWishRPI Printn8n
01

Guided Memoir Writing

50 curated life-story questions organized by theme (childhood, relationships, career, growth, wisdom) with progress tracking and skip/resume.

02

4 Book Types

Memoir, Self-Growth, Loved One Tribute and Faith Journey, each with tailored question sets.

03

AI Text Refinement

OpenAI and Google Gemini integration for quick fixes, proofreading, rewording and expansion.

04

AI Photo Enhancement

PicWish integration to restore and enhance old or blurry photos with before/after comparison.

05

Custom Cover Designer

6 color themes, photo upload with crop/rotate, customizable title/subtitle and a live PDF preview.

06

Print-on-Demand Fulfillment

RPI print-order integration with checks for content, image counts and purchased copies before submission, plus recorded rejection reasons, submission results and shipping details.

07

Subscriptions & Payments

Recurring subscriptions, lifetime access, gift purchases, pause/resume/cancel flows and in-app add-ons.

08

Collaboration & Gifting

Organization workspaces with invite-based team access and editor/viewer roles.

09

Multi-language Support

Full i18n across 8 languages (EN-US, EN-GB, DE, ES, FR, IT, LT, PT-BR).

10

Photo Management

Up to 100 photos per book with captions, HEIC conversion, EXIF-based rotation and automatic compression.

11

Book PDF Generation

Automated full-book PDF rendering with content validation (28–490 page limits).

12

Admin Dashboard

Back office for print requests, clients, orders, previews/edits, shipping, quality checks and date-range analytics.

13

Data Migration Tooling

Redesigned the legacy Firebase data structure into a PostgreSQL relational model, mapping existing records and relationships into the new schema with migration validation.

14

Administrative Access & Audit Logging

Authenticated administrative routes and audit logs recording the actor, action and target record, with visibility into orders, failed requests and customer data.

15

Analytics & Feedback

Google Analytics, Microsoft Clarity, Sentry, in-app NPS surveys and Trustpilot review prompts.