misc‎ > ‎

miscnotes

Some private stuff here: https://sites.google.com/a/lukej.net/stuff/home

Garmin pinout

Garmin Rino120 <-> DB9 pinout

-|-
/4 1\
\3 2/
---

-----------
\5 4 3 2 1/
\9 8 7 6/
-------

DB9 Garmin
--- ------
1 2
2 3
3 1
4 ?
5
6
7
8
9

SanDisk Playlists

My silly little SanDisk SDMX-1 256R seems to have no control over play order of files (assuming the 'shuffle' is off).

Apparently, the only way to control the play order is via directories... However, even that is limited. What REALLY matters is what order your OS copies the files to the SanDisk. (This obviously implies that the OS might not copy in alphabetical/numerical order). My quick trick is to get the OS to sort the files first, then copy them one at a time (again, in order).

On my MacBook:

   find -s /Volumes/files/mp3/ -name "*.mp3" -exec cp {} /Volumes/SDMX1/PH/ \;

http://www.sandisk.com/Products/Item(1203)-SDMX1-256-Digital_Audio_Player_256MB.aspx

Mysql

  • SELECT p.id, p.mlsid, p.address, p.status, p.realtor, w.price FROM property p JOIN pricewatch w ON p.id = w.pid WHERE STATUS = 'active' AND w.price BETWEEN 250000 AND 400000 ORDER BY p.address, w.price DESC
  • SELECT p.id, p.mlsid, p.address, p.status, p.realtor, w.price FROM property p JOIN pricewatch w ON p.id = w.pid WHERE p.address LIKE '%cascade%' ORDER BY p.mlsid, w.price DESC ;

Bash

  • rsync --progress -a --size-only --exclude='lukedive' --delete /Volumes/files/* /Volumes/400GB/
  • rsync --progress -a --size-only --delete /Volumes/Macintosh\ HD/Users/luke/Music/iTunes/iTunes\ Music/* /Volumes/files/mp3/2008/
  • ssh -L 8080:localhost:80 root@server.lukej.net
  • rsync -av -e ssh  --bwlimit=15 /usr/share/gallery2/g2data username@jaguars.dreamhost.com:~/server.lukej.net/
  • rsync -av -e ssh  --bwlimit=30 --exclude='*.avi' /home/files/photos/2010/100308amara1stbday lukejohnson@jaguars.dreamhost.com:~/pics.lukej.net_new/

CMD.exe

PERL

  • [root@granite luke]# perl -pi -e 's/(\d\d)\/(\d\d)\/(\d\d\d\d)/$3-$1-$2/g;' /tmp/file.csv
    • Convert US dates to mysql in a csv via PERL
  • perl -pi -e 's/luke\/tenakee/luke\/denali/gi `grep -ilr tenakee .g*`
  • http://www.google.com/search?q=dutree+perl

Disk Recovery


Embedded Monitoring

Comments