Today I learned

View LSP logs from COC in nvim

:CocList commands
select > workspace.showOutput

Connect observer to iex

iex --sname k --cookie cookie -S mix

then

erl -sname observer -setcookie cookie -run observer start

Run SQL from file with DB2

db2 -tvmf filename.sql

Load data from CSV in DB2

LOAD FROM "/database/config/db2inst1/db_load_temp/smdsear.txt" OF DEL INSERT INTO TMDSEAR

Find what we're compiled against

SELECT QUALIFIER, BINDTIME
FROM SYSIBM.SYSPACKAGE
WHERE NAME = <PROG_ID>

nix-direnv

sudo mkdir -m 0755 -p /nix/var/nix/{profiles,gcroots}/per-user/$USER
sudo chown -R $USER:nixbld /nix/var/nix/{profiles,gcroots}/per-user/$USER
mkdir -p ~/.config/direnv/

nix-env -f '<nixpkgs>' -iA nix-direnv
# add "source $HOME/.nix-profile/share/nix-direnv/direnvrc" to $HOME/.config/direnv/direnvrc

Get first N bytes of file

dd if=in.file bs=1 count=500 of=out.file