fix: resolve CI test failures by using raw sql.js adapter and adding redis service

fix(test): correct retry logic in frontend test and add postgres service to ci

fix: sql.js Docker/Alpine compatibility layer for PatternMemory and FailureMemory