Category Archives: Linux

Best Practices for shared postgres hosting

Posted on December 27, 2012 by admin

This is what you are looking for: http://wiki.postgresql.org/wiki/Shared_Database_Hosting

Posted in Linux, postgres | Comments Off on Best Practices for shared postgres hosting

How to install mysql driver on Mac OSX

Posted on December 21, 2012 by admin

ruby -e “$(curl -fsSkL raw.github.com/mxcl/homebrew/go)” brew install mysql

Posted in Mac OS X, mysql | Comments Off on How to install mysql driver on Mac OSX

Convert pfx certificate to pem

Posted on December 11, 2012 by admin

I can never remember those darned openssl parameters. So, I posted this for my own reference. openssl pkcs12 -in cert.pfx -out cert.pem -nodes Inside there you will find the certificate(s) and private key — all the included certs and key. … Continue reading →

Posted in Linux, Mac OS X, SSL | Comments Off on Convert pfx certificate to pem

Delete duplicates from table

Posted on December 5, 2012 by admin

Sometimes you end up with a lot of duplicates in a table and you need to get rid of them quickly. Do this; create table tmp like zipcodes; alter table tmp add unique (zip, city, state); insert into tmp select … Continue reading →

Posted in mysql | Comments Off on Delete duplicates from table

How to connect to the serial port of your pogo plug

Posted on December 3, 2012 by admin

This is a great article. https://sites.google.com/site/slimjb/ I bought the little usb adapter referenced in that article at http://www.ebay.co.uk/itm/180734359719?ssPageName=STRK:MEWNX:IT&_trksid=p3984.m1439.l2649#ht_2940wt_1221

Posted in Linux | Comments Off on How to connect to the serial port of your pogo plug