Worked on the Tencent/WeKnora repository to deliver critical SQLite compatibility fixes for WeKnora Lite mode, focusing on backend development with Go and GORM. Addressed issues in FAQ import handling by implementing in-memory progress tracking to prevent Redis-related panics and introduced robust seq_id management through pre-assignment and custom hooks, ensuring consistent behavior even with soft deletes. Enhanced the codebase with dialect-aware SQL replacements and improved cross-platform build processes for Linux and macOS. Expanded integration testing to cover SQLite-specific scenarios, resulting in higher reliability and data integrity for lightweight deployments while supporting faster QA cycles and broader deployment compatibility.