Ubuntu springtime cleaning

Clean up the junk that Ubuntu Desktop brings, esp if you are actually running a server

# remove desktop  related stuff
apt purge ubuntu-desktop -y && sudo apt autoremove -y && sudo apt autoclean
# apt
apt autoclean
apt autoremove
# apt archives still filled with junk
du -hd1 /var/cache/apt
apt clean

# old kernel modules
ls /usr/lib/modules
apt remove $(dpkg-query --show 'linux-modules-*' | cut -f1 | grep -v "$(uname -r)")

# remove old logs
find /var/log -name "*.gz" | xargs rm -f
# (some more you can find by hadn and remove, if you are confident you can do so)

MySQL json

extracting data from a json column

select json_extract(column_name, '$.key_name') from table_name;

Conda for dummies

conda create  python=3.10.4 --prefix $HOME_PATH/<name of your env>
conda init bash
conda activate $HOME_PATH/<name of your env>

To initialize env for which you already know dependencies

pip install -r requirements.txt

where requirements.txt looks something like

aiofiles==22.1.0
aiohttp==3.8.3
aiosignal==1.2.0
aiosqlite==0.17.0
alembic==1.8.1
anyio==3.6.2
apprise==1.1.0
asgi-lifespan==1.0.1
astroid==2.12.12
async-timeout==4.0.2

To get rid of the ridiculously long prompt that conda creates add the following (literally) to ~/.condarc

env_prompt: '({name})> '

To enable autocompletion using tab, see https://docs.conda.io/projects/conda/en/latest/user-guide/configuration/enable-tab-completion.html.