chore: cleanup tasks for storage preparation

[coderabbitai]

This issue tracks cleanup tasks for preparing the storage package for future use with Fiber v3.

Context

The storage package is being enhanced with context support (see #1569). As a follow-up, we need to perform several cleanup tasks to prepare for future integration with Fiber v3, while maintaining the package's independence.

Tasks

• Update all dependencies to their latest versions
• Update CI workflows to support the last 2 current Go versions (1.23, 1.24)
• Evaluate and increase major version if necessary
• Migrate tests to use testcontainers

References

• Related PR: enhancement: add context management support to storages #1569
• Discussion: enhancement: add context management support to storages #1569 (comment)

Note: These changes are preparatory work for Fiber v3 but will be implemented independently as the storage package can be used standalone.

[ReneWerner87]

target is the v3 branch