6 Commits

Author	SHA1	Message	Date
elmerfds	9f1b32e851	fix: update SQLite installation instructions and scripts for better dependency management	2025-05-17 23:28:44 +01:00
elmerfds	1d03d97e13	feat: update SQLite installation instructions and fix script for better dependency management	2025-05-17 23:26:30 +01:00
elmerfds	89c61f4796	feat(SQLite): add reset script and enhance transaction handling with improved migration coordination	2025-05-12 23:51:12 +01:00
elmerfds	9eabedfe09	feat(LockManager): implement OS-level locking for database initialization and enhance concurrency handling	2025-05-12 22:52:56 +01:00
elmerfds	65fe1f07a4	Enhance BetterSQLite with Retry Logic for Database Operations ... - Implemented retry mechanism for database table creation, transaction management, and query execution to handle "database is locked" errors. - Added helper functions for executing SQL commands with retries, improving robustness during concurrent access. - Introduced migration lock file management to prevent concurrent migrations and ensure safe initialization. - Updated the initialize function to check for migration locks and handle stale locks appropriately. - Enhanced error handling during database operations, including logging and rollback mechanisms. - Added support for skipping migrations if another process is already handling them.	2025-05-12 22:31:02 +01:00
elmerfds	ddd6f87e75	feat: implement comprehensive SQLite migration and management scripts ... - Added scripts for debugging and fixing SQLite issues. - Enhanced user model to support both SQLite and JSON storage. - Improved database initialization with better error handling and permission checks. - Implemented JSON file management for migration and cleanup. - Updated migration utility to track and log migrated records.	2025-05-11 23:45:19 +01:00