Investigate other async runtimes for Python functions

[albertsgarde]

Most of the Python API currently starts a Tokio runtime for each function call. This can be expensive, so maybe a more lightweight runtime like smol would be fitting.

Note that this is incredibly low priority since it only touches the parts of the API relevant for creating the database which is not performance critical at all, and most of these functions take a long time anyway.