Pybiocfilecache

- Fixing issues with using R and Python interfaces to the same cache directory.
- List resources now returns a `BiocFrame` object.

- Generate rid's that match with R's cache.
- Remove rname pattern checks.
- Add functions to access metadata table.
- Add function to add web urls and download them if needed.
- Rename GitHub actions for consistency with the rest of the packages.

- Reverting schema changes that break compatibility with the R/BiocFileCache implementation.
- Added support for Python 3.13

- chore: Remove Python 3.8 (EOL).
- precommit: Replace docformatter with ruff's formatter.

- SQLAlchemy session management
* Implemented proper session handling
* Fixed `DetachedInstanceError` issues and added helper method `_get_detached_resource` for consistent session management
* Improved transaction handling with commits and rollbacks

- New features
* Added cache statistics with `get_stats()` method
* Implemented resource tagging
* Added cache size management
* Added support for file compression
* Added resource validation with checksums
* Improved search
* Added metadata export/import functionality

- Method to list all resources.