2 Commits

Author	SHA1	Message	Date
Sudo-Ivan	bc8969ab16	Improve database performance and SQL handling ... - Introduced SQLite pragma tuning in the Database initialization for improved performance. - Wrapped multiple database operations in transactions to optimize batch processing in MessageDAO. - Updated DatabaseSchema to version 39, adding new indexes for better query performance. - Improved test coverage for batch operations and SQL injection scenarios in the DAO layer.	2026-03-06 03:26:36 -06:00
Sudo-Ivan	9d7ae2017b	Add SQL injection prevention measures in database migration and schema validation ... - Implemented identifier validation regex in legacy migrator and schema. - Enhanced database path handling to escape single quotes during ATTACH DATABASE. - Added tests for SQL injection scenarios, ensuring robustness against malicious inputs. - Introduced fuzz tests for DAO layers to cover edge cases and improve overall test coverage.	2026-03-06 03:08:28 -06:00