Sqlite is amazing! It's simple to set up, there is no db server process, you get extremely low latency. Testing is simplified because you can run tests against an in-memory database.

I haven't tried rqlite, but I have an API service that runs Litestream. That gives me a database backup that I can rewind to different points in time, and it lets me recreate the production database state locally for troubleshooting.