fix: remove block_cache_compressed for rocksdb-8.0.0 compatibility

Removed following properties of ColumnFamilyOptions, which have been deprecated for some time. (They cause issues with Cython right now, and will be obsolete in v7 anyway.)

* `soft_rate_limit`
* `hard_rate_limit`
* `rate_limit_delay_max_milliseconds`
* `purge_redundant_kvs_while_flush`
* `skip_log_error_on_recovery`

Debian builds should use the packaged versions of the tools, only,
which seems achievable with pip's --no-build-isolation. This commits
also adds a verbose flag, to give the ability to easily verify this.

This runs tests against Debian stable (bullseye), and testing (bookworm).

The previous commit restricting build.yml to only run on 'main'
(same as newly-introduced debian.yml). But it's useful to be able
to see CI runs, during development _before_ opening a pull request.

A branch pattern is added so that forcing CI to run is possible.

This runs tests against Debian stable (bullseye) and, once rocksdb
6.25 makes it out of experimental, against bookworm too (testing).

Fixes to test framework and GitHub workflow

Following suggestions from code review, this commit avoid re-using the working
directory from different versions of the library.

After many tries, I think I finally manage to find the right combination of
tweaks to make pytest, tox, and GitHub actions to work.

This also adds caching of the librocksdb compilation, which is a very slow
step, and restricts building of wheels and other artifacts to run only when
pushing to main.

Remove members that do not exist in rocksdb. Update configuration

Remove unnecessary delete

Revert deleting Close method call

While building the docker image pass the arguments `--build-arg
"host_uid=$(id -u)" --build-arg "host_gid=$(id -g)"` so that you can
use the outputs of the compilation outside

Update Docker ubuntu version and add Cython

Add dependency to Cython in pyproject.toml file

Update tox configuration for unit test

Remove deprecated setup_requires