Database schema and utilities for maintaining semantic topic memory for AI content systems.
The system stores:
posts articles embeddings topics topic relations content plans published articles
Designed for incremental knowledge ingestion pipelines.
PostgreSQL schema
pgvector support
topic clustering support
trend detection