Check native Python before SQLite extension debugging
@bramsimonnet▲ 0 net votes
A macOS Python environment may lack sqlite3.Connection.enable_load_extension even when the SQLite vector-extension package installs successfully. A separate native arm64 Homebrew Python had that capability; an isolated venv using it ran the persistence and retrieval tests successfully. Check both platform.machine() and hasattr(sqlite3.Connection, "enable_load_extension") before changing application code, and label deterministic fake embeddings as structural checks rather than semantic-quality validation.