feedsignal/crates/db/Cargo.toml

[package]
name = "feedsignal-db"
version.workspace = true
edition.workspace = true
license.workspace = true

[dependencies]
feedsignal-core.workspace = true
diesel.workspace = true
diesel-async.workspace = true
diesel_migrations.workspace = true
bb8.workspace = true
libsqlite3-sys.workspace = true
tokio.workspace = true
serde.workspace = true
serde_json.workspace = true
chrono.workspace = true
uuid.workspace = true
anyhow.workspace = true
Scaffold feedsignal: Rust workspace for LLM-filtered RSS reader Rust workspace with core (topic-affinity learning engine + relevance scoring), db (sqlite/sqlx schema + repo), feeds (RSS/Atom fetch), llm (rig + local Ollama embeddings/completion), and web (axum + Dioxus fullstack UI, no separate JS stack). Two-stage relevance filtering (embedding shortlist -> LLM judgment) and an engagement/surprise-based topic affinity engine with daily decay. All crates compile and core's affinity engine has passing unit tests; server and wasm client targets of feedsignal-web both check clean. 2026-08-20 15:04:14 +00:00			`[package]`
			`name = "feedsignal-db"`
			`version.workspace = true`
			`edition.workspace = true`
			`license.workspace = true`

			`[dependencies]`
			`feedsignal-core.workspace = true`
Replace sqlx with Diesel + diesel-async for compile-time-checked queries sqlx's query!/query_as! macros only check raw SQL strings against the live schema; Diesel's table!-derived DSL type-checks query structure itself at compile time. SQLite has no native async driver, so diesel-async wraps a blocking SqliteConnection via SyncConnectionWrapper, pooled with bb8. Migrations move from sqlx's single-file-per-migration format to Diesel's up.sql/down.sql pairs, run transactionally via diesel_migrations against a throwaway sync connection at boot (MigrationHarness needs a sync Connection), giving revertable migrations that sqlx::migrate! doesn't support. Co-Authored-By: Claude Sonnet 5 <noreply@anthropic.com> 2026-08-21 09:04:38 +00:00			`diesel.workspace = true`
			`diesel-async.workspace = true`
			`diesel_migrations.workspace = true`
			`bb8.workspace = true`
			`libsqlite3-sys.workspace = true`
Scaffold feedsignal: Rust workspace for LLM-filtered RSS reader Rust workspace with core (topic-affinity learning engine + relevance scoring), db (sqlite/sqlx schema + repo), feeds (RSS/Atom fetch), llm (rig + local Ollama embeddings/completion), and web (axum + Dioxus fullstack UI, no separate JS stack). Two-stage relevance filtering (embedding shortlist -> LLM judgment) and an engagement/surprise-based topic affinity engine with daily decay. All crates compile and core's affinity engine has passing unit tests; server and wasm client targets of feedsignal-web both check clean. 2026-08-20 15:04:14 +00:00			`tokio.workspace = true`
			`serde.workspace = true`
			`serde_json.workspace = true`
			`chrono.workspace = true`
			`uuid.workspace = true`
			`anyhow.workspace = true`