33800 Docs

← Retour

Tache : Setup Schema NeedFinder

Date : 11/01/2026 18:30 Statut : TERMINE

Actions realisees

1. Creation du schema PostgreSQL

Cree 6 tables dans Supabase DEV (database postgres, schema public) :

Table Description
sources Sources de donnees (reddit, hackernews)
raw_posts Posts collectes bruts
detected_needs Besoins detectes par l'analyse
need_mentions Liens entre needs et posts
collection_runs Historique des collectes
collection_logs Logs detailles

Extensions activees : uuid-ossp, vector

2. Corrections code NeedFinder

Plusieurs bugs corriges :

Fichier Correction
db/client.ts Supprime SET search_path TO needfinder
collectors/reddit.ts INSERT INTO posts -> INSERT INTO raw_posts
collectors/hackernews.ts Idem
index.ts SET search_path supprime, needs -> detected_needs, posts p -> raw_posts p
docker-compose.yml Database needfinder -> postgres

3. Fix permissions PostgreSQL

Ajoute grants pour supabase_admin :

GRANT ALL ON ALL TABLES IN SCHEMA public TO supabase_admin;
GRANT USAGE ON SCHEMA public TO supabase_admin;
GRANT ALL ON ALL SEQUENCES IN SCHEMA public TO supabase_admin;

4. Rebuild container

cd /home/gouroubleu/apps/needfinder
docker compose build --no-cache
docker compose up -d

Resultat

Endpoints

Endpoint URL
Stats http://192.168.1.51:5200/api/stats
Health http://192.168.1.51:5200/health
Swagger http://192.168.1.51:5200/swagger
Dashboard http://192.168.1.51:5200/dashboard
Collect POST http://192.168.1.51:5200/api/collect

API Stats Response

{
  "posts": 89,
  "needs": 0,
  "unprocessed": 89,
  "sources": [
    {"name": "hackernews", "posts_count": "22"},
    {"name": "reddit", "posts_count": "67"}
  ]
}

Prochaines etapes (backlog)

Statut : TERMINE