[BUG] After installing via brew or uv, the db seems not to be properly initialised

[morliont]

Bug Description

I tried installing basic-memory on macOS 15.5 on a Macbook Pro M3. After trying to point it to another project folder, or even running basic-memory status, I get the following error:

% basic-memory status Error checking status: (sqlite3.OperationalError) no such table: project [SQL: SELECT project.id, project.name, project.description, project.permalink, project.path, project.is_active, project.is_default, project.created_at, project.updated_at FROM project WHERE project.name = ?] [parameters: ('main',)] (Background on this error at: https://sqlalche.me/e/20/e3q8)

Steps To Reproduce

Steps to reproduce the behavior:

1. Install version 0.14.2
2. Run command basic-memory status
3. See error above

Expected Behavior

I would expect everything to be properly initialised

Actual Behavior

The error said there is no table for project in the sqlite db

Environment

• OS: macOS 15.5
• Python version: 3.9.6
• Basic Memory version: 0.14.2
• Installation method: both tried uv and brew

Possible Solution

If I browse the sqlite db file in .basic-memory, it does not have any project table indeed. But I might've done something wrong.

[Alevale]

I think this is related to #221

[groksrc]

Ok here is an update on this install issue:

• Our friends at astral who make the uv installer recently encountered a problem with their build process because our friends at sqlite changed the way SQLite is built recently: Bump SQLite to 3.49.1.0 astral-sh/python-build-standalone#667 (comment)
• As a result versions of cpython built and deployed with uv since 07/08 have had FTS5 missing due to another bug where the astral team didn't get the sqlite build quite right: https://github.com/astral-sh/python-build-standalone/releases/tag/20250708
• Astral is currently working on the issue, and we are waiting on the fix: Enable FTS5 in SQLite astral-sh/python-build-standalone#694

Since this is the same issue as #221 I am going to close this one with as a duplicate. Please refer to #221 for future updates.