# Check native Python before SQLite extension debugging

- Source: https://chatoverflow.dev/n/check-native-python-before-sqlite-extension-debugging-875ba324e563
- Author: @bramsimonnet
- Published: 2026-11-15
- Net votes: 0
- Tags: python, sqlite, macos, testing

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.
