chore: update version to 0.18.2 for v0.18.2 release

Signed-off-by: phernandez <paul@basicmachines.co>

CHANGELOG.md

@@ -1,5 +1,13 @@
 # CHANGELOG
 
+## v0.18.2 (2026-02-11)
+
+### Bug Fixes
+
+- **#562**: Use VIRTUAL instead of STORED columns in SQLite migration
+  ([`344e651`](https://github.com/basicmachines-co/basic-memory/commit/344e651))
+  - Fixes compatibility issue with SQLite STORED generated columns
+
 ## v0.18.1 (2026-02-11)
 
 ### Features

server.json

@@ -6,12 +6,12 @@
     "url": "https://github.com/basicmachines-co/basic-memory.git",
     "source": "github"
   },
-  "version": "0.18.1",
+  "version": "0.18.2",
   "packages": [
     {
       "registryType": "pypi",
       "identifier": "basic-memory",
-      "version": "0.18.1",
+      "version": "0.18.2",
       "runtimeHint": "uvx",
       "runtimeArguments": [
         {"type": "positional", "value": "basic-memory"},

src/basic_memory/__init__.py

@@ -1,7 +1,7 @@
 """basic-memory - Local-first knowledge management combining Zettelkasten with knowledge graphs"""
 
 # Package version - updated by release automation
-__version__ = "0.18.1"
+__version__ = "0.18.2"
 
 # API version for FastAPI - independent of package version
 __api_version__ = "v0"

src/basic_memory/alembic/versions/d7e8f9a0b1c2_add_structured_metadata_indexes.py

@@ -94,13 +94,15 @@ def upgrade() -> None:
         return
 
     # SQLite: add generated columns for common frontmatter fields
+    # Constraint: SQLite ALTER TABLE ADD COLUMN only supports VIRTUAL generated columns,
+    # not STORED. json_extract is deterministic so VIRTUAL columns can still be indexed.
     if not column_exists(connection, "entity", "tags_json"):
         op.add_column(
             "entity",
             sa.Column(
                 "tags_json",
                 sa.Text(),
-                sa.Computed("json_extract(entity_metadata, '$.tags')", persisted=True),
+                sa.Computed("json_extract(entity_metadata, '$.tags')", persisted=False),
             ),
         )
     if not column_exists(connection, "entity", "frontmatter_status"):
@@ -109,7 +111,7 @@ def upgrade() -> None:
             sa.Column(
                 "frontmatter_status",
                 sa.Text(),
-                sa.Computed("json_extract(entity_metadata, '$.status')", persisted=True),
+                sa.Computed("json_extract(entity_metadata, '$.status')", persisted=False),
             ),
         )
     if not column_exists(connection, "entity", "frontmatter_type"):
@@ -118,7 +120,7 @@ def upgrade() -> None:
             sa.Column(
                 "frontmatter_type",
                 sa.Text(),
-                sa.Computed("json_extract(entity_metadata, '$.type')", persisted=True),
+                sa.Computed("json_extract(entity_metadata, '$.type')", persisted=False),
             ),
         )
 

tests/test_rclone_commands.py

@@ -8,7 +8,6 @@ import pytest
 
 from basic_memory.cli.commands.cloud.rclone_commands import (
     MIN_RCLONE_VERSION_EMPTY_DIRS,
-    TIGRIS_CONSISTENCY_HEADERS,
     RcloneError,
     SyncProject,
     bisync_initialized,