Design the database schema #2

New issue

Open

opened 2026-08-23 11:11:23 +02:00 by gaetan · 0 comments

gaetan commented

2026-08-23 11:11:23 +02:00

Owner

Part of #1

Question

Design the SQLite schema for the bookshelf app. We need tables for:

Book: id, isbn (nullable), title, authors (JSON array or separate table), cover_url, publisher, publish_date, total_pages, genres (JSON array), created_at, updated_at
UserBook (the user's relationship to a book): id, book_id, status (want_to_read/reading/read), current_page, rating (nullable), review (nullable), added_at, started_at, finished_at
Tag: id, name (unique), created_at
UserBookTag (junction table): user_book_id, tag_id

Consider:

Should authors be a separate table or stored as JSON?
Should genres be separate or JSON?
Index strategy for search/filter queries
Foreign key constraints

The schema should support: search by title/author, filter by status, sort by date added/started/finished/rating.

Part of #1 ## Question Design the SQLite schema for the bookshelf app. We need tables for: - **Book**: id, isbn (nullable), title, authors (JSON array or separate table), cover_url, publisher, publish_date, total_pages, genres (JSON array), created_at, updated_at - **UserBook** (the user's relationship to a book): id, book_id, status (want_to_read/reading/read), current_page, rating (nullable), review (nullable), added_at, started_at, finished_at - **Tag**: id, name (unique), created_at - **UserBookTag** (junction table): user_book_id, tag_id Consider: - Should authors be a separate table or stored as JSON? - Should genres be separate or JSON? - Index strategy for search/filter queries - Foreign key constraints The schema should support: search by title/author, filter by status, sort by date added/started/finished/rating.

gaetan added the

wayfinder:grilling

label

2026-08-23 11:11:23 +02:00

gaetan added a new dependency

2026-08-23 11:17:38 +02:00

#6 Go project structure and package layout

gaetan added a new dependency

2026-08-23 11:17:44 +02:00

#5 UI structure and page design

gaetan self-assigned this

2026-08-23 11:21:34 +02:00