· postgresql
pgvector 0.8.7 Security Fix: Upgrade, Then Pick HNSW or IVFFlat
pgvector 0.8.7 fixes a high-severity IVFFlat bug. Check your version, upgrade on Docker or Supabase, and choose between HNSW and IVFFlat.
Tag
Posts tagged “postgresql”
3 articles about postgresql.
· ai
RAG with Citations on PostgreSQL and pgvector: How I Built It
How I built RAG with citations on PostgreSQL and pgvector for Pactroom: schema, project-scoped retrieval, citation prompts and the HNSW filtering trap.
· pactroom
GitHub Actions CI/CD for a Solo SaaS: Tests, SSH Deploy and Prisma Migrations
The GitHub Actions pipeline I run for Pactroom: tests, build, SSH deploy to a VPS, prisma migrate deploy and a health check, with a workflow you can adapt.