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. You can open the resulting file with a text editor and copy/paste out what you need.

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 * from zipcodes
on duplicate key update tmp.id=values(id);

rename table zipcodes to deleteme, tmp to zipcodes;

drop table deleteme;

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