I can’t setup a ‘default user’ (only root), but there is now a MR adding exact commands you can copy-paste in a README: https://salsa.debian.org/mariadb-team/mariadb-server/-/merge_requests/115

I am asking for general strategies, not for a solution to a specific case.

By UV 3000 you probably don’t mean the ultraviolet lamp that is the first page of Google is full of when searching with this term…? I doubt UV - whatever it is - is a common approach.

What do you mean a default user? You can just run ‘mariadb’ to access to console with the same user that had permissions to run ‘apt install’.

For your actual application you need to plan what database name to use, what user, what permissions it needs, potentially remote connection and TLS etc. This indeed is some work and could perhaps be automated a bit, but it also needs sysadmin to make some decisions.

Yes, increasing the InnoDB buffer pool to use all available memory is the most important configuration change a sysadmin can do. But in order to do it, you need to know if the host is dedicated to one MariaDB instance or if there are multiple servers on the same host. Otherwise you would just have processes each hogging more memory when they can and not giving it up to others.

I could think about having a dialog during the installation that asks something like “Is host dedicated to this MariaDB instance? If yes, automatically configure it to use most of the system RAM available.”

MariaDB supports Galera clustering out-of-the-box, and also traditional primary/replica setups. But you need to have something that spans multiple hosts to monitor and manage it, and that is outside of what a single-host OS package management system can do.

You mean ollama? There are so many options, any favorites?

https://www.perplexity.ai/search?q=howto+upgrade+windows+to+ubuntu+linux

I just prefix all my git aliases with g-. So for status I type g-s<tab>.

You need bisect only as a last resort. Effective use of git blame, git log -p -S <keyword> etc has always been enough for me. Also, the projects I work with take 10+ minutes to compile even when cached, so doing tens of builds to bisect is much slower than just hunting for strings in git commits and code.

I had the same feeling until I started using gitk. I always have a gitk window open and press F5 to reload, so it shows me the state of everything after I’ve run git commands. Now I grasp everything much better.

Only product from Microsoft I actually like using and trust. Quality from 1998, and still going :)

One is enough if it is very big

Try again tomorrow, seems it got popular today

We just need specific portals for sharing that remember your homeserver. See for example https://mastodonshare.com/.