This release resolves critical database lock issues and adds comprehensive hybrid backend support to the installer.
🎯 Key Improvements
✅ Zero Database Locks - Proper SQLite pragma configuration eliminates "database is locked" errors
✅ Hybrid Backend Default - Fast local SQLite (5ms) + background Cloudflare sync
✅ Auto-Configuration - Installer handles SQLite pragmas (busy_timeout=15000,cache_size=20000)
✅ Interactive Setup - Cloudflare credential configuration with connection testing
✅ Graceful Fallback - Falls back to sqlite_vec if cloud setup fails
🔧 Fixes
- Database Lock Prevention: Resolved "database is locked" errors during concurrent HTTP + MCP server access
- Root cause: Default
busy_timeout=5000mstoo short for concurrent writes - Solution: Applied recommended SQLite pragmas
- Impact: 5/5 concurrent writes succeeded without locks
- WAL mode properly configured for multi-client operations
- Root cause: Default
✨ New Features
- Full Hybrid Backend Support in simplified installer
- Automatic Claude Desktop Configuration with:
- SQLite pragmas for concurrent access
- Cloudflare credentials for background sync
- Proper environment variable propagation
📊 Technical Details
- Modified Files:
scripts/installation/install.py(163 lines changed) - Version: 8.8.2 → 8.9.0
- Backward Compatible: Works with existing installations
- Concurrent Access Testing: 5/5 simultaneous writes succeeded
📚 Documentation
For complete details, see CHANGELOG.md.
Installation:
```bash
pip install mcp-memory-service
or
python scripts/installation/install.py --storage-backend hybrid
```