gaetan/knowledgify

Decision: Data storage — embedded database choice #5

New issue

Closed

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

gaetan commented

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

Owner

Part of #1

Question

Which embedded database should store user progress and content?

Options:

SQLite (via mattn/go-sqlite3 or modernc.org/sqlite): Most feature-rich, SQL, mature
BadgerDB: Key-value, Go-native, good for simple patterns
BoltDB / bbolt: Key-value, simple, embedded
PostgreSQL/MySQL (self-hosted): If we want to support multi-user later

Considerations:

Single-user app — embedded is sufficient
Need relational queries? (user progress per card, categories, review history)
Migration needs? (content updates, schema changes)
Backup/restore simplicity
Connection pooling (SQLite handles this well)

This decision shapes the data layer architecture and deployment model.

Part of #1 ## Question Which embedded database should store user progress and content? Options: - **SQLite** (via mattn/go-sqlite3 or modernc.org/sqlite): Most feature-rich, SQL, mature - **BadgerDB**: Key-value, Go-native, good for simple patterns - **BoltDB / bbolt**: Key-value, simple, embedded - **PostgreSQL/MySQL** (self-hosted): If we want to support multi-user later Considerations: - Single-user app — embedded is sufficient - Need relational queries? (user progress per card, categories, review history) - Migration needs? (content updates, schema changes) - Backup/restore simplicity - Connection pooling (SQLite handles this well) This decision shapes the data layer architecture and deployment model.

gaetan added the

wayfinder:grilling

label

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

gaetan added a new dependency

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

#2 Decision: Content model — structure of culture générale cards and categories

gaetan added a new dependency

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

#6 Decision: User model — single user vs multi-user with auth

gaetan commented

2026-08-20 15:24:03 +02:00

Author

Owner

This is a duplicate of #10 (Data storage), which is already closed with the resolution: modernc.org/sqlite with hash-based sync, KNOWLEDGIFY_DB env var. Closing as duplicate.

gaetan closed this issue

2026-08-20 15:24:03 +02:00