For small personal projects I like to use pocketbase. (https://pocketbase.io)
It uses Sqlite under the hood and provides a good admin interface, allows static file hosting, creates an API for your tables automatically which you can secure with security rules and has several authentication providers built in.