[Story 1/3] Tutorial: Sovereign Contact & Task Hub (Local-First to Cloud) #4

Open
opened 2026-10-27 14:51:17 +00:00 by crapougnax · 0 comments
Owner

Migrated from GitHub https://github.com/Quatrain/Core/issues/31 (opened by @crapougnax on 2026-09-18).

🎯 Story Overview

As a solopreneur or indie hacker,
I want to build a local-first Contact & Task Hub using pure TypeScript domain models, SQLite, and local file storage with zero infrastructure overhead,
So that I can prototype and test at 0ms latency and effortlessly migrate to cloud PostgreSQL with zero business logic changes.


📦 Ecosystem Packages

  • @quatrain/core (BaseObject, Properties, Validation)
  • @quatrain/backend & @quatrain/backend-sqlite (PersistedBaseObject, Dynamic Repository, SQLiteAdapter)
  • @quatrain/storage & @quatrain/storage-local (LocalStorageAdapter)
  • @quatrain/api-server-express (CrudEndpoint)

📋 Child Tasks & Implementation Plan

  • #5: feat(example-contact-hub): scaffold domain models and typed validation schema
  • #6: feat(example-contact-hub): configure SQLite local persistence and local file storage
  • #7: feat(example-contact-hub): implement REST CRUD endpoints and ObjectUri retrieval
  • #8: docs(example-contact-hub): write comprehensive step-by-step tutorial and README

✅ Acceptance Criteria

  1. Domain models (Contact, TaskItem) contain zero external database dependencies.
  2. In-memory tests run via SQLiteAdapter({ config: { database: ':memory:' } }).
  3. Switch from SQLite to PostgreSQL achieved by changing only the adapter registration in Backend.addBackend().
  4. Full runnable reference application under examples/contact-hub.
> Migrated from GitHub https://github.com/Quatrain/Core/issues/31 (opened by @crapougnax on 2026-09-18). ## 🎯 Story Overview **As a** solopreneur or indie hacker, **I want to** build a local-first Contact & Task Hub using pure TypeScript domain models, SQLite, and local file storage with zero infrastructure overhead, **So that** I can prototype and test at 0ms latency and effortlessly migrate to cloud PostgreSQL with zero business logic changes. --- ### 📦 Ecosystem Packages - `@quatrain/core` (BaseObject, Properties, Validation) - `@quatrain/backend` & `@quatrain/backend-sqlite` (PersistedBaseObject, Dynamic Repository, SQLiteAdapter) - `@quatrain/storage` & `@quatrain/storage-local` (LocalStorageAdapter) - `@quatrain/api-server-express` (CrudEndpoint) --- ### 📋 Child Tasks & Implementation Plan - [ ] #5: `feat(example-contact-hub): scaffold domain models and typed validation schema` - [ ] #6: `feat(example-contact-hub): configure SQLite local persistence and local file storage` - [ ] #7: `feat(example-contact-hub): implement REST CRUD endpoints and ObjectUri retrieval` - [ ] #8: `docs(example-contact-hub): write comprehensive step-by-step tutorial and README` --- ### ✅ Acceptance Criteria 1. Domain models (`Contact`, `TaskItem`) contain zero external database dependencies. 2. In-memory tests run via `SQLiteAdapter({ config: { database: ':memory:' } })`. 3. Switch from SQLite to PostgreSQL achieved by changing only the adapter registration in `Backend.addBackend()`. 4. Full runnable reference application under `examples/contact-hub`.
Sign in to join this conversation.
No milestone
No project
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
quatrain/core#4
No description provided.