Disclaimer: these questions may be a bit dumb, since I just started trying out a scoold deployment. If I host a scoold server on my own server (on-prem), it ...

For example, if my db backend for my_other_application was sqlserver, I could, independently of the app, open up the sqlserver gui and issue some sql command...

Which database are you recommending in production ? Is it OK do use H2 ? We are using the default configuration for database - nothing is specified in para/ ...