Add user model and SQLite storage #8

New Issue

2026-02-25T16:05:09+01:00

libretech commented

2026-02-25 16:05:09 +01:00

Summary

Design and implement the user model and SQLite database layer for multi-tenant user management.

User Model

User {
id: UUID (primary key)
email: string (unique, indexed)
created_at: timestamp
last_login_at: timestamp
storage_path: string
}

Implementation Tasks

Choose SQLite driver for Go (e.g., modernc.org/sqlite or mattn/go-sqlite3)
Create database schema with migrations
Implement user CRUD operations
Add email uniqueness constraint
Implement connection pooling / WAL mode configuration
Add database initialization on first run
Write unit tests for user storage operations

Design Decisions

SQLite chosen for simplicity and zero-dependency deployment
WAL mode for concurrent read access
UUID primary keys for non-sequential user IDs

Acceptance Criteria

User model supports create, read, update, delete operations
Email uniqueness is enforced at the database level
Database is created automatically on first run
SQLite WAL mode is enabled for concurrent access
Unit tests pass for all CRUD operations

## Summary Design and implement the user model and SQLite database layer for multi-tenant user management. ## User Model User { id: UUID (primary key) email: string (unique, indexed) created_at: timestamp last_login_at: timestamp storage_path: string } ## Implementation Tasks - [x] Choose SQLite driver for Go (e.g., modernc.org/sqlite or mattn/go-sqlite3) - [x] Create database schema with migrations - [x] Implement user CRUD operations - [x] Add email uniqueness constraint - [x] Implement connection pooling / WAL mode configuration - [x] Add database initialization on first run - [x] Write unit tests for user storage operations ## Design Decisions - SQLite chosen for simplicity and zero-dependency deployment - WAL mode for concurrent read access - UUID primary keys for non-sequential user IDs ## Acceptance Criteria - [x] User model supports create, read, update, delete operations - [x] Email uniqueness is enforced at the database level - [x] Database is created automatically on first run - [x] SQLite WAL mode is enabled for concurrent access - [x] Unit tests pass for all CRUD operations

libretech added the phase-1 label 2026-02-25 16:05:09 +01:00

libretech added the task label 2026-02-28 20:26:10 +01:00

~~libretech referenced this issue 2026-02-28 21:17:20 +01:00~~

Dockerize the application with multi-stage build and Compose #25

libretech referenced this issue

2026-02-28 21:41:31 +01:00

Epic: Phase 1 — Multi-tenant Backend #7

libretech added the backend database labels 2026-02-28 22:00:42 +01:00

~~libretech referenced this issue 2026-03-01 20:32:14 +01:00~~

Implement per-user note directory isolation with filesystem sandboxing #10

libretech closed this issue

2026-04-28 22:29:03 +02:00