Coffee Shop Security

You go into a coffee shop with “free” WiFi. The catch is that you have to agree to their terms of service. The do this by temporarily intercepting all of your traffic until you click that agree button. The term for that in the industry is “captive portal.” A year or two ago, more and more websites began encrypting their web traffic using secure HTTP - HTTPS. This was a very healthy move on part of the Internet community.

GIT Log Formats

I found this super helpful git of info the other day. [alias] lg1 = log --graph --abbrev-commit --decorate --format=format:'%C(bold blue)%h%C(reset) - %C(bold green)(%ar)%C(reset) %C(white)%s%C(reset) %C(dim white)- %an%C(reset)%C(bold yellow)%d%C(reset)' --all lg2 = log --graph --abbrev-commit --decorate --format=format:'%C(bold blue)%h%C(reset) - %C(bold cyan)%aD%C(reset) %C(bold green)(%ar)%C(reset)%C(bold yellow)%d%C(reset)%n'' %C(white)%s%C(reset) %C(dim white)- %an%C(reset)' --all lg = !"git lg1"

Purpose

This blob is just an excuse to post a lot of crap that doesn’t go well with my normal Facebook audience.

Oracle Tablespace Move

The other day I had to move a crapload of Oracle table indicies into a different Oracle tablespace … Here’s what I ended up doing begin for C in (select * from DBA_INDEXES where OWNER = 'UCSC' and TABLESPACE_NAME = 'UCSC' and INDEX_TYPE = 'NORMAL') LOOP execute immediate 'alter index "' || C.index_name || '" rebuild tablespace ucscidx'; end LOOP; end; /