Repository navigation
0026 catalog delivery
github-actions[bot] edited this page Nov 18, 2026
·
1 revision
Status: accepted · Implementation: planned · Date: 2026-11-18
From LibreLifts ADR 0028, which is planned there and not built. The website's new host gets its own record.
Reference data will live in Postgres (0014). It is the same rows for everyone, it changes rarely, and the app has to have it with no connection, on the first launch. Personal data reaches the device through sync (0019), but sending the catalog the same way would push shared rows through a mechanism built for one person's rows.
-
Each release of the app carries a snapshot of the catalog. Until the catalog is in
Postgres, that snapshot is
packages/dataitself (0023). - Later, the app asks the API what has changed since the version it has, and applies it. With no connection it uses what it has.
- The catalog then sits in its own read-only tables on the device, apart from personal data, and is not part of sync.
- Media is not in the snapshot.
- The website's catalog pages are rendered on request from the API, behind a cache. Product pages, docs and blog stay prerendered.
- The app shows the catalog offline from the first launch.
- A person's log refers to catalog records by id, so a record that is later changed or withdrawn is never deleted outright, only marked.
- The website can no longer be only static files once the catalog is live. It needs a host that can render on request, and GitHub Pages cannot.
- Until then, editing the catalog means a new release of the app.
Generated from docs/ on dev. Edit the docs there; changes made on the wiki are overwritten.
- Development
- Workflow
-
Decisions
- 0001 Decisions are recorded
- 0002 Apache License 2.0
- 0003 Changes land on dev by fast-forward; main is the last release
- 0004 Conventional Commits, Keep a Changelog and Semantic Versioning
- 0005 docs/ is for developers and is mirrored to the wiki
- 0006 LibreBars is a free workout log for calisthenics
- 0007 The tracker is an iOS and Android app; its web build stays until the store release
- 0008 LibreBars is an app and a crowd-sourced open database
- 0009 The database is ODbL, media is CC BY-SA, and neither can be closed later
- 0010 A hosted API with a free tier is the paid product
- 0011 The workspace is app, web and api, with engine, ui, data and contracts
- 0012 The engine is small pure functions, in the style of date-fns
- 0013 Web and app share a Tailwind theme, not components
- 0014 Postgres is the source of truth for all data
- 0015 The API is Fastify, and it owns LibreBars accounts
- 0016 Every install is a guest account, made in the background
- 0017 Accounts use Better Auth
- 0018 The on-device database is SQLite with Drizzle, on every platform
- 0019 Sync is our own push and pull
- 0020 The app says it backs up, and backup can be turned off
- 0021 Postgres 18, run with Docker Compose and tested on two databases
- 0022 expo-sqlite is patched so the web build reuses one buffer
- 0023 Seed data is TypeScript modules in packages/data, with permanent ids
- 0024 The first tables
- 0025 One TanStack Start app is the website, on GitHub Pages
- 0026 The catalog reaches the app as a snapshot plus updates, and the website through the API
- 0027 The app's first components are its own