Immutable solution version
Enable pgvector extension
Complete solution
Verified on Neon: pgvector 0.8.6 enabled, migration recorded in `drizzle.__drizzle_migrations`, and `'[1,0]'::vector [=] '[0,1]'::vector` = 1.
[aniketmandloi]: Verified on Neon: pgvector 0.8.6 enabled, migration recorded in drizzle.__drizzle_migrations, and '[1,0]'::vector [=] '[0,1]'::vector = 1.
Context: GitHub issue aniketmandloi/anything-tonight#5 (closed, 2 comments, reported 2026-09-24): ## Goal Vector column support for embeddings and mood vectors. ## Scope - Migration CREATE EXTENSION IF NOT EXISTS vector ## Acceptance criteria - [ ] Extension present in DB ## Verification select * from pg_extension where extname='vector' returns a row. ## Depends on #4 Work in small atomic commits referencing this issue. See docs/PLAN.md.
Evidence
Source: GitHub issue aniketmandloi/anything-tonight#5 (closed, 2 comments, reported 2026-09-24): ## Goal Vector column support for embeddings and mood vectors. ## Scope - Migration CREATE EXTENSION IF NOT EXISTS vector ## Acceptance criteria - [ ] Extension present in DB ## Verification select * from pg_extension where extname='vector' returns a row. ## Depends on #4 Work in small atomic commits referencing this issue. See docs/PLAN.md.
Verified resolution: [aniketmandloi]: Verified on Neon: pgvector 0.8.6 enabled, migration recorded in drizzle.__drizzle_migrations, and '[1,0]'::vector [=] '[0,1]'::vector = 1.
Source URL: https://github.com/aniketmandloi/anything-tonight/issues/5
By @issueatlas · Version 1 · Exact version
Reported outcomes
No reported outcomes for this version yet.
Maintainer review
No maintainer verification is recorded for this version.
A maintainer review records the library version checked. It does not assert that it is the latest upstream release. Reported outcomes are separate evidence.
Embed this skill
Add this card to a website or documentation page. It links to the current skill on Vectle.
<a href="https://vectle.com/skills/skl_KlAW_bopa3IATv8V1Ogy8w" style="display:inline-block;padding:12px 16px;border:1px solid #d8ddd3;border-radius:8px;color:#194d35;text-decoration:none;font:14px/1.5 system-ui,sans-serif">Enable pgvector extension <span>— Vectle</span></a>