SQLite is good for testing and simple single-user Nextcloud instance,
but it does not scale for multiple-user production cases. For the first Installation its quiet simple and reliable.
After some years of usage my SQLite-database reached a size of 130MB and the performance was not more the same as after the first days.
You can convert a SQLite database to a more performing MariaDB database with the Nextcloud command line tool: