Introduce a versioned schema migration system for local libSQL shards. Track each shard's schema version using PRAGMA user_version, apply pending migrations atomically and exactly once during upgrades, and create recoverable backups before destructive changes. This enables safe evolution of tables, indexes, and metadata without risking existing memory data.
Introduce a versioned schema migration system for local libSQL shards. Track each shard's schema version using PRAGMA user_version, apply pending migrations atomically and exactly once during upgrades, and create recoverable backups before destructive changes. This enables safe evolution of tables, indexes, and metadata without risking existing memory data.