Useful git commands

Ty Walls has an excellent collection of git commands for reviewing git history and troubleshooting.

https://tygertec.com/find-stuff-git/

Using GIT from a network share

Running git on a remote network share, even when you have a good connectivity, is painful and slow.

It turns out someone clever has a better approach to using git in this use case.

http://www.watkyn.com/blog/2011/09/22/Using-git-at-work-on-a-Windows-network-drive/

Type errors when using VLOOKUP

When using VLOOKUP it will only find matches of the same data type as source.

The link below has some solutions;

https://exceljet.net/formula/vlookup-with-numbers-and-text

TL;DR,

=IFERROR(VLOOKUP(id,planets,3,0),VLOOKUP(id&"",planets,3,0))

Useful Docker and LXD info

Documentation

Developer documentation of using docker inside LXD
There are problems using docker inside LXD, many applications cannot run inside a LXD, this can in part be mitigated by applying the docker profile provided by LXD but this does not work for many applications.

Good example of bridging containers onto LAN, including setting up static ip's

Start container at boot time

Snippets

Delete all containers and images 

• #!/bin/bash
• # Delete all containers
• docker rm $(docker ps -a -q)
• # Delete all images
• docker rmi $(docker images -q)