Commit Graph

  • 1085a54761 fix: prompt_styles.themenfeld_id → kategorie_id mit FK auf categories main Tim Leikauf 2026-06-20 21:15:28 +02:00
  • dbd077e239 docs: CLAUDE.md – Bild-Generierungs-Pipeline (prompt_styles, picture_jobs) Tim Leikauf 2026-06-20 21:04:13 +02:00
  • 01f6df67f3 feat: API-Routen für prompt_styles und picture_jobs Tim Leikauf 2026-06-20 21:02:36 +02:00
  • 1335136dcb feat: prompt_styles + picture_jobs Tabellen + Seed-Daten Tim Leikauf 2026-06-20 20:54:33 +02:00
  • 455969bdec fix: unique index words.titel_en als partial index + robuster Upsert ohne ON CONFLICT admin 2026-06-18 21:14:21 +02:00
  • 1d25f84f5d fix: POST /api/words akzeptiert conc_m + ON CONFLICT (titel_en) DO UPDATE admin 2026-06-18 21:06:53 +02:00
  • 294608de22 fix: enrich-batch Endpoint in words-Router verschieben (war nach 404-Handler in index.js) admin 2026-06-18 21:03:20 +02:00
  • 7ba6b7120b feat: words-Tabelle – Brysbaert-Import + hierarchische Kategorien + Batch-Anreicherung admin 2026-06-18 20:41:52 +02:00
  • 1605d2cdd1 docs: CLAUDE.md – Fortschritt/Gamification (Level-Kurve, Progress-Vertrag, Achievements) admin 2026-06-17 22:17:03 +02:00
  • 61b3bcb5ff feat: Erfolge (Achievements) – Unlock-Erkennung + Listing admin 2026-06-17 21:53:49 +02:00
  • bb863640c0 feat: progressive Level-Kurve + atomarer /auth/progress-Vertrag admin 2026-06-17 21:43:36 +02:00
  • 806e25c3ff docs: CLAUDE.md – Hintergrund-Job & Kategorie-Datenfluss dokumentieren admin 2026-06-15 14:48:03 +02:00
  • 339a3ed27d fix: bessere Wort-Kategorisierung, weniger "Sonstiges" admin 2026-06-15 14:39:28 +02:00
  • bd18a9c303 fix: greeting für en/sv zuverlässig setzen admin 2026-06-15 14:34:04 +02:00
  • d66cff3f61 feat: automatische Wort-Kategorisierung (Batches API + Sofort-Backfill) admin 2026-06-15 14:27:09 +02:00
  • 9738d3e35a feat: Profil-Kategorien + Begrüßung in Zielsprache admin 2026-06-15 12:55:57 +02:00
  • 508d6993ee feat: Feed-Pagination – erledigte und vom Client gelieferte Pairs ausschließen admin 2026-06-15 11:53:05 +02:00
  • e44d896f9e feat: Objekt-Token-Cleanup + schärferer LLM-Prompt (Kopf-Kompositum vs Bestimmungswort) admin 2026-06-13 19:56:13 +02:00
  • 434839e1d4 feat: Objekt-Wörter deterministisch tokenisieren (Forward + Backfill) admin 2026-06-13 19:37:12 +02:00
  • f0f768ff2c feat: Fortschritts-Tracking – user_daily_activity, Tagesziel & GET /auth/stats admin 2026-06-13 16:40:57 +02:00
  • 895d7c56a1 feat: Placeholder in der Auto-Generierung + Token-Leak-Fix admin 2026-06-12 22:43:39 +02:00
  • 25d1e89446 feat: Deep-Delete für Pairs und Bilder (Fragen/Statements/Audios/Objekte kaskadieren) admin 2026-06-12 21:25:15 +02:00
  • ddbd879dab feat: KI-Review-Schritt in der Pipeline (Korrekturlesen vor Audio) admin 2026-06-11 21:41:20 +02:00
  • 96ae76f295 fix: gültige Default-Voice für Schwedisch (voice_not_found behoben) admin 2026-06-11 21:04:10 +02:00
  • f5b69a9213 feat: ElevenLabs-Voice-Liste + Fehlerdetails in Audio-Batch-Ergebnissen admin 2026-06-11 21:00:27 +02:00
  • 985119bb03 fix: Übersetzungs-Retry + robuster Translate-Step + Nachhol-Endpoints admin 2026-06-10 22:03:11 +02:00
  • fb93d2296e fix: Readiness pro answer_type + Objekt-Zuweisung & Audio-Nachholen im Publish-Flow admin 2026-06-10 21:48:03 +02:00
  • 6af2428df5 feat: automatische Content-Pipeline (release → pairs → übersetzen → audio → ready) admin 2026-06-10 20:52:11 +02:00
  • 29a260e351 feat: bessere Übersetzungsqualität (Sonnet + Wörter mit Kontext) admin 2026-06-05 21:29:11 +02:00
  • ccba8902a4 feat: answer-Feld im Pair-Content-Bündel (für yes_no-Anzeige im Modal) admin 2026-06-05 21:01:08 +02:00
  • 8f9a48fa5a feat: Pro-Pair-Übersetzung + Review-Kaskade auf Objekt/Bild admin 2026-06-05 14:27:52 +02:00
  • 209a765154 fix: translation-coverage zählt nur übersetzbare Zeilen als fehlend admin 2026-06-05 13:49:02 +02:00
  • 28435e89c3 docs: API_TOKENS env in .env.example (für ServerMonitor) admin 2026-06-03 07:59:17 +02:00
  • a3ff787259 feat: reviewed-Status für Bilder, Auto-Trigger, Übersetzungen, Vertonbarkeits-Regel admin 2026-06-03 07:35:37 +02:00
  • 6c74aabc3f feat: TTS-Settings je Sprache, Audio-Coverage entkoppelt, Veröffentlichen-Workflow admin 2026-06-02 22:02:07 +02:00
  • 9bfd5e8dba feat: Status-Pipeline (reviewed), Audio-Verknüpfung+Coverage, EP-Fortschritt, Wort-Generierung admin 2026-06-02 21:29:48 +02:00
  • 75f05f45f2 feat: add audios table and ElevenLabs TTS endpoint admin 2026-06-01 13:05:34 +02:00
  • 2f0e08e264 fix: instruct Claude to avoid pronouns/articles in word-type pairs admin 2026-05-28 21:54:10 +02:00
  • 4fc7b42032 feat: add word type and difficulty to Claude pair generation prompt admin 2026-05-28 21:31:20 +02:00
  • 24853f710f feat: add Claude proxy endpoint for auto pair generation admin 2026-05-28 21:00:29 +02:00
  • 7b3ce50a17 feat: add set-password endpoint for admin user management admin 2026-05-27 14:01:47 +02:00
  • 556fdb1d29 feat: new placeholder format {{label.w:id}} / {{label.o:id}} admin 2026-05-26 15:11:03 +02:00
  • 3147191f55 migrate: backfill old {{uuid}} placeholders to new {{label.w/o:uuid}} format admin 2026-05-26 15:00:04 +02:00
  • b57d69fa8e fix(feed): load pictures via object_pairs instead of sentence UUID heuristic admin 2026-05-25 22:20:00 +02:00
  • fa446ab353 fix(feed): resolve word→object links for picture lookup on word-type cards admin 2026-05-25 22:16:40 +02:00
  • d243e6e286 Use object.selections polygon for chip highlight instead of bbox columns admin 2026-05-25 21:38:04 +02:00
  • b8802baf36 Add bbox PATCH endpoint + seed watermelon test bbox admin 2026-05-25 21:29:55 +02:00
  • 9f738312e7 Add bbox coordinates to object_pictures for chip highlight feature admin 2026-05-25 21:24:27 +02:00
  • 6d13000248 feat: add /auth/feed endpoint for hydrated learning pairs admin 2026-05-25 18:37:06 +02:00
  • 2f4285dbe9 feat: add user profile endpoints + language seed for LanguParent app admin 2026-05-25 17:56:19 +02:00
  • 52dce342f4 docs: complete README rewrite — current schema, auth, all endpoints admin 2026-05-25 17:40:43 +02:00
  • b0a67df328 refactor: answer_type single TEXT + new 'question' type admin 2026-05-25 16:11:15 +02:00
  • 7c8d5bfaaf feat: pairs answer_type TEXT[], statements.answer bool admin 2026-05-24 20:48:29 +02:00
  • 5411e478cb feat: objects_created flag on pictures, native_lang on users admin 2026-05-24 19:20:43 +02:00
  • cea19083b4 Add ?search= server-side ILIKE filter to words, pictures, categories admin 2026-05-21 22:50:38 +02:00
  • 6d1f610e3d Fix sub-route shadowing: move /:id after sub-routes, add missing GETs admin 2026-05-21 22:42:09 +02:00
  • 15fa315b3f Add sentence_de filter to GET /api/questions admin 2026-05-21 15:09:08 +02:00
  • b4de0b98c3 Add missing relation endpoints for content_mentor migration admin 2026-05-21 15:07:18 +02:00
  • 9b0603427e Add users management route (GET, PATCH role/is_active, DELETE) admin 2026-05-21 14:29:49 +02:00
  • 10570786e9 Add languages, user_names, users_public tables and routes; fix _se→_sv rename admin 2026-05-21 13:47:52 +02:00
  • 217aab7dcd feat: registration and login with JWT auth admin 2026-05-21 13:04:17 +02:00
  • 5f79e76b67 feat: blocklist table with registration check endpoint admin 2026-05-21 10:29:53 +02:00
  • 9eac7b47fc feat: statements table with positive/negative words M2M admin 2026-05-21 10:16:56 +02:00
  • 227247d51c feat: questions table with trilingual sentences admin 2026-05-21 10:08:22 +02:00
  • 30d180a3de feat: pairs table with questions/statements placeholders admin 2026-05-21 10:00:35 +02:00
  • dac991c861 feat: objects table with M2M words/pictures/pairs admin 2026-05-21 09:51:34 +02:00
  • 8bd4240ea9 feat: categories table with full CRUD admin 2026-05-20 14:10:22 +02:00
  • 8751d7ceae feat: words table, M2M with pictures and categories admin 2026-05-20 14:05:28 +02:00
  • b5f5745107 docs: add README with full API and database documentation admin 2026-05-20 13:47:31 +02:00
  • 0f35459b86 feat: pictures table, Hetzner S3 upload/delete, auto-migration admin 2026-05-20 13:39:16 +02:00
  • b82a468197 fix: add Docker native HEALTHCHECK, replaces broken Coolify HTTP check admin 2026-05-20 11:38:55 +02:00
  • 7921929f73 feat: add Bearer token authentication admin 2026-05-20 11:22:45 +02:00
  • fc35e265b2 fix: prevent container crash on DB error, fix health check admin 2026-05-20 10:04:52 +02:00
  • 69f7962518 add package-lock.json for npm ci in Dockerfile admin 2026-05-20 10:00:31 +02:00
  • ab720b09d0 Initial setup: snakkimo API server with PostgreSQL connection admin 2026-05-20 09:02:31 +02:00