v1.0.0 "Louise" Release Notes

Theme: Production Release

"All right, let's do this." The mastermind brings it all together.

What's New

Write-Write Conflict Detection

FeatherDB now implements first-committer-wins for MVCC write-write conflicts. When two concurrent transactions modify the same row, the first to commit succeeds and the second receives a conflict error. This closes the last known correctness gap in the MVCC implementation.

Previously, both transactions could commit successfully, with the last writer silently overwriting the first. Now the behavior matches what you'd expect from a proper MVCC database.

Security Audit

• cargo-deny integrated for dependency auditing (licenses, advisories, banned crates)
• Production unwrap audit — 8 unwrap calls in non-test code identified and replaced with proper error handling
• All dependencies checked against RustSec advisory database

Publishing

• All crate versions bumped to 1.0.0
• Cargo.toml metadata updated: keywords, categories, repository URL, documentation links
• Ready for crates.io and PyPI publishing
• Repository goes public

Documentation

• SQLite Migration Guide — feature comparison, API mapping, SQL dialect differences, and migration checklist for users coming from SQLite (docs/guide/migrating-from-sqlite.md)
• TPC-H Benchmark Report — full results for all 22 queries at SF=0.01 vs SQLite (docs/benchmarks/tpch-results.md)
• All crate READMEs, ROADMAP, CHANGELOG, and KNOWN_GAPS updated for v1.0.0

Stats

• Tests: 1,250+ passing, 7 doc tests ignored (need runtime context)
• TPC-H: All 22 queries pass. 2 queries faster than SQLite, 5 competitive (<5x)
• Crates: 10 (featherdb, core, query, storage, mvcc, catalog, crypto, derive, mcp, python)
• Releases: 17 total (v0.1.0 through v1.0.0)

Remaining Known Limitations

The Journey

From v0.1.0 "Bender" ("I'm 40% B-tree!") to v1.0.0 "Louise" -- 17 releases, each named after a Bob's Burgers or Futurama character. What started as a core SQL engine grew into an agent-native embedded database with true MVCC, encryption, auth, sessions, an MCP server, and a complete SQL engine that passes all 22 TPC-H queries.