ci(deps): bump docker/setup-qemu-action from 4.2.0 to 4.4.0 (#232)

Harden PDS write paths against silent local-state drift

build(deps): bump the npm_and_yarn group across 1 directory with 73 updates

feat: add cached community stats to landing page

feat: show active user count on the home page

proposal lexicons

build: update bun.lock

build: update bun.lock

fix(dev,a11y): harden the dev server config; name the library table

ci: run tests in CI, fix bare `bun test`, and make the suite ~5-8x faster

fix: review follow-ups on the OPDS download path

ci(deps): bump actions/attest-build-provenance from 4.1.1 to 4.2.2

chore: move Portainer webhook URL to GitHub secret

fix: bridge KOSync progress to public book via personal_book fallback

feat: support orphan book pages for books without a hiveId

feat: add Libby availability checking and OpenLibrary integration

docs: correct the WAF token cache age in the solver README

Harden refresh lock: heartbeat + scoped timeout cleanup

fix: move previousReads to onConflict handler, add vite as direct dep

chore: upgrade takumi to 2.0.2

fix: don't auto-fill finishedAt during imports when source has no date (#175)

fix: use stable nitro beta to fix Docker build

chore: update nitro-nightly to latest (3.0.1-20260617)

fix: only set finishedAt when import status is finished

fix: capture actual times for startedAt/finishedAt

feat: auto-generate initials avatar for new accounts without profile photo

refactor: derive activeGenre instead of syncing with effect

fix: patch takumi to fall back to WASM under Bun, drop NAPI workarounds

chore: bump Bun from 1.3.9 to 1.3.12

fix: trigger rolling session cookie refresh on warm cache hits

perf: parallelize DB queries, batch buzz inserts, and optimize head asset loading

feat: migrate database from SQLite to PostgreSQL

feat: client-side library table on profile page to avoid full-page refresh

perf: align session cache TTL to token expiration, skip redundant restore()

feat: extend session cookie TTL to 180 days

fix: correct GitHub link and sidebar theme toggle styling

style: format analyze-profile script

feat: add GDPR account deletion settings page

fix: address 13 code review findings across workers, routes, and utils

fix: add fetch timeouts and fix library tab switching bug

fix: prevent search race conditions and clear stale results

chore: update slides last time

fix: parse HTML line breaks in review comments

chore: reformat lexicon and update lint/format scripts

fix: repair SQLite KV singleton and share one connection per file

fix: DB schema cleanup, query optimizations, and PRAGMA order fix

fix: use exclusive locking mode in production to prevent SQLITE_IOERR_SHMSIZE

fix: use exclusive locking mode to prevent SQLITE_IOERR_SHMSIZE in containers

feat: add mobile account creation for bookhive.social PDS

fix: resolve typecheck errors and formatting

feat: add backfill progress endpoint

feat: add ?force-refresh=true to profile page to re-sync books from PDS

feat: add dynamic OG image for marketing landing page

perf: add missing user_book indexes and drop redundant genres column

fix: clean up stale export artifacts before each new export

feat: mobile UI improvements — shelves section, header refactor, list management

feat: remove reading challenge feature

chore: minor env stuff

feat: sidebar nav fixes, force-refresh enrichment, and UI tweaks

feat: add marketing landing page for logged-out users

feat: redesign book info page and fix profile photos in buzz sections

feat: unify book card components into single composable BookCard

feat: implement book lists/shelves functionality

feat: enrich OG images with social proof, series info, and reading stats

revert: restore src/app.ts to previous state

chore: credit

Add userStatuses to searchBooks lexicon and surface in search palette

fix: resolve lint issues

chore: resolve merge conflicts with origin/redesign

Add Jetstream cursor persistence and proactive backfill for BookHive

Add RSS feeds for user and friends activity

Redesign explore hub with genres, authors, and performance optimization

chore: replace ESLint/Prettier with oxlint/oxfmt, disable exactOptionalPropertyTypes

Optimize Docker image size (283MB → 152MB, -46%)

chore: try to skip instrumentation

fix: add owned status #66

Add book id map lexicon, endpoint, and indexed mapping table

fix: add a disable form button for a better client experience