gaetan/knowledgify

Decision: Content source and curation — where does culture générale content come from? #7

New issue

Closed

opened 2026-08-20 13:59:35 +02:00 by gaetan · 1 comment

gaetan commented

2026-08-20 13:59:35 +02:00

Owner

Part of #1

Question

How is the curated "culture générale" content sourced and managed?

Key sub-questions:

Content origin: Manually authored by the app creator? Imported from existing sources? AI-generated?
Content format: Structured JSON/CSV? Database seed files? CMS-like editing?
Content volume: How many cards at launch? How are new cards added over time?
Quality control: Who verifies factual accuracy?
Update mechanism: How are cards updated/corrected over time?
Language: French-only at launch?

Considerations:

This is the core value proposition — the content IS the product
Content pipeline is separate from the SRS engine
May need a content management interface (even if just for the app creator)
Content categories and difficulty levels need to be defined

This decision shapes the content model ticket and the overall product strategy.

Part of #1 ## Question How is the curated "culture générale" content sourced and managed? Key sub-questions: - **Content origin**: Manually authored by the app creator? Imported from existing sources? AI-generated? - **Content format**: Structured JSON/CSV? Database seed files? CMS-like editing? - **Content volume**: How many cards at launch? How are new cards added over time? - **Quality control**: Who verifies factual accuracy? - **Update mechanism**: How are cards updated/corrected over time? - **Language**: French-only at launch? Considerations: - This is the core value proposition — the content IS the product - Content pipeline is separate from the SRS engine - May need a content management interface (even if just for the app creator) - Content categories and difficulty levels need to be defined This decision shapes the content model ticket and the overall product strategy.

gaetan added the

wayfinder:grilling

label

2026-08-20 13:59:35 +02:00

gaetan self-assigned this

2026-08-20 14:31:44 +02:00

gaetan commented

2026-08-20 14:33:29 +02:00

Author

Owner

Resolution

Content source decided:

Origin: Manually authored JSON files in the repo.

Launch volume: 100-200 cards (~25-50 per launch category × 4 categories).

Editing: Direct JSON editing in the repo. No CLI tool or web admin at launch.

Language: French-only at launch.

Content loading: JSON files are the source of truth. On startup, parse all JSON files and upsert into SQLite. DB is the working copy, JSON is the canonical store.

File structure:

content/
  histoire.json
  geographie.json
  sciences.json
  transversal.json

Quality control: Manual — you verify factual accuracy when writing cards.

Update mechanism: Edit JSON files directly, restart the app to reload.

## Resolution Content source decided: **Origin**: Manually authored JSON files in the repo. **Launch volume**: 100-200 cards (~25-50 per launch category × 4 categories). **Editing**: Direct JSON editing in the repo. No CLI tool or web admin at launch. **Language**: French-only at launch. **Content loading**: JSON files are the source of truth. On startup, parse all JSON files and upsert into SQLite. DB is the working copy, JSON is the canonical store. **File structure**: ``` content/ histoire.json geographie.json sciences.json transversal.json ``` **Quality control**: Manual — you verify factual accuracy when writing cards. **Update mechanism**: Edit JSON files directly, restart the app to reload.

gaetan closed this issue

2026-08-20 14:33:32 +02:00

gaetan referenced this issue

2026-08-20 14:33:57 +02:00

Wayfinder map: Anki-like spaced repetition web app for culture générale #1