Post by peter greenI wonder if the trick shown at https://www.sparkfun.com/tutorials/114
could work, by staggering the pins on a header footprint slightly you
make the header a much firmer fit
They did it to make soldering the connector easier but I suspect that
with the pins staggered like that it would make a good enough connection
for programming without being soldered.
I just tried the staggered pin method, wroks well. On my target PCB I used 6 x SIL
0.1" pitch pads with 0.9mm (0.035") holes offset alternately 0.05mm (0.002") either
side of the centre line. Pins are a fairly loose fit, but ok for programming. Next time I
might increase the offset, perhaps by as much as 100%. In this case the PCB is
immersion gold finish, likewise mating with gold plated header pins. I'm sure it would
still work acceptably well for solder plated PCB's, at least for production
programming when everything is new and clean.