[Feature]: Allow other types of DB for `application_database`

[casudo]

Feature description

It seems a bit of a hurdle to force the user to have a PostgreSQL database for the application logs. Instead, add the ability to log them to a lightweight SQLite file for testing things out.

Additional context

No response

[casudo]

As requested @ManoftheSea, I've added the ability to configure the application_database via SQLite instead of the default hardcoded PostgreSQL requirement. You can find the changes in the branch 58.

It's just the top-of-my-head code and I wasn't able to test it yet. If you can spare the free time, feel free to test things out. I'll be able to test once im back from vacation.