You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
25 lines
1.1 KiB
Markdown
25 lines
1.1 KiB
Markdown
---
|
|
# edu-ic66
|
|
title: §6 Setting Up Turso + sqlite-vec
|
|
status: scrapped
|
|
type: task
|
|
priority: normal
|
|
created_at: 2026-03-10T23:30:00Z
|
|
updated_at: 2026-03-10T23:30:00Z
|
|
---
|
|
|
|
## §6 Setting Up Turso + sqlite-vec — ALREADY COMPLETE
|
|
|
|
This section is fully written in `edu/src/vector-db.md` under `### 6. Setting Up`. No further content work is needed. Mark this ticket done.
|
|
|
|
## What was written
|
|
|
|
- Project setup: `cargo new vec-demo`, `libsql = "0.9"`, `tokio` with full features
|
|
- Release profile: `opt-level = "z"`, `lto = true`, `strip = true`, `codegen-units = 1`
|
|
- Opening a local connection: `Builder::new_local("vectors.db").build().await?`
|
|
- Verifying the connection with `SELECT sqlite_version()`
|
|
- Reference table of all sqlite-vec constructs used in later exercises: `F32_BLOB(d)`, `vector()`, `vector_extract()`, `vector_distance_cos()`, `libsql_vector_idx`, `vector_top_k()`
|
|
- Creating a `F32_BLOB(3)` vector table
|
|
- Creating an HNSW index with `USING libsql_vector_idx(embedding)`
|
|
- Complete working `main.rs` listing — produces "SQLite version: x.y.z" and "Database ready."
|